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

Part 5: Creating Formulas and Performing... > Functions for Analyzing Statistics

Chapter 17. Functions for Analyzing Statistics

Analyzing Distributions of Data 464

Understanding Linear and Exponential Regression 469

Using the Analysis Toolpak Data Analysis Tools 477

Microsoft Excel provides a wide range of features that can help you analyze statistical data. A number of functions that assist in simple analysis tasks, such as AVERAGE, MEDIAN, and MODE, are built into the program. If the built-in statistical functions aren't enough, you can turn to the Analysis ToolPak, an add-in module that provides a collection of functions and tools to augment the built-in analytic capabilities of Excel. You can use these tools to create histograms, rank-and-percentile tables, extract samples from a data set, perform regression analysis, generate special random-number sets, apply Fourier and other transformations to your data, and more. In this chapter, we'll explore statistical analysis functions built into Excel, as well as those included with the Analysis ToolPak.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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