Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
See Chapter 3, Case Problem #2: Movie Theater Releases, and download the data fi
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.
Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.