Data Analysis Plus Toolpak For Mac Runtime Error

• XLMiner Analysis ToolPak
• Can't Access Data Analysis Toolpak - Microsoft Community

Paired t-test Using Microsoft Excel

Analysis ToolPak Guide: This is a supplement to our books for those of you who would like to use Excel's built-in Analysis ToolPak add-in, rather than StatTools, for statistical analysis. The zip file contains a pdf version of the guide and accompanying data files: Analysis ToolPak Guide.zip. Biology: Data Analysis and Interpretation. Presenter: Dr Gurion Ang, The University of Queensland Overall description of mini-MOOC: This mini-MOOC about basic data analysis and interpretation for science is delivered in the context of the senior Biology syllabus but may also be applicable to other subjects, such as Agricultural Science, Earth and Environmental Science, and Marine Science. Cause: Excel 2011 does not include the Analysis ToolPak. Solution: Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2011. That last link used to include loads of comments from disgruntled Office for Mac users, but Microsoft seems to have removed comment functionality from that help center article.

These tutorials briefly explain the use and interpretation of standard statistical analysis techniques. The examples include how-to instructions for Excel. Although there are different version of Excel in use, these should work about the same for most recent versions. They also assume that you have installed the Excel Analysis Pak which is free and comes with Excel (Go to Tools, Addins.. if it is not already installed in your version of Excel.)

See www.stattutorials.com/EXCELDATA for files mentioned in this tutorial, © TexaSoft, 2008

Performing a Paired t-test in Excel

To compare two paired values (such as in a before-after situation) where both observations are taken from the same or matched subjects, you can perform a paired t- For example, suppose your data contained the variables BEFORE and AFTER, (before and after weight on a diet), for 8 subjects. The hypotheses for this test are:

_{Ho: mLoss = 0 (The average weight loss was 0)}

Ha: mLoss ≠ 0 (The weight loss was different than 0)

For example, the following weight loss data is used in this example

(DIET.XLS)

1.To perform a paired t-test, select Tools/ Data Analysis / t-test: Paired two sample for means.

2.In the t-test: Paired two sample for means dialog box: For the Input Range for Variable 1, highlight the 8 values of Score in group 'Before' (values from 162 to 170). For the input range for Variable 2, highlight the eight values of Score in group 'After' (values from 168 to 145). For now, leave the other items at their default selections. https://freetrax.mystrikingly.com/blog/cloudtv-3-9-9-x-9. This dialog box is shown below. Click OK. This dialog box is shown below:

1.To perform a paired t-test, select Tools/ Data Analysis / t-test: Paired two sample for means.

2.In the t-test: Paired two sample for means dialog box: For the Input Range for Variable 1, highlight the 8 values of Score in group 'Before' (values from 162 to 170). For the input range for Variable 2, highlight the eight values of Score in group 'After' (values from 168 to 145). For now, leave the other items at their default selections. https://freetrax.mystrikingly.com/blog/cloudtv-3-9-9-x-9. This dialog box is shown below. Click OK. This dialog box is shown below:

3.The results are shown in the output below:

XLMiner Analysis ToolPak

Can't Access Data Analysis Toolpak - Microsoft Community

^✻ Portions of file data provided by Exiftool (Phil Harvey) distributed under the Perl Artistic License.