Required: A.Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the central tendency, variability and shape for Gross Revenue, Theatres, and Metacritic Score. How would you interpret the mean of dummy variables such as Sequel/Reboot or Action? B.Draw a graph that displays the distribution of the number of theatres that show a film. Be sure to comment on the distribution. C.Create a box-and-whisker plot for the distribution of the gross revenue and describe the shape. Is there evidence of outliers in the data? D.Film critics often believe that there is little correlation between a rating of a film and the revenue that it brings in. What is the likelihood that a film that receives a metacritic rating below a 50 still earns more than $90 million? Is the gross revenue statistically independent of the rating? Use a Contingency Table. E.Estimate the 90% confidence interval for the population mean film rating. F.Film critics also claim that film audiences do not care about the quality of the film. Any action film guarantees that it will gross more than $100 million. Test their 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 "Thriller" from the regression results. H.Is the coefficient estimate for Theatres 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 the gross revenue? Provide a couple possible examples and indicate their predicted relationship with the gross revenue if they were included. M.Predict the average gross revenue of an action film with a metacritic score of 30 if it shows in 4,000 theatres, but it is not a sequel or a reboot if it is appropriate to do so. 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.Would these results likely tell us anything about how well Australian-made films will perform in Australia? If not, describe a scenario in how you would construct a sample of Australian films to predict their performance.