Question

The owner of a movie theater company would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

Weekly Gross Revenue ($1,000s)	Television Advertising ($1,000s)	Newspaper Advertising ($1,000s)
96	5	1.5
91	2	2
95	4	1.5
93	2.5	2.5
95	3	3.3
94	3.5	2.3
94	2.5	4.1
94	3	2.5

(a)

Use α = 0.01 to test the hypotheses

H0:	β1 = β2 = 0
Ha:	β1 and/or β2 is not equal to zero

for the model

y = β₀ + β₁x₁ + β₂x₂ + ε,

where

x1	=	television advertising ($1,000s)
x2	=	newspaper advertising ($1,000s).

(A) Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

(B) Find the value of the test statistic. (Round your answer to two decimals places.)

p-value=

(C) Find the value of the test statistic. (Round your answer to two decimals places.)

p-value=

Answer 1

I have used excel to fit the regression and summary result--

Steps are --

Enter data>>Data>>Data Analysis>>Regression>>Enter Y and X range >>OK

The output of excel is ---

From above output,

A) For intercept,
Value of test statistic =85.76
P-Value=0

B) For Slope coefficient of Television,
Value of test statistic =1.82
P-Value=0.001

C) For Slope coefficient of newspaper,
Value of test statistic =0.98
P-Value=0.011

( Please give thumps up, if you like the answer)