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 S$1,$ S$2$ and S$3?$

$($iii$)$ Can you explain the pattern of average sales of S$1,$ S$2$ and S$3?$

$2.$ Correlation Analysis:

$($i$)$ Explain the reason we observe high correlations between S$1,$ S$2$ and S$3.$

$($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 S$3$ 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$).$

$($iv$)$ Do you think it is appropriate to use S$3$ as the DV$?$ Why or why not?

$4.$ Run a regression with S$3$ 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.$ What is your overall conclusion? Are the marketing variables effective for sales?

$($You may use the next slide as a guidance for your discussion.$)$

$9$

Discussion: What is your overall conclusion?

Are the marketing variables effective for sales?

$$ What are the main results?

$$ Does the analysis address the objectives of the research?

$(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

$$ Evaluate the regression analysis. What may be the strengths and

weaknesses?

$$ The most important k

$(3)$ To estimate the long$-$run potential of the product

$(4)$ To determine a better introductory plan for pricing and advertising

$$ Evaluate the regression analysis. What may be the strengths and

weaknesses?