{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

excel scatter plot sample - Excel Contents Do you have the...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Contents: Do you have the Data Analysis ToolPak? Drawing a Scatter Plot Sample Correlation Coefficient Simple Linear Regression Adding a Trend Line and its Equation to a Scatter Plot Do you have the Data Analysis ToolPak? 1. Click Tools on the menu bar. If Data Analysis is on list then you have the Data Analysis ToolPak add-in and there is nothing else to do. If you don’t see Data Analysis then complete the following steps. 2. Click Add-Ins from the Tools list. 3. Click in the Analysis ToolPak checkbox (Figure 1). Figure 1 4. Click OK 5. Repeat Step 1 to check that the Data Analysis ToolPak has been added to the Tools list. Year13 Statistics 1
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Drawing a Scatter Plot Example: Using the Car data, construct a scatter plot of Eng against Weight 1. Open the Excel file containing the car data as seen in Figure 2. Figure 2 2. Click Insert on the menu bar, then click Chart . 3. Click XY (Scatter). Click Next (Figure 3).
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}