How to Analyze Statistics Using Excel

Submit Your Tip

How to Analyze Statistics Using Excel – This is a place for the community to provide tips and advice on How to Analyze Statistics Using Excel. This topic was created by Himanshu Kikani and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Tip 1 - Descriptive Statistics in Excel

Published: 9 years, 3 month(s) ago | Submitted by Connie Kallback | permalink

You can use the Excel Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test.
Tags: descriptive statistics, excel, analysis toolpak add-in, data analysis, input, output, range, summary statistics

For further reading: http://www.excel-easy.com/examples/descriptive-statistics.html ^[1]

Tip 2 - Excel Data Analysis

Published: 9 years, 3 month(s) ago | Submitted by f R 3a K 0225 | permalink

This section illustrates the powerful features Excel has to offer to analyze data.
Tags: excel data analysis, sort, filter, conditional formatting, charts, pivot tables, tables, what-if analysis, solver, analysis toolpak

For further reading: http://www.excel-easy.com/data-analysis.html ^[2]