Problem Description:
A local game retailer has asked us to evaluate global video game sales for the current generation of consoles. We have collected data on 129 video game sales in which globally sold in excess of 1 million units. We have included critic and user ratings and the type of console.
You will use descriptive statistics, inferential statisticsand your knowledge of multiple linearregression to complete this task.
Global Sales (Dependent Variable)and several characteristics (Independent Variables) are given in the Excel file: MondayTuesday.xlsx. You can find the data that we will use in the project in the "Processed" tab with the definitions of the variables in the "Dictionary" tab.
Required:
A. Calculate the descriptive statistics fromthe data and display in a table. Be sure to comment on the central tendency,variabilityand shape for Global Sales, Critic Score and User Score.How would you interpret the mean of dummy variables such as Mature or Xone?
B. Draw a graph that displays the distribution of Global Sales. Be sure to comment on the distribution. Does it appear normally distributed?
C. Create a box-and-whisker plot for the distribution of User Ratingsand describe the shape. Is there evidence of outliers in the data?
D. What is the probability that we could randomly select a game where the global sales is greater than 2 million units? What is the likelihood that the sales exceed 2 millionunits for games that are rated as mature?Is the salesstatistically independent of whether they are rated as mature? Use a Contingency Table.
E. Estimate the 95% confidence interval for the population mean critic score. How does this compare to the 95% confidence interval for the population mean user score?
F. A fellow student recently stated that any of the major games released, those selling in excess of 5 million units, almost always have a meanuser score higher than 60. Test her claim at the 10% level of significance.
G. Run a multiple linear regression using the data and show the output from Excel.Exclude the dummy variable Xone from the regression results as well as Year.
H. Is the coefficient estimate for the Critic Score statistically different than zero at the 5% level of significance? Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach. Interpret the coefficient estimate of the slope.
I. Interpret the remaining slope coefficient estimates.Discuss whether the signs are what you are expecting and explain your reasoning.
J. Interpret the value of the Adjusted R2.Is there a large difference between the R2 and the Adjusted R2? If so, what may explain the reasoning for this?
K. Is the overall model statistically significant at the 5% level of significance? Use the p-value approach.
L. Based on the results of the regressions, what other factors would have influenced global sales? Provide a couple possible examples and indicate their predicted relationship with sales if they were included.
M. Predict the average sales of a game that is not rated maturewith a critic score of 95, a user score of 60 that is released on the WiiU. Discuss if it is appropriate to do predict under these conditions. Show the predicted regression equation.
N. Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of the Errors, and Homoscedasticity of Errors? Show using scatter diagrams, normal probability plots and/or histograms and Explain.
O. Does this data indicate the true population distribution of console sales? Explain and if not, describe a sampling procedure that could lead to more accurate results.
P. Construct Sales Indexes for each console using 2013 as a base year. Which console had the strongest growth between 2013 and 2016?
Attachment:- Data.xlsx