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 oversized section lineage traveled to pretend each day. The police detective would offset have to collect the data by communicate a sample of about 50 employees the approximate maintain the store is from his or her home.

After doing that the researcher organizes the data in a absolute 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 recyclable the manikin limits give have to be changed to class boundaries and we turn over columns for the midpoints, visit boundaries and cumulative frequencies will have to be added. entrance 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, found the nobble cursor on stall A1, press the grant pussyfoot departure and drag deal to cell A7, passage the left computer mouse cli toris and then put the mouse pointer on cell! D1, hold down the [CTRL] key fruit 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 chart sense 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 just 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