To study how social media may influence the products consumers buy, researchers collected the opening weekend box office revenue (in millions of dollars) for 23recent movies and the social media message rate(average number of messages referring to the movie per hour). The data are available below. Conduct a complete simple linear regression analysis of the relationship between revenue (y) and message rate (x).
To study how social media may influence the products consumers buy, researchers collected the opening weekend box office revenue (in millions of dollars) for
2323
recent movies and the social media message rate(average number of messages referring to the movie per hour). The data are available below. Conduct a complete simple linear regression analysis of the relationship between revenue (y) and message rate (x).
To study how social media may influence the products consumers buy, researchers collected the opening weekend box office revenue (in millions of dollars) for
2323
recent movies and the social media message rate(average number of messages referring to the movie per hour). The data are available below. Conduct a complete simple linear regression analysis of the relationship between revenue (y) and message rate (x).
Message Rate |
Revenue ($millions) |
||
---|---|---|---|
1363.2 |
146 |
||
1219.2 |
79 |
||
681.2 |
67 |
||
583.6 |
37 |
||
454.7 |
35 |
||
413.9 |
34 |
||
306.2 |
21 |
||
289.8 |
18 |
||
245.1 |
18 |
||
163.9 |
17 |
||
148.9 |
16 |
||
147.4 |
15 |
||
147.3 |
15 |
||
123.6 |
14 |
||
118.1 |
13 |
||
108.9 |
13 |
||
100.1 |
12 |
||
90.3 |
11 |
||
89.1 |
6 |
||
70.1 |
6 |
||
56.2 |
5 |
||
41.6 |
3 |
||
8.4 |
1 |
Message Rate |
Revenue ($millions) |
||
---|---|---|---|
1363.21363.2 |
146146 |
||
1219.21219.2 |
7979 |
||
681.2681.2 |
6767 |
||
583.6583.6 |
3737 |
||
454.7454.7 |
3535 |
||
413.9413.9 |
3434 |
||
306.2306.2 |
2121 |
||
289.8289.8 |
1818 |
||
245.1245.1 |
1818 |
||
163.9163.9 |
1717 |
||
148.9148.9 |
1616 |
||
147.4147.4 |
1515 |
||
147.3147.3 |
1515 |
||
123.6123.6 |
1414 |
||
118.1118.1 |
1313 |
||
108.9108.9 |
1313 |
||
100.1100.1 |
1212 |
||
90.390.3 |
1111 |
||
89.189.1 |
66 |
||
70.170.1 |
66 |
||
56.256.2 |
55 |
||
41.641.6 |
33 |
||
8.48.4 |
11 |
The least squares regression equation is
y=−0.031+ 0.086x. (Round to three decimal places as needed.)
Check the usefulness of the hypothesized model. What are the hypotheses to test?
A.H0:β1≠0 against Ha:β1=0
B.H0:β0=0 against Ha:β0≠0
C.H0:β0≠0 against Ha:β0=0
D.H0:β1=0 againstHa:β1≠0 Your answer is correct.
Determine the estimate of the standard deviation.
s=9.59(Round to two decimal places as needed.)
What is the test statistic for the hypotheses?
t=15.14 (Round to two decimal places as needed.)
What is the p-value for the test statistic?
p-value=0 (Round to three decimal places as needed.)State the conclusion at α=0.05.
Since the p-value is less than α, there is sufficient evidence to reject H0.
Conclude there is a linear relationship between revenue and message rate.What is the value for the coefficient of determination r2?
r2=_____(Round to two decimal places as needed.).
|
Let's use excel:
Step 1) First enter the given data set in excel columns.
Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK
Step 3) Input Y Range: Select the data of column "B"
Input X Range: Select the data of column "A" .
Click on Labels:
then Click on Output Range
Look the following Image
Then Click on OK, we get following result.
From the above output the p-value and R2 are as follows:
p-value = 0.000
R2 = 0.916
To study how social media may influence the products consumers buy, researchers collected the opening weekend...
To study how social media may influence the products consumers buy, researchers collected the opening weekend box office revenue (in millions of dollars) for 23 recent movies and the social media message rate(average number of messages referring to the movie per hour). The data are available below. Conduct a complete simple linear regression analysis of the relationship between revenue (y) and message rate (x) Message Rate Revenue ($millions) 1363.2 146 1219.2 79 681.26 67 583.6 37 454.7 35 413.9 34...
Please open Tweets data. The data is related to Opening weekend box office revenue (in millions of dollars) for a sample of 23 movies, along with each movies tweet rate (in thousands). Tweet rate is defined as the average number of tweets (at twitter.com) referring to the movie per hour 1, one week prior to the movie's release. Suppose that a film production company in Hollywood collected this data and they request you to analyze data with following steps: 1....
Online Trailer Views (millions) Opening Weekend Box Office Gross ($millions) 55.111 34.124 9.416 6.181 7.71 5.578 5.895 23.917 83.065 102.533 32.862 62.143 24.105 19.96 5.005 9.721 4.986 11.059 45.03 34.715 10.232 20.686 25.461 17.497 2.238 3.926 55.386 149.481 4.512 9.113 11.469 12.88 11.472 2.08 1.666 1.816 0.792 0.4 3.985 4.444 3.476 1.652 10.421 1.069 33.085 99.151 1.386 3.904 5.535 9.989 6.637 13.392 55.098 46.803 4.953 3.993 28.861 15.018 4.282 5.937 11.836 9.929 60.033 44.189 82.933 176.137 4.346 7.222 33.811 61.791...