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
a. How many orders were placed?
b. What is the midpoint of the first class?
c. Draw a histogram.
Steps of drawing a Histogram are enumerated in the solution file.
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