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

COMPUTER APPLICATION IN ECONOMIC ANALYSIS-Practical | Economics

COMPUTER APPLICATION IN ECONOMIC ANALYSIS-Practical

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 324 (B - P)
Credits: 
2
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This lab is designed to introduce the students with financial and statistical functions of MS – Excel, MS – Access and SPSS.

 

 

MS-Excel: Excel Basics, Cell Referencing (Relative, Absolute, Mixed), Cell Formatting, Functions in excel (SUM, AVERAGE, COUNT, MAX, MIN, IF), What-if analysis, Goal seek, Scenario, Pivot Table, Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER), sorting, Data filters (Auto and Advanced), Mathematical Functions (Ceiling, Floor, Trunc, Mid), lookup & references (Lookup, Vlookup, Hlookup) Hyper linking, Macros. Summarizing data: Graphical methods (line graph, bar graph, pie chart, histogram, scatter plot), Descriptive Statistics (mean, median, mode, standard deviation, sample variance, kurtosis, skewness, Range), Correlation and Regression Analysis (ANOVA model).

 

MS-Access: Tables, data types, creating tables, entering data table, editing data, viewing records, sorting records, relationship, querying a database (crosstab query) & Generating reports.

 

SPSS: A package for Statistical Analysis in Social Sciences. Basic Operations; File, Edit, View, Data, Transformation, Graph and utilities. Statistical Analysis using SPSS: Summary, Tabulation and comparison of summary statistics; Correlation and Regression (Linear and non-linear).

Academic Session: 
2016-17
  • Printer-friendly version
  • PDF version