Statistical Methods through MS Excel

Paper Code: 
ECO 115
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

1.      To appraise the students with the basics of Excel.

2.      To understand the use MS Excel for diagrammatic and graphical representation of data.

3.      To comprehend the use MS Excel for in applying various statistical techniques.

Unit I: 
Basic Concepts

Excel basics; Creating Frequency Distributions; Diagrammatic representation of data-Bar Diagram and Pie Diagram; Graphic representation of data-Line Graph, Histogram, Frequency Polygon and Ogives

Unit II: 
Measures of Central Tendency

Performing calculations using cell references; Introduction to Mathematical and Statistical functions;Measures of Central Tendency- Mean, Median, Mode Geometric Mean and Harmonic Mean.

Unit III: 
Measures of Dispersion, Skewness and Kurtosis

Measures of Dispersion, Skewness and Kurtosis.

Unit IV: 
Correlation Analysis

Simple Correlation - Karl Pearson’s Correlation Coefficient and Spearman’s Rank Correlation Coefficient.

Unit V: 
Regression Analysis

Regression analysis- Estimation of regression equations.

Essential Readings: 

Davis, Glyn and PecarBranko, Business Statistics using Excel, Oxford University Press 2010.

References: 

Levine, David M., Statistics for Managers Using Microsoft Excel, Pearson Education, 2017.

Academic Session: 
2022-23
  • Printer-friendly version
  • PDF version