Answer to Question #338621 in Management for Man

Question

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

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

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