Conduct an analysis to examine the impact of items, type of…

QuestionConduct an analysis to examine the impact of items, type of…Conduct an analysis to examine the impact of items, type of customer, and method of payment on net sales.  Use the results to answer questions 27-30, Use Minitab or Excel. 27. Assuming the regression equation for this set of variables met all conditions and was usable, what is the predicted value of sales for a promotional customer purchasing 3 items using the proprietary credit card?  Answer using two decimal places._________________________________________________ 28. Explain multicollinearity and its effects of it on a multiple linear regression analysis.______________________________________________________________________________________________ 29. Is there an issue with multicollinearity in this analysis? Be specific.  Cut and paste or upload the Minitab output or include the specific information from the output you are using in your assessment of multicollinearity. _______________________________________________________________________________________________ 30. What steps would you take next to get to the best regression model? Be specific using the variables from this example._______________________________________________________________________________________________ Data set is listed below:Customer Store location Type of Customer Items Net Sales Method of Payment Gender Marital Status Age1 A Regular 1 $39.50 Discover Male Married 322 B Promotional 1 $102.40 Proprietary Card Female Married 363 B Regular 1 $22.50 Proprietary Card Female Married 324 A Promotional 5 $100.40 Proprietary Card Female Married 285 C Regular 2 $54.00 MasterCard Female Married 346 A Regular 1 $44.50 MasterCard Female Married 447 A Promotional 2 $78.00 Proprietary Card Female Married 308 A Regular 1 $22.50 Visa Female Married 409 B Promotional 2 $56.52 Proprietary Card Female Married 4610 A Regular 1 $44.50 Proprietary Card Female Married 3611 C Regular 1 $29.50 Proprietary Card Female Married 4812 C Promotional 1 $31.60 Proprietary Card Female Married 4013 B Promotional 9 $160.40 Visa Female Married 4014 B Promotional 2 $64.50 Visa Female Married 4615 B Regular 1 $49.50 Visa Male Single 2416 A Promotional 2 $71.40 Proprietary Card Male Single 3617 A Promotional 3 $94.00 Proprietary Card Female Single 2218 C Regular 3 $54.50 Discover Female Married 4019 B Promotional 2 $38.50 MasterCard Female Married 3220 A Promotional 6 $44.80 Proprietary Card Female Married 5621 C Promotional 1 $31.60 Proprietary Card Female Single 2822 A Promotional 4 $70.82 Proprietary Card Female Married 3823 B Promotional 7 $266.00 American Express Female Married 5024 C Regular 2 $74.00 Proprietary Card Female Married 4225 C Promotional 2 $39.50 Visa Male Married 4826 B Promotional 1 $30.02 Proprietary Card Female Married 6027 A Regular 1 $44.50 Proprietary Card Female Married 5428 B Promotional 5 $192.80 Proprietary Card Female Single 4229 B Promotional 3 $71.20 Proprietary Card Female Married 3230 C Promotional 1 $18.00 Proprietary Card Female Married 7031 C Promotional 2 $63.20 MasterCard Female Married 2832 A Regular 1 $75.00 Proprietary Card Female Married 5233 B Promotional 3 $63.20 Proprietary Card Female Married 4434 C Regular 1 $40.00 Proprietary Card Female Married 3435 A Promotional 5 $105.50 MasterCard Female Married 5636 C Regular 1 $29.50 MasterCard Male Single 3637 C Regular 2 $102.50 Visa Female Single 4238 B Promotional 6 $117.50 Proprietary Card Female Married 5039 A Promotional 5 $13.23 Proprietary Card Female Married 4440 B Regular 2 $52.50 Proprietary Card Female Married 5841 A Promotional 13 $198.80 Proprietary Card Female Married 4242 B Promotional 4 $19.50 Visa Female Married 4643 A Regular 2 $123.50 Proprietary Card Female Married 4844 A Promotional 1 $62.40 Proprietary Card Female Married 5445 C Promotional 2 $23.80 Proprietary Card Female Married 3846 C Promotional 2 $39.60 Proprietary Card Female Married 6047 A Regular 1 $25.00 MasterCard Female Married 4648 A Promotional 3 $63.64 Proprietary Card Female Married 3049 A Promotional 1 $14.82 Proprietary Card Female Married 3250 B Promotional 9 $145.20 MasterCard Female Married 4651 A Promotional 6 $176.62 Proprietary Card Female Married 3852 C Promotional 5 $118.80 Proprietary Card Male Married 6853 A Regular 1 $58.00 Discover Female Single 7854 C Regular 2 $74.00 Visa Female Single 2055 B Regular 2 $49.50 MasterCard Female Married 3256 B Promotional 3 $141.60 Proprietary Card Female Married 3857 B Promotional 6 $123.10 Proprietary Card Female Married 5458 C Promotional 2 $80.40 Proprietary Card Female Married 4859 B Promotional 4 $65.20 MasterCard Female Married 4660 A Promotional 4 $113.00 Proprietary Card Female Single 5061 A Promotional 1 $108.80 Proprietary Card Female Married 4662 A Promotional 3 $59.91 Proprietary Card Female Single 3063 B Promotional 5 $53.60 Proprietary Card Female Married 5464 A Promotional 1 $31.60 Proprietary Card Female Single 4265 A Promotional 2 $49.50 Proprietary Card Female Married 4866 B Promotional 1 $39.60 Proprietary Card Female Married 6267 C Promotional 2 $59.50 Proprietary Card Female Married 3468 A Promotional 5 $146.80 Proprietary Card Female Married 2869 A Promotional 2 $47.20 Proprietary Card Male Married 4670 B Promotional 8 $95.05 Proprietary Card Female Married 5471 C Promotional 5 $155.32 Proprietary Card Female Married 3072 A Promotional 4 $58.00 MasterCard Female Married 3273 C Regular 1 $69.00 Proprietary Card Female Single 2274 A Promotional 2 $46.50 Proprietary Card Female Married 3275 B Promotional 2 $45.22 Proprietary Card Female Married 7476 B Promotional 4 $84.74 Proprietary Card Female Married 6277 B Regular 2 $39.00 Proprietary Card Female Married 4278 A Promotional 4 $111.14 Proprietary Card Female Married 2879 A Promotional 3 $86.80 Proprietary Card Female Married 3880 B Regular 2 $89.00 Discover Female Married 5481 C Promotional 2 $78.00 MasterCard Female Married 6882 B Promotional 6 $53.20 Proprietary Card Female Single 3083 A Promotional 4 $58.50 Visa Female Married 3684 C Promotional 3 $46.00 Proprietary Card Female Married 4485 B Regular 2 $37.50 Visa Female Married 4486 B Promotional 1 $20.80 Proprietary Card Female Married 6287 C Regular 6 $144.00 MasterCard Female Single 4888 C Regular 4 $107.00 Proprietary Card Female Married 3689 C Promotional 1 $31.60 Proprietary Card Female Single 2090 C Promotional 6 $57.60 Proprietary Card Female Married 4291 B Promotional 4 $95.20 Proprietary Card Female Married 5492 A Promotional 1 $22.42 Proprietary Card Female Married 5493 B Regular 5 $159.75 Proprietary Card Female Married 7294 A Promotional 17 $229.50 Proprietary Card Female Married 3095 A Regular 3 $66.00 American Express Female Married 4696 C Regular 1 $39.50 MasterCard Female Married 4497 C Promotional 9 $253.00 Proprietary Card Female Married 3098 C Promotional 10 $287.59 Proprietary Card Female Married 5299 A Promotional 2 $47.60 Proprietary Card Female Married 30100 B Promotional 1 $28.44 Proprietary Card Female Married 44MathStatistics and ProbabilitySTATISTICS 501Share Question