1. Ahmad works as a marketing analyst in ABC Company. He is trying to understand the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 S000). Answer the following: Month 1 2 3 4 5 56700 8 9 10 Sales 8.4 10.2 13.2 16.0 20.4 21 24 30 33.3 35.3 Month 13 14 15 16 17 18 19 20 Sales 44.8 45.1 45.6 45.7 45.7 46.2 46.7 47.0 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.11x² + 3.6x +5.0 .....(1) Calculate the R² 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. I 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? 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 S000). Answer the following: Month 1 2 3 4 5 56700 8 9 10 Sales 8.4 10.2 13.2 16.0 20.4 21 24 30 33.3 35.3 Month 13 14 15 16 17 18 19 20 Sales 44.8 45.1 45.6 45.7 45.7 46.2 46.7 47.0 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.11x² + 3.6x +5.0 .....(1) Calculate the R² 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. I 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?
Expert Answer:
Answer rating: 100% (QA)
actual prodcect was mancifaciied and the raw material conscursed ... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
A real estate agent is trying to understand the pricing of homes in her area, a region in the United States comprising small to midsize towns and a small city. For each of 1200 homes recently sold in...
-
The new University president is trying to understand the Universitys finances. Classify each of the following costs as direct costs or indirect costs of operating the Universitys College of Business:...
-
A real estate agent is trying to understand the pricing of homes in her area, a region comprised of small to midsize towns and a small city. For each of 1200 homes recently sold in the region, the...
-
Sung Corporation, a clothing retailer, engaged in the transactions listed in the first column of the table below. Opposite each transaction is a ratio and space to mark the effect of each transaction...
-
Return to the facts of problem 40. Assume that Judith is an individual taxpayer. What is the effect of the capital asset transactions on Judiths taxable income? Compare this result with the result in...
-
Matsumura Dairy began operations on April 1, 2019, with the purchase of 200 milking cows for 6,700,000. It has completed the first month of operations and has the following information for its...
-
Refer to the data for E5-16A. However, instead of the FIFO method, assume Austins Jewelers uses the average cost method. Requirements 1. Prepare a perpetual inventory record for the watches on the...
-
Butler Manufacturing Corporation raised capital for a plant expansion by borrowing from a bank and making a stock offering. Butler engaged Weaver, CPA, to audit its December 2014 financial...
-
Projects with a positive net present value (NPV) are economically feasible. Compute the NPV of the two (2) systems below. Use 8% interest yield. Project completion time Expected useful life of system...
-
Julio and Milania are owners of Falcons Corporation, an S corporation. They each own 50 percent of Falcons Corporation. In year 1, Julio and Milani received distributions of $20,000 and $10,000,...
-
Suppose a firm the firm's initial costs when hiring a worker include hiring and training costs of $50. The wage rate for each period of employment is W t =$100 (the same for all periods), and the...
-
Which account type is used to record bad debt estimation and is a contra account to Accounts Receivable?
-
Briefly explain why it is useful for us to be able to approximate the binomial and Poisson distributions by using a normal distribution. Explain how we make this approximation.
-
A name-brand TV dinner boasts that its pot roast has no more than 120 calories per serving. Suppose 95% of the servings of this product actually contain fewer than 120 calories. Find the probability...
-
Construct a tally table for the closing stock prices Close column. Use 1,000- point intervals beginning with 3011,300, 1,3012,301, etc. Use the following prices of Swiss stocks to answer question....
-
JD is a member in the Canyons North limited liability company. The LLC has opted to be treated as a partnership for federal income tax purposes. At the beginning of the taxable year, JDs basis in her...
-
2.) A 1200-mH inductor is connected in series with a 200-k2 resistor. This network can be either connected to or disconnected from a 25-V battery through the action of a switch. When the network is...
-
1. True or False. Pitfalls to consider in a statistical test include nonrandom samples, small sample size, and lack of causal links. 2. Because 25 percent of the students in my morning statistics...
-
LP models are used by many Wall Street firms to select a desirable bond portfolio. The following is a simplified version of such a model. A company is considering investing in four bonds; $1 million...
-
A food company produces two types of turkey cutlets for sale to fast-food restaurants. Each type of cutlet consists of white meat and dark meat. Cutlet 1 sells for $4 per pound and must consist of at...
-
The file S02_16.xlsx contains traffic data from 256weekdays on four variables. Each variable lists the number of vehicle arrivals to a tollbooth during a specific five-minute period of the day. a....
-
Explain the limitations that auditors face when they perform the attest function.
-
Indicate whether you think the following third-party groups would normally represent a (1) primary beneficiary, (2) foreseen party, or (3) foreseeable party. Give reasons for your answers. a. A...
-
Use and Dispose Company was organized to manufacture and sell inexpensive golf clubs that can be used during the golf round and then thrown away at the end of the round. In order to keep the business...
Study smarter with the SolutionInn App