SOLUTION: 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 sal
Algebra ->
Probability-and-statistics
-> SOLUTION: 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 sal
Log On
Question 1194475: 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
553
5512
1
1
Badgam
56251
8337
1
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
(10 Marks) Answer by ikleyn(52781) (Show Source):
