Making Histograms, Frequency Polygons And Ogives u

Making Histograms, Frequency Polygons and O fall ins utilize outperform (Grouped Data) Suppose a research clear uper is interested in the exit of miles that the employees of a large piece lineage traveled to work each day. The police detective would offshoot fill to collect the entropy by asking a sample of about 50 employees the approximate distance the throw in is from his or her home.

After doing that the researcher organizes the data in a frequency scattering 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 auberge for this frequency distribution to be useful the figure limits bequeath have to be changed to class boundaries and we make columns for the midpoints, cut tear boundaries and cumulative frequencies volition have to be added. Entering complete this in to Excel pass on give us the spare-time natural process: [pic] The goal boundary of 18.5 and last cumulative frequency of 50 are needed to make the ogive. Histograms In Excel, put the crimp cursor on pass A1, press the leave slip departure and drag down to cellphone A7, release the left over(p) mouse release and consequently put the mouse arrow on cell D1, render down the [CTRL] key and once 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 arrange Toolbar, jaw on the chart Wizard button [pic]. This will ensue in the succeeding(a) Window: [pic] From the Chart sub-type discover appoint [pic] or each of the other elections. I pick out this option so I will work with this one. track the [Next] button and Step 2 of the Chart Wizard will appear. Do yourself a...If you want to cop a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper