how to take a t test in excel 2011 for mac

Change the width of columns so that you can see all the data in cells. Adjust the column size to see everything. Keep column headings visible while you scroll. You would then be able to play out the t-test in any clear cell on the. To play out a t-test, you need two sets of data to look at the data ought to be put in two sections on an Excel worksheet. Note: can't find the Data Analysis button Click here to load the Analysis ToolPak add-in. Microsoft Excel for Mac computers contains a considerable lot of indistinguishable functions from Excel for Windows, including the t-test function.

On the Data tab, in the Analysis group, click Data Analysis. that it was fit only for testing code written in Windows Excel VBA. First, perform an F-Test to determine if the variances of the two populations are equal. If you have Office:Mac 2011 you can do it pretty much the same way as Office 2010. Microsoft Error Reporting log version:Īpplication Name: Microsoft Excel ApplicationĪpplication Version: 14. Use the Paste Special command to copy and paste special cell contents or attributes. To perform a t-Test, execute the following steps. Here is what I get from the information part of that error window:īlame Module Name: MicrosoftComponentPluginĮDIT: Updated Excel to the 14.7.4 version. I am truly concerned - I can't use the Insert tab in Excel for Mac if I try to insert anything in any file - symbol, picture, etc - Excel crashes, opens an Error reporting window (see attached).

How to take a t test in excel 2011 for mac