Description
This activity guides students to use excel/ google sheets to
1. Randomly select from a data set
2. Transform the data into a power model
3. Graph scatterplots and histograms of the data and residual plots
4. Use XLMiner ToolPak to identify key statistics in the regression analysis
5. Identify and interpret R, R^2, S, b0, b1, SEb1
6. Construct a confidence interval
7. Identify the t-value and p-value for hypothesis tests
This file was originally created as a google sheet.
A sample answer key is included.
There are 13 sheets in the sheet total.
AP Statistics LSRL Transformations and Inference Activity with Excel
Highlights
Description
This activity guides students to use excel/ google sheets to
1. Randomly select from a data set
2. Transform the data into a power model
3. Graph scatterplots and histograms of the data and residual plots
4. Use XLMiner ToolPak to identify key statistics in the regression analysis
5. Identify and interpret R, R^2, S, b0, b1, SEb1
6. Construct a confidence interval
7. Identify the t-value and p-value for hypothesis tests
This file was originally created as a google sheet.
A sample answer key is included.
There are 13 sheets in the sheet total.
