Answer to Question #342084 in Statistics and Probability for MJ3

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’ 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) 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

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

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order