# Question

The Excel file MLB 2012 Payroll. xlsx contains the total payroll in millions of dollars for each Major League Baseball team at the start of the 2012 season along with the total number of each team’s wins at the end of the season. Use Excel and PHStat to answer the following questions:

a. Construct a scatter plot for these data.

b. Identify the slope and the y intercept for the regression equation.

c. Provide an interpretation for the value of the slope.

d. Is the linear relationship between payroll and wins statistically significant using α = 0.05?

e. Identify the 95% confidence interval for the slope and interpret the results.

f. Construct a 95% confidence interval for the average number of wins for teams that have $ 100 million payrolls.

g. Construct a 95% prediction interval for the number of wins for a team that has a $ 100 million payroll.

a. Construct a scatter plot for these data.

b. Identify the slope and the y intercept for the regression equation.

c. Provide an interpretation for the value of the slope.

d. Is the linear relationship between payroll and wins statistically significant using α = 0.05?

e. Identify the 95% confidence interval for the slope and interpret the results.

f. Construct a 95% confidence interval for the average number of wins for teams that have $ 100 million payrolls.

g. Construct a 95% prediction interval for the number of wins for a team that has a $ 100 million payroll.

## Answer to relevant Questions

The University of Delaware would like to describe the linear relationship between the grade point average (GPA) and the starting monthly salary of a graduate who earned a business degree from the university. The following ...Consider the following set of dependent and independent variables. These data can also be found in the Excel file Prob 153.xlsx. a. Using PHStat, identify the SST, SSR, and SSE. b. Calculate the multiple coefficient of ...Consider the following set of dependent and independent variables. These data can also be found in the Excel file Prob 152.xlsx. a. Using PHStat, construct a multiple regression model with these data. b. Interpret the ...Jersey Shore Realtors would like to develop a regression model to help it set weekly rental rates for beach properties during the summer season in New Jersey. The independent variables for this model are the number of ...Consider the following set of dependent and independent variables. The variable x3 is qualitative with H = High, M = Medium, and L = Low. The quantitative data for this problem can be found in the Excel file Prob ...Post your question

0