STATISTICAL METHODS THROUGH MICROSOFT EXCEL

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

1.     To acquaint the students with the basics of Microsoft Excel and its uses for data representation and tabulation. 

2.     To help the students to describe the use of Excel for univariate and bivariate data analysis.

3.     To develop an understanding of the applications of hypothesis testing using Excel

6.00
Unit I: 
Basics of MS Excel and Graphical Representation of Data

Editing and formatting data

Performing calculations (absolute and relative referencing)

Mathematical and Statistical functions

Data presentation- creating frequency distribution and charts.

6.00
Unit II: 
Univariate Analysis

Measures of Central Tendency, Dispersion, Skewness and Kurtosis

6.00
Unit III: 
Bivariate Analysis

Correlation analysis- Karl Pearson’s & Spearman’s rank correlation coefficient.

Regression analysis.

6.00
Unit IV: 
Time series & Index Numbers

Time series: moving averages, trend, forecasting

Calculation of Index numbers

6.00
Unit V: 
Probability distributions & Hypothesis Testing

Probability distributions-Binomial, Poisson and Normal.

Applications of Z, t, chi-square & F (one-way & two-way ANOVA) tests.

Essential Readings: 
  1. Davis, Glyn and PecarBranko, Business Statistics using Excel, Oxford University Press 2010.
References: 
  1. Levine, David M., Statistics for Managers Using Microsoft Excel, Pearson Education, 2017.
Academic Session: 
2022-23
  • Printer-friendly version
  • PDF version