Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

## Histogram Graph Examples

When bars of various height is used to display the data in graphical form is called the histogram graph. Every bar groups into ranges in a histogram. The bars that are taller in size shows that most of the data will fall in that taller range. A histogram depicts the spread and the shape of the continuous given data set or the given sample data. In this article, we are going to provide you top 4 examples of histogram graphs.

### Top 4 Examples of Histogram Graphs

Below are the top 4 examples of histogram graphs.

#### Histogram Example #1

SBI Manager Mr. Shaw is worried about the customer complaint regarding long queues in the branch. He wants to analyze first what is the frequency of a major customer’s waiting time. He has called out the cashier and asked him the details.

Below is the waiting time of the customer at the cash counter of SBI bank branch during peak hours which was observed by the cashier. You are required to create a histogram based on the below data.

**Solution:**

We have created a histogram using 5 bins with 5 different frequencies as seen below in the chart. In Y axis it’s the average number of customers falling in that particular category. In X-axis we have the range of waiting time, for example, the 1^{st} bin range is 2.30 mins to 2.86 mins. And we can note that the count is 3 for that category from the table and as seen in the below graph.

This is a random distribution which is a type of distribution that has several peaks and it lacks an apparent pattern.

There can be a scenario that various data properties that were combined. Hence, the data should be analyzed separately.

4.9 (1,067 ratings)

#### Histogram Example #2

Mr. Larry a famous doctor is conducting research on the height of the students studying in 8^{th} standard. He has gathered a sample of 15 students but wants to know which the maximum category is where they belong.

**Solution:**

** **We have created a histogram using 6 bins with 6 different frequencies as seen below in the chart. In Y axis it’s the average number of students falling in that particular category. In X-axis we have the range of height, for example, the 1^{st} bin range is 138 cms to 140 cms. And we can note that the count is 1 for that category from the table and as seen in the below graph.

Here we can see the heights of the students on an average is in range of 142 cm to 146 cm for 8^{th} standard. And also, one can note that one side of the average also falls on the other side of the average which is the sign of normal distribution.

#### Histogram Example #3

Mr. A wants to make an investment in the stock market. He has shortlisted below stocks and wants to know the frequency of the prices.

Use the histogram and state what kind of distribution this is?

**Solution:**

We have created a histogram using 5 bins with 5 different frequencies as seen below in the chart. In Y axis it’s the number of stocks falling in that particular category. In X-axis we have the range of stock prices, for example, the 1^{st} bin range is 100 to 300. And we can note that the count is 7 for that category from the table and as seen in the below graph.

Here we can note that the graph is biased towards the left side and hence this is a sign of distribution which is right-skewed distribution. A large number of data values occurs on the left side and less number of data on the right side.

#### Histogram Example #4

Shastri the coach of an Indian cricket team is conducting analysis on batsmen average score and wants to finalize the chosen batsmen for the upcoming world cup. However, he is first interested in creating a benchmark to shortlist the batsmen. He has received a list of below batsmen in their last 15 innings but however, he wants to know the odd one out from this list. Use the histogram and find the out one out and comment upon the distribution.

**Solution:**

We have created a histogram using 6 bins with 6 different frequencies as seen below in the chart. In Y axis it’s the number of batsmen falling in that particular category. In X-axis we have the range of runs, for example, the 1^{st} bin range is 90 to 190. And we can note that the count is 1 for that category from the table and as seen in the below graph.

We can see that the above table is showing a left-skewed distribution. A large number of data values occurs on the right side and a smaller number of data on the left side.

90 runs in 15 innings appear to be the odd one out and appear to be of a bowler and hence needs to be removed.

### Conclusion

Creating a histogram will provide a representation which is visual in nature of the given data set or the data distribution. Histograms display the frequency of the data values and a large amount of data. The histogram helps in determining the median and the distribution of the given dataset. In addition, this can display any gaps or any outliers in the given set of data.

### Recommended Articles

This has been a guide to Histogram Examples. Here we discuss its definition, top 4 practical examples of histogram graphs with a detailed explanation. You may learn more about excel from the following articles –

- Terms used in the Stock Market
- Create KPI Dashboard in Excel
- Hypergeometric Distribution Formula | Examples
- Excel Dashboard Course
- Normal Distribution Excel Graph
- Standard Deviation Excel Graph
- Create Charts in Excel

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion