More recent data is weighted more heavily. Exponential Smoothing Smooths out irregularities (peaks and valleys) in data, to easily recognize trends. Descriptive Statistics Create a report of univariate statistics for the selected data.

Covariance This analysis tool is used to calculate the average product deviation value from the mean of the data set. Correlation This tool was used in more than two variable measurements of every N subject. Anova: Two-Factor without Replication This tool determines the usefulness when data is categorized on two different measurements as in the Two-Factor case With Replication. ANOVA: Two Factor with Replication This tool is used to determine if there is a relationship between two datasets and classified into two different dimensions. Tool Description ANOVA: Single Factor This tool determines a simple analysis of variance between the relationship of two data sets. Here are the analytical tools you can use along with their purposes. And if not installed on the computer click YES to install it.However, if the Analysis Toolpak is not available in list of add-ins, click the browse command to find it.And now in the Add-Ins dialog box, check the Analysis ToolPak check box, then click OK.In add-ins dropdown list, select the preferred add-ins then Click GO.However, when still using Excel 2007, go to Microsoft Office Button and click it, and then click Excel Options. When the dialog box appears, click the Add-Ins in the Excel options category on the left.First, on the File tab click it then find and click Options.Here are the steps to add Analysis Toolpak in Excel.

Add data analysis to excel mac