Lesson 21

Part II (Introduction to Statistics in Spreadsheet, continued)

In this part, we will experiment with the t distribution and degrees of freedom.

image013

 

1. Inputting Degrees of Freedom

image014

2. Locating the t distribution

image015

3. Getting Started with Exploration

image016

4. Exploring Shape as the Degrees of Freedom (df) Increases

image017

5. Outputting Data to Spreadsheet

image018

6. Viewing Probability as Degrees of Freedom (df) Increase Graphically

image019

______________________________________________________________________

PART II


Practice Exercises

  1. Please begin by opening the Spreadsheet application. Clear the window.
  2. Input 1 into cell A1 and press EXE.
  3. Using Fill Range to place the numbers 2 to 30 in A2 to A30.
  4. Select column A and then Calc/Distribution.
  5. Change the distribution to Student-T CD.
  6. Click Next>> and drag A1:A30 to the df field.
  7. Set Lower to -2 and Upper to 2.
  8. Click Next>> and graph the result for df = 5.
  9. With the Stat and graph windows showing, get a screen capture. Paste it into your Lesson21 document (under a title of PART II).
  10. Change the df to 25. It may be easier to resize the window to scroll the df dropdown list box. Notice the graph updates automatically.
  11. With the Stat and graph windows showing, get a screen capture. Add two blank spaces following the first screen capture and paste this one.
  12. Click Output>> and then Paste.
  13. Close both windows to view the Spreadsheet window only.
  14. Select columns A and B and draw a Scatter plot.
  15. Change cell A1 to 30 and press EXE.
  16. With the spreadsheet and scatter plot showing, get a screen capture. Add two blank spaces following the second screen capture and then paste this one.

_______________________________________________________________________

PART III


Written Exercises

Please copy and paste the following questions into your Lesson21 document (under a title of Part III) and answer them.

  1. What makes up the coordinate point of a point in a residual plot?
  2. How can we estimate from a residual plot whether or not the regression will pattern the population accurately?
  3. How do we put residual data in Spreadsheet?
  4. Is a t distribution graph more spread out or less spread for small degrees of freedom numbers?

Reflection Exercises

You have just completed the twenty-first lesson in ClassPad 101. Please take a few moments to copy and paste the following three questions at the end of your Lesson21 document and answer them.

  1. Approximately how long did it take you to complete this lesson?
  2. Which activity did you enjoy the most?
  3. Do you have suggestions for a third activity?

Assessment 21: Introduction to 3D Graphing