Coming soon
STATISTICAL METHODS THROUGH MICROSOFT EXCEL
Course Objectives:
The objectives of this course are-
- To acquaint the students with the basics of Microsoft Excel and its uses for data representation and tabulation.
- To help the students to understand the use of Excel for univariate and bivariate data analysis.
- 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: Analyze data in terms of diagrammatic and graphical representation. CO14: Understand the calculation and interpretation of descriptive measures and correlation and regression analysis through Excel. CO15: Acquire knowledge of 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. |
Editing and formatting data
Performing calculations (absolute and relative referencing)
Mathematical and Statistical functions
Data presentation- creating frequency distribution and charts.
Measures of Central Tendency, Dispersion, Skewness and Kurtosis
Correlation analysis- Karl Pearson’s & Spearman’s rank correlation coefficient.
Regression analysis.
Time series: moving averages, trend, forecasting
Calculation of Index numbers
Probability distributions- Binomial, Poisson and Normal.
Applications of Z, t, chi-square & F (one-way & two-way ANOVA) tests.
Davis, Glyn and Pecar Branko, Business Statistics using Excel, Oxford University Press 2010.
