A box office analyst has obtained data for 66 movies. The data file Movie accessed via LMS under Assessments contains the ‘YouTube trailer view count’ (the number of YouTube trailer views from the release of the trailer

A box office analyst has obtained data for 66 movies. The data file Movie accessed via LMS under Assessments contains the ‘YouTube trailer view count’ (the number of YouTube trailer views from the release of the trailer through to the Saturday before a movie opens) and the ‘opening weekend box office gross’ (in $millions). (Data extracted from ‘Box Office Report’ available at bit.ly/2srM34F) 

What conclusions can you reach about the number of YouTube trailer views and the opening weekend box office gross (in $millions)? What conclusions can you reach about predicting weekend box office gross from YouTube trailer views? Write a report to interested stakeholders summarising your conclusions.

For the ‘YouTube trailer view count’ and the ‘opening weekend box office gross’:
(a) Construct Histograms for each.
(b) Construct Boxplots for each.
(c) Compute Summary Statistics for each.
(d) Create a scatter plot for the ‘YouTube trailer view count’ and the ‘opening weekend box office gross’.
(e) Assuming a linear relationship, determine the regression coefficients bo and b1. Interpret the meaning of the slope, b1. Predict the mean weekend box office gross for a movie that had 20 million YouTube trailer views.
(f) Compute the Coefficient of Determination of the ‘YouTube trailer views’ and the ‘opening weekend box office gross’.
(g) Perform a residual analysis for this data. Based on these results, evaluate whether the assumptions of regression have been seriously violated. 
Use this information to comment on (e).

You must include all Excel results for this data as part of the justification for your conclusions. (Include them within the appropriate section – not at the end of your document.) Your assignment must be submitted as a single word document via LMS.