Histogram Analysis

Share Now


A histogram is a graphical representation (Vertical Bar Chart) showing a visual impression of the distribution of data. It’s help in understanding where majority of values falls.

How to Create Histogram in excel 2007:

Histogram can be constructed in MS excel with the help of column chart tool, to create it follow the below mentioned steps:

Step1: Make sure your analysis tool pack is installed, to install it follow below mentioned steps:
a. Click Microsoft Office button > Excel Options

Histogram Analysis graph_1

b. Click Add-ins, In Add-ins dialog box make sure that the “Analysis Toolpak” is selected, and then click ok.

Histogram Analysis Histogram Analysis graph_3

Step 2: Use reference file, for opening it click here Histogram, now click on the “Data” tab and then click “Data Analysis.”

Step 3: Click on “Histogram” and then click on “OK.”

Step 4: In “Input range” field type select “A1:A10” and in “Bin Range” select “B1:B4”. In “Output Options” select “New Worksheet Ply” and select “chart output” and press “OK.”

Histogram Analysis graph

In “Frequency-Bin” Table, Excel counts the number of data points in each data bin as frequency. In the attached worksheet frequency table, In 20 bin 3 data points occurs, In 40 bin 3 data point and In 60 bin 4.



Share Now
November 16, 2019

0 responses on "Histogram Analysis"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Social Media

    ECAnalytics-facebookECAnalytics_Linkedin

    Address:

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED