Status: Live
For Problem 1, open a new spreadsheet and put the usual heading on it. On the Baseball.xlsx sheet copy columns a through f and place them on your new spreadsheet. Delete columns b, d and e. Make columns a through l a width of 15 units. On d5, put your hypothesis, namely Ho: ρ = 0, no significant correlation Ha: ρ ≠ 0, significant correlation α = .05 (ρ is the small Greek letter rho, the population parameter for Pearson’s Product Moment Correlation Coefficient, for a sample we use r.) Now go to the ribbon and click on “Data” and go to “Data Analysis” and highlight “Regression”. The y-values—the response variable—are the wins column, and the x-values—the explanatory variable—are the runs. We are determining if runs are correlated with wins. If you included the titles, check the “labels” box. Check the “output” box and put in d8. Initiate. Excel will provide many statistics for us to utilize. We are only looking for the p-value for runs. Compare this to α.
Date Posted: 02/03/2021
Category: Math
Due Date: 05/03/2021
Willing to Pay: $30.00
Due Date: 05/03/2021
Willing to Pay: $30.00
Instruction
The File Baseball_2015.xlsx file consists of 30 Major League Baseball teams' statistics from 2015. It includes variables regarding the games played, wins & losses, at bats, runs scored, hits, homeruns, total bases, runs batted in, batting average, on base percentage, strikeouts, stolen bases, earned run average, saves, opponent runs, opponent batting average, errors, team payroll, the dollar value of each team win, and whether the team made it to the playoffs (FYI, Kansas City ultimately won the World Series). Assigned Problem 1: A team must score more than their opponents to win a game, and so they must ultimately score runs, since they cannot win with a score of zero. Are runs correlated with wins; i.e., does a team that scores more runs win more games? Conduct a correlation analysis to determine if there is a correlation between Runs and Wins. Use a .05 significance level. Answer the following questions: State your conclusion. Base this on the p-value. Find the correlation coefficient and the coefficient of determination. What is the best fit regression equation that can predict the Wins from the Runs? How many games would you expect a team to win if they scored 800 runs in a season? Assigned Problem 2: Let us look at a popular argument that it takes money to win. Kansas City had one of the lowest payrolls and won it all, Houston had the second lowest payroll and made it far in the playoffs, and seven of the top ten payrolls did not even qualify for the playoffs. The evidence will show that money is not a predicting factor, but we are going to make it official. Perform a correlation analysis to determine if there is a correlation between Payroll and Wins. Use a .05 significance level. Answer the following questions: Is the p-value statistically significant? What is the correlation coefficient and the coefficient of determination? If the results are not statistically significant, you would normally stop at this point? What is the regression equation, even if the results are not statistically significant? Assigned Problem 3: In order to obtain an even better model for predicting Wins, we are going to look at multiple variables. Create a multiple regression equation predicting the Wins using Runs, Hits, Home Runs, Average, Strikeouts, Stolen Bases and ERA. Use the Stepwise procedure to eliminate non-significant variables until the final equation has only significant variables. After you create your regression equation, predict the Wins for a team that has 700 runs, 1500 hits, 200 homeruns, a .260 average, 1000 strikeouts, 100 stolen bases and a 3.00 ERA.
Tutor Uploads
No File uploaded yet.
Bidders
12
Average bid
$104.17
.jpeg)
.jpg)