I don't know where to start with this in Excel.

Player Rating TD% Inter%
Steve Young 96.8 5.6 2.6
Kurt Warner 95.7 5.5 3.5
Daunte Culpepper 93.2 5.4 3.1
Peyton Manning 92.3 5.6 3.1
Joe Montana 92.3 5.1 2.6
Trent Green 87.9 4.7 2.9
Tom Brady 87.5 4.8 2.6
15.34 For the data in Exercise 15.23, and with y=
touchdown percentage and x=interception percentage,
determine and interpret the coefficients of correlation and
determination.

To determine the coefficients of correlation and determination for the given data in Excel, you can follow these steps:

Step 1: Organize the data in Excel:
- Create columns for Player, Rating, TD% (touchdown percentage), and Inter% (interception percentage).
- Enter the respective values for each player in the corresponding columns.

Step 2: Calculate the coefficients of correlation:
- Select an empty cell where you want to display the correlation coefficient.
- Use the CORREL function to calculate the correlation between TD% and Inter%.
- For example, if the TD% values are in column C and the Inter% values are in column D, you can use the formula: =CORREL(C2:C8, D2:D8)
- The result will be the correlation coefficient between the two variables (TD% and Inter%).

Step 3: Interpret the correlation coefficient:
- The correlation coefficient ranges from -1 to 1.
- If the coefficient is close to 1, it indicates a strong positive correlation, meaning as one variable increases, the other variable also tends to increase.
- If the coefficient is close to -1, it indicates a strong negative correlation, meaning as one variable increases, the other variable tends to decrease.
- If the coefficient is close to 0, it indicates no or very weak correlation between the two variables.

Step 4: Calculate the coefficient of determination:
- The coefficient of determination, also known as R-squared, provides the proportion of the variation in one variable (TD%) that can be explained by the other variable (Inter%).
- To calculate R-squared, square the correlation coefficient obtained in Step 2. This will give you the coefficient of determination.

Step 5: Interpret the coefficient of determination:
- The coefficient of determination ranges from 0 to 1.
- It represents the percentage of variation in the dependent variable (TD%, in this case) that can be explained by the independent variable (Inter%).
- For example, if the coefficient of determination is 0.6 (or 60%), it means 60% of the variation in TD% can be explained by the variation in Inter%.

Following these steps, you can use Excel functions to calculate the coefficients of correlation and determination for the given data and interpret the results.