If you would like to test the release I can put it online later today as a beta version. Thank you very much for volunteering to help with the beta testing of the latest Mac version of the Real Statistics software. I have just made Release 3. I have just tested it, but not as extensively as I would have liked since I only had access to a Mac computer for a few hours. I would appreciate your checking to see whether it can be used on a different Mac besides mine.
The mathematical part of the software is identical to the Windows version, but some of the interface has been rewritten for the Mac. Some features are not working. For Mac users, I have had success copying the RealStats RealStats will appear on the list.
Check the box, then click the Select button. I installed the Real Statistics resource pack on my Mac, under Excel , without any problems. But, when I go to Data Analysis Tools under the Real Statistics menu, the Real Statistics pop-up box is quite small, and the text is difficult to decipher.
Is there an option available to expand the size of the pop-up box? In any case, I will look into making the size of this dialog box adjustable in a future release. Happy to say it installed correctly on my Mac running Excel I immediately did a PCA analysis on a covariance matrix I had recently constructed from equity price histories: it performed flawlessly. Thank you for all the hard work that went into creating this add-in. I have Excel for MAC. Which version of your RealStats should I use?
Sorry for that. Is there a passwd that I should be entering? You do not need to provide a password to use the software.
The usual reason for getting this message is that the installation process has not been completed as described on the referenced webpage. You said that you selected RealStats from the Add-in options. For the Mac I think this should be something like RealStat instead. You probably need to use the Browse button to find the correct file. If you have followed the Installation instructions then I suggest that you download an earlier version of the software.
This can be obtained from the referenced webpage. Try using Release 3. You will need to follow the Installation instructions. This time you will need to use something like RealStats 1 Oct from the Add-in options. I am most definitely selecting the correct one. Do you still have them? You will receive this message if you try to open the file.
Just follow the instruction on the referenced webpage, namely. Hi, I am experiencing the exact symptom. I downloaded the package and it is called RealStats. I open excel and choose it as an add-in not opening the file and I get the exact same errors and prompts for a password. Was this issue ever resolved? Barbara, Please confirm that when you select Add-Ins on the Tools menu that you see the Realstats option on the dialog box that appears with a check mark next to it.
I have installed realstats They are all coming up name. It sounds like you have installed the software on your mac, but you still need to have Excel recognize the software. You do this by accessing the Tools menu and selecting the Add-ins choice. Next click on the Browse button in the dialog box that appears and choose the realstats Press the Close button. Finally check the Realstats option on the dialog box. This is described on the referenced webpage. This add-in set is really nice. But I am seeing a bug in the t-test routine. Everything else starts fine. If more information would be helpful, let me know.
Alistair, Are you running the latest version of the software Rel 3. Just to confirm, are you able to run other data analysis tools e.
You provide the data and parameters for each analysis, and the tool uses the If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins. The following table shows which Excel for Mac versions include these add-ons. Click the Data Analysis ToolPak or Solver option to enable it.
I have the same problem as Alistair. I am running the latest version 3. Release 3. The main differences are that there is an error in the p-value for the KAPPA function one-tail value instead of two-tail value and the dialog boxes for the data analysis tools are not so nicely formatted. Please let me know whether this version works properly.
Firsts of all I want to congratulate you for the excellent work on creating the Real Statistics Resource Pack.
I have the same problem described by Maryam and I already tried the two previous version and it persists. Are you using Excel or an earlier version of Excel for the Mac? Hi Charles, I just downloaded the RealStats I am wondering, should I have moved the. Seems to work OK, but must I leave the file in the Downloads file? I assume the fonts will scale-up too? Make a copy of the Real Statistics Resource Pack file and give it a new name. Move it to where you want to put it and then repeat the installation process. I will add this to the list of potential enhancements for a future release.
I downloaded the file, ran it. Choosing 1 Excel appeared to accept it.
Going into Add Ins within Excel Real stats did not appear. Instead you need to install it i. For the Mac environment follow the following steps:. On the dialog box that appears click on Browse to locate and choose the realstats You only need to install the Real Statistics Resource Pack one time. After that any time you open Excel you will automatically have access to the resource pack.
I have this same problem with Excel When I click on Add-ins, the pop-up window shows me that Solver is checked, but there is nothing that says Browse. Thank you, Charles, for developing this! I am pleased that you were able to use the software on a newer Window computer. Your email address will not be published. RSS - Posts.
RSS - Comments. Real Statistics Using Excel. Skip to content. Installation Once you have downloaded the Resource Pack, you need to install it using the following steps. Move the Resource Pack to where you want it located on your computer. Caution : once you install the resource pack at a particular location it will be more difficult to move it later. Make sure that the Solver option is checked on the dialog box that appears.
Then complete step 5 as described above. Real Statistics Functions 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. Jackie says:. August 24, at am. Jackie N. Charles says:. August 28, at pm. September 12, at pm. Charles, How does Real-Stats differ from regular Excel? Jason Grange says:. August 4, at pm. August 5, at am. Valerie Preye says:. July 27, at am. I need HELP, this is the error message i get. Tom MacInnes says:. August 25, at pm.
August 29, at am. August 30, at pm. Hi Charles Thanks for getting back to me. Grateful for any advice Tom. September 1, at pm. September 3, at pm. The predictions, in particular, were very useful Thanks again Tom. September 5, at am. Ann says:. July 19, at pm.
James B says:. June 19, at pm. Shruthi says:. May 27, at am. May 27, at pm. Benjamin C. Arnold says:. May 21, at am. May 21, at pm. James Chang says:. February 23, at am. ICC user says:. March 12, at pm. April 19, at pm. April 20, at pm. Joel, To uninstalls Real Statistics: 1. To reinstall it presumably with a different copy of the Real Statistics file : 1. Evan Hazenberg says:. January 3, at am. Cheers, Evan. January 3, at pm.
Hi Charles — Thanks for the info. Amadna Van Horne says:. December 22, at pm. November 8, at am. Steph says:. September 19, at am. Many thanks, Steph. September 19, at pm. September 20, at am. Bonnie Dornom says:. October 8, at am. Nur H says:. September 8, at am.
September 27, at am. Jake says:. May 17, at pm. Alex says:. July 25, at am. Any ideas? Regards, Alex. July 26, at am. Elton says:. July 24, at am. Aaron Phillips says:. September 7, at am. Hey Charles, Thanks for alerting me to the keyboard issue. Andrea says:. July 7, at pm. July 8, at am. July 8, at pm. June 22, at pm. Jeff Russell says:. June 2, at pm. Rach says:.
April 27, at pm. Hi Charles I cannot seem to find the weighted linear regression function in the real stat resource pack. Harsh Hemani says:. March 30, at pm. Charles Smith says:. January 7, at am. I wanted to also add that it asks me for a password as well. Add-ins window. We have successfully loaded the Analysis Toolpak. Figure 5. Output: Load the Analysis Toolpak in Mac. If it needs to be installed on the computer, click Yes to download and install. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.
If you want to save hours of research and frustration, try our live Excelchat service! We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Quick Excel Help. Get instant live expert help with Excel or Google Sheets. Your message must be at least 40 characters. Our professional experts are available now. In the click a new box open. But you cannot see any data analysis tool Pak there because you were not installed. So now what do you do?
Go to the Microsoft office support page. Now download this free software version putting your information. After finishing download install it. Now open up application folder in the finder menu. Scroll down and search for that software. Now open you excel sheet.
So now you officially install data analysis toolbar into your Microsoft excel for mac. You will not find this tool built in your mac excel. So after install this tool you will see a lots of proper data visualization tool that you needed.