Statistical Methods through Microsoft Excel

Paper Code: 
24ECO 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: 

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies 

Course Code

Course Title

24ECO 126

Statistical Methods for Economics through Microsoft Excel

(Practical)

Students will -

CO31: comprehend the fundamental features of MS Excel and effectively apply them in diagrammatic and graphic representation of data

CO32: apply MS Excel to determinemeasures of central tendency, dispersion, skewness and kurtosis and correlation analysis and regression analysis

CO33: apply MS Excel in time series analysis, formation of index numbers, in statistical inference and hypothesis testing

CO34: create a document related to different types of analysis using MS Excel

CO35: defend orally the findings of the analysis using MS Excel

CO36: contribute effectively in course-specific interaction

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: 
  1. Davis, Glyn and PecarBranko, Business Statistics using Excel, Oxford University Press 2010.

 

 

References: 

Suggested Reading:

  1. Levine, David M., Statistics for Managers Using Microsoft Excel, Pearson Education, 2017.

E-Resource:

  • Davis &Pecar: Business Statistics Using Excel, Data from exercises in the book

https://global.oup.com/uk/orc/busecon/business/davis_pecar2e/student/data/

Journal:

 

Academic Session: 
2024-25
  • Printer-friendly version
  • PDF version