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.

 

Course Outcomes (COs):

Course

 Outcome (at course level)

Learning and teaching strategies

Assessment Strategies 

Paper Code

Paper Title

ECO 115

Statistical Methods through MS Excel

CO12: Students will use MS Excel in statistical computations.

CO13: Students will develop the knowledge of data interpretation.

CO14: Students will use the applications of statistical techniques like descriptive measures in practical life.

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: 
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.

 

6.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 Geometric Mean and Harmonic Mean.

 

6.00
Unit III: 
Measures of Dispersion, Skewness and Kurtosis

Measures of Dispersion, Skewness and Kurtosis.

 

6.00
Unit IV: 
Correlation Analysis

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

 

6.00
Unit V: 
Regression Analysis

Regression analysis- Estimation of regression equations.

 

Essential Readings: 

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

 

Academic Session: 
2021-22
  • Printer-friendly version
  • PDF version