Question

The table is posted to answer the questions and all work must be shown.

Sections 2.3 and 2.4: Question #6 (23 points) Using the information about performance data for 10 motion pictures in Table 2.20 on p.86, answer the following questions. a. Prepare a crosstabulation of the data on Opening Gross Sales (rows) and b. Comment on the relationship between the two variables based upon the crosstabulation c. Using Excel, develop a scatter diagram of the data on Opening Gross Sales and d. Comment on the relationship between the two variables based upon the scatter diagram Weeks in Release (columns) developed in part (a). Total Gross Sales. Use the vertical axis for Opening Gross Sales developed in part (c).

Answer 1

(a)

Total Gross Sell
	Opening Gross Sales($millions)
Week in Release	169.19	97.85	138.12	85.95	90.15	86.2	12.79	66.14	39.64	65.72
19	381.01
15		352.39
14			281.29
16				254.46
19					241.07
15						209.84
13							208.55
25								191.45
13									186.59
16										181.03

Opening Gross Sales($millions)	Week in Release
169.19	19
97.85	15
138.12	14
85.95	16
90.15	19
86.2	15
12.79	13
66.14	25
39.64	13
65.72	16

(b) there is positive correlation between two variables opening gross sells and week in release

(c) the scatter plot between opening gross sell and total gross sell is given as

(d) there is positive relationship between opening gross sell and total gross sell, as points on scatter plot is on diagonally from lower-left to upper-right