Answer to Question #339875 in Marketing for Msing

Question

Rashmi Dhar, manufacturer, and seller of ‘Kashmiri- kahwa’ through E-commers

websites. She wanted to know the effect of her spending in advertisement of ‘Kahwa’

Part 1) Define dependent and independent variables

Part 2) Write regression model equation only.

Part 3) Run regression analysis in EXCEL

Part 4) Write the Interpretation of Regression statistics-table, ANOVA- table.

Write an interpretation (by referring P-value/ t-stat) on significant effect of independent variables on sales. 

Sales of Kahwa (in INR)- 55328, 56251, 57126, 58739, 66984, 70676, 73206, 80571, 93168, 99432

Spending in advertise (in INR)- 5512, 8337, 8788, 8828, 9050, 10150, 11236,12538, 13161,13448

number of sales representatives (person)- 1, 1, 4, 5, 5, 7, 8, 8, 8, 9

customer-satisfaction ratings (1=highly dissatisfied to 5 = highly satisfied)- 1, 1, 1, 1, 2, 2, 2, 3, 3, 4