Generate a full table of descriptive statistics for Industry Box Office

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Q1 - Practice

1. Generate a full table of descriptive statistics for Industry Box Office (4.8 points)

a. Mean (0.4 points)

b. Median (0.4 points)

c. Mode (0.4 points)

d. Minimum (0.4 points)

e. Maximum (0.4 points)

f. Range (0.4 points)

g. Variance (0.4 points)

h. Std Dev (0.4 points)

i. 1st quartile (0.4 points)

j. 3rd quartile (0.4 points)

k. Interquartile Range (0.4 points)

l. Count (0.4 points)

 

2. Create the following (5 points):

a. Column chart with year as the x-axis and Box Office Sales as the Y axis (2.5 points)

 

b. Line chart demonstrating a time series of Disney’s Market Share and Include a trendline (2.5 points)

 

The Walt Disney Company is one of the most powerful companies in Media & Entertainment. However, when the company acquired Marvel Studios in 2009 and Lucasfilm in 2012, there were a number of doubters that an animated, children’s studio could make the leap to live, action films.

3. (5.1 points) Using the Marvel Dataset Pre 2010 – Q3-1 - Practice:

a. Generate a full table of descriptive statistics for Marvel Box Office Revenue (1.2 points)

i. Mean (0.1 points)

ii. Median (0.1 points)

iii. Mode (0.1 points)

iv. Minimum (0.1 points)

v. Maximum (0.1 points)

vi. Range (0.1 points)

vii. Variance (0.1 points)

viii. Std Dev (0.1 points)

ix. 1st quartile (0.1 points)

x. 3rd quartile (0.1 points)

xi. Interquartile Range (0.1 points)

xii. Count (0.1 points)

b. What is the 90% Confidence Interval for Marvel revenue at the time Disney acquired Marvel rights? (1 points)

c. What is the 95% Confidence Interval for Marvel revenue at the time Disney acquired Marvel rights? (1 points)

d. What is the 99% Confidence Interval for Marvel revenue at the time Disney acquired Marvel rights? (1 points)

e. At the time of the Marvel acquisition, Marvel had mean annual Box Office Revenue of 354,655,650.22 with a standard deviation of 164,414,416.63 (This is for the POPULATION of Marvel Studios releases). The dataset Marvel Studios Since 2009 – Q3-2 - Practice has the box office receipts since the Disney merger. At the time of the Disney merger, if this had been the sample, would we deem the merger successful? To answer this, perform a hypothesis test using the Marvel Studios Since 2009 data as your sample, and use a significance level of 0.05 (or 5%). (0.9 points)

i. Construct the appropriate Hypothesis test (0.1 points)

ii. Calculate (0.5 points):

1. Degrees of Freedom (d.f.) (0.1 points)

2. Std Err (0.1 points)

3. Critical Value (0.1 points)

4. Test Statistic (Z) (0.1 points)

5. P-Value (p) (0.1 points)

iii. Please interpret the above analysis in a couple of sentences, using language appropriate to a Disney Executive (0.3 points). 

 

4. (5.1 points) Using the Lucasfilm Dataset Pre 2013 – Q4-1 Practice:

a. Generate a full table of descriptive statistics for Lucasfilm Box Office Revenue (1.2 points)

i. Mean (0.1 points)

ii. Median (0.1 points)

iii. Mode (0.1 points)

iv. Minimum (0.1 points)

v. Maximum (0.1 points)

vi. Range (0.1 points)

vii. Variance (0.1 points)

viii. Std Dev (0.1 points)

ix. 1st quartile (0.1 points)

x. 3rd quartile (0.1 points)

xi. Interquartile Range (0.1 points)

xii. Count (0.1 points)

b. What is the 90% Confidence Interval for Lucasfilm revenue at the time Disney acquired Lucasfilm rights? (1 points)

c. What is the 95% Confidence Interval for Lucasfilm revenue at the time Disney acquired Lucasfilm rights? (1 points)

d. What is the 99% Confidence Interval for Lucasfilm revenue at the time Disney acquired Lucasfilm rights? (1 points)

e. At the time of the Lucasfilm acquisition, Lucasfilm had mean annual Box Office Revenue of 271,150,219.75 with a standard deviation of 151,010,089.74 (This is for the POPULATION of Lucasfilm releases). The dataset Lucasfilm Since 2012 – Q4-2 - Practice has the box office receipts since the Disney merger. At the time of the Disney merger, if this had been the sample, would we deem the merger successful? To answer this, perform a hypothesis test using the Lucasfilm Since 2012 – Q4-2 Practice data as your sample, and use a significance level of 0.05 (or 5%). (0.9 points)

i. Construct the appropriate Hypothesis test (0.1 points)

ii. Calculate (0.5 points):

1. Degrees of Freedom (d.f.) (0.1 points)

2. Std Err (0.1 points)

3. Critical Value (0.1 points)

4. Test Statistic (Z) (0.1 points)

5. P-Value (p) (0.1 points)

iv. Please interpret the above analysis in a couple of sentences, using language appropriate to a Disney Executive (0.3 points).

 

 

Attachments:

Expert's Answer

495 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme