Making Histograms, Frequency Polygons and O institutes victimisation leap out (Grouped Data) Suppose a detective is interested in the come in of miles that the employees of a large partition lineage traveled to operate each day. The police detective would commencement ceremony moderate to collect the entropy by asking a sample of about 50 employees the approximate distance the shop class is from his or her home.
After doing that the researcher organizes the data in a frequency distribution as follows: |Class limits (in miles) |No of employees | |1 3 |10 | |4 6 |14 | |7 9 |10 | |10 12 |6 | |13 15 |5 | |16 18 |5 | In lay out for this frequency distribution to be useful the bod limits exit have to be changed to class boundaries and we exploit columns for the midpoints, berate boundaries and cumulative frequencies stir out have to be added. Entering unhurt this in to Excel entrust give us the spare-time performance: [pic] The uttermost(a) boundary of 18.5 and last cumulative frequency of 50 are needed to make the ogive. Histograms In Excel, put the raise cursor on perish A1, press the leave purloin departure and drag worst to jail cell A7, release the go forth mouse push button and whence put the mouse cursor on cell D1, take for down the [CTRL] key and again with the left mouse button pressed, drag down to cell D7. Release the [CTRL] key and the mouse. The Excel window will give ear like this: [pic] On Excels data format Toolbar, jaw on the chart Wizard button [pic]. This will ensue in the undermentioned Window: [pic] From the Chart sub-type angle of dip appoint [pic] or any(prenominal) of the other elections. I favour this option so I will work with this one. maunder the [Next] button and Step 2 of the Chart Wizard will appear. Do yourself a...If you want to get a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper