Marketing Assignment
For this submission, you will be given a series of scenarios and small collections of data. You should plot the data or calculate probabilities using excel. Then, you will create your own real or hypothetical scenario to graph and explain.
Answer the following:
• The mean temperature for the month of July in Boston, Massachusetts is 73 degrees Fahrenheit. Plot the following data, which represent the observed mean temperature in Boston over the last 20 years:
1. Is this a normal distribution? Explain your reasoning.
2. What is an outlier? Are there any outliers in this distribution? Explain your reasoning fully.
3. Using the above data, what is the probability that the mean will be over 76 in any given July?
4. Using the above data, what is the probability that the mean will be over 80 in any given July?
• A heatwave is defined as 3 or more days in a row with a high temperature over 90 degrees Fahrenheit. Given the following high temperatures recorded over a period of 20 days, what is the probability that there will be a heatwave in the next 10 days?
Day 193Day 288Day 391Day 486Day 592Day 691Day 790Day 888Day 985Day 1091Day 1184Day 1286Day 1385Day 1490Day 1592Day 1689Day 1788Day 1890Day 1988Day 2090
Customer surveys reveal that 40% of customers purchase products online versus in the physical store location. Suppose that this business makes 12 sales in a given day
Does this situation fit the parameters for a binomial distribution? Explain why or why not?
Find the probability of the 12 sales on a given day exactly 4 are made online
Find the probability of the 12 sales fewer than 6 are made online
Find the probability of the 12 sales more than 8 are made online
Your own example:
• Choose a company that you have recently seen in the news because it is having some sort of problem or scandal, and complete the following:
o Discuss the situation, and describe how the company could use distributions and probability statistics to learn more about how the scandal could affect its business.
o If you were a business analyst for the company, what research would you want to do, and what kind of data would you want to collect to create a distribution?
o Would this be a standard, binomial, or Poisson distribution? Why?
o List and discuss at least 3 questions that you would want to create probabilities for (e.g.,What is the chance that the company loses 10% of its customers in the next year?).
o What would you hope to learn from calculating these probabilities?
o Assuming that upper management does not see the value in expending the time and money necessary to collect data to analyze, make an argument (at least 100 words) convincing them that the expenditure is necessary and explaining some dangers the company could face by not knowing what the data predict.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Data.zip