B C D E F G H I J2 EGR 1203 Introduction to Engineering4 File: Hist.xls5 Using Histograms in Microsoft Excel67 Histograms are used to graph the frequency of events according to the number of times8 that they occur in predefined ranges. In the example below, a histogram is used to9 graph the number of runners that cross the finish line in 1 minute intervals in a 5 km race.1011 Runner Time Upper12 Number (min) Bound Steps in creating the histogram:13 1 18.2 18 1) Enter the runner numbers and times in14 2 21.9 19 columns B and C15 3 25.5 20 2) Decide on the desired ranges and enter the16 4 24.4 21 upper bound for each17 5 27.9 22 3) Pick Tools - Data Analysis - Histogram18 6 20.0 23 from the main menu19 7 17.6 24 4) Fill out the histogram information as20 8 21.1 25 follows (also see screen capture below):21 9 23.3 26 Input Range : Specify runners' times22 10 24.4 27 Bin Range : Specify upper bound values23 11 25.8 28Output range : Pick the cell for the top24 12 19.8 left of the output (Bin/Freq Table)25 13 24.0 Chart Output : Check box for a graph26 14 23.8 Click OK and then Excel produces the 27 15 24.5 table and graph shown below.28 16 26.629 17 27.530 18 23.3 Bin Frequency31 19 22.8 18 232 20 22.1 19 133 21 26.1 20 334 22 19.7 21 035 23 18.0 22 236 24 22.7 23 337 25 23.9 24 538 25 339 26 227 228 2More 0Histogram of times for 5K
View Full Document
Unlocking...