I. 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 weeks and stopped, then collected data over the weeks 11 to 20. The data Ahmad collected are shown (Sales are in 1000 JOD). Answer the following: Week Sales Week Sales 1 3.6 11 29.9 2 4.7 12 32.8 3 5.9 13 34.6 4 7.2 14 38.1 5 8.6 15 38.1 6 10.5 16 38.5 17 38.9 7 13.1 18 39.2 8 16.2 19 39.6 9 20.3 20 39.97 10 25.6 1- Considering the data of the first 10 weeks, use Microsoft Excel and regression analysis to fit the data to a linear model. Provide the graph and comment on the goodness of fit. 2- Considering the data in the second table, use Microsoft Excel and regression analysis to fit the data to a linear model. Provide the graph and comment on the goodness of fit. (Use same X-Y Scale in both graphs). 3- Combine the two tables and use excel to create a trend line for the combined data. Fit the data to a "Power Series Model" of the 4th order. 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). 4- Combine the two tables and use the following equation (for which the parameters were estimated by trial and error). x = 39 1+e-(-10-x) +2 Calculate the R value and comment on the accuracy of this equation. 5- In your opinion, was the senior marketing analyst right or wrong? 6- Project sales using Eqn. 1 to 40 weeks and notice when shampoo sales will reach saturation level, what is the potential market size?