Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
★★★★★
3.45 Rating (171 Votes )
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