Coming soon
Statistical Methods through MS Excel
Course Objectives:
The objectives of this course are –
- To introduce the students to the basics of Excel.
- To help them use MS Excel for diagrammatic and graphical representation of data.
- To help them understand solving various statistical problems with the help of Excel
Course Outcomes (COs):
|
Course |
Outcome (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
|
Paper Code |
Paper Title |
|||
|
ECO 115 |
Statistical Methods through MS Excel |
CO12: Gain knowledge of using MS Excel in statistical computation. CO13: Acquire knowledge of data interpretation CO14: Understand the applications of statistical techniques in practical life |
Approach in teaching: Interactive Lectures, Discussion and Demonstration.
Learning activities for the students: Practice modules and Assignments. |
Practical File Preparation, Assignments, Semester end examinations. |
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.
Performing calculations using cell references; Introduction to Mathematical and Statistical functions; Measures of Central Tendency- Mean, Median, Mode Geometric Mean and Harmonic Mean.
Measures of Dispersion, Skewness and Kurtosis.
Simple Correlation - Karl Pearson’s Correlation Coefficient and Spearman’s Rank Correlation Coefficient.
Regression analysis- Estimation of regression equations.
Davis, Glyn and Pecar Branko, Business Statistics using Excel, Oxford University Press 2010.
