Data Analysis through MS Excel (Skill Based Course)

Paper Code: 
SECO 501
Credits: 
4
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 applying various statistical techniques.
12.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

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: 
Bivariate Analysis

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

Regression analysis - Estimation of regression equations

12.00
Unit V: 
Time Series and Index Numbers

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

Essential Readings: 

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

References: 

Levine, David M., Statistics for Managers Using Microsoft Excel, Pearson Education, 2017

Academic Session: