Explore BrainMass

Statistics - Constructing a Histogram in Excel

This content was STOLEN from BrainMass.com - View the original, and get the 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 September 22, 2018, 7:25 am ad1c9bdddf - https://brainmass.com/statistics/histogram/statistics-constructing-histogram-excel-184645

Solution Summary

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