Answer to Question #336154 in Statistics and Probability for Tina

Question

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