This is the complete study package for Statistical Data Analysis using MS-Excel. The
course teaches how to use Excel as a powerful tool for statistical work — from basic spreadsheet
operations to descriptive statistics, correlation, regression, and hypothesis testing. Each topic
shows the exact Excel formulas / ToolPak procedures with worked examples.
Pre-requisite: Courses 1–6, plus basic familiarity with Microsoft Excel
(cells, rows, columns, saving a workbook).
Course Outcomes
Master data entry, formatting, sorting, filtering, validation, and Excel add-ins (Analysis ToolPak, Solver).
Create and interpret charts; prepare frequency tables; summarise data with PivotTables/PivotCharts.
Calculate measures of central tendency, dispersion, ranks, skewness, kurtosis; generate descriptive reports.
Analyse relationships using correlation and regression; apply forecasting methods.
Perform Z, t, F, ANOVA and Chi-Square tests; interpret outputs for decision-making.
K. V. S. Sharma — Statistics Made Simple: Do it yourself on PC.
N. Balakrishnan, K. Chandrasekaran & M. Saravanavel — Practical Statistics using Microsoft Excel, Sultan Chand & Sons.
S. P. Gupta & Archana Gupta — Statistical Methods, Sultan Chand & Sons.
J. K. Sharma — Business Statistics: Problems and Solutions using Excel, Vikas Publishing House.
P. N. Arora & S. Arora — Statistics for Management with Excel Applications, S. Chand.
N. D. Vohra — Business Statistics, McGraw Hill.
Enabling the Data Analysis ToolPak: File → Options → Add-Ins → Manage: Excel Add-ins → Go → tick "Analysis ToolPak" → OK. A new "Data Analysis" button appears under the Data tab.