EBTM 350

Towson University

EBTM

### Question Description

I’m studying for my Excel class and need an explanation.

Hi I have this midterm and I need help with it, please read instructions which are in the excel file.

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final Answer

Attached.

Develop a multiple regression model using both independent variables for predicting Sales. (2 points)

a. Write the linear equation in form of Y=m1X1+m2X2 + b. (3 points)

b. Explain the statistical significance of the model according to SignificanceF and significance of independe

c. According to the confidence intervals, what will be the lower and upper range of sales when Radio&TV a

Thousands of Thousands of

Sales ($1000)

Radio&TV ads Newspaper ads

$1.119,00

0

40

$973,00

0

40

$875,00

25

25

$625,00

25

25

$910,00

30

30

$971,00

30

30

$931,00

35

35

$1.177,00

35

35

$882,00

40

25

$982,00

40

25

$1.628,00

45

45

$1.577,00...