Question

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.

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

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 the overall lowest price and the least fluctuation. Create and include at least two charts that will be useful to best support your conclusions. (PLEASE DRAW THE CHARTS, THANK YOU!)
4. Write a brief informative letter in response to the request from ABC Grocery answering their request. Be sure to include:
   1. A very detailed explanation of the data and the conclusions you came to. You should use the statistics you calculated 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 in your letter of response.

Answer 1

a) From the given descriptive statistic, we know that Sunny Oranges has the approximately equal measure of central tendency with Tree Groves. These two company has smaller values of central tendency than the company Fruit Guys. Whereas, the values of the central tendency among these three companies, the company Sunny Oranges has a minimum in terms of standard deviation and range. So, the company Sunny Oranges have a minimum mean price together with less fluctuation. Hence, we will recommend the company Sunny Oranges to choose for supply.

b)

From the above box-plot, the company Sunny Oranges has the minimum central tendency value and less variability.

From the histogram of the price for three different companies, the sunny company has the most similar nature with the normal distribution than the remaining two companies.

From the above graphs, the Sunny company is the best for the supply.