Question: Please answer using excel! PROBLEM: REGRESSION ANALYSIS BELOW YOU ARE GIVEN WEEKLY SALES (15 WEEKS) OF OREO COOKIES AT WALMART YOU ARE ALSO TOLD FOR

Please answer using excel! PROBLEM: REGRESSION ANALYSIS BELOW YOU ARE GIVEN WEEKLYPlease answer using excel!

PROBLEM: REGRESSION ANALYSIS BELOW YOU ARE GIVEN WEEKLY SALES (15 WEEKS) OF OREO COOKIES AT WALMART YOU ARE ALSO TOLD FOR EACH WEEK IF THERE WAS A PRICE CUT AND / OR THE PRODUCT WAS ON DISPLAY. QUESTION: A) EXPLAIN HOW THE PRICE AND DISPLAY AFFECT OREO SALES ? (I.E., EXPALIN THE REGRESSION EQUATION) B) DURING A WEEK IN WHICH THE PRODUCT IS ON DISPLAY AND THE PRICE IS CUT YOU ARE 95% SURE THE SALES WILL BE BETWEEN AND Week Display Price cut On Display? No No Price Cut? No 1 0 No Sales 817 1150 886 817 713 769 1099 744 yes No No No No 0 0 yes No 5 0 0 0 1 0 1 0 1 0 0 BEBO V AWN 6 yes No 7 yes No 0 1 0 8 yes No 9 1150 1 yes No 0 0 881 780 No No 0 0 1 0 yes yes 13 No No yes No No 1 816 1120 763 857 1 1 0 14 15 yes No 0 0 PROBLEM: REGRESSION ANALYSIS BELOW YOU ARE GIVEN WEEKLY SALES (15 WEEKS) OF OREO COOKIES AT WALMART YOU ARE ALSO TOLD FOR EACH WEEK IF THERE WAS A PRICE CUT AND / OR THE PRODUCT WAS ON DISPLAY. QUESTION: A) EXPLAIN HOW THE PRICE AND DISPLAY AFFECT OREO SALES ? (I.E., EXPALIN THE REGRESSION EQUATION) B) DURING A WEEK IN WHICH THE PRODUCT IS ON DISPLAY AND THE PRICE IS CUT YOU ARE 95% SURE THE SALES WILL BE BETWEEN AND Week Display Price cut On Display? No No Price Cut? No 1 0 No Sales 817 1150 886 817 713 769 1099 744 yes No No No No 0 0 yes No 5 0 0 0 1 0 1 0 1 0 0 BEBO V AWN 6 yes No 7 yes No 0 1 0 8 yes No 9 1150 1 yes No 0 0 881 780 No No 0 0 1 0 yes yes 13 No No yes No No 1 816 1120 763 857 1 1 0 14 15 yes No 0 0

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 Finance Questions!