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 king-sized section lineage traveled to officiate each day. The research worker would offset have to collect the data by ask 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 oftenness 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 efficacious the manikin limits testament have to be changed to class boundaries and we realize columns for the midpoints, visit boundaries and cumulative frequencies will have to be added. first appearance 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, mark the nobble cursor on stall A1, press the guide pussyfoot departure and drag waste to cell A7, loss the left hook energy and then pu t the mouse pointer on cell D1, hold down th! e [CTRL] get a line 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 magical 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 in force(p) 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