Question

In: Finance

The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies...

The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies are shown below. Complete parts​ (a) through​ (c).

Budget, x Gross, y

206 253

205 302

200 423

199 688

182 688

175 1035

173 1878

168 1225

(a) Display the data in a scatter plot

​(b) Calculate the correlation coefficient r.

(c) Make a conclusion about the type of correlation.

Solutions

Expert Solution

(a) Display the data in a scatter plot

​(b) Calculate the correlation coefficient r.

x y xy x^2 y^2
206 253                         52,118                         42,436                         64,009
205 302                         61,910                         42,025                         91,204
200 423                         84,600                         40,000                       178,929
199 688                       136,912                         39,601                       473,344
182 688                       125,216                         33,124                       473,344
175 1035                       181,125                         30,625                   1,071,225
173 1878                       324,894                         29,929                   3,526,884
168 1225                       205,800                         28,224                   1,500,625

correlation coefficient​ r = [n(xy) - xy] / [nx^2-(x)^2] [ny^2-(y)^2]

= [ 8*1172575 - 1508*6492] / [8*285964- 1508^2] * [8*7379564 - 6492^2]

= -409,336 / 13648*16890448

= -409,336 / 480125.85

= -0.8526

- .85

(c) Make a conclusion about the type of correlation.

If two variables are negatively correlated, then one variable increases as other will decreases. As we first plot scatter graph , it shows a downward trend, indicating negative correlation.


Related Solutions

Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Answer parts ​a-c. Budget (x)   Gross (y) 63   60 93   66 45   51 31   57 203   624 105   143 90   46 a. Find the value of the linear correlation coefficient b. Find the critical values of r from the table showing the critical values for the Pearson correlation coefficient using α=0.05. c. Is there sufficient evidence to conclude that...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Construct a​ scatterplot, find the value of the linear correlation coefficient​ r, and find the​ P-value using alphaequals0.05. Is there sufficient evidence to conclude that there is a linear correlation between budgets and gross​ receipts? Do the results change if the actual budgets listed are ​$60,000,000​, ​$91,000,000​, ​$48,000,000​, and so​ on? Budget​ (x) 60 91 48 40 196 100...
8. Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions...
8. Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Construct a​ scatterplot, find the value of the linear correlation coefficient​ r, and find the​ P-value using a=0.05. Is there sufficient evidence to conclude that there is a linear correlation between budgets and gross​ receipts? Do the results change if the actual budgets listed are ​$63000000. $85000000, $45000000, and so on Budget_(x)         Gross_(y) 63           66 85           69 46          ...
1. Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions...
1. Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. . Budget​ (x) 64 87 47 31 199 99 85 Gross​ (y) 67 60 49 56 630 143 47 Find the value of the linear correlation coefficient r. 2. For a sample of eight​ bears, researchers measured the distances around the​ bears' chests and weighed the bears. Calculator was used to find that the value of the linear...
listed below are the budgets in million of dollars and the gross receipts in millions of...
listed below are the budgets in million of dollars and the gross receipts in millions of dollars for randomly selected movies. budget x: 61, 92, 54, 37, 202, 105, 93 gross receipts: 64, 66, 52, 62, 543, 148, 51 a. find the value of the linear correlation coefficient r. b.find the p value for this hypothesis test for linear correlation. c. is there sufficient evidence to conclude yhqt there is a libeqr relatiibship between budgets and gross receipys? use level...
Consider the following 2016 data for Newark Hospital (in millions of dollars) Simple Budget Flexible Budget...
Consider the following 2016 data for Newark Hospital (in millions of dollars) Simple Budget Flexible Budget Actual Results Revenues $4.7 $4.8 $4.5 Costs 4.1 4.1 4.2 Profit 0.6 0.7 0.3 a. Calculate and interpret the two profit variances b. Calculate and interpret the two revenue variances. c. Calculate and interpret the two cost variances. d. how are the variances related Answer a-d.
Given the following data (in millions of dollars): gross profit, $900; depreciation expense, $100; preferred stock...
Given the following data (in millions of dollars): gross profit, $900; depreciation expense, $100; preferred stock dividends, $25; cost of goods sold, $400; earnings before interest, taxes, depreciation & amortization, $300; interest expense, $75. Assume a tax rate of 21%. Compute the numerical values of sales revenue, operating expenses, earnings before interest and taxes, and earnings available for the common stockholders.
On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the...
On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the total gross sales for records visible in the table. Format as Accounting. In cell B2(Average Gross Sales), enter a function that will calculate the average gross sales for records visible in the table. Format as Accounting. In cell B3 (Total Movies) enter a function that will calculate the number of movies visible in the table, using the MovieID field. Total Gross Sales (filtered) Average...
The average production cost for major movies is 61 million dollars and the standard deviation is...
The average production cost for major movies is 61 million dollars and the standard deviation is 18 million dollars. Assume the production cost distribution is normal. Suppose that 7 randomly selected major movies are researched. Answer the following questions. Round all answers to 4 decimal places where possible. What is the distribution of X?X ~ N(,) What is the distribution of ¯x? ¯x ~ N(,) For a single randomly selected movie, find the probability that this movie's production cost is...
The average production cost for major movies is 58 million dollars and the standard deviation is...
The average production cost for major movies is 58 million dollars and the standard deviation is 21 million dollars. Assume the production cost distribution is normal. Suppose that 7 randomly selected major movies are researched. Answer the following questions. Give your answers in millions of dollars, not dollars. Round all answers to 4 decimal places where possible. What is the distribution of X? X ~ N   () What is the distribution of ¯x? ¯x ~ N () For a single...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT