Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

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.] 8 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: Next page. 9 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 (4) To determine a better introductory plan for pricing and advertising Evaluation of the metho

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Techniques in Business and Economics

Authors: Douglas A. Lind, William G Marchal

17th edition

1259666360, 978-1259666360

More Books

Students also viewed these Mathematics questions