This assignment uses a scoring guide. Review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion.
To calculate the correlation factor (r), go to Excel, Formulas, Statistics, and select the CORREL function. To calculate the Regression Equation and
To calculate the correlation factor (r), go to Excel, Formulas, Statistics, and select the CORREL function. To calculate the Regression Equation and Coefficient of Determination: a. Select the x,y data b. Insert a scatter chart from that data c. Click the chart, go to Chart Design d. Go to Quick