Which genre had greater variation in total gross income

Assignment Help Project Management

Reference no: EM131621550

Assignment Mini-Project

Assignment Steps

Refer to Mini-Project Movie Data Set. (ATTACHED)

Analyze and write a report summarizing this data. This report should include answers to at least the following questions:

1. Calculate the summary measures (the mean, standard deviation) of the total gross income for each movie genre. Why would we want to calculate these vs. looking at total gross income by itself? Which genre(s) are performing best? Show your results in a table in the Word.doc.

2. Which genre had greater variation in total gross income? Explain your reasoning behind your conclusion. Why is this important to know from a business standpoint?

3. Look at the average opening gross income as a percentage of the average total gross income for each genre. Which genre(s) are the most successful when they first open? Why is this important to know?

4. Consider all of the above measures - average total gross income, variability of the total gross income and the average opening gross income as a percentage of the average total - for all genres. If you were a manager for a multiplex movie theater that could show 4 movies at a time, which genre(s) would you want showing at your theater? Explain why based on the statistical analysis.
Use Excel to sort the data and calculate your summary statistics (see videos).

Create Summary tables in Excel and copy and paste into your Word document for the respective sections. Do NOT submit separate Excel workbooks or discuss numbers without a table to refer to.

Write a 700-word report addressing each of the requirements, above. Be succinct. The reasoning behind these decisions is not complicated but you must understand the concepts.

Proofread your paper using a spell/grammar checker and make sure you have references as needed.

Format your assignment consistent with APA guidelines.

Attachment:- Project-Data.rar

Reference no: EM131621550

Questions Cloud

Complete portions of opportunity section of your business : In this assignment, you will complete portions of the Opportunity section of your business plan. Current Alternatives and Our Advantages.

Learn how to capture network traffic : Exercise 1 provides a suggestion for you to better understand the technology by referring to course materials.

Which is the better deal : One manufacturer lists a stand-up workstation for $448 with a chain discount of 10/6/4. Another manufacturer lists a station of similar quality for $550.

Should mark just have given up on the idea : Would it make sense for Mark to assign this problem to someone else now, after Jack could not solve the problem the second time around?

Which genre had greater variation in total gross income : Which genre had greater variation in total gross income? Explain your reasoning behind your conclusion. Why is this important to know from business standpoint?

Calculate the net price for several items : If you were writing a spreadsheet program to calculate the net price for several items and you were not interested in showing the trade discount.

Prepare the companys cash budget for october : Prepare the company's cash budget for October in good form. Make sure to indicate what borrowing, if any, would be needed to attain desired ending cash balance

Define the workmanship of the parts and browne wishes : A dispute arises concerning the workmanship of the parts and browne wishes the case to be arbitrated in San Francisco. What result

Calculate the trade discount : Calculate the trade discount for 20 boxes of computer paper if the unit price is $14.67 and a single trade discount rate of 20% is allowed.

User Account

All Pages