Quantitative Techniques including MS Excel Semester II- Session &
Evaluation Plan
Core course
Total Marks: 100
Sessio
n
No.
1
Credits: 4
External Examination: 60 marks
marks
Topic to be covered
Data Representation (using Excel)
Presenting ungrouped data with a
frequency table
Drawing graphs in Excel
Calculation of Statistical Measures (using
Excel)
Arithmetic mean
Geometric mean
Harmonic mean
Median
Mode
Quartiles
Mean deviation
Standard deviation
Variance
Coefficient of variation
Skewness
Kurtosis
Correlation Analysis
Simple Correlation
Scatter Diagrams
Karl Pearsons coefficient of
correlation
Spearmans coefficient of rank
correlation
Introduction to Multiple Correlation
Drawing scatter diagrams using Excel
Calculation of correlation coefficients using
Excel
Regression Analysis
Constructing simple regression
equation using least squares method
Introduction to multiple regression
Simple and Multiple regression using
Excel
Number of Hours: 60
Internal Evaluation: 40
Learning Outcome
To classify data using appropriate
frequency distribution with the help
of Excel
To draw different types of graphs
using Excel
To apply Excel functions for
calculating different statistical
measures
Hour
s
5
5
To calculate and interpret the
correlation between two variables
To apply Excel tool for drawing
scatter diagrams
To apply Excel functions for
calculating correlation coefficients
5
To estimate the simple linear
regression equation for a set of data
and know the basic assumptions
behind regression analysis
To recognize regression analysis
applications for purposes of
description and prediction
Quantitative Techniques including MS Excel Semester II- Session &
Evaluation Plan
6
7
8
9
Time Series Analysis and Forecasting
Methods
Introduction to Time Series
Components of Time Series
Forecasting trend using least squares
method
Forecasting using exponential smoothing
method
Presenting and interpreting trend using
Excel
Developing trend equation using Excel
Exponential smoothing method using Excel
Index Numbers
Price index numbers
Quantity index numbers
Volume index numbers
Sampling
Random sampling methods
Non random sampling methods
Testing of Hypothesis
Introduction to hypothesis testing
Types of errors
Level of significance
Tests of significance
Mean(s)
Proportion(s)
Regression coefficient(s)
Test for independence of attributes (chi
square test)
Analysis of Variance (ANOVA)
Presentations and Viva
Class Tests
Practical Tests
Total
To apply Excel functions for
calculating regression coefficients
To apply statistical methods for
analyzing past data and infer future
trends
To
apply
Excel
functions
developing trend equation
for
To explain the use of index numbers
To calculate various index numbers
To explain the need of sampling
To explain various sampling methods
15
To describe the use of testing of
hypothesis
To describe the method of hypothesis
testing
To apply various statistical tests
To learn Excel for applying various
statistical tests
11
2
2
60
Internal Evaluation Pattern
Serial
Numbe
r
1
2
3
4
5
Type
Proposed Period (exact date will be
intimated)
Mark
s
Class Test 1
Practical Test 1
Practical Test 2
Class Test 2
Presentations and
January 2013
February 2013
March 2013
March 2013
February and March 2013
15*
10**
10**
15*
15
Quantitative Techniques including MS Excel Semester II- Session &
Evaluation Plan
Viva
Total
40
* Beat of two class tests
** Best of two practical tests
Suggested Books:
o
o
o
o
Statistics for Management: T N Srivastava and Shailaja Rao, TMH
Statistical Tools for Managers using MS Excel: D.P. Apte, Excel Books
Basic Statistics Using Excel to accompany Statistical Techniques in Business and
Economics: Douglas Lind, William Marchal, Samuel Wathen, TMH
Statistics for Managers Using Microsoft Excel: Levine, Stephan, Krehbiel and
Berenson, PHI
Name of Faculty: Dr. Kriti Priya Gupta
Signature:
