| Salary (in millions) | Attendance (in millions) |
| Mean | XXXXXXXXXX | Mean | XXXXXXXXXX |
| Standard Error | XXXXXXXXXX | Standard Error | XXXXXXXXXX |
| Median | 80.35 | Median | 2.325 |
| Mode | #N/A | Mode | #N/A |
| Standard Deviation | 33.9011 | Standard Deviation | XXXXXXXXXX |
| Sample Variance | XXXXXXXXXX | Sample Variance | XXXXXXXXXX |
| Kurtosis | XXXXXXXXXX | Kurtosis | XXXXXXXXXX |
| Skewness | XXXXXXXXXX | Skewness | XXXXXXXXXX |
| Range | 164.7 | Range | 2.35 |
| Minimum | 36.8 | Minimum | 1.41 |
| Maximum | 201.5 | Maximum | 3.76 |
| Sum | 2655.4 | Sum | 73.43 |
| Count | 30 | Count | 30 |
Below please type an interpretation of the means, standard deviations, minimum and maximum values in the table for Salary and Attendance.The summary showcases that in baseball season, there is a direct relationship with the attendance and the amount of salary increase. The increase of one variable will cause a change in the other variable.
Please copy and paste your correlation table for Built and Size below. | Built | Size |
| Built | 1 |
| Size | 0.15819 | 1 |
Below please type an interpretation of your correlation explaining the relationship between when the stadium was built and the size of the stadium. When the stadium was built has a strong relationship on the size of the stadium.
Please copy and paste your scatter diagram for Built and Size below.Below please type an interpretation stating whether or not this scatter diagram agrees with the correlation calculated above and why you conclude this.The scatter diagram shows a strong relationship that shows little scatter. This shows that the newer the year, the more in depth the size is.
Please copy and paste your t-Test: Two-Sample Assuming Unequal Variances table below. | t-Test: Two-Sample Assuming Unequal Variances |
| Variable 1 | Variable 2 |
| Mean | XXXXXXXXXX | 80.1875 |
| Variance | XXXXXXXXXX | XXXXXXXXXX |
| Observations | 14 | 16 |
| Hypothesized Mean Difference | 0 |
| df | 27 |
| t Stat | XXXXXXXXXX |
| P(T | XXXXXXXXXX |
| t Critical one-tail | XXXXXXXXXX |
| P(T | XXXXXXXXXX |
| t Critical two-tail | XXXXXXXXXX |
Below please type an interpretation of your results explaining if there is a significant difference in the average number of wins obtained by League 1 versus League 2 (use a two-tailed test assuming you have no hypothesis about which league might be better).There is not a significance difference in the average number of in for League 1 and League 2.
Please copy and paste the three tables (Regression Statistics and two ANOVA tables) below.Please answer the questions/respond to the statements regarding your regression analysis.1) What percent of the variance in numbers of wins is accounted for by team batting average, number of stolen bases, number of errors committed, team ERA, and number of home runs?
2) What is the typical amount of error we can expect when using this equation to predict number of wins?
3) Is your overall model (including team batting average, number of stolen bases, number of errors committed, team ERA, and number of home runs) a significant predictor of number of wins? How did you arrive at this conclusion?
4) What is your regression equation for predicting number of wins from team batting average, number of stolen bases, number of errors committed, team ERA, and number of home runs?
5) If a team had team batting average of .277, plus 100 stolen bases, 83 errors committed, a team ERA of 4.07, and 201 home runs, how many wins would you predict?
6) Which of your predictors are significant?
7) If you ran this analysis again, which predictors would you include?
Based on your above Excel output and interpretations, write a formal memo (typed, full sentences, paragraphs, conclusions, etc.) detailing the results of your regression analysis, a discussion of your results, and a recommendation for how a baseball team manager might use this information. In addition to statistical (content) errors, you will be graded for typing errors, spelling errors, grammatical errors, and format errors. Please note that this assignment is to be done on your own without the aid of any other student or instructor. You will be graded based on the rubric on the following page.GRADING RUBRIC | Possible Points | Points Earned |
| Output from Excel (14%) |
| | 2 |
| | 2 |
| | 2 |
| | 2 |
| | 6 |
| Interpretation of Results (76%) |
- Summary Statistics Interpretation
| 7 |
- Correlation Interpretation
| 7 |
- Scatterplot Interpretation
| 6 |
| | 7 |
- Answers to Seven Regression Questions
| 49 |
| Formal Memo (10%) |
- Sentence structure, grammatical errors, etc.
| 10 |
| SCORE |