Covariance Matrix – creates the population or sample covariance matrix for the specified data range.Correlation Matrix – creates the correlation matrix for the specified data range.Remove rows with non-num cell(s) – remove any row with a non-numeric cell.Remove rows with empty cell(s) – remove any row with an empty cell.Sort by rows – sort rows based on the value of the cell in a selected column.Copy exact formulas – copy a range to a new location without changing the cell addresses.Remove error cells – replace any error cells by empty cells.Remove non-numeric cells – remove all cells with non-numeric data.Remove blank cells – remove all empty cells.Randomize – randomly select data from data range (with replacement).Shuffle – randomly permute the data (selection without replacement).Sort without duplicates – reproduce the data in sorted order removing duplicates.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.
0 kommentar(er)
