Reference no: EM132107847

Project 1 - Descriptive Statistics and Graphical Displays

Valencia Orange Price Comparison

You have been hired as a consultant to determine who ABC Grocery Store should be ordering Valencia Oranges from.

To: Statistician

From: ABC Grocery Store

Please advise us on which company to use as our orange distributor. Three highly recommended distributors have provided us with statistical data on the weekly prices for one load of Valencia oranges per week for a ten-week period last year. Prices fluctuate according to availability, and we would like to use the company with the lowest overall price and the least amount of fluctuation. We would like your written report showing your results and a detailed recommendation as to which company we should choose.

Thank you.

Here are the prices, listed as price in dollars per crate:

You must type in and analyzethedata for each company.

Analyze the data for each company:

Frequency:

Relative frequency:

Mean:

Median:

Mode:

Standard deviation:

Range:

Use this information to calculate and complete either a relative or percent frequency chart.

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.

Write a brief informative letter in response to the request from ABC Grocery answering their request. Be sure to include:

A very detailed explanation of the data and the conclusions you came to. You should use thestatistics you calculated to make this decision.

Charts to support your explanation.

Attach copies of the Excel pages or embed the Excel work in your letter of response