STATISTICAL METHODS THROUGH MICROSOFT EXCEL

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

Course Objectives:

The objectives of this course are-

  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 understand the use of Excel for univariate and bivariate data analysis.
  3. To develop an understanding of the applications of hypothesis testing using Excel.

 

Course Outcomes (COs):

Course

Outcome (at course level)

Learning and teaching strategies

Assessment Strategies 

Paper Code

Paper Title

ECO 126

Statistical Methods for Economics through Microsoft Excel

CO13: Analyze data in terms of diagrammatic and graphical representation.

CO14: Understand the calculation and interpretation of descriptive measures and correlation and regression analysis through Excel.

CO15: Acquire knowledge of time series analysis and hypothesis testing using Excel tools.

 

Approach in teaching: Interactive Lectures, Discussion and Demonstration.

 

Learning activities for the students:

Practice modules and  Assignments.

Practical File Preparation,  Assignments,  Semester end examinations.

 

 

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: 

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

 

Academic Session: 
2020-21
  • Printer-friendly version
  • PDF version