PART 3
Slope
1. place the cursor inside an empty cell to right side of the data table in spreadsheet Part III.
2. Open "formula" tab at the top of the spreadsheet.
3. Open "more functions" tab at the top of the spreadsheet.
4. Open "statistical" tab from the menu that opens.
5. Select and open "SLOPE" tab from a vertical menu that opens.
6. Type in exactly "C2:C253" inside the top window labeled as “Known_Y’s”
7. Type in exactly "B2:B253" inside the lower window labeled as “Known_X’s”
8. Left click on "OPEN" tab of the window.
9. Move the cursor to a remote cell location (a blank cell).
10. Finally, move and place the cursor inside the original cell location for slope.
You should be able to see the correct value for the slope of the regression line.
Intercept
For Y-intercept of the regression line, follow the steps stated above by selecting
“ INTERCEPT” tab from the vertical menu, in Step 5 (above).
Correlation
To find the correlation coefficient between body fat and body weight, follow the 10 steps shown above including:
5. Select and open "CORREL" tab from a vertical menu that opens.
6. Type in exactly "C2:C253" inside the top window labeled as ”Array 1”.
7. Type in exactly "B2:B253" inside the lower window labeled as “Array 2”.
Graph
In order to find the graph in Part 3 (inside Spreadsheet III), follow these steps:
1. Place the cursor in an empty area (below calculated regression and correlation).
2. Place the cursor in the cell location B2 (top cell for body fat) by holding down the left click of the mouse. Then, drag and cover the entire data for columns B and C (B2 to B253 and C2 to C253) so that you can see shaded area inside this long window.
3. Open the “Inset” tab at the top of the spreadsheet.
4. Open the “Scatter” tab below the insert tab.
5. Select and open the top left window (with picture of scattered points).
6. You should be able to see the graph of scattered points open in a large window.
7. Move the cursor to the rectangle at the top labeled as “Quick Layout” inside “Chart Layouts “.
8. Place the cursor on a small arrow on Quick Layout looking downward. Open that arrow with left click of your mouse. Then, select the square tab at the intersection of third row and third column (labeled as “ Layout 9 “. Press on left click to open that tab.
9. Select and open the small window on labeled as "Layout 9" as explained above. This window shows graph of a small line along with some scattered points.
10. You should be able to see the graph the regression line inside the original graph passing through the scattered points.
11. Open the tab labeled as “Axis Title” under the horizontal axis.
12. Delete the “Axis Title” by using backspace key and type in: “Body Fat (%)”.
13. Open the tab labeled as “Axis Title” under the vertical axis.
14. Delete the “Axis Title” by using backspace key and type in: “Body Weight (lbs)”.
15. Open the tab labeled as “Chart Title” at top of the graph.
16. Delete the “Chart Title” by using backspace key and type in: “Regression Line”