1 / 12

T02-03 Histogram (Equal Classes)

T02-03 Histogram (Equal Classes).

holly
Download Presentation

T02-03 Histogram (Equal Classes)

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. T02-03 Histogram (Equal Classes) PurposeAllows the analyst to analyze quantitative data by summarizing it in sorted format, scattergram by observation, frequency dot plot by data value, equal class width (analyst choice based on beginning, ending and number of classes) frequency histogram and relative frequency histogram. Inputs Original Quantitative Data Number Classes Beginning Class Ending Class Outputs Sorted Quantitative Data Summary Statistics Original Data Scattergram Frequency Dot Plot Frequency Histogram Relative Frequency Histogram Limitations 1000 quantitative data

  2. An Example An accounting firm has collected a sample of audit times from last year. To get a better feel for the distribution of the audit times the manager wants to look at a Histogram of the data using 5 equal width classifications.

  3. Data can either be entered directly into the OriginalData cells or copy/paste special/values into the cells.

  4. Once the data is entered SummaryStatistics (Count, Max, Min & Range) are automatically calculated. The SortMacro can be run to sort the OriginalData into the SortedData cells. This also automatically calculates the necessary information for the DotPlot.

  5. The Summary Statistics (Max & Min) can be used to establish the BeginClassPoint and the EndClassPoint. These are then entered with the NumberClasses for the Histogram.

  6. The HistogramMacro can be run to automatically calculate the Histogram Information. The EqualClassWidth and HistogramBin Classifications are automatically calculated.

  7. Decimal Point Accuracy can be set for the Relative Frequency The Histogram Information (frequency & relative frequency) is displayed in tabular format by the classifications.

  8. WorksheetTabs can be selected to view the Original Data Scattergram, Frequency Dot Plot, Frequency Histogram and Relative Frequency Histogram.

  9. The Scattergram displays a plot of the observations in the sequence they were entered.

  10. The Dot Plot displays a frequency plot of the observations.

  11. The Equal Width Frequency Histogram shows the histogram for the number of equal width classes chosen. The legend should be read bottom-up.

  12. The Equal Width Relative Frequency Histogram shows the histogram for the number of equal width classes chosen. The legend should be read bottom-up.

More Related