- 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.
The post See Chapter 3, Case Problem #2: Movie Theater Releases, and download the data fi appeared first on GET HELP WITH PAPERLINQ.