Answer each of the following questions. You will need to use technology. Test the claim that there is a correlation between the explanatory variable, budget, and the response variable, Domestic Gross, at the 5% significance level. H0: p= 0 Ha: p≠ 0 p-value = (Rounded to exactly four decimal places.)  Linear correlation coefficient r= (Round to exactly four decimal places.)   Based on your work, is there a linear correlation? (Enter Y for yes or N for no) Compute the linear regression line in the form y=mx+b. (Round both m and b to exactly two decimal places.) y = ______ x + _______ Based on your work, does the regression model or the mean  of the data serve as a better predictor of the Domestic Gross (in millions of $) based on a $13.2 million budget? Enter R for regression model, enter M for mean.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

A sample of 30 movies, an Excel .XLSX file of data is attached. Use the data contained to answer all parts of this question.

  • The Movie column provides the name of the movie. 
  • The Year column provides the year the movies was released
  • The Budget column provides the amount of money spent (in Millions of dollars) to film the movie
  • The Domestic Gross($M) column provides the amount of money (in Millions of dollars) a movie made within the United States of America

Answer each of the following questions. You will need to use technology.

Test the claim that there is a correlation between the explanatory variable, budget, and the response variable, Domestic Gross, at the 5% significance level.

H0: p= 0

Ha: p≠ 0

p-value = (Rounded to exactly four decimal places.)


 Linear correlation coefficient r= (Round to exactly four decimal places.)

 

Based on your work, is there a linear correlation? (Enter Y for yes or N for no)

Compute the linear regression line in the form y=mx+b. (Round both m and b to exactly two decimal places.)

y = ______ x + _______

Based on your work, does the regression model or the mean  of the data serve as a better predictor of the Domestic Gross (in millions of $) based on a $13.2 million budget? Enter R for regression model, enter M for mean.)

 

Files 8:14 AM Sat Apr 29
5
fx
1
2
3
Movie+Budgets+and+Box+Office+Earnin...Sample+-+Updated+Spring+2018%29+A+
Home
Calibri (Body)
Sheet1
A
Insert Draw
Movie
Once Upon a Time in America
13 Going On 30
4 Interrupted
5 Artie Lange's Beer League
6
Force 10 from Navarone
7
Arthur
8
The Terminal
9
Jackass 3D
10 Les Triplettes de Belleville
11 The Gallows
12 Frozen
13 Shopgirl
14 Chasseurs de dragons
15 She's the One
16
Life
17 Arnolds Park
18 The Visitor
19 Lunchtime Heroes
20 Death Race
21
Hross i oss
22 Muppets Most Wanted
23
The Ant Bully
24 The Hurricane
25
La Cara Oculta
26 Project Almanac
27
How Do You Know?
28 The Mirror Has Two Faces
29 A Charlie Brown Christmas
30 The Runaways
31 Tales from the Hood
32
33
34
35
36
37
38
39
40
12
Year
B
4E
●●●
Formulas
1962
2011
1995
1968
2001
2010
2004
2012
1984
2015
2016
1991
1998
2011
1996
2005
2010
2012
2002
1972
2006
2001
1995
2001
1999
2016
2011
1995
1999
2014
Data
с
Budget
BIU SO
20
12
17.7
125
24
10
60
20
15
55
5
2.9
30
1
15
175
60
8.4
4
20
63.7
48
84
13
2
40
22
120
Review View
25 75
D
Domestic Gross($M)
0.144583
0
0.25115
0.35348
3.484331
13.442412
75.590286
7.309628
63.408614
0
90.135191
2.484186
3.652206
63.826569
6.069605
1.188194
2.511476
17.018422
12.795746
130.058047
234.770996
14.334645
23.43825
36.443442
7.027762
0.004803
5.308707
1.200216
322.719944
0.017472
Q
E
70%
Gene
Transcribed Image Text:Files 8:14 AM Sat Apr 29 5 fx 1 2 3 Movie+Budgets+and+Box+Office+Earnin...Sample+-+Updated+Spring+2018%29+A+ Home Calibri (Body) Sheet1 A Insert Draw Movie Once Upon a Time in America 13 Going On 30 4 Interrupted 5 Artie Lange's Beer League 6 Force 10 from Navarone 7 Arthur 8 The Terminal 9 Jackass 3D 10 Les Triplettes de Belleville 11 The Gallows 12 Frozen 13 Shopgirl 14 Chasseurs de dragons 15 She's the One 16 Life 17 Arnolds Park 18 The Visitor 19 Lunchtime Heroes 20 Death Race 21 Hross i oss 22 Muppets Most Wanted 23 The Ant Bully 24 The Hurricane 25 La Cara Oculta 26 Project Almanac 27 How Do You Know? 28 The Mirror Has Two Faces 29 A Charlie Brown Christmas 30 The Runaways 31 Tales from the Hood 32 33 34 35 36 37 38 39 40 12 Year B 4E ●●● Formulas 1962 2011 1995 1968 2001 2010 2004 2012 1984 2015 2016 1991 1998 2011 1996 2005 2010 2012 2002 1972 2006 2001 1995 2001 1999 2016 2011 1995 1999 2014 Data с Budget BIU SO 20 12 17.7 125 24 10 60 20 15 55 5 2.9 30 1 15 175 60 8.4 4 20 63.7 48 84 13 2 40 22 120 Review View 25 75 D Domestic Gross($M) 0.144583 0 0.25115 0.35348 3.484331 13.442412 75.590286 7.309628 63.408614 0 90.135191 2.484186 3.652206 63.826569 6.069605 1.188194 2.511476 17.018422 12.795746 130.058047 234.770996 14.334645 23.43825 36.443442 7.027762 0.004803 5.308707 1.200216 322.719944 0.017472 Q E 70% Gene
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman