Statistics HW - Only Experts Please - 16 Hours at the Max
Problem Set 5: ECON 216
Professor Derrick Robinson
Question: Does performance matter when considering the value of a local sports team?
Use data sets: NBA or Baseball:
i) Construct scatter plots and correlation coefficients to illustrate relationships between annual revenue (AR) (Y axis) and all performance measures (i.e., FG%, 3pt%, Points, ERA, batting averages, etc.) (X axis) across teams.
ii) Discuss the observed relationships. Does team performance seem to be correlated with AR?
iii) Construct scatter plots and correlation coefficients to illustrate relationships between team value (TV) and all performance measures (i.e., FG%, 3pt%, Points, ERA, batting averages, etc.) across teams.
iv) Discuss the observed relationships. Does team performance seem to be correlated with TV?
v) Use an Ordinary Least Squares linear regression to estimate coefficients for 2 models with AR and TV as dependent variables.
vi) Express your predicted coefficient results in functional equation form using the equation building tool in Word.
vii) Interpret the coefficients and how they relate to the idea: TV/AR of a sports team is directly related to, or explained by, the amount of performance a team generates.
viii) Interpret R2 in relationship to goodness of fit of the model.
ix) Interpret the p-values (t-test) and confidence interval estimates.
x) Is each model overall significant?
xi) Write a paragraph describing your findings across variables. Specifically, answer the question of interest from the top?
1