1 / 22

Excel Histogram Tutorial

Excel Histogram Tutorial. Example 2-5 Histograms Capital Credit Union. Issue: Analyze credit card balances for Capital Credit Union customers using a frequency distribution and histogram. Objective:

luka
Download Presentation

Excel Histogram Tutorial

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. Excel Histogram Tutorial Example 2-5 HistogramsCapital Credit Union Issue: Analyze credit card balances for Capital Credit Union customers using a frequency distribution and histogram. Objective: Use Excel to develop a frequency distribution and histogram for credit card balances. Use ten class intervals. Data file is Capital.xls

  2. Example 2-5 Histograms Open File Open the Excel file called Capital.xls File contains 300 observations - Last row is 301 - Column B contains the balances

  3. Example 2-5 Histograms Max Function Use Excel Max function to determine largest value

  4. Example 2-5 Histograms Min Function Use Excel Min function to determine smallest value

  5. Example 2-5 Histograms Class Width Compute Class Width Round Up to $150.00 $90 to less than $240 $240 to less than $390 Class Intervals $390 to less than $540 etc….

  6. Example 2-5 Histograms Bins Construct the Bins (the upper limit of each class.

  7. Example 2-5 Histograms Tools, Data Analysis Select Tools and Data Analysis

  8. Example 2-5 Histograms Histogram Option Select the Histogram option

  9. Example 2-5 Histograms Histogram Wizard Complete the Histogram Wizard - Note, check Chart Output. Placing output on a new worksheet is optional.

  10. Example 2-5 Histograms Default Output This is Excel’s Default Output. You need to make some modifications to make it acceptable for most applications.

  11. Example 2-5 Histograms Select Histogram Select the graph by clicking it. Note, the points on the graph boarder indicate it has been selected. Enlarge Graph by dragging from lower right corner down and to the right.

  12. Example 2-5 Histograms Remove Gaps 1 Histograms should have no gaps between the bars! Select the bars on the graph by clicking on any bar - then right click.

  13. Example 2-5 Histograms Remove Gaps 2 Click on Selected Object

  14. Example 2-5 Histograms Remove Gaps 3 Click on Options tab

  15. Example 2-5 Histograms Remove Gaps 4 Set Gap Width to 0 to close the gaps between the bars - click OK

  16. Example 2-5 Histograms Delete Legend The legend is not needed. Select it and press the delete key

  17. Example 2-5 Histograms Label x-axis Label the Graph Variable – Select the “Bin” Label and type desired label. Press the Enter key.

  18. Example 2-5 Histograms Fine Tune 1 2. Select the horizontal axis line 1. Enter Correct Group Labels 3. Select Format Axis

  19. Example 2-5 Histograms Fine Tune 2 Select Font and make desired changes.

  20. Example 2-5 Histograms Fine Tune 3 Select Alignment and make desired changes.

  21. Example 2-5 Histograms Fine Tune 4 Select the “More” row and press the Delete key

  22. Example 2-5 Histograms Fine Tune 5 You can make other modifications to the histogram – color, labels, size, etc.

More Related