Statistical Methods for Economics through Microsoft Excel

Paper Code: 
ECO 223(P)
Credits: 
2
Contact Hours: 
60.00
Objective: 

To acquaint the students with tools of MS Excel used for statistical analysis and data handling techniques.

12.00

Excel Basics                                                                                                     Editing and formatting data                                                                        Performing calculations (absolute and relative referencing)                        Mathematical and Statistical functions                                                                  Data presentation- creating frequency distribution and charts.

12.00

Measures of central tendency, dispersion, skewness and kurtosis

12.00

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

12.00

Time series: moving averages, trend, forecasting                                                    Calculation of Index numbers

12.00

Probability distributions- Binomial, Poisson and Normal. Applications of Z, t, chi-square & F tests, Analysis of Variance: One way and two way.

 

 

 

 

 

 

Software to be used: MS Excel

 

 

Essential Readings: 

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

Academic Session: 
2018-19
  • Printer-friendly version
  • PDF version