One approach that might be useful for you is to use resampling. Get a powerful statistical tool for free – now with a set of new essential features - without leaving Excel. Find the Excel file you want to edit on your computer, and open it. Related post: Use the F-Test to Assess Variances in Excel. Excel requires the same number of observations ("Rows per sample" in the ANOVA dialog box) for each pair of the factor categories. If you click Help in the ANOVA dialog box, there is an example of how to arrange the data. Create four column titles called pt_oldest, pt_middle, pt_youngest, and pt_only 2. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. Double-click the file on your computer to open it now. But Microsoft removed VBA from Mac Excel 2008, so the VBA Analysis Toolpak won't run in it. This is explained on the website for the one-way ANOVA case, but can be extended to more complicated ANOVA scenarios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |