Explore BrainMass
Share

Statistics - Constructing a Histogram in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Ecocommerce.com, a large internet retailer, is studying the lead time (elapsed time between when an order is placed and when it is filled) for a sample of recent orders. The lead times are reported in days.
Lead Time (days) Frequency
0 up to 5 6
5 up to 10 7
10 up to 15 12
15 up to 20 8
20 up to 25 7
Total 40
a. How many orders were placed?
b. What is the midpoint of the first class?
c. Draw a histogram.

© BrainMass Inc. brainmass.com October 24, 2018, 11:12 pm ad1c9bdddf
https://brainmass.com/statistics/histogram/statistics-constructing-histogram-excel-184645

Solution Summary

Steps of drawing a Histogram are enumerated in the solution file.

$2.19
See Also This Related BrainMass Solution

Construct a histogram, a frequency polygon and an ogive for the frequency distribution given

Please help with the following problem. Provide the answer in Excel.

I'm confused on how to create a histogram in Excel. The first two columns (Class Interval and Frequency) were given by the book. I manually figured out Class Midpoint and Cumulative Frequency, and I don't understand how to get Relative Frequency.

The problem is asking to construct a histogram, a frequency polygon and an ogive for the frequency distribution given.

See attached file for full problem description.

View Full Posting Details