Answer:
97.60% of the variation in receipt per theater can be explained by the variation in Twitter activity
Explanation:
The coefficient of determination can be computed from the data
Movie Twitter Activity Receipts
The Devil Inside 219509 14763
The Dictator 6405 5796
Paranormal Activity 3 165128 15829
The Hunger Games 579288 36871
Bridesmaids 6564 8995
Red Tails 11104 7477
Act of Valor 9152 8054
Here twitter activity be the independent variable and Receipts be the response variable.
Using MS Excel for regression analysis
DATA>DATA ANALYSIS>REGRESSION
Selecting twitter activity as X variable and Receipts as Y variable. We get the following output
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.987916601
R Square 0.97597921
Adjusted R Square 0.971175052
Standard Error 35967.08167
Observations 7
ANOVA
df SS MS F Significance F
Regression 1 2.62805E+11 2.62805E+11 203.1530224 3.06274E-05
Residual 5 6468154818 1293630964
Total 6 2.69273E+11
Coefficients Standard Error t Stat P-value
Intercept -128751.8007 23384.79926 -5.505790293 0.002702573
Receipts 19.41414946 1.362092886 14.25317587 3.06274E-05
We can see that R Square=0.97597921, So the 97.6% of variation in Receipts is explained by its linear relationship with twitter activity or we can say that 97.60% of the variation in receipt per theater can be explained by the variation in Twitter activity.