lkpunion.blogg.se - Make an xy scatter chart in excel

To display the slope and intercept in OpenOffice for the above data, use the following functions:

The graph will display the best fit line, but not the function.

Choose the linear regression, click on OK.

Choose create (the various titles can be filled in as appropriate).

The first variant works best in this course.

Drag to indicate where the graph should be located and how big the graph should be.

Select the data and click on the chart wizard.

For directions on using version 2.3, refer to the notes on version 2.4. Starting with version 2.3, the chart wizard does not wait for the user to use the mouse to drag the chart location. In version 2.3 the chart wizard was altered. The following directions apply to Calc versions 2.0, 2.1, and 2.2.

Distribution of 3.0 and 3.1 on Windows continue to use a semi-colon.Įxcel 2007 uses different screens to obtain a linear regression.Ĭreating an xy scattergraph in Calc 2.0 3.0 and 3.1 on Ubuntu 9.04 and 9.10 respectively use a comma. Excel uses a comma by default, OpenOffice 2.0 a semi-colon. To obtain the slope and intercept in Excel for the above data, use the following functions: Select both Display equation on chart and Display R-Squared value on chart (the image shows only the first item being selected.Choose a linear regression and then click on the Options tab.Click on a point on the chart to highlight the data points:.

Select the data and click on the chart wizard button:.Creating an xy scattergraph in Microsoft Excel and Calc 2.0 Creating XY Scattergraphs with SpreadsheetsĬreating an xy scattergraph in Microsoft ExcelĬreating an xy scattergraph in Calc 2.0 Creating an xy scattergraph in Microsoft Excel