Lesson 21

Getting Started (Introduction to Statistics in Spreadsheet, continued)

We will begin by looking are residual plots to help us decide if there is unusual behavior with our data and choice of regression. 

image001

 

Part I

1. Inputting Data of the Form (student #, test score)

image002

2. Plotting Data and Drawing a Regression

image003

3. Outputting Residuals to Spreadsheet

image004

4. Drawing a Residual Plot

image005

5.Trying Another Regression Curve

image006

6. Comparing Residual Values

image007

7. Drawing the Second Residual Plot

Before drawing the second residual plot, we need to place the data in Column A in front of Column E. To do this, we will first insert a column in front of Column E.

image008

 

 

Part I


Practice Exercises

Before beginning the practice exercises, open a word document, type in the following information and then save it as Lesson21 in your CASIO folder within My Documents:

  • Date: (enter today's date)
  • To: (put your instructor's name here)From: (put your name here)
  • Re: Lesson 21
  1. Please begin by opening the Spreadsheet application. Clear the window.
  2. Input =rand(1,20) into cell A1.
  3. Copy cell A1 (select it and press Ctrl+c or Edit/Copy).
  4. Select cells A2 to A20. Hint: Press on A2 (do not let go) and drag to A20.
  5. Select Column A and draw a scatter plot. The x-values are assumed to be 1 to 20.
  6. With your scatter plot and spreadsheet showing, get a screen capture. Paste it into your Lesson21 document (under a title of PART I).
  7. Select Calc/Linear Reg. Make sure the DispStat box is checked in the Calc menu!
  8. Click Output>> and uncheck Labels and Results.
  9. Check Residuals and change the cell to begin the paste in from D1 to B1.
  10. Click Paste and close the output window.
  11. Select just Column B and draw a scatter plot. The x-values are assumed to be 1 to 20.
  12. With the residual plot and spreadsheet showing, get a screen capture. Add two blank spaces following the first screen capture and then paste this one.
  13. Select just Column A and draw a scatter plot.
  14. This time, select Calc/Cubic Reg.
  15. Click Output>> and uncheck Labels and Results.
  16. Paste the residuals beginning in cell C1 and close the output window.
  17. With the spreadsheet showing, get a screen capture. Add two blank spaces following the last screen capture and then paste this one.