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 releasedThe Budget column provides the amount of money spent (in Millions of dollars) to film the movieThe Domestic Gross($M) column provides the amount of money (in Millions of dollars) a movie made within the United States of AmericaAnswer 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= 0Ha: p≠ 0p-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 295fx123Movie+Budgets+and+Box+Office+Earnin...Sample+-+Updated+Spring+2018%29+A+HomeCalibri (Body)Sheet1AInsert DrawMovieOnce Upon a Time in America13 Going On 304 Interrupted5 Artie Lange's Beer League6Force 10 from Navarone7Arthur8The Terminal9Jackass 3D10 Les Triplettes de Belleville11 The Gallows12 Frozen13 Shopgirl14 Chasseurs de dragons15 She's the One16Life17 Arnolds Park18 The Visitor19 Lunchtime Heroes20 Death Race21Hross i oss22 Muppets Most Wanted23The Ant Bully24 The Hurricane25La Cara Oculta26 Project Almanac27How Do You Know?28 The Mirror Has Two Faces29 A Charlie Brown Christmas30 The Runaways31 Tales from the Hood32333435363738394012YearB4E●●●Formulas196220111995196820012010200420121984201520161991199820111996200520102012200219722006200119952001199920162011199519992014DataсBudgetBIU SO201217.712524106020155552.930115175608.442063.748841324022120Review View25 75DDomestic Gross($M)0.14458300.251150.353483.48433113.44241275.5902867.30962863.408614090.1351912.4841863.65220663.8265696.0696051.1881942.51147617.01842212.795746130.058047234.77099614.33464523.4382536.4434427.0277620.0048035.3087071.200216322.7199440.017472QE70%Gene

Given that, Dependent variable (y) = domestic gross Independent variable (x) = budget Sample size…

Answered: Answer each of the following questions.…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.2: Representing Data

Problem 10PPS

See similar textbooks

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.)