- #How to install data analysis in excel onmac how to
- #How to install data analysis in excel onmac for mac
Uninstalling the Real Statistics Resource Pack
#How to install data analysis in excel onmac how to
The descriptions of how to use the Real Statistics functions and data analysis tools apply to the Mac version of the software, although sometimes with minor modifications especially as described in Mac User Interface. control key + m) or click on the Real Statistics menu. To use the data analysis tools enter Control-m (i.e. A complete list of these functions can be found in the Tools menu of the website. These functions are described throughout the rest of this website. Once you have installed the Real Statistics Resource Pack you can use the supplemental functions in the same way as you use the built-in worksheet functions supplied with Excel. If the XRealstats-Mac option doesn’t appear, click on Browse to find and choose the XRealStats-Mac.xlam or RealStats-Mac-2011.xlam file that you downloaded earlier.Check the XRealstats-Mac option on the dialog box that appears and click the OK button.Make sure that the Solver option is checked on the dialog box that appears.Open Excel, but don’t try to open the xrealstats-mac.xlam or realstats-mac-2011.xlam file that you downloaded earlier.Caution: once you install the resource pack at a particular location it will be more difficult to move it later. Move the Resource Pack to where you want it located on your computer.Once you have downloaded the Resource Pack, you need to install it using the following steps.