Descriptive Statistics and GraphicalDisplays

Valencia Orange Price Comparison

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

To: Statistician

From: ABC Grocery Store

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

Thank you.

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

Week	The Fruit Guys	Sunny Oranges	Tree Groves
1	350	345	345
2	350	295	340
3	310	325	310
4	330	315	290
5	340	290	305
6	290	305	290
7	305	300	320
8	315	315	320
9	325	340	300
10	355	350	359

You must type in and analyze the data for each company.

Helpful directions:

1. Analyze the data for each company: frequency, relativefrequency, mean, median,******* (ONLY complete the mode,standard deviation and range because below I am going to list myanswers for the frequency, relative frequency, mean andmedian)
2. You need to decide which statistics to compare to determine theoverall lowest price and the least fluctuation. Create and includeat least two charts that will be useful to best support yourconclusions.
3. Write a brief informative letter in response to the requestfrom ABC Grocery answering their request. Be sure to include:
   1. A very detailed explanation of the data and the conclusions youcame to. You should use the statistics youcalculated to make this decision.
   2. Charts to support your explanation.
4. Attach copies of the Excel pages or embed the Excel work inyour letter of response.