You have been hired as a consultant to determine who abc


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:

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 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

Solution Preview :

Prepared by a verified Expert
Basic Statistics: You have been hired as a consultant to determine who abc
Reference No:- TGS02901302

Now Priced at $20 (50% Discount)

Recommended (90%)

Rated (4.3/5)