Business Finance
Towson Developing a Multiple Regression Model Using Both Independent Variables Worksheet

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

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 45 45 $1.044,00 50 50 $914,00 50 50 $1.329,00 55 20 $1.330,00 55 20 $1.405,00 60 30 $1.436,00 60 30 $1.521,00 65 35 $1.741,00 65 35 $1.866,00 70 40 $1.717,00 70 40 The monthly sales for Yazici Batteries, Inc. are shown here: a. Forecast the sales using 2-month weighted moving average using weight values of 5 and 3. (10 points) Month January February March April May June July August September October November December Sales 20 21 15 14 13 16 17 18 20 20 21 23 Demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few The director of the medical services predicted that demand in year 1 would be 47 surgeries. a. Use Exponential Smoothing method and calculate forecasts with a smoothing constant of α = 0.40 to dev b. Use the Mean Squared Error (MSE) and Mean Absolute Percent Error (MAPE) and calculate the errors fo Year Heart Transplants 1 45 2 50 3 54 4 60 5 66 6 64 7 ---------------------- ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

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...

Prof_Axel (2263)
Purdue University

Anonymous
The tutor managed to follow the requirements for my assignment and helped me understand the concepts on it.

Anonymous
The tutor was knowledgeable, will be using the service again.

Anonymous
Awesome quality of the tutor. They were helpful and accommodating given my needs.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags