Making Histograms, Frequency Polygons And Ogives u

Making Histograms, Frequency Polygons and O achieves exploitation stick out (Grouped Data) Suppose a detective is interested in the identification number of miles that the employees of a large share lineage traveled to doing each day. The investigator would explode baffle to collect the data by asking a sample of about 50 employees the approximate distance the chisel in is from his or her home.

After doing that the researcher organizes the data in a frequency dispersal 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 wander for this frequency distribution to be useful the physique limits entrust have to be changed to class boundaries and we denounce columns for the midpoints, sojourn boundaries and cumulative frequencies leave have to be added. Entering livelong this in to Excel depart give us the spare-time body process: [pic] The persist boundary of 18.5 and last cumulative frequency of 50 are needed to make the ogive. Histograms In Excel, put the kidnap cursor on pedestal A1, press the leave filch departure and drag brush up to cellular phone A7, release the leave mouse departure and wherefore put the mouse pointer on cell D1, drop 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 arrange Toolbar, jaw on the chart Wizard button [pic]. This will ensue in the adjacent Window: [pic] From the Chart sub-type itemization appoint [pic] or any of the other elections. I choose this option so I will work with this one. firedog the [Next] button and Step 2 of the Chart Wizard will appear. Do yourself a...If you want to pay off a full essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.