1 / 28

GRAPHICAL DESCRIPTIVE STATISTICS FOR QUANTITATIVE DATA

GRAPHICAL DESCRIPTIVE STATISTICS FOR QUANTITATIVE DATA. Graphical Techniques Quantitative Data. Histograms Consider Boundaries of measurement classes Choose values that are easy to read/understand Number of classes will “fall out” Where to place data occurring at “break points”

jessamine-french
Download Presentation

GRAPHICAL DESCRIPTIVE STATISTICS FOR QUANTITATIVE DATA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GRAPHICAL DESCRIPTIVE STATISTICS FOR QUANTITATIVE DATA

  2. Graphical TechniquesQuantitative Data • Histograms • Consider • Boundaries of measurement classes • Choose values that are easy to read/understand • Number of classes will “fall out” • Where to place data occurring at “break points” • Excel – in the lower interval • Inclusion of Outliers? – unrepresentative data far above or far below most of the rest of the data • Seek reason for outliers • Relative Frequency (Percentage) Histograms • Cumulative Relative Frequency Ogives

  3. Frequency Distributions • Take a Survey of Incomes of 200 High School Graduates 2 Years After Graduation • Results: $31,500, $26,900, …., $26,100 • Create Class Intervals So Data Can Convey Information • Not too many • Not too few • Include All Data (?) --- Outliers • Intervals of Equal Size

  4. Results Income Frequency Rel. Freq. $15,000-$20,000 9 9/200 = .045 $20,000-$25,000 34 34/200 = .170 $25,000-$30,000 91 91/200 = .455 $30,000-$35,000 61 61/200 = .305 $35,000-$40,000 5 5/200 = .025

  5. Histogram

  6. RELATIVE FREQUENCY HISTOGRAM Same shape as histogram – different scale on y-axis

  7. Check Analysis Tool Pak Check Analysis Tool Pak-VBA Click OK EXCELDATA ANALYSIS • Go to Tools Menu • Select Data Analysis • What If Data Analysis Isn’t There? • Go to Tools Menu • Select Add-Ins

  8. EXCELHistograms • Basic Approach: • Put Data in a Column • Create Bins (Measurement Classes) • Go To Tools Select Data Analysis Select Histogram Check Chart Output

  9. Data put into a column

  10. 2. First entry should be less than lowest value – actually the lower bound of the first measurement class – this allows us to begin the histogram at a value >0. 1. Enter label for X-Axis + 3. Enter the upper bound of the first measurement class 4. Highlight the first two entries and drag down to the upper bound of the last measurement class CREATE BINS

  11. Go to ToolsSelect Data Analysis Select Histogram TOOLS/DATA ANALYSIS/HISTOGRAM

  12. Enter • cells containing data including label • Enter • cells containing bins including label • Enter • where you want the output 3. Check Labels 4. Check Chart Output Histogram Dialogue Box

  13. Grab Lower Corner and drag to resize Resizing

  14. Change Numbers to Midpoint Values Delete first entry (15000) and last entry (More) Click in Grey Area and Delete Click and Rename Click and Delete To close gap width: Right mouse click on a bar Select Format Data Series Select Options Set Gap Width = 0 Result of Resizing

  15. Resulting Histogram

  16. Relative Frequency • Proportion of Data in a Particular Class • Divide Frequencies by 200 gives these results:

  17. Relative Frequency Histogram • Change the numbers on the y-axis to percentages • Can manipulate Excel Histogram • Numbers on Y-axis appear in column B • Somewhere create a cell with the formula =B2/200 (Say in cell B12) • Drag down until all relative frequencies are shown • Highlight this new set of numbers and press COPY • Then PASTE SPECIAL (Values) these numbers back into cell B2 • Erase numbers in cells B12 and below • Change Name in cell B1 and on Y-Axis to Relative Frequency

  18. 2. Select Copy 3. Put cursor in cell B2 • Go to Edit • Select Paste Special 5. Select Values 1. Enter =B2/200 Drag to B18 Then highlight B12:B18 Creating Relative Frequencies

  19. 6. Change to Relative Frequency 7. Highlight and delete Creating Relative Frequencies

  20. Cumulative Relative Frequencies • Give the proportion of values that are less than the upper boundary point of the class • Cumulative frequency for first class is the relative frequency • For subsequent classes cumulative frequency = relative frequency + cumulative frequency of previous class

  21. The same as the relative frequency .670 = .455 + .215 Cumulative Relative Frequencies

  22. Ogives • Line graph of cumulative relative frequencies • Begin with y-value = 0 at $15,000 and draw line to .045 at $20,000 • Draw line from .045 at $20,000 to .215 at $25,000 • Draw line from .215 at $25,000 to .670 at $30,000 • Draw line from .670 at $30,000 to .975 at $35,000 • Draw line from .975 at $35,000 to 1 at $40,000 • Draw line flat at 1 (to infinity)

  23. Result

  24. 0.44 27500 Using Ogives to Approximate Prob (Income < $27,500)

  25. Check both EXCEL Ogives

  26. 4. Change Names 5. Right Mouse Click On any bar --Delete 1. Resize 3. Delete Background 2. Delete Legend 6. Delete More

  27. RESULT

  28. Review • Frequency Distributions • Frequency Histograms • Relative Frequency Distributions • Relative Frequency Histograms • Cumulative Relative Frequencies • Cumulative Relative Frequency Ogives

More Related