- See Chapter 3, Case Problem #2: Movie Theater Releases, and download the data file (attached).
- Part 1: Add additional columns and create formulas to show, for each movie:
- Average opening weekend sales per theater
- Average total sales per theater
- Average sales per week
- Apply conditional formatting to the “average sales per week” column to highlight (in green) any movies that averaged over $20M per week.
- Part 2: Use the tabular and graphical methods of descriptive statistics to learn how these variables contribute to the success of a motion picture. Include the following in your report.
- Tabular and graphical summaries for each of the four variables along with a discussion of what each summary tells us about the movies that are released to theaters.
- A scatter diagram to explore the relationship between total gross sales and opening weekend gross sales.
- A scatter diagram to explore the relationship between total gross sales and number of theaters.
- A scatter diagram to explore the relationship between total gross sales and number of weeks in release.
- Add a new sheet and rename the tab “Summary” and complete the following:
- In cell A1, type the movie with the highest average sales per theater.
- In cell A2, type the movie with the highest average sales week.
- Copy your “Total Gross Sales and Opening Weekend Gross Sales” diagram to your Summary sheet. In cell A3, type any observations or takeaways you learn from this diagram.