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' on the sales, along with the other factors; 'number of sales representatives', 'customer-satisfaction ratings'. For this research she has gathered the sales data in the following table, along with other necessary information. Part 1) Define dependent and independent variables Part 2) Write regression model equation only. Part 3) Run regression analysis in EXCEL (copy all those tables from EXCEL and paste them in your document). Part 4) put down the Interpretation of Regression statistics-table, ANOVA- table. put down an interpretation (by referring P-value/ t-stat) on significant effect of independent variables on sales.

Region/ Sales of Spending in number of sales customer-satisfaction Districts Kahwa (in advertise (in INR) representatives ratings (1=highly INR) (person) dissatisfied to 5 = highly satisfied Kupwara 55328 5512 Badgam 56251 8337 Leh-ladakh 57126 8788 Kargil 58739 8828Region/ Sales of Spending in number of sales customer-satisfaction Districts Kahwa (in advertise (in INR) representatives ratings (1=highly INR) (person) dissatisfied to 5 = highly satisfied Punch 66984 9050 UI 2 Rajouri 70676 10150 7 2 Kathua 73206 1 1236 2 Baramula 80571 12538 3 Bandipore 93168 13161 3 Srinagar 99432 13448 A