Assignment:

For this assignment, you are required to use only R-Studio. You may use Power BI if you wish that it would be helpful. The decision to use Power BI is yours. All the visuals and/or tabular summaries should be beautiful, colored, and labeled.

Report format:

No page limit, cover page with your name and/or identity required. The file should be named after your name when uploaded to canvas. Make a professional report that provides statistics supported by figures and explanation. The first page of the report should provide a tabular summary of the answers to the questions. Details should follow in the subsequent pages.

Problem

The movie industry is a competitive business. More than 50 studios produce hundreds of new movies for theater release each year, and the financial success of each movie varies considerably. The opening weekend gross sales ($ millions), the total gross sales ($ millions), the number of theaters the movie was shown in, and the number of weeks the movie was in release are common variables used to measure the success of a movie. Data on the top 100 grossing movies released in 2016 (Box Office Mojo website) are contained in the file Movies2016. Table 3.10 shows the data for the first 10 movies in this file. The data is provided in the attached excel file.

Managerial Report

Include the followings in your report:

1. Descriptive statistics for each of the four variables, along with a discussion of what the descriptive statistics tell us about the movie industry.
2. What movies, if any, should be considered high-performance outliers? Explain and support your answer by making appropriate graphs (e.g., box plot) and standardized scores.
3. Descriptive statistics showing the relationship between total gross sales and each of the other variables. The answer to this question should provide both statistical tests and graphs, all in R.