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: Week 2 1 2 3 4 5 6 7 8 9 10 The Fruit Guys 350 350 310 330 340 290 305 315 325 355 Sunny Oranges 345 295 325 315 290 305 300 315 340 350 Tree Groves 345 340 310 290 305 290 320 320 300 359 4. Write a brief informative letter in response to the request from ABC Grocery answering their request. Be sure to include: a. A very detailed explanation of the data and the conclusions you came to. You should use the statistics you calculated to make this decision. b. Charts to support your explanation. (30 points20 for correct conclusion written as RESPONSE LETTER, 10 for providing supporting details) 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: Week 2 1 2 3 4 5 6 7 8 9 10 The Fruit Guys 350 350 310 330 340 290 305 315 325 355 Sunny Oranges 345 295 325 315 290 305 300 315 340 350 Tree Groves 345 340 310 290 305 290 320 320 300 359 4. Write a brief informative letter in response to the request from ABC Grocery answering their request. Be sure to include: a. A very detailed explanation of the data and the conclusions you came to. You should use the statistics you calculated to make this decision. b. Charts to support your explanation. (30 points20 for correct conclusion written as RESPONSE LETTER, 10 for providing supporting details)
