New Mac Release
Excel 2016 for Mac brings lots of welcome improvements to the workhorse spreadsheet but also leaves out useful tools. Moving to the cloud: Like the other apps in the latest Mac Office suite. May 11, 2020. Keep in mind that there are also two versions of Excel, at least for Excel 2010, 2013, 2016, 2019 and 365, the 32-bit version and the 64-bit version. Most people use the 32-bit version. The Real Statistics Resource Pack works in both versions of Excel. Real Statistics Resource Pack for Excel 2010, 2013, 2016, 2019 or 365 for Windows. There is a general-purpose Data Analysis add-in available in Excel for Mac 2016, but it does not include calculation of a reference interval. To verify that the Data Analysis add-in lacks this capability, first choose Excel About Excel. The current Excel version is 15.22 (160506). If you need an update, choose Help Check for Updates. Jun 26, 2020.
Good news for Mac users. The latest release of the Real Statistics Resource Pack (Release 5.0) is now available for use with Excel 2016 for the Mac. You can now download this release at Real Statistics Resource Pack for Mac.
There is also a new release of the Real Statistics Resource Pack that is compatible with Excel 2011 (Mac), but this has not been tested. You can download this version from Real Statistics Resource Pack for Mac as well. I would appreciate your informing me whether this release works on your Mac computer.
I have put in considerable energy and investment to create this new release and test it on a Mac computer. Any donation from you would be appreciated to help offset my costs.
User Interface
The user interface for the Mac version of the Real Statistics data analysis tools is identical to the Windows version with one important difference. When inserting a range into an input field, in Windows you can simply highlight the range of cells and the field will automatically contain the address of the highlighted range (see Figure 1).
Figure 1 – Inserting a Range in Windows
In the Mac version of Real Statistics to accomplish the same thing, you need to click on the + button, as shown in Figure 2.
Figure 2 – Inserting a Range on the Mac (step 1)
Real Statistics Excel Mac Download Free
This will display the dialog box shown on the right side of Figure 3. You can now highlight the desired data range (M3:M7 in this example) and when you press the OK button, the Input Range field will automatically be filled with the appropriate cell range address.
Figure 3 – Inserting a Range in the Mac (step 2)
Download Excel On Mac
The situation is the same for the Output Range, except that now you should only highlight one cell.