• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Mastering the Analysis ToolPak > Using Statistical Analysis Tools

Using Statistical Analysis Tools

The remaining tools in the Analysis ToolPak are more focused on straight statistical analysis of data. The descriptive statistics package calculates the basic summary statistics associated with any data set. The Z, T, and F tests allow you to conduct a variety of tests on the means and variances of both small and large samples. The Anova package allows you to conduct three types of analyses of variance, allowing you to work with three experimental designs. The regression analysis tool helps you to describe complex linear trends in data.

Descriptive Statistics

In dealing with any data, you often need to have some sense of its central tendency and some sense of its variability. You can look at a range of cells all day long, even if you sort them by value, and not be able to say whether the data are closely packed about some center or widely spread out. The descriptive statistics package calculates for you several measures of central tendency and several measures of dispersion for a single set of measurements, or a variable. Because these descriptive statistics apply to a single measure or variable, they are often called univariate measures.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint