Statistical Methods for Economics through MS Excel

Paper Code: 
CECO 413
Credits: 
2
Contact Hours: 
60.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.
12.00
Unit I: 
Basic Concepts and Data Visualization

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

12.00
Unit II: 
Measures of Central Tendency

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

12.00
Unit III: 
Measures of Dispersion and Skewness

Measures of Dispersion and Skewness

12.00
Unit IV: 
Correlation Analysis and Regression Analysis

Simple Correlation - Karl Pearson’s Correlation Coefficient and Spearman’s Rank Correlation Coefficient. Regression analysis- Estimation of regression equations

12.00
Unit V: 
Time Series & Index Numbers

Time series: moving averages, trend, forecasting

Calculation of Index numbers

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: 
2023-24
  • Printer-friendly version
  • PDF version