list of statistical tools for data analysis

Sort – reproduce the data in ascending sorted order.

Reverse – reverse the order of the input data range.

Reshape – reproduce input data in a range of a different shape.

Shannon’s, Brillouin’s and Simpson’s diversity indicesĮxtract Columns from Data Range – allows you to create a new data range by selecting certain columns from an existing data range.Create a histogram with normal curve overlay.Create a frequency table and histogram based on bins.Descriptive statistics for frequency table.

Descriptive Statistics Tabĭescriptive Statistics and Normality, includes: The data analysis tools are listed in the tab order of the multipage interface. You can click on any of the data analysis tools listed below (or the listed options within these tools) to get additional information about that tool (or option). List of Real Statistics Data Analysis Tools The following are the currently supported Real Statistics data analysis tools. You next choose one of the data analysis tools from this list. A dialog box will now appear which is similar to that presented in Figure 2 of Excel’s Data Analysis Tools, as described in detail in Using Real Statistics Data Analysis Tools. One of two dialog boxes will appear which lists all the available supplemental data analysis tools (see Figure 1 and 2).įigure 1 – Original Real Statistics data analysis tools main menuįigure 2 – Real Statistics multipage data analysis tools main menu You can access the Real Statistics data analysis tools by pressing Ctrl-m or via the Add-Ins ribbon (as described in Accessing Real Statistics Tools). Accessing Real Statistics Data Analysis Tools Here we briefly review the available supplemental data analysis tools. The functions provided in the Real Statistics Resource Pack are summarized in Real Statistics Functions. Although all the statistical analyses described in this website can be done with standard Excel capabilities, it is often easier to use the supplemental functions and data analysis tools provided in the Real Statistics Resource Pack.

List of statistical tools for data analysis