Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Ahmad works as a marketing analyst in ABC Company. He is trying to understand the behavior of sales for the new ABC shampoo over
1. Ahmad works as a marketing analyst in ABC Company. He is trying to understand the behavior of sales for the new ABC shampoo over time. A senior marketing analyst told Ahmad that he typically uses a Logistic Regression model to predict all Shampoo products. Ahmad did not listen and wanted to find out for him self. He collected sales data over the first 10 months and stopped, then collected data over the months 13 to 20. The data Ahmad collected are shown (Sales are in $000). Answer the following: Month 1 WN 2 3 st Month 13 14 15 16 17 18 19 20 Sales 8.4 10.2 13.2 16.0 20.4 21 24 30 33.3 35.3 Sales 44.8 45.1 45.6 45.7 45.7 46.2 46.7 47.0 Voor 000 5 6 7 9 10 1. For the data in the first 10 months, use Microsoft Excel and regression analysis to predict the mathematical relationship between Time and Sales. Provide the graph and proper mathematical equation. Comment on the goodness of fit. 2- For the data in the second table, use Microsoft Excel and regression analysis to predict the mathematical relationship between Time and Sales. Provide the graph and comment on the goodness of fit. (Use same X-Y Scale in both graphs). 3- Combine the two tables, ignoring missing values, and use the following equation (for which the parameters were estimated by trial and error). y = -0.11x2 + 3.6x +5.0 (1) Calculate the RP value and comment on the accuracy of this equation. 4- Use excel to create a trend line for the combined data. What is the equation of the trend line? Calculate R for this equation. What do you notice? What types of phenomena does this shampoo sales follow? (See Exhibit 2 in 'Response Models' additional-reading file). 5. In your opinion, was the senior marketing analyst right or wrong? 6- Project sales using Eqn. 1 to month 24 and notice when shampoo sales will start deteriorating below the level of $49,000, what do you think is the life cycle of this shampoo? In other words, how often should ABC Company come up with a new shampoo or modify the features of current one
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started