Please view to attached docs for more instructions. Please use attached template.
Imagine you are working in the marketing department of a company. Your supervisor assumes that if the
company spends more on digital advertisements it would lead to an increase in sales. In fact, she hopes
that doubling the budget for digital advertising will result in daily sales that are greater than $10,000. She
wants to solve the problem at hand and asks you to investigate. To verify this assumption, the marketing
department will raise the digital advertisement budget for a six-month period, then analyze the collected
data at the end of that period.
You collect monthly data from the past six months and then randomly sample 30 days. The results of your
sample and your calculations are shown in the Excel file provided in the assignment instructions.
Write a two to three (2–3) page report using the provided template in which you:
1. Construct a box-and-whisker plot for the daily sales.
2. Copy the sample mean, median, and standard deviation for the daily sales.
3. Copy the 95% Confidence Interval for the daily sales.
4. Conduct a hypothesis test to verify if the claim that the mean daily sales is greater than $10,000
is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.
5. Provide the following discussion based on the conclusion of your test:
a. If you conclude that the mean daily sales is greater than $10,000, provide three (3)
possible causes. Share marketing strategies that will support this upward trend the
company is experiencing.
Or
b. If you conclude that the claim of mean daily sales is not greater than $10,000 is not
supported or justified, provide a detailed explanation to your supervisor of how the
company can increase daily sales. Include marketing strategies that will support an
increase in daily sales. Include your speculation on the reason(s) behind the claim.