Question

please help!

nework The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow Televison Weekly Gross Newspaper Advertising Reyenue Advertising ($1000s) ($1000s) ($1000s) 97 1.5 91 2.5 92 2.5 2.5 06 3.3 4. 94 3.5 2.3 2.5 5.2 95 4 2.5 a. Use a 0.01 to test the hypotheses H,:6 and/or B is not equal to zero for the model y Bo+Pa+h+,where z television advertising (1000s) newspaper advertising ($1000s) r Compute the F test statist c (to 2 decimals)Use F table What is the p-value? 256 PM è here to search What is the p-value? less than .01 What is your conclusion? The overall model is significant 0.05 to test the significance of Bi. Compute the t test statistic (to 2 decimals). Use t table. b. Use What is the p-value? less than .01 What is your conclusion? Significant relationship between television advertising and revenue Should 1 be dropped from the model? No, x1 should not be dropped from the model c. Use a 0.05 to test the significance of B2. Compute the t test statistic (to 2 decimals). Use t table. What is the p-value? less than .01 What is your conclusion? Significant relationship between newspaper advertising and revenue Should 2 be dropped from the model? No, x2 should not be dropped from the model e pe here to search

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.963675544
R Square	0.928670553
Adjusted R Square	0.900138775
Standard Error	0.654199266
Observations	8
ANOVA
	df	SS	MS	F	Significance F
Regression	2	27.8601166	13.93006	32.54864	0.001358852
Residual	5	2.139883399	0.427977
Total	7	30
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	83.59772656	1.439736981	58.06458	2.87E-08	79.89676483	87.2986883
X Variable 1	1.91267209	0.238822232	8.008769	0.00049	1.29876	2.52658418
X Variable 2	1.324848107	0.260262147	5.090437	0.003801	0.655822959	1.99387325

a. F test statistic 32.55 p value p - value less than 0.01 Since p-value< 0.01 so we The overall model is significant b. value of t test statistic 8.01 p - value p value less than 0.01 Since p value < 0.05 significant relationship between television advertising and revenue. Since B1 is significantly different from zero, No, should not be dropped from the model c. value of t test statistic p - value 0.0038 p - value less than 0.01 Since p value < 0.05 so we significant relationship between newspaper advertising and revenue. Since B2 is significantly different from zero, No, 2 should not be dropped from the model 0.0014 reject Ho at 1% level of significance and conclude that 0.0005 conclude that So we 5.09 conclude that