Get Academic Help Instantly!

https://bestqualitywriters.com/business-finance-homework-help-11540/

Temple University Correlation & Multiple Regression Results Worksheet

 

I have attached the file needed for the assignment, and also an example PDF of how the final work has to look like ( it has to be exactly the same just with different numbers)

Use Baseball_2015.xls file which 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)? Use Correlation.xls to conduct a simple correlation analysis to determine if there is a correlation between Runs and Wins. Use a .05 significance level. Also answer the following:
    1. Is the correlations statistically significant? State the p-value.
    2. What is the correlation coefficient and how strong is it?
    3. What is the best fit regression equation that can predict the Wins from the Runs? What does the coefficient in the regression equation mean (i.e., the number in front of Runs)?
    4. What percent of the variability in the Wins by the regression model?
    5. How many games would you expect a team to win if they scored 800 runs in a season?
  • ASSIGNED PROBLEM 2: Let’s look at a popular argument that it takes money to win. Well Kansas City had one of the lowest payrolls and won it all, Houston had the 2nd lowest payroll and made it far in the playoffs, and 7 of the top 10 payrolls didn’t even qualify for the playoffs. The evidence will show that money is not a predicting factor, but let’s make it official. Use Correlation.xls to conduct a simple correlation analysis to determine if there is a correlation between Payroll and Wins. Use a .05 significance level. Also answer the following:
    1. Is the correlations statistically significant? State the p-value.
    2. What is the correlation coefficient and how strong is it?

Solved!:

10% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET10 to claim 10% Discount This Month!!

Why US?

100% Confidentiality
100% Timely Delivery
100% Original Writing

100% Money Back

Cheap Essay Writing

Do my Assignment

Order custom essay

Sample Essays

Custom term paper

Write My Research Paper

Affiliate program

Custom essay

Research paper

Write my essay

Write my paper

Essay writers

Become a Freelance Writer

Contact us

Glossary

Sitemap

Terms and conditions

Privacy policy

Proficient Concepts  is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.