Apply Online
IIS University

Admissions

It is a University which is committed to excellence and overall development of the student and one where talent is nurtured and honed in the best possible manner. Come, be a part of our never-ending journey of accomplishments and accolades.

Psychometric Counselling Tele-Counselling E-mail Counselling Subject Counselling International Admissions
Placement Placements Go Down
Life@IIS Univ Life@IIS Univ Go Down
Academics Go Down
Research Go Down
About-Us Go Down
University Status

Admissions

It is a University which is committed to excellence and overall development of the student and one where talent is nurtured and honed in the best possible manner. Come, be a part of our never-ending journey of accomplishments and accolades.

Read More

Placements

Excellent education not only imparts knowledge, but also paves the way for a promising and successful career. The Placement Cell at The IIS University has numerous success stories to narrate in this regard...

Read More

Life@IIS Univ

Life @ IISU is nothing less than a kaleidoscope of myriad hues; complete with vibrant events and memorable occasions to cherish for a lifetime.

Read More

Academics

Taking the age-old tradition of enlightenment through education forward, The IIS University - in its continuous pursuit of excellence - firmly believes that an institution’s academic profile determines its worth and value. Therefore, on offer are a wide variety of both conventional and contemporary programmes of study.

Read More

Research

To stimulate curiosity and cater to the global needs of a dynamic education, The IIS University - since inception - has been promoting and encouraging research-based experiential learning among all its students.

Read More

About Us

The IIS University, with its perfect amalgamation of innovation, inspiration and synergy, aims to be a model institution for students across disciplines and programmes.

Read More
IIS Univ
  • Admissions

    It is a University which is committed to excellence and overall development of the student...

  • Placements

    Excellent education not only imparts knowledge, but also paves the way for...

  • Life@IIS Univ

    Life @ IISU is nothing less than a kaleidoscope of myriad hues; complete with...

  • Academics

    Taking the age-old tradition of enlightenment through education forward,...

  • Research

    To stimulate curiosity and cater to the global needs of a dynamic education,...

  • About Us

    The IIS University, with its perfect amalgamation of innovation, inspiration...

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India

Phone:- +91-141-2400160-61, 2397906-07,

Fax: 2395494,2781158, Toll Free No.: 1800 180 7750

Data Analysis through MS Excel | Economics

Data Analysis through MS Excel

Error message

  • Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in drupal_environment_initialize() (line 691 of /home/iisunivac/public_html/includes/bootstrap.inc).
  • Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in drupal_environment_initialize() (line 692 of /home/iisunivac/public_html/includes/bootstrap.inc).
  • Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in drupal_environment_initialize() (line 693 of /home/iisunivac/public_html/includes/bootstrap.inc).
  • Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in drupal_environment_initialize() (line 698 of /home/iisunivac/public_html/includes/bootstrap.inc).
  • Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in drupal_environment_initialize() (line 702 of /home/iisunivac/public_html/includes/bootstrap.inc).
Paper Code: 
25SECO 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 Outcomes (COs):

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies 

Course Code

Course Title

25SECO 501

Data Analysis through MS Excel

(Practical)

Students will-

CO1: analyzefundamental 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: 
2025-26
  • Printer-friendly version
  • PDF version