Question
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
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) put down the Interpretation of Regression statistics-table, ANOVA- table. put down an interpretation (by referring P-value/ t-stat) on significant effect of independent variables on sales.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667499e5c720c_605667499e5a5844.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667499e61f376_605667499e600c7d.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started