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

STATISTICAL METHODS THROUGH MICROSOFT EXCEL | Economics

STATISTICAL METHODS THROUGH MICROSOFT 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: 
ECO 126
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 
  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 describe 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: Students willanalyse data in terms of diagrammatic and graphical representation.

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

CO15: Students willexamine 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 PecarBranko, Business Statistics using Excel, Oxford University Press 2010.

 

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