Question: 1) Please find the partially completed multiple regression analysis below, whichexplores the relationship between the sales (in hundreds) and the independentvariables price(in dollars), promotional expenditure(in

1)Please find the partially completed multiple regression analysis below, whichexplores the relationship between the sales (in hundreds) and the independentvariables price(in dollars), promotional expenditure(in hundreds of dollars) and the quality score ( 0-100) for a very popular Christmas season toy.

The regression equation is

Sales = 343.2 - 0.23* Price + 2.7* Promotional exp + 0.22* Quality

PredictorCoefStandard Error/ SE CoefTPVIF

Constant343.2062.59

Price-0.233580.0373 2.415

Promotional exp2.7041.4 1.047

Quality0.22040.1429 10.387

R-Sq=

Analysis of Variance

SourceDFSSMSF

Regression2847.78

Residual Error

Total153933.40

Answer questions A - F based on the above analysis

A) Is the factorPromotional Expsignificant at=0.05 ? Perform the test of hypothesis and show all the relevant calculations.

B)Construct a 95% confidence interval estimate of the population slope of sales withQualityshowing all the relevant calculations and also state whether 'Quality'is a significant factor in predicting sales.

C) What is the value of the partial F test statistic (F_STAT) for the independent variable'Price'(show all the relevant calculations)?

D) Is there a problem withmulti-collinearityamong independent variables in this analysis? Explain.

E) What is theadjusted R²value?(show all the relevant calculations)

F) Based on the ANOVA presented, perform theoverall F- testshowing all the relevant calculationsand alsostate if the regression is significant? (=0.05)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Is the factor promotional exp significant at a=.05? Perform the test of hypothesis. 1) Please find the partially completed multiple regression analysis below, which explores the relationship between...

**Must be answered by 4:20pm today, December15, thank you!** 1) Please find the partial multiple regression analysis performed to explore the relation between the sales (in hundreds) and the...

Page 1 > of 2 - ZOOM + Press Esc to exit full screen Price ($) Promotional Exp ($K) Location Store Size (Sq.Ft) Sales($K) 949 5 1 5,500 168 941 3.5 1 5,200 150 934 4.8 1 5,400 168 921 3.6 1 4,750 14...

Please consider the data presented above for the monthly sales of Ever-cool brand of refrigerators in 1,000s of dollars (Dependent Variable) and the four independent variables. Independent variables...

Store Size Price ($) Promotional Exp (SK) Location Sales(SK) (Sq.Ft) 949 5 1 6,500 168 941 3.5 5,200 150 934 4.8 6,400 168 921 3.6 4,750 148 915 4.3 5,250 152 909 4.7 1 6,000 162 904 4.5 1 6,000 160...

Please explain in excel and show the method how it is done. Sales(K 168 150 168 148 152 162 160 123 130 116 142 145 134 128 PricelS) Promotional exp(K) Quality City1/su 100 949 941 934 921 915 909...

Department of Economics Ohio Wesleyan University Delaware, OH Economics 251 Research Methods Fall 2015 Daniel Kidane Midterm Exam II This exam is 50 points and will count 15% of your final grade. It...

The following is the partial printout of problem "The Fresh Detergent Case": Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more...

How are bidirectional influences between parent and child involved in the impact of malnutrition on psychological development? After her adoption, how did those influences change for Grace?

What challenges in the U.S. cultural environment do you expect Fiat to face as it uses its Chrysler connection to compete in the American car market? What management challenges will Marchionne face...

Question 6 An 8 year old child is in need of immediate intubation and MV . Which of the following ETT sizes would you select for this patient? 4 . 0 mm 5 . 0 mm 6 . 0 mm 7 . 0 mm

Mr. Mohammed is working as a Vice President - Finance in Suhail Bahwan Group of Companies. After 3 months of his appointment he found, many finance related problems that are faced by treasurer and...