- Analyze the data for each company: frequency, relative frequency, mean, median, mode, standard deviation, and range. 10 points for the analysis of each company.
- You need to decide which statistics to compare to determine the overall lowest price and the least fluctuation.
- Create and include at least two charts that will be useful to best support your conclusions. Clearly label your graphs, including the title and axes.
- Write a brief informative letter in response to the request from ABC Grocery answering their request. Be sure to include in the letter:
- The company you are recommending
- What assumption(s) were made about the data provided in order to make your recommendation?
- A very detailed explanation of the data and the conclusions you came to.
- Use the statistics you calculated to make this decision. Specifically, show the details of the mean calculations for the three companies
- Use charts to support your explanation
- Attach copies of the Excel pages or embed the Excel work in your letter of response.