Data Analysis through MS Excel

Paper Code: 
24SECO 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.

 

 

Course Outcomes: 

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies 

Course Code

Course Title

24SECO 501

Data Analysis through MS Excel

(Practical)

Students will-

CO1: analyze fundamental features of MS Excel, examine data presentation and measures of central tendency in MS Excel

CO2: solve problems of dispersion, skewness, correlation and regression in MS Excel

CO3: perform time series analysis and compute index numbers using MS Excel.

CO4: create a document pertaining to different types of analysis using MS Excel

CO5: defend orally the findings of the analysis using MS Excel

CO6: contribute effectively in course-specific interaction

Approach in teaching: Interactive Lectures, Discussion and Demonstration.

 

Learning activities for the students:

Practice modules and  Assignments

Practical File Preparation,  Assignments,  Semester end examinations.

 

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 PecarBranko, Business Statistics using Excel, Oxford University Press 2010

 

References: 

Suggested Reading:

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

E-Resource:

Davis &Pecar: Business Statistics Using Excel, Data from exercises in the book

https://global.oup.com/uk/orc/busecon/business/davis_pecar2e/student/data/

 

Journal:

Journal of Quantitative Economics

 

Academic Session: 
2024-25
  • Printer-friendly version
  • PDF version