Use NP_CASE DATA.xlsx as the data file. 1. Descriptive Statistics: (i) How many

Use NP_CASE DATA.xlsx as the data file.
1. Descriptive Statistics: (i) How many stores did we observe to evaluate sales of the new snack? (ii) What are the average sales of S1, S2 and S3? (iii) Can you explain the pattern of average sales of S1, S2 and S3? 2. Correlation Analysis: (i) Explain the reason we observe high correlations between S1, S2 and S3. (ii) Why do we observe negative correlations between price and sales? (iii) AD and Shelf POS have low correlations with Sales. What is your explanation? (iv) AD GRP is highly correlated to AD. Is it desirable? Why? (v) Store Size and AD is highly correlated in negative direction. Is it desirable? Why? [Optional question: Correlations among price, AD and POS are 0. Explain.]
3. Run a regression with S3 as the dependent variable and PRICE, AD, SHELF POS and STORE SIZE as independent variables. (i) Interpret the output. (ii) Which independent variables are significant? Are the results reasonable? (iii) Interpret the coefficients of PRICE, AD, STORE SIZE (and Shelf Pos). 4. Run a regression with S3 as DV and PRICE, AD and STORE SIZE as independent variables. Interpret the output. 5. From the model used in 4, run a regression using AD GRP instead of AD as an independent variable. Interpret the output. 6. Discussion: What is your overall conclusion? Are the marketing variables effective for sales? Main Results & Conclusion: Are the marketing variables effective for increasing sales? Addressed the objectives? (1) To determine the position (2) To estimate the first-year sales (3) To estimate the long-run potential of the product Please help me do the Discussion part 6, I already did part 1 to 5 already.