This activity guides students to use excel/ google sheets to1. Randomly select from a data set2. Transform the data into a power model3. Graph scatterplots and histograms of the data and residual plots4. Use XLMiner ToolPak to identify key statistics in the regression analysis5. Identify and interpret R, R^2, S, b0, b1, SEb16. Construct a confidence interval7. Identify the t-value and p-value for hypothesis testsThis file was originally created as a google sheet.A sample answer key is included.T