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
Measures of Dispersion and Skewness
Correlation analysis- Karl Pearson’s & Spearman’s rank correlation coefficient;
Regression analysis - Estimation of regression equations
Time series: moving averages, trend, forecasting; Calculation of Index numbers
Davis, Glyn and PecarBranko, Business Statistics using Excel, Oxford University Press 2010
Levine, David M., Statistics for Managers Using Microsoft Excel, Pearson Education, 2017