Mathematics Homework Help

Statistics Essentials of Statistics Correlation & Regression Question

In your textbook, Essentials of Statistics, read:
1. Chapter 10, Section 1: “Correlation”
2. Chapter 10, Section 2: “Regression”
Watch the video “Scatterplot Regression” that explains the Excel skills you will need to complete the practice problems. Note that the version of Excel presented in the video may differ from the one you are using.
Open the file WS2Practice (Excel). Follow the directions in the worksheet to create:
1. A scatterplot
2. A trend line of the plot showing the regression formula and r² value
3. An interpretation of the slope and r² value
4. A prediction y value based on the x value
Save your exercises as a single Excel file with one worksheet for each completed exercise.