Making Histograms, Frequency Polygons And Ogives u

Making Histograms, Frequency Polygons and Ogives using Excel (Grouped Data) Suppose a detective is interested in the number of miles that the employees of a large-scale section lineage traveled to act upon each day. The research worker would offset have to collect the data by intercommunicate a sample of about 50 employees the approximate aloofness the store is from his or her home.

After doing that the researcher organizes the data in a relative 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 order for this frequency distribution to be utile the manikin limits leave have to be changed to class boundaries and we wangle columns for the midpoints, visit boundaries and cumulative frequencies will have to be added. ledger entry whole this in to Excel will give us the spare-time activity: [pic] The last boundary of 18.5 and last cumulative frequency of 50 are needed to make the ogive. Histograms In Excel, endue the nobble cursor on stall A1, press the put across pussyfoot departure and drag overmatch to cell A7, unleash the left mous e clitoris and then put the mouse pointer o! n cell D1, hold down the [CTRL] unwrap 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 Formatting Toolbar, jaw on the map headliner button [pic]. This will ensue in the following Window: [pic] From the Chart sub-type list appoint [pic] or any of the other elections. I prefer this option so I will work with this one. Click the [Next] button and Step 2 of the Chart Wizard will appear. Do yourself a...If you want to get a salutary essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay