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

Info iconThis 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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). Figure 3
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/14/2009 for the course BUSINESS Res 320 taught by Professor Diaz during the Spring '09 term at University of Phoenix.

Page1 / 11

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

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online