Statistics with Excel

Data Analysis with Microsoft Excel:

Updated for Office 2019 harnesses the power of Excel and transforms it into a tool for learning basic statistical analysis. Students learn statistics in the context of analyzing data. We feel that it is important for students to work with real data, analyzing real-world problems, so that they understand the subtleties and complexities of analy[1]sis that make statistics such an integral part of understanding our world.

Spreadsheet software allows the user to combine data, mathematical formulas, text, and graphics together in a single report or workbook. For this reason, spreadsheets have become indispensable tools for business, as they have also become popular in scientific research. Excel in particular has won a great deal of acclaim for its ease of use and power.

The statistical functions that basic Excel provides include descriptive statistics such as means, standard deviations, and rank statistics. There are also cumulative distribution and probability density functions for a variety of distributions, both continuous and discrete. The Analysis Tool Pak is an add-in that is included with Excel. If you have not loaded the Analysis Tool Pak, you will have to install it from your original Excel installation. 

The Analysis Tool Pak adds the following capabilities to Excel

Analysis Tool Pak:

· Histogram

· Descriptive Statistics

· Anova

·  F-Test

·  t-Test

·  Moving Average

·  Exponential Smoothing

·  Correlation

·  Regression

**Certificate of Participation will be issued.

Course Fee: Rs.150/-