2a Excel 2010, Excel 2013, and Excel 2016 Security Settings In these Excel versions, select File Options and in the Excel Options dialog box: 1.

(There are no security settings for you to review if you use OS X Excel.) In the following instructions, the symbol means on the next display, select. To use PHStat with Microsoft Windows versions, you first must review and change, if necessary, the Microsoft Office Trust Center security settings. (This add-in may have already been installed at the time that Excel was installed on your computer system.) * See special note about using OS X Excel 2016 in Section 6.Ģ 2 Other Requirements and Technical Notes PHStat requires English language as the Office language setting and the period as the decimal point (as used in the United States) and uses (a modest) 3 MB of disk storage space for its files and you should store all files together in one directory.

If you plan to use the Logistic Regression procedure, you will need to install the optional Microsoft Solver add-in (Solver.xlam). However many PHStat worksheet solutions will be viewable and usable in these versions. As of January 2016, Excel versions that PHStat supports include: Microsoft Windows Excel 2007, Excel 2010, Excel 2013, and Excel 2016 OS X Excel 2011 and OS X Excel 2016* (OS X Excel is also known as Excel for Mac) Excel installed as part of a current Office 365 subscription (excludes Office 365 Business Essentials) PHStat is not compatible with Excel Online or mobile versions of Excel such as Office Mobile, Office for ipad and iphone, and Office for Android. This readme discusses version 4.1 of August 2016 and contains these sections: 1 Excel Requirements 2 Other Requirements and Technical Notes 3 Obtaining PHStat 4 Using PHStat 5 Check to See if the Solver Add-in Is Installed 6 PHStat Visual Differences in Microsoft Windows and OS X Excels 7 Commonly-Asked FAQs About PHStat 8 Common Troubleshooting FAQs 9 What's New in PHStat? 1 Excel Requirements To use PHStat, you will need a properly licensed and up-to-date version of Microsoft Excel. PHStat solutions can be later examined to learn actual native Excel techniques, such as formulas, for a given solution and many solutions serve as what-if templates in which you explore how results change when you change the data. With PHStat, you can focus on learning statistics as you perform many types of statistical analyses using the familiar Excel interface and PHStat dialog boxes. You avoid the unnecessary clerical errors that can arise from creating worksheets from scratch or from manually modifying worksheet templates. You make entries in dialog boxes and PHStat creates the solutions for you. 1 PHStat Version 4.1 Readme PHStat provides a software assist to help you create Excel worksheet solutions to statistical problems.

Phstat for excel