Question
Instructions 1. Open the Excel File Module 6 Excel Assignment. 2. On Sheet 1, you will find measurements for wait times for a bus. Use
Instructions | |
1. Open the Excel File Module 6 Excel Assignment. 2. On Sheet 1, you will find measurements for wait times for a bus. Use Excel functions to find and label the maximum value in the data set. Use Excel functions to find and label the minimum value in the data set. Use the Max and Min value to construct appropriate bins for the data. (Remember, it's often to have 5~6 bins. One way to find the bins is to start by finding the range and dividing by 5 or 6. This will give you the bin width. Now, pick your lowest bin to be just a bit higher than your minimum value. Next, let your bins go up by the bid width that you calculated a moment before. Keep going until you reach a bin that is higher than your maximum data value. At this point, you have all of your bins.) Use Excel (through Data Analysis in the Data Tab) to construct a frequency table for this data. Construct a Histogram for this Data. Use the Frequency information for the Legend Entries and use the bin values for the Horizontal Axis. Make sure the horizontal and vertical axes have labels (not the word bin) and that the bars touch. |
To improve bus line efficiency, a representative of the bus company measured the wait time of customers at a certain bus stop. | |
The measurements are shown below and are given in minutes. |
2.219088129 |
2.57783286 |
0.429037784 |
1.963100823 |
2.719013823 |
0.362836692 |
4.704396738 |
8.910699206 |
5.361205155 |
3.237827625 |
20.08934072 |
1.006592405 |
7.900734068 |
2.244429938 |
0.588048049 |
8.597001651 |
0.349486704 |
0.38636226 |
7.216524578 |
0.808047614 |
19.455939 |
2.85957525 |
2.236174285 |
5.558436841 |
2.325148901 |
1.680580865 |
3.082726607 |
1.960141359 |
10.02171464 |
3.575685818 |
6.943034303 |
0.229423776 |
4.436785208 |
6.480023713 |
9.505145281 |
1.182438257 |
5.214930803 |
0.328711172 |
5.827575737 |
2.123761548 |
6.248261988 |
3.276640346 |
1.627916113 |
0.559758899 |
1.481756698 |
0.565706628 |
3.197987635 |
2.637515748 |
2.720592238 |
0.468634937 |
4.341491736 |
1.247272957 |
3.022066792 |
1.118781143 |
6.111083668 |
6.985227337 |
0.931839109 |
1.160990498 |
7.785765182 |
2.167324633 |
3.064478351 |
0.790370727 |
0.302471562 |
4.240317843 |
0.887068787 |
3.584711477 |
3.334608909 |
0.759528354 |
0.907847031 |
0.434687879 |
3.964930097 |
6.38442052 |
0.761957301 |
1.361051224 |
3.515009479 |
4.481977631 |
3.213076567 |
1.304748743 |
0.012531133 |
2.727002811 |
3.845676343 |
5.908688303 |
2.748389171 |
2.689179619 |
1.384404588 |
1.552839766 |
0.214746125 |
1.310943417 |
2.733389717 |
1.398042275 |
1.868718559 |
4.572257016 |
1.435762298 |
6.978186605 |
1.310062167 |
4.60782414 |
2.420904768 |
1.633378397 |
2.152699553 |
1.186577391 |
3.177042921 |
5.955325141 |
0.00948099 |
0.023738181 |
0.569505138 |
8.759566587 |
0.035820897 |
8.824413592 |
6.627626761 |
2.748593843 |
0.276654685 |
3.517134733 |
1.663580257 |
4.741507904 |
0.49026866 |
3.721976467 |
7.104130581 |
0.832603472 |
2.16298542 |
0.25310656 |
1.01200634 |
1.122429632 |
0.482555468 |
2.045815445 |
10.06497334 |
0.125343956 |
0.534745258 |
0.237620616 |
2.087044241 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started