The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new…

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.

Rank
Movie Title
Opening Gross
Total Gross
Theaters
Weeks

1
Marvel’s The Avengers
207,438,708
623,357,910
4,349
22

2
The Dark Knight Rises
160,887,295
448,139,099
4,404
21

3
The Hunger Games
152,535,747
408,010,692
4,137
24

4
Skyfall
88,364,714
304,360,277
3,526
17

5
The Hobbit: An Unexpected Journey
84,617,303
303,003,568
4,100
19

6
The Twilight Saga: Breaking Dawn Part 2
141,067,634
292,324,737
4,070
16

7
The Amazing Spider-Man
62,004,688
262,030,663
4,318
15

8
Brave
66,323,594
237,283,207
4,164
30

9
Ted
54,415,205
218,815,487
3,303
17

10
Madagascar 3: Europe’s Most Wanted
60,316,738
216,391,482
4,263
19

11
Dr. Seuss’ The Lorax
70,217,070
214,030,500
3,769
21

12
Wreck-It Ralph
49,038,712
189,422,889
3,752
26

13
Lincoln
944,308
182,207,973
2,293
24

14
MIB 3
54,592,779
179,020,854
4,248
15

15
Django Unchained
30,122,888
162,805,434
3,012
20

16
Ice Age: Continental Drift
46,629,259
161,321,843
3,886
30

17
Snow White and the Huntsman
56,217,700
155,332,381
3,777
14

18
Les Miserables (2012)
27,281,735
148,809,770
2,927
14

19
Hotel Transylvania
42,522,194
148,313,048
3,375
22

20
Taken 2
49,514,769
139,854,287
3,706
20

21
21 Jump Street
36,302,612
138,447,667
3,148
15

22
Argo
19,458,109
136,024,128
3,247
28

23
Silver Linings Playbook
443,003
132,092,958
2,809
29

24
Prometheus
51,050,101
126,477,084
3,442
15

25
Safe House
40,172,720
126,373,434
3,121
14

26
The Vow
41,202,458
125,014,030
3,038
14

27
Life of Pi
22,451,514
124,987,023
2,946
35

28
Magic Mike
39,127,170
113,721,571
3,120
13

29
The Bourne Legacy
38,142,825
113,203,870
3,753
13

30
Journey 2: The Mysterious Island
27,335,363
103,860,290
3,500
20

31
Rise of the Guardians
23,773,465
103,412,758
3,672
20

32
Zero Dark Thirty
417,150
95,720,716
2,946
15

33
Flight
24,900,566
93,772,375
2,638
15

34
Think Like a Man
33,636,303
91,547,205
2,052
11

35
The Campaign
26,588,460
86,907,746
3,302
15

36
The Expendables 2
28,591,370
85,028,192
3,355
14

37
Wrath of the Titans
33,457,188
83,670,083
3,545
13

38
Jack Reacher
15,210,156
80,070,736
3,352
13

39
Dark Shadows
29,685,274
79,727,149
3,755
14

40
Parental Guidance
14,554,053
77,267,296
3,368
21

41
John Carter
30,180,188
73,078,100
3,749
16

42
Act of Valor
24,476,632
70,012,847
3,053
15

43
This Is 40
11,579,175
67,544,505
2,931
10

44
Contraband
24,349,815
66,528,000
2,870
9

45
Looper
20,801,522
66,486,205
2,993
14

46
Tyler Perry’s Madea’s Witness Protection
25,390,575
65,653,242
2,161
12

47
Battleship
25,534,825
65,422,625
3,702
11

48
Pitch Perfect
5,149,433
65,001,093
2,787
20

49
Mirror Mirror
18,132,085
64,935,167
3,618
20

50
Chronicle (2012)
22,004,098
64,575,175
2,908
18

51
Hope Springs
14,650,121
63,536,011
2,441
11

52
Underworld Awakening
25,306,725
62,321,039
3,078
7

53
The Lucky One
22,518,358
60,457,138
3,175
13

54
The Dictator
17,435,092
59,650,222
3,014
10

55
Total Recall (2012)
25,577,758
58,877,969
3,601
9

56
Titanic 3D
17,285,453
57,884,114
3,674
9

57
American Reunion
21,514,080
57,011,521
3,203
8

58
ParaNorman
14,087,050
56,003,051
3,455
20

59
This Means War
17,405,930
54,760,791
3,189
17

60
Project X
21,051,363
54,731,865
3,055
11

61
The Woman in Black
20,874,072
54,333,290
2,856
13

62
Paranormal Activity 4
29,003,866
53,921,300
3,412
11

63
The Devil Inside
33,732,515
53,261,944
2,551
11

64
The Odd Life of Timothy Green
10,822,903
51,854,875
2,717
22

65
Ghost Rider: Spirit of Vengeance
22,115,334
51,774,002
3,174
12

66
The Grey
19,665,101
51,580,236
3,208
12

67
Red Tails
18,782,154
49,876,377
2,573
20

68
The Possession
17,732,480
49,130,154
2,860
12

69
Diary of a Wimpy Kid: Dog Days
14,623,599
49,008,662
3,401
20

70
Sinister
18,007,634
48,086,903
2,542
12

71
Beauty and the Beast (3D)
17,751,905
47,617,067
2,625
16

72
Savages (2012)
16,016,910
47,382,068
2,635
9

73
The Best Exotic Marigold Hotel
737,051
46,412,041
1,298
25

74
Moonrise Kingdom
522,996
45,512,466
924
23

75
Here Comes the Boom
11,816,596
45,290,318
3,014
18

76
Red Dawn (2012)
14,276,668
44,806,783
2,781
13

77
The Three Stooges
17,010,125
44,338,224
3,482
18

78
Star Wars: Episode I – The Phantom Menace (in 3D)
22,469,932
43,456,382
2,655
15

79
Resident Evil: Retribution
21,052,227
42,345,531
3,016
8

80
The Cabin in the Woods
14,743,614
42,073,277
2,811
13

81
What to Expect When You’re Expecting
10,547,068
41,152,203
3,021
11

82
Finding Nemo (3D)
16,687,773
41,128,283
2,904
18

83
End of Watch
13,152,683
41,003,371
2,780
17

84
Rock of Ages
14,437,269
38,518,613
3,470
9

85
Abraham Lincoln: Vampire Hunter
16,306,974
37,519,139
3,109
13

86
Lawless
10,001,982
37,400,127
3,138
13

87
The Guilt Trip
5,290,629
37,134,215
2,431
11

88
That’s My Boy
13,453,714
36,931,089
3,030
5

89
Trouble with the Curve
12,162,040
35,763,137
3,212
12

90
The Watch
12,750,297
35,353,000
3,168
12

91
Frankenweenie
11,412,213
35,291,068
3,005
21

92
Step Up Revolution
11,731,708
35,074,677
2,606
10

93
Tyler Perry’s Good Deeds
15,583,924
35,025,791
2,132
12

94
Monsters, Inc. (3D)
4,774,686
34,043,006
2,618
19

95
2016 Obama’s America
31,610
33,449,086
2,017
13

96
House at the End of The Street
12,287,234
31,611,916
3,083
13

97
The Pirates! Band of Misfits
11,137,734
31,051,126
3,358
14

98
Joyful Noise
11,225,190
30,932,113
2,735
10

99
Chimpanzee
10,673,748
28,972,764
1,567
16

100
The Five-Year Engagement
10,610,060
28,835,528
2,941
8

Managerial ReportPrepare 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.
Your report must contain the following:
A title page in APA style.
An introduction that summarizes the problem.
The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.
Submit your Excel file in addition to your report.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.