This video tutorial describes how to compute Descriptive Statistics in Excel. Most people underestimate the power and use of microsoft Excel for Statistical analysis. Excel can very quickly generate statistics, percentiles and can do variety of statistical tasks in excel including hypothesis testing and running ttests as well.
in this video, we compute measures of central tendency, measures of dispersion, measures of location such as percentiles. We generate, mean, median, mode, percentiles, Frequency table and also histogram. Using these methods one can summarize the data quickly.