Lesson 21
Introduction to Statistics in Spreadsheet
Welcome
In this lesson we will explore features of the ClassPad that allow us study Statistics in a new way using Spreadsheet. The possibilities are endless!
Lesson Goals
- To understand what a residual plot is
- To be able to decide which regression better fits the data based on residuals
- To understand how the degrees of freedom affects the graph of a t distribution
In Lesson 21 you will learn how to:
- Fill a range of cells
- Draw a regression curve
- Place residual values for a regression in Spreadsheet
- Generate statistical values for multiple inputs at one time
- View multiple graphs quickly
- Output data from Statistics to Spreadsheet
- View probabilities based on multiple degrees of freedom graphically
Upon completion of this lesson you will be able to answer the following questions:
- What makes up the coordinate point of a point in a residual plot?
- How can we estimate from a residual plot whether or not the regression will pattern the population accurately?
- How do we put residual data in Spreadsheet?
- Is a t distribution graph more spread out or less spread for small degrees of freedom numbers?
Time Required
About 50 minutes.