Below is the monthly sales data for Company Y over the course of the prior year. 2019
Fantastic news! We've Found the answer you've been seeking!
Question:
Below is the monthly sales data for Company Y over the course of the prior year.
2019 | Visitors To Website | Visitors That Purchased | Avg Order Amount |
Jan | 13,991 | 3,217 | $121 |
Feb | 13,711 | 2,938 | $107 |
Mar | 12,731 | 2,658 | $113 |
Apr | 12,731 | 3,078 | $121 |
May | 12,451 | 3,078 | $96 |
June | 13,571 | 3,637 | $121 |
July | 12,871 | 3,777 | $110 |
Aug | 14,550 | 4,477 | $98 |
Sept | 13,291 | 4,057 | $90 |
Oct | 13,431 | 3,357 | $94 |
Nov | 14,130 | 4,057 | $101 |
Dec | 13,851 | 4,337 | $112 |
- Create an appropriate Bar Chart for the Average Order Amount per Month.
- Calculate the mean for each of the three categories of data.
- Assuming the data is normally distributed, calculate the standard deviation of each of the three categories of data.
- Determine the overall probability that a visitor to the website will order. Explain your reasoning.
- Determine the probability that the company will sell at least its average monthly orders. Explain your reasoning.
- A marketing campaign estimates an ad buy will increase the probability of a visitor purchasing an order by 0.247%. Determine the probability that the company will sell at least its average monthly orders under this new marketing ad campaign.
- A marketing campaign estimates an ad buy will increase the probability of a visitor purchasing an order by 0.247%. Determine the probability that the company will sell at most 1.98% more average monthly orders under this new marketing ad campaign.
- Prepare a memo to your supervisor detailing the findings of your analysis. Include all applicable numbers, tables, charts, and graphs. Explain in detail.
Related Book For
Posted Date: