Question

The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. Gross sales for the opening weekend, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was open are common variables used to measure the success of a motion picture. Data collected for a sample of 100 motion pictures produced in 20XX are contained in the file named Movies, linked at the bottom of the page. Use all 100 data points.

Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a motion picture. Be sure to include the following three (3) items in your report.

Descriptive statistics (mean, median, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry.

Use the z-score to determine which movies, if any, should be considered high-performance outliers in each of the four variables. If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.

Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables. Evaluate the relationships between total gross sales and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your conclusions.

Rank	Movie Title	Opening Gross	Total Gross	Theaters	Weeks
1	Spider-Man 3	151,116,516	336,530,303	4,324	15
2	Shrek the Third	121,629,270	322,719,944	4,172	12
3	Transformers	70,502,384	319,246,193	4,050	18
4	Pirates of the Caribbean: At World's End	114,732,820	309,420,425	4,362	19
5	Harry Potter and the Order of the Phoenix	77,108,414	292,004,738	4,285	22
6	I Am Legend	77,211,321	256,393,010	3,648	17
7	The Bourne Ultimatum	69,283,690	227,471,070	3,701	17
8	National Treasure: Book of Secrets	44,783,772	219,964,115	3,832	26
9	Alvin and the Chipmunks	44,307,417	217,326,974	3,499	25
10	300	70,885,301	210,614,939	3,280	18
11	Ratatouille	47,027,395	206,445,654	3,940	24
12	The Simpsons Movie	74,036,787	183,135,014	3,926	21
13	Wild Hogs	39,699,023	168,273,550	3,401	22
14	Knocked Up	30,690,990	148,768,917	2,975	17
15	Juno	413,869	143,495,265	2,534	28
16	Rush Hour 3	49,100,158	140,125,968	3,778	14
17	Live Free or Die Hard	33,369,559	134,529,403	3,411	19
18	Fantastic Four: Rise of the Silver Surfer	58,051,684	131,921,738	3,963	18
19	American Gangster	43,565,115	130,164,645	3,110	13
20	Enchanted	34,440,317	127,807,262	3,730	16
21	Bee Movie	38,021,044	126,631,277	3,984	15
22	Superbad	33,052,411	121,463,226	3,069	9
23	I Now Pronounce You Chuck and Larry	34,233,750	120,059,556	3,501	13
24	Hairspray (2007)	27,476,745	118,871,849	3,121	14
25	Blades of Glory	33,014,202	118,594,548	3,467	15
26	Ocean's Thirteen	36,133,403	117,154,724	3,565	15
27	Ghost Rider	45,388,836	115,802,596	3,620	10
28	Evan Almighty	31,192,615	100,462,298	3,636	15
29	Meet the Robinsons	25,123,781	97,822,171	3,435	23
30	Norbit	34,195,434	95,673,607	3,145	12
31	The Bucket List	335,837	93,466,502	2,915	23
32	The Game Plan	22,950,971	90,648,202	3,342	20
33	Beowulf	27,515,871	82,280,579	3,249	11
34	Bridge to Terabithia	22,564,612	82,272,442	3,210	19
35	Disturbia	22,224,982	80,209,692	3,132	16
36	No Country for Old Men	1,226,333	74,283,625	2,037	22
37	Fred Claus	18,515,473	72,006,777	3,603	14
38	1408	20,617,667	71,985,628	2,733	16
39	The Golden Compass	25,783,232	70,107,728	3,528	13
40	Charlie Wilson's War	9,656,250	66,661,095	2,594	11
41	Saw IV	31,756,764	63,300,095	3,183	7
42	Stomp the Yard	21,833,312	61,356,221	2,169	9
43	Surf's Up	17,640,249	58,867,694	3,531	11
44	Halloween (2007)	26,362,367	58,272,029	3,475	15
45	Tyler Perry's Why Did I Get Married?	21,353,789	55,204,525	2,034	9
46	TMNT	24,255,205	54,149,098	3,120	13
47	P.S. I Love You	6,481,221	53,695,808	2,471	12
48	3:10 to Yuma (2007)	14,035,033	53,606,916	3,006	10
49	Sweeney Todd: The Demon Barber of Fleet Street	9,300,805	52,898,073	1,507	13
50	Atonement	784,145	50,927,067	1,400	18
51	Resident Evil: Extinction	23,678,580	50,648,679	2,848	5
52	Music and Lyrics	13,623,630	50,572,589	2,955	13
53	Are We Done Yet?	14,262,724	49,662,533	2,944	13
54	This Christmas	17,958,183	49,121,934	1,921	7
55	Michael Clayton	719,910	49,033,882	2,585	24
56	Premonition	17,558,689	47,852,604	2,831	6
57	Dan in Real Life	11,809,445	47,642,963	1,941	15
58	The Kingdom	17,135,055	47,536,778	2,836	13
59	Shooter	14,523,571	47,003,582	2,806	12
60	License to Wed	10,422,258	43,799,818	2,715	13
61	Underdog	11,585,121	43,760,605	3,013	19
62	No Reservations	11,704,357	43,107,979	2,425	16
63	Because I Said So	13,122,865	42,674,040	2,529	9
64	Aliens Vs. Predator - Requiem	10,059,425	41,797,066	2,617	13
65	The Water Horse: Legend of the Deep	9,186,054	40,946,255	2,777	7
66	There Will Be Blood	190,739	40,222,514	1,620	18
67	Epic Movie	18,612,544	39,739,367	2,840	14
68	Hitman	13,180,769	39,687,694	2,468	16
69	30 Days of Night	15,951,902	39,568,996	2,859	5
70	Fracture	11,014,657	39,015,018	2,443	14
71	Stardust	9,169,779	38,634,938	2,565	11
72	The Brave One	13,471,488	36,793,804	2,837	11
73	The Heartbreak Kid	14,022,105	36,787,257	3,233	9
74	Freedom Writers	9,405,582	36,605,602	2,286	10
75	Smokin' Aces	14,638,755	35,787,686	2,219	7
76	The Messengers	14,713,321	35,374,833	2,529	6
77	The Number 23	14,602,867	35,193,167	2,759	5
78	Good Luck Chuck	13,652,001	35,017,297	2,612	8
79	Mr. Bean's Holiday	9,889,780	33,302,167	1,778	8
80	Breach	10,504,990	33,231,264	1,505	8
81	Zodiac	13,395,610	33,080,084	2,379	9
82	Balls of Fury	11,352,123	32,886,940	3,081	11
83	Mr. Magorium's Wonder Emporium	9,630,085	32,061,555	3,168	17
84	August Rush	9,421,369	31,664,162	2,310	14
85	Tyler Perry's Daddy's Little Girls	11,210,754	31,366,978	2,111	6
86	The Great Debaters	6,005,180	30,236,407	1,290	16
87	28 Weeks Later	9,807,292	28,638,916	2,305	14
88	We Own the Night	10,826,287	28,563,179	2,402	4
89	Mr. Brooks	10,017,067	28,549,298	2,453	11
90	Hannibal Rising	13,051,650	27,670,986	3,003	13
91	The Nanny Diaries	7,480,927	25,930,652	2,636	14
92	Mr. Woodcock	8,761,369	25,799,486	2,237	9
93	Nancy Drew	6,832,318	25,612,520	2,612	11
94	The Mist	8,931,973	25,594,957	2,423	17
95	The Reaping	10,025,203	25,126,214	2,603	9
96	Grindhouse	11,596,613	25,037,897	2,629	11
97	Sicko	68,969	24,540,079	1,117	17
98	Across the Universe	667,784	24,343,673	964	12
99	Perfect Stranger	11,206,163	23,984,949	2,661	6
100	Sea Monsters: A Prehistoric Adventure (IMAX)	605,722	23,746,066	252	49

Answer 1

The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. Gross sales for the opening weekend, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was open are common variables used to measure the success of a motion picture. Data collected for a sample of 100 motion pictures produced in 20XX are contained in the file named Movies, linked at the bottom of the page. Use all 100 data points. Managerial Report Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a motion picture. Be sure to include the following three (3) items in your report

Descriptive statistics (mean, median, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry

We can find descriptive statistics in EXCEL.

steps :

ENTER data into excel sheet --> Data --> Data Analysis --> Descriptive statistics --> ok --> Input range : Select all the variables together --> Labels in first row --> Output Range : select one empty cell --> ok

Opening Gross
Mean	24862477
Standard Error	2590091
Median	14620811
Mode	#N/A
Standard Deviation	25900910
Sample Variance	6.71E+14
Kurtosis	7.591172
Skewness	2.479535
Range	1.51E+08
Minimum	68969
Maximum	1.51E+08
Sum	2.49E+09
Count	100

Total Gross
Mean	85096527
Standard Error	7528226
Median	50787873
Mode	#N/A
Standard Deviation	75282257
Sample Variance	5.67E+15
Kurtosis	2.74781
Skewness	1.810178
Range	3.13E+08
Minimum	23746066
Maximum	3.37E+08
Sum	8.51E+09
Count	100

Theaters
Mean	2856.35
Standard Error	76.63948
Median	2844
Mode	2529
Standard Deviation	766.3948
Sample Variance	587361
Kurtosis	0.744973
Skewness	-0.53627
Range	4110
Minimum	252
Maximum	4362
Sum	285635
Count	100

Weeks
Mean	14.09
Standard Error	0.623787
Median	13
Mode	13
Standard Deviation	6.237869
Sample Variance	38.91101
Kurtosis	8.797407
Skewness	1.931593
Range	45
Minimum	4
Maximum	49
Sum	1409
Count	100

Mean opening gross = 24862477.45

Mean total gross = 85096527

Mean theaters = 2856.35

Mean weeks = 14.09

Median opening gross = 14620811

Median total gross = 50787873

Median theatres = 2844

Median weeks = 13

Range for opening gross = 151047547

Range for total gross = 3.13E+08

Range for theaters = 4110

Range for weeks = 45

Standard deviation for opening gross = 25900910.33

Standard deviation for total gross = 75282257

Standard deviation for theaters = 766.3948

Standard deviation for weeks = 6.237869

Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables.

Correlation between total gross and opening gross = 0.9089

Correlation between total gross and theater = 0.6991

Correlation between total gross and weeks = 0.3642

We can see that all the correlations are positive so there is positive relationship between the variables.