As you specify your goal (compare means/medians, regression/correlation, analyze contingency table), the program provides an example or two of the possible purpose of the analysis. Data can be entered as ra data, averaged, x and y, two rows and two columns, or larger contingency tables. Step 3: Select the Data tab > Click Data Analysis > Click Anova: Single Factor > Press OK. XLSTAT contains more than 200 basic and advanced statistical tools that include all of the Analysis.
Option 1: Download the XLSTAT add-on statistical software for Mac and use it in Excel 2011. There are a few third-party add-ins that provide Analysis ToolPak functionality for Excel 2011. Step 2: Tabulate your data on a completely empty spreadsheet as shown below. I cant find the Analysis ToolPak in Excel for Mac 2011. It is fast and responsive, and provides easy access to common needs - providing comparisons of means (through numerous methods), regression and correlation (linear and nonparametric, but not stepwise as far as I can tell so far), and analyzing contingency tables through Chi-square, Fisher's, and other tests. If it’s already enabled, you can skip Step 1.
The program itself seems fairly easy to use, and is designed in wizard fashion, better thought out than most. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. A quick look through a demonstration copy showed us that InStat is helpful for beginners, providing a guide that goes step by step as you use actual data. Pdf Measure Tool For Mac If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak.