Zookal
Zookal

We’d love to hear any feedback or comment from you!

© 2011-2021 Zookal Pty Ltd

View question and answer

From our collection of questions and answers
Math · Statistics And Probability
Question details

Question B:

Consider the following MS Excel partial output for the independent variable monthly Promo Expenditure ‘X’ (in 100s of dollars) and the monthly Demand ‘Y’ for a product’ (in 1000s of dollars)

Regression Analysis: Demand (in thousands of $) versus Promo Exp (in hundreds of $)

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error of the Estimate 6.03
Observations 8.00
ANOVA
df SS MS F
Regression 7181.54
Residual/ Error
Total 7 7399.50
Coefficients SE Coef/ Standard Error
Intercept 96.27 5.84
Promo Exp(X)/ Estimated slope 13.02 0.93

Please answer the following questions based on the above Excel output

1) What is the slope(b1) and what is its statistical interpretation ? (10 points)

2) Perform the test of hypothesis ( t-test) on the following, and state your statistical decision. Use α = 0.05. Please show all the relevant calculations.

(10 points)

H0 : β1 = 0

H1 : β1 ≠ 0

3) Perform the test of hypothesis (F-test) on the following, and state your statistical decision. Use α = 0.05. Please show all the relevant calculations.  

(10 points)

H0 : β1 = 0

H1 : β1 ≠ 0

4) What is the coefficient of determination (r2) i.e., percentage of variability in Demand explained by the independent variable Promo Expenditure? Please show all the relevant calculations. (10 points)

5) What is the value of the standard error of the estimate (SYX) in dollars (10 points)?

Answer
Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.

Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.