Statistics and Graphical Displays

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.

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, mode, standard deviation, and range.(I already made a chart which is show right below thisquestion for this and answered it. I just need help with the restplease)

2. 	The Fruit Guys	Sunny Oranges	Tree Groves
   Mean	327	318	317.9
   Median	327.5	315	315
   Mode	350	315	290,320
   Standard Deviation	20.761	20.273	22.421
   Range	65	60	69
   Frequency	3270	3180	3179
   Relative Frequency	355	350	359

3. 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. (PLEASE DRAW THE CHARTS, THANKYOU!)
4. 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. (HELPPPPP PLEASEEEE!THANK YOU******)
   2. Charts to support your explanation.
5. Attach copies of the Excel pages or embed the Excel work inyour letter of response.