Exploratory Data Analysis

Name : Shanika Jhunjhunwala

Roll no. : 040

Exploratory data analysis (EDA) :

Exploratory data analysis (EDA)is an approach to analyse data sets and summarize their main characteristics. EDA is for seeing what the data can tell us beyond hypothesis. EDA is different from initial data analysis (IDA) which focuses more narrowly on the checking assumptions required for hypothesis testing, and handling missing values. EDA includes IDA.

Objectives of EDA:

• Suggest hypotheses about the causes of observed phenomena
• Assess assumptions on which statistical inference will be based
• Support the selection of appropriate statistical tools and techniques
• Provide a basis for further data collection through surveys or experiments.

Techniques:

Ø Graphical techniques:

• Box plot
• Histogram
• Scatter plot
• Stem-and-leaf plot

Ø Quantitative techniques:

• Median polish
• Tri mean
• Ordination

 

Source: wikipedia.org

 

How to Create a Histogram in Excel:

1.Open Microsoft Excel.

2.Go to the OFFICE BUTTON ---->excel options----->Add-Ins---->Analysis Toolpak---->Go

3.Enter data that you want to be in a histogram.e.g.grades in one row and bin value in another row(Bin value is the range)

4.Click the data tab -----> select Data Analysis---->Histogram---->OK

5.Select the input range (this is your data) then select the bin range.

6.Check the chart output box.

7.Click OK.

8.Your histogram is ready

Source- www.wikihow.com