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.Com
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): You can put this solution on YOUR website!
.

Why we should read so many words ?

For what purpose ?


It is disrespect to readers to write and to post so long texts.



RELATED QUESTIONS

Rashmi Dhar, manufacturer, and seller of ‘Kashmiri - Kahwa’ through E-commerce... (answered by proyaop)
A fruit seller had the same number of apples and pears. After selling 82 apples and 34... (answered by richwmiller,josmiceli)
In testing a new drug, researchers found that 10% of all patients using it will have a... (answered by solver91311)
I need help finding values for logx and log2x, e^x and e^2x. And I need to plot the... (answered by scianci)
You are an online seller for a clothing manufacturer. You are paid a weekly salary, plus... (answered by ikleyn)
1. You are an online seller for a clothing manufacturer. You are paid a weekly salary,... (answered by ikleyn)
For the exponential function e^x and logarithmic function log x, graphically show the... (answered by Alan3354)
marietta bought 4½ of cloth for a dress which cost php55 per meter. She gave the seller. (answered by ikleyn)
For the exponential function e^x and logarithmic function log x, graphically show the... (answered by stanbon)