Answer to Question #331463 in Statistics and Probability for Maham

Question

Rashmi Dhar, manufacturer, and seller of ‘Kashmiri – Kahwa’ through E-commerce 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) Run regression analysis in EXCEL

Part 2) Write the interpretation of Regression statistics-table, ANOVA-table.

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

Kathau

73206

11236

8

2

Baramula

80571

12538

8

3

Bandipore

93168

13161

8

3

Srinagar

99432

13448

9

4