Quantitative Techniques – Drawing Graphs using Excel

Histogram:

From Data tab, select Data Analysis -> Histogram option:

Data Analysis

Settings for Histogram Window:

DataAnalysis-Histogram

 

 

 

 

 

 

To decrese or increase values on x-axis (Bin), select BIN column and then from Home tab click on decrease/increase icon:

Histogram

Descriptive Statistics:

From Data tab, select Data Analysis -> Descriptive Statistics:

DescriptiveStatistics

 

 

 

 

 

 

DSWindow

 

 

 

 

 

 

 

 

 

 

Trendline:

Select points on graph, right click -> Add Trendline…

Trendline

 

 

 

 

 

 

 

 

 

Settings on Trendline window:

TrendlineWindow

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

trendlineExample

 

 

 

 

 

 

 

 

 

It will generate trendline and display equation on chart

Article written by

Please comment with your real name using good manners.

Leave a Reply