In EXCEL: The motion picture industry is a competitive business. More than60 studios produce
a total of 300 to 400 newmotion pictures each year, and the financial success of
each motion picture variesconsiderably. The opening weekend gross sales ($ millions)
are often used to predict thesuccess of a motion picture. Data collected for a
sample of 30 motion pictures is shownbelow.
Round and label your answersproperly!
Opening Weekend GrossSales        ($ millions)	Total GrossSales         ($millions)
29.16	67.25
2.14	7.64
48.74	205.27
10.90	24.47
0.05	0.22
12.40	102.00
102.69	287.18
44.11	282.88
24.11	125.88
50.34	186.21
23.45	55.80
0.32	30.00
64.63	89.68
14.00	29.00
20.02	30.04
5.26	17.08
67.42	94.61
77.06	234.20
0.02	0.41
5.62	11.01
0.20	0.24
93.50	164.61
18.07	32.04
0.16	0.16
0.06	0.84
0.08	1.22
0.02	0.48
29.63	47.31
0.05	4.36
0.25 1. Describe the Total Gross Sales data in appropriate language(4 pt)	11.23
2. Draw an appropriate chart showing the distribution of theTotal Gross Sales data. (4 pt)
3.(a) Show the relationshipbetween these two variables withan
appropriate chart. (2pt)
(b) Develop a linearregression equation to predict the total
gross sales usingthe opening weekend gross sales. (1 pt)
(c) Estimate the total grosssales if the opening weekend
grosssales is $56 million. (1 pt)
(d) How much of thevariability in total gross sales is
explained by the opening weekend gross sales? (1pt)
(e) According to yourregression equation, if opening weekend gross sales are zero,
what willthe total gross sales be? (1pt)
(f) According to yourregression equation, for every million dollar increase in openingweekend
grosssales, the total gross sales (increases / does not change /decreases) by
_________ (2 pts) (Fill in the blank with anumber.)
(g) Are the total gross salesstatistically related to the opening weekend gross sales? Test atthe
.05level of significance:
	State H0 and H1. (1pt)
	What is your pvalue? (1 pt)