Click on an icon below for a free download of either of the following files.

**Real Statistics Resource Pack**: contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website.

**Real Statistics Examples Workbooks**: four Excel workbooks can be downloaded for free, which contain worksheets that implement the various tests and analyses described in the rest of this website. Two files cover univariate tests and the other two cover multivariate tests and time series analysis.

**Real Statistics Analysis using Excel books**: Shortly you will be able to purchase books that will contain information that is similar to what you find in the website. The first of these books is expected to be available in early 2017.

I have downloaded the resource pack, but it won’t let me add it in as an add-in. It keeps saying RealStats.xlam is not a valid add-in. Any ideas? I am running Office 2003 so perhaps that is the problem?

Roger,

The Real Statistics Resource Pack add-in should operate correctly with Excel 2007, 2010 and 2013. I have not tested it with Excel versions before Excel 2007. In particular the file extension of the add-in that is supplied is .xlam. The file extension for Excel 2003 add-ins is .xla. In the next couple of days I will try to to save the Real Statistics Resource Pack add-in in the older .xla format. If so I will put this version on the website for downloading. I would appreciate it if you would then tell me if this version works on your computer.

Charles

Update(29 Aug 2013). You can now download the Excel 97/2003 version of the Real Statistics Resource Pack from webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Please let me know whether it works on your computer.This looks like a very good thing for me who still runs Excel 2003. I would like to try this out, but where on the page is the link to the .XLA file?

Cheers

Robert

Robert,

I am trying to get an .XLA version running now. I hope to have this available later this week.

Charles

Robert,

I added the .XLA version of the software earlier this month. Have you been able to download it? Is it working properly?

Charles

Charles, I downloaded the package, but when I went to customize my ribbon, I could not find the macro.

John,

Unfortunately this is a common problem. I don’t have a solution yet. For now simply press

Ctrl-mto access the Real Statistics data analysis tools. This works fine.Charles

Hi Charles,

This is a wonderful add-on and am enjoying using it for teaching postgrads online . Have a window that keeps asking for a password though. Can’t seem to get rid of it…

/steve

Hi Steve,

Pleased to read that you are using the software to teach postgraduate students.

I don’t know why you would receive a window requesting the password. The only reason I can think of for this happening is if you try to open the add-in. In that case you would certainly receive a request for the password. As you have seen you can use the software without needing a password.

In any case it is not great to keep being badgered for a password. Perhaps I can figure out how to get rid of the request. Which version of Excel are you using? Can you send me a screen capture of the window that asks for the password (using the PrntSrn key or Window’s Snipping Tool)?

Charles

Dear Charles:

I downloaded the last version of the Pack, ver 2.6, but the Ver() function output is still 2.5. Any comments?

Best regards,

Jorge

Hi Charles,

I downloaded the last version of the Pack, but when I loaded it into Excel 2013, and used it via Ctrl+M, I met with a popup window that keeps asking for a password too.

Jianguo

Hi Jianguo,

It is not sufficient to download the software. You also need to install the software. You do not need a password to do this. Please follow the following steps:

To install the software select

Office Button > Excel Options > Add-Insin Excel 2007 orFile > Help|Options > Add-Insin Excel 2010/2013, it is important that you look for theGobutton at the bottom of the window. You need to click on this button.Once you do this you should be presented with a dialog box as described in the instructions. If you have already put the Real Statistics Resource Pack file in the appropriate add-in directory you should see its name on the list shown, in which case you need to make sure that the file is checked. If not, you will need to search for it by pressing the

Browsebutton on the dialog box.Please let me know if this doesn’t work for you.

Charles

Hi Charles,

I have downloaded and installed the software follwing the steps as you told me, and I can open the function window via Ctrl+M to analysis my data. But, when I close the function window, a popup window that keeps asking for a password still appeared in the screen, and I can only close it after clicking the mouse twenty times. I don’t know why.

Jianguo

I need to have EXCEL SOFTWARE BECAUSE THE ONE IN COMPUTER DOES ONLY FOR LINEAR MODEL.I NEED REAL STATISTICS RESOURCES.

THANKS.

LINUS

Linus,

Were you able to download the Real Statistics Resource Pack?

Charles

Hi Charles,

Just wanted to thank you for this add-in, its a major help!

Hi Charles,

It seems you had created a wonderful add-in application, unfortunately I am not able to use it.

I had installed the add-in as per instruction in my Excel 2013, but not able to see the Realstata add-in in the ADD-IN ribbon. So my question is where to find the Realstats add-in after installation to use it?

Please suggest.

CK

Hi,

Once the Add-in dialog box is displayed (e.g. by pressing Alt-TI) if realstats is not displayed, click on the Browse button and select the file containing the software that you downloaded from the website. You should now see realstats on the Add-in dialog box. Check the box to the left of realstats and you should be in business. Let me know if this works.

Charles

Hi Charles,

Actually I had already installed the application successfully and it’s displayed in the Add-in dialogue box.. Options–>Add-in–> Active Application Add-in–> Realstats. Till here installation is completed.

Now my problem is where to find that add-in to solve the calculation? I am not able to see the Realstats under Add-in ribbon on the spreadsheet.

Thank you!

CK

Hi,

To access the data analysis tools just press Ctrl-m. To access the supplemental functions just type them into the worksheets just like a regular Excel function. A list of the data analysis tools can be found at http://www.real-statistics.com/excel-capabilities/supplemental-data-analysis-tools/. A list of the functions can be found at http://www.real-statistics.com/excel-capabilities/supplemental-functions/.

Charles

WOW.. Now I can use it…Thanks you very much…

Hopely I will get the result of Fleiss Kappa

Haewon,

Just use the formula KAPPA.

Charles

Can I use your Real Statistics Using Excel with Excel for Mac on my Mac Pro?

Tony,

There is a version of the Real Statistics Resource Pack designed for the Mac. You can download it for free at http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/. It has been tested with Excel 2011 for the Mac.

Charles

Sir

I have installed Realstats on my computer- excel add in as step wise.

But I can’t add it on Excel worksheet just like other tool pack -Data -analysis, Solver In.

Anybody plz help me

Cheers

bishnu

Vishnu,

The easiest way to access the data analysis tools is to press Ctrl-m.

The following webpage explain how to get access to the data analysis tools from a ribbon/menu, but this approach doesn’t seem to work for most people. I still need to fix it.

http://www.real-statistics.com/excel-capabilities/supplemental-data-analysis-tools/accessing-supplemental-data-analysis-tools/

Charles

Been continuously asked about RealStat password. Help! 🙁

I have OS Win8

Cathrine,

You don’t need to supply a password. This request usually means that you are trying to open the file containing the Real Statistics Resource Pack. You shouldn’t do this.

What you need to do is

installthe file, i.e. make sure that Excel recognizes the file as an add-in containing software. To do this follow the Installation instructions on the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/.Charles

Pingback: Release 2.17 of the Real Statistics Resource Pack | Real Statistics Using Excel

Pingback: Rel 3.0 Real Statistics Add-in | Real Statistics Using Excel

Dear Charles,

I have successfully downloaded the software, and the functions appear in excel, they don’t seem to work. Can you help me with this problem?

Sincerely,

David Fuzes

David,

Can you give me some examples of functions that don’t work? Please provide the name of the function and the arguments used. Do some functions work and other don’t? What happens when you use the function =VER()

Charles

Thanks for making it available for our use. it is very useful and simple.

Pingback: Release 3.4 of the Real Statistics Resource Pack | Real Statistics Using Excel

Many thanks for this software help! Definitely comes in handy with my position!!

Currently working on my BA, first time doing empirical research and it’s a real help using your website. However, I downloaded your Real Statistics Resource Pack but keep running into error messages. I installed it and can open the console via Strg + m. However, if I try to actually active the formulas (e.g. the correlation matrix) I always receive an error saying (roughly, it’s in German):

2Compiler error in the module: frmMatrix

This error generally occurs if code is not compatible with the used version, platform or architecture.”

I’m using Office 365 Home, if that matters. Any idea what might be the issue?

Jakob,

I don’t know what is causing this problem. I know that some other people have experienced similiar problems, but the software seems to run fine for most people.

Do use see the version number when you enter =VER() in any cell in a worksheet? (if not the installation was not performed correctly) Are you by any chance running the 64 bit version of Excel? (select File > Help to find out) Are you able to get the software working on some other computer?

Charles

The =VER() command works, showing me Version 3.5.2. I’m using the 32bit Excel, so that can’t be it. I don’t have another machine available currently to test your last question.

Sorry, there’s no option to edit a post: I’m also being asked (sometimes) to enter a password and if I activate/deactivate the AddIn I receive an error message saying something like:

Microsoft Visual Basic for Applications

“Project or library not found.”

Jakob,

You should never need to enter a password. Since the formula =VER() works properly I am very surprised to see that you are getting a message to enter a password.

I have just put a new version of the software online (Release 3.6). I suggest that you delete the software from your computer and install the latest version. Let’s see whether this eliminates the problem.

Charles

Pingback: Release 3.6 of Real Statistics | Real Statistics Using Excel

Pingback: Rel 3.7 Real Stats Software | Real Statistics Using Excel

excel packages are simple, effective and learner-friendly- lal

Hello Charles,

I am trying to download the RealStats onto my laptop. I am using Excel 2015….it let me download, but when I went to to Excel–File—Option, RealStat was not there all the other add-ins were there. Could you please help me out?

Mesha,

I assume that you are using Excel 2013 and not Excel 2015. Please see the latest Blog which seems to be related to this issue. Please let me know if the suggested approach doesn’t resolve your issue.

Charles

Pingback: Rel 4.0 Real Statistics software | Real Statistics Using Excel

Pingback: Rel 4.1 Real Statistics software | Real Statistics Using Excel

Hi. I downloaded the version and the installation went fine but my excel is in portuguese, so it appears a compilation error for me. Now, I cant even uninstall the .xlam supplement. How do I uninstall it? And how can I get a portuguese version? (assuming that the error is because of the language)

Gabriel,

The version that you downloaded has worked in German, Italian, Spanish and several other languages. There appears to be a large user population in Brazil, and so it probably also supports Portuguese.

Uninstall is similar to Install. Assuming that you are using Windows, press Alt-TI and unclick RealStats from the dialog box that appears and press the Close button. That’s all you need to do.

Charles

thank you for the free download. may God gives you hale and healthy.

Pingback: Rel 4.2 Real Statistics software | Real Statistics Using Excel

Hi sir, thank you very much for putting so much effort and share it with everyone who may need it.

I tried to install and use the addins package but it failed. I accidentally click the downloaded file when my Ms Excell was active. A dialog box asking me something about macros and i got suspicious and refer to your installation guidance once again. I then simply closed the dialog box and follow your installation guide. The installation seemed flawless but no operation nor analysis were successful everything turned out “compile error in hidden module analysis”. When I typed =ver() it turned 4.2 Excel 2007 and I believe i downloaded the right package. My wondows is windows vista servce pack 2, 32 bit. Please suggest me what to do.

Ahmed,

Were you using a previous version of the software or is this the first version that you have installed?

Charles

Hi Charles,

I am having problems with using the Stats program. I have downloaded it and it appears on my tool bar but when I try to use it to manipulate data it wont work within the excel spreadsheet. I cant select or enter data etc

I am using a Mac, OS X 10.10.3, Excel 14.5.3 for Mac 2011.

Can you help

Warm regards

Lisa

Lisa,

What value do you see when you enter the formula VER() in any cell in a spreadsheet?

What do you see if you press Command-m? Are you able to use the Descriptive Statistics data analysis tool?

Charles

I am using Windows 7 Professional, Service Pack 1 32-bit OS; =Ver() turns out 4.2 Excel 2007

I have downloaded the resource pack. The following problems found:

1. After install, it asked for “RealStats Password”

2. During using chi-square test, “Compile error in hidden module: ChiSquare”

Terry,

In order to figure out what is going wrong I have the following questions:

1. When someone is asked to give a password, this usually means that they are trying to open the RealStats-2007 file. You should never need to supply the password. Since you are getting the correct value for =VER(), this usually means that you were able to install the software properly (as described on the Download webpage. Is this what you did?

2. Are you able to use any of the Real Statistics data analysis tools? E.g. the Descriptive Statistics and Normality data analysis tool. Does the version of Office 2007 also include Outlook and Access?

Charles

1. Yes

2. Unable. Including Outlook only.

Terry,

I have recently heard from others who are having problems specifically with Excel 2007 as part of Office 2007 Professional. I have also been given the suggestion that upgrading to the latest Office 2007 service pack (namely SP3) can resolve this type of problem, but I have not been able to test this myself.

Charles

Pingback: Rel 4.3 Real Statistics software | Real Statistics Using Excel

Pingback: Real Statistics Release 4.4 | Real Statistics Using Excel

I have downloaded a MS Excel AddIns from a website for statistic analysis. There is a link to the downed file that has been saved to the following folder:

=’C:\Users\myname\AppData\Roaming\Microsoft\AddIns\RealStats.xlam

However, the actual link in the downloaded software is different and shown below:

=’C:\Users\Charles\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!RANDOMIZE(E4:E23)

when I tried to change Charles in the link back to “myname” I am not allowed to do so.

Please reply and help.

David

David,

If this link is in one of the examples workbook files, then you need to proceed as described on the following webpage:

Examples Installation

Charles

Hi, actually i had the programme successfully installed and the application working but when i try to apply Realstats on my excel it gives me this message ”Error compilation with the cache module:Chisquare” … Any idea how to fix this?

Thanks!

Robert,

A few questions to help me isolate the problem:

1. What value do you get when you enter the formula =VER()

2. What version of Windows or Mac are you using?

Charles

Hi Charles,

I downloaded the RealStats pack for Mac. It’s a great product btw. I’ve used it to run Kruskal Wallis test and now want to run a Dunn’s Test as a follow-up. The latest Mac version of RealStats doesn’t seem to have the Dunn’s Test as an option. Is that correct? (Perhaps I need to download an updated version.)

Andrew

Andrew,

That is correct. Sorry, but Dunn’s Test is currently only available on the Windows version of the software.

Charles

Dear Chales

Today I have downloaded and add in stat pack to use logistic regression, but the command of logistic regression is not appearing in the command list.

Please help me to find out the way, how to get the logistic regression command.

Regards

Sharad

India

Choose Regression from the main menu (which will appear if you press Ctrl-m) and then choose Logistic Regression from the dialog box that appears.

Charles

Charles, thank you very much for the add-in.

How do you calculate the Probability Density Function (pdf) ?

I understand formula normsdist(z,false) is the one to use; however, in Excel 2007 that does not work – it works without the FALSE argument. If I enter FALSE, or TRUE, I get an error message as the formula is not set up to accept the TRUE or FALSE.

Is it possible to calculate the pdf using your add-in ?

Carlos,

You can use =NORMDIST(x,0,1,FALSE) in Excel 2007.

Excel 2007 also doesn’t provide the pdf for the t distribution. In this case you can use the Real Statistics function T_DIST(x,df,FALSE).

Charles

Dear Charles

I have downloaded and installed Real Statistics Resource Pack, I am using excel 2010

I am not able to find the option Logistic Regression in the list. Please help

The current option coming after the regression is Reliability, no logistic regression option.

Regards

Sharad

Choose the Regression option. Logistic Regression is one of the options on the dialog box that appears.

Charles

Hi Charles,

I did a =VER() and it states 4.5 Excel 2010/2013/2016. I am using Excel 2010.

I am unable to find an option to use Slopestest. I looked under regression but don’tsee any sub-options. Am I missing something?

Thanks,

Jim

Hi Jim,

SlopesTest is currently only available as a function. You use it just like any Excel function. See the following webpage for details:

http://www.real-statistics.com/regression/hypothesis-testing-significance-regression-line-slope/comparing-slopes-two-independent-samples/

Charles

Pingback: Release 4.6 Announcement | Real Statistics Using Excel

Hello sir I am getting a message popup”Compilation error in hidden module ” That’s why Logistic regression is not working in my project.Help me and Thanks in advance

Sachin,

If you are using Excel 2007, a likely reason for this is that you need to install the latest service pack, namely SP3.

Otherwise, it is possible that you need to install Excel’s Solver, as described in the next paragraph.

The latest version of the software uses Excel’s Solver, and so you need to make sure that Excel’s Solver is installed. You do this by pressing Alt-TI (i.e. hold down the Alt key and press T and I) and making sure that there is a check mark next to Solver in the dialog box that appears. Then close Excel and reopen Excel.

Charles

I can’t believe tools like these are free.

Thanks a lot Charles, amazing work.

Hi Dr. Charles. I’ve been using this for my grad and undergrad research classes and its a great big tremendous help. Thanks. Do you have an instructional book or PDF on this? Should you have one, where can I purchase one? thanks so much.

I am pleased that the site/software has been helpful.

I am putting together some books, but they are not ready yet.

Charles

I have downloaded it. Thank you very much. It is excellent.

Pingback: Release 4.8 | Real Statistics Using Excel

Hello sir

I read the comments and complaints alongside your helpful response and I am amazed and for which I say thanks for helping our research students

On my own, I would have loved if you send or work in here for me, a practical model formulation process so that I can easily state my research model properly as I need to know how best to present a model of one dependent and 3 independent variable and how to go about the coding and regression analysis

Thanks so much

You can learn more about building a regression model by going to the http://www.real-statistics.com/regression-models/ webpage. Most likely you will use a multiple linear regression model, which you can find described on the webpage http://www.real-statistics.com/multiple-regression/.

Charles

Hi Charles,

Please let me know what versions of Excel and Windows can use your program. I have students that have Windows 10 and Excel 2016 and others with Excel 2013. I also have students that are still running Windows 7 and Windows 8. I also have some students that have MACs that run Excel 2016 and others that run Excel 2013. Do these differences matter or will Real Statistics run on any combination of operating system and version of Excel?

Thanks in advance,

Ken Burger

Ken,

The software will run on Windows 7, 8 and 10 (and probably XP as well). It supports Excel 2007, 2010, 2013 and 2016.

The software will also run on Mac OS, supporting Excel 2011 and 2016 (I don’t believe there is an Excel 2013 version for the Mac, but if there is then the software should support that as well). The Windows version of the software has more capabilities than the Mac version.

Charles

Charles,

Thank you very much for your prompt response. I will download today and check it out.

Ken

It would be great if you could put the Excel version requirements on the home page, as I had trouble finding this info here. I only have Excel 2000 and LibreOffice Calc 5 (2016), neither of which have the modern Excel macro commands.

Sorry about that, Max. I didn’t know that people were still using such old versions of Excel. I support Excel 2002 and beyond.

Charles

Good day Mr Zaiontz,

Thank you to enabling us to access the tool free of cost. I have downloaded the pack, but unfortunately, logistic regression is missing on the list of my ”add in list”. I’m trying to see the relationship between level of satisfaction (yes or no) and family size.

Thank you

Benedict Oni

Benedict,

Select Regression and logistic regression will be one of the options.

Charles

This is fantastic! Thank you for sharing.

You also have an error on sheet “SW Table” for the coefficients at n=49 a=13. 0.919 should be 0.0919. No need to post this, just for future releases.

Thanks for finding this typo as well. I will fix this shortly.

Charles

Hello,

I am trying to perform a Cox Regression survival analysis, however Cox Regression is not showing up on the list of add ons even though the site says it should be available. Where do I go about finding that?

Thank you!

Kristen,

When you press Ctrl-m you will get the main menu. Choose Survival Analysis from this menu and you will then get access to Cox Regression.

Charles

Thank you so much for the wonderful tool you have created.

Francisco – Brazil

Thank you so much Profesor. Very very very important and useful.

Pingback: Real Statistics Release 4.9 | Real Statistics Using Excel

Thank you very much Charles Zaiontz for developing such a wonderful statistical add-on and am enjoying it for using in my Ph.D analysis!!!!

Professor Charles Zaiontz thanks for sharing their knowledge … excellent gesture

I am a complete newbe to statistics. I had calculated a point-by point agreement but was told to use Kappa.I need to calculate agreement between the observer and myself about, The rate of correct questions answered by three children over 7 observations which is 21 sessions. We had 100% agreement on 19 of the sessions and 83% on the remaining 2.

Please help

Mandy,

See the following webpage

Cohen’s Kappa

Charle

Pingback: Real Statistics Rel 4.11 | Real Statistics Using Excel

Hi Charles.

I have a question about installation of Excel.

I am using 2011 version of Excel with Mac.

but whenever I try to check the real-estate and solver, “errors over loading dll”comes up and I can’t see real stats installed.

How can I deal with it?

thanx and this is a very nice program BTW.

Sandra,

Are you saying that you can’t check both RealStats 2011 and Solver?

Charles

Yes, I tried to check both at the same time at first, which didn’ work well so checked solver first and real stats next. but it didn’t work, too. I checked real stats only but it didn’t work…Should I install new Excel ?

Sandra,

All I can think of is to try unchecking RealStats and reinstalling from the beginning.

Charles

Hi Charles,

Thank you for creating these useful tools for Excel, and I was wondering if you could make the same tools in 64-bit version? Sometimes, I have a very large dataset (containing large amount of array formulas), and 32-bit Excel can only use 2GB Ram as pointed out at https://support.microsoft.com/en-nz/kb/3066990.

Thanks again for giving us the basic statistics knowledge on this website.

Lu

Lu,

A few people have asked for a 64-bit version, and I will consider implementing this when a receive a larger number of requests.

Charles

Charles,

I too would like to request the 64-bit version. Thanks.

Nathan,

Thanks for your input.

Charles

Charles,

Realstats is a valuable tool. I second the request for developing a realstat plugin that would work with 64-bit version of Excel.

Thanks.

Sourav

Thank you Sourav for your suggestion.

Charles

Great software but after downloading the latest version it seems to not have the Scheirer-Ray-Hare Test as detailed in your blog post:

http://www.real-statistics.com/two-way-anova/scheirer-ray-hare-test/

the two way ANOVA options has only the first four options listed in the above link and not the SRH test? Has the test been removed?

Even the help only lists the four test options.

Thanks.

Bryan,

The latest version has seven options. The help lists all seven options.

Charles

Bryan,

Are you using Release 4.11? You can check by using the formula =VER(). The latest version has seven options for the Two Factor ANOVA data analysis tool.

Charles

No, I am not it turns out, I have 3.2.2 but then I downloaded it directly from the above links maybe ten minutes before I posted the message.

Bryan.

Re-downloaded it and now all is good.

Thanks again.

Bryan,

That was probably the version for Mac, which does not yet contain the test that you are looking for.

Charles

Thanks Prof for sharing. I am really enjoy your detail explanation.

Sorry to bother you about this simple question:

Does the table presented in Sheet TOC0 of Real-Statistics-Multivariate-Examples.xlsx

represent 120 student ratings of 9 traits or criteria for only ONE professor?

The corresponding web page states “…observed data for each of these (9) variables.”

(Beyond that, Professor Zaiontz deserves a Nobel Prize for these outstanding tools.)

Roland,

I guess you are referring to the data for Principal Component Analysis or Factor Analysis.

The ratings aren’t for any specific professor or professors, but for the students’ ideal professor.

Thanks for your kind words about me.

Charles

Hi,

Although I can download the Real Statistics Resource Pack License, I cannot download the Real Statistics Resource Pack itself – I just get a blank window! I’m using Excel 2013 in Windows 10.

Please advise.

Thank you in advance – much appreciated.

Regards

Roy,

I am not sure what sort of difficulty you are having, but I just downloaded the software without any problems. See

http://www.real-statistics.com/free-download/real-statistics-resource-pack/

Charles

I have placed xlam file at D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns. Some of references in Examples-Part-1, Part-2 don’t seem to resolve. Like I am seeing #NAME? in cov sheet where its showing =’D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!COVARP(B4:B11,C4:C11). Several other sheets work fine. Please help.

Sanjeev,

You can use Excel’s Replace capability to replace all instances of =D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’! by =

See http://www.real-statistics.com/free-download/examples-installation/ for more details.

Charles

Thanks for the Response. I have replaced as suggested in entire workbook still problem persists. For eg the formula bar on clicking the cell with #Name? shows =RESHAPE(A5:C8). I tried to copy the Input range from somewhere else in sheet and write corresponding output formula in other cell but still its giving #Name?.I am using Excel 2013.

To me it looks to issue in loading of RealStats.xlam functions as when I click the cell with #Name? it shows =RESHAPE(A5:C8) in formula bar and now select Insert Function, the function popup shows the name RESHAPE with parameters but below it writes undefined.

I have one observation through ‘Show Calculation Steps’ on selecting the call displaying #Name?, for eg: In Reformat sheet, I select cell with =RESHAPE(A5:C8) in formula bar, and now when I see ‘Show Calculation Steps’ it references Reformat!$E$5 and in this execution it gives #Name?(A5:C8)

May be this info might be helpful in diagnosing the issue?

Sanjeev,

What do you see when you enter the formula =VER() in any blank cell?

Charles

On entering =VER(), getting #NAME?. On checking with ‘Show Calculation Steps’ it references Reformat!$P$17 (Cell number).

Sanjeev,

In this case, the Real Statistics add-in has not been installed or has not been installed correctly.

You need to download and install the Real Statistics Resource Pack before you can use the examples workbooks. See the following webpage:

http://www.real-statistics.com/free-download/real-statistics-resource-pack/

Charles

Hi there,

Please can you tell me how to do a PROBIT regression analysis to determine the detection limit of the method I am testing. Which function in Real Stats can do this.

Thanks so much

Anita

Anita,

The Real Statistics Resource pack doesn’t yet support Probit regression. It is similar to logistic regression. I expect to add this capability shortly.

Charles

Pingback: Real Statistics Rel 4.12 | Real Statistics Using Excel

Dear Sir

Thank you for a very useful site!

However, I am unable to use the Realstat add-in due to the lack of 64-bit version. How is your implementation going?

Best regards

Anders

Anders,

Sorry, but I am not currently working on a 64 bit version. This is on my list of future enhancements, but so far the demand hasn’t been high enough that I have prioritized this enhancement over others.

Charles

I would use the 64 bit version as well if that becomes a reality.

Michael,

It is a reality. See Blog.

Charles

Hello,

Does it works with office 365?

Yes

Dear Sir, I ve attempted to use the real stats for both 2013 and 2016

for 2013- i cant get pass the installation and for excel 2016, it requires a password?

Anne,

See http://www.real-statistics.com/appendix/faqs/password-prompt/

Charles

Hello, can use it for my excel 2016?

Anne,

Yes for Excel 2016 for Windows. Soon for the Mac.

Charles

Pingback: Real Statistics Release 4.13 | Real Statistics Using Excel

Pingback: Release 4.14 | Real Statistics Using Excel

Thank you very much, this is life saving.

Ciuldnt find SUrvival Analysis option in the mac version?

Shruthi,

This capability is not currently supported on the Mac version. I am working on a new version for the Mac that should be available sometime in June.This version will include Survival Analysis.

Charles

Pingback: Real Statistics Release 5.0 | Real Statistics Using Excel

FOR MANY YEARS AGO IAM LOOKING FOR SOME LIKE THIS BY CHANCES I FIND IT HOPE THAT TO FIT WITH MY REQUEST

Pingback: Real Statistics Rel 5.1 | Real Statistics Using Excel

it request password. where do i get it?

See Password Prompt

Charles

Hai Dr. Charles;

I hope you are well.

I sure you would help me, where I have a statistical problem as follow:

I have 2 populations, 1st is a health providers at 2 hospitals (supervisory staff) with total sample size of (328 person) and the 2nd population is the in-patient at the same 2 hospitals with total sample size of (540 pts.). 2 surveys was used to collect the data, one survey for each population, the 1st one (with 68 questions) for the 1st population used to measure the level of using Six Sigma Methodology (DMAIC) at 2 hospitals, and 2nd one (with 36 questions) for the 2nd population that used to measure the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) at the same 2 hospitals. Both surveys has the same 5 dimensions (DMAIC) with same Likert Scale (5 scale), the data was collected at the same times. There are difference in questions no. between the 2 surveys, but there are (13) similar questions in every survey.

N.B: The surveyed (male and female) pts are from several ward (medical, surgery and obstetric wards), also most of health provider (male and female) are from these wards.

I need to find the effect or association (correlation) between the level of using Six Sigma Methodology (DMAIC) as (X variable) and the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) as (Y variable) using the data that collected as mentioned above. So I do the following:

1. Assuming that, level of pt. satisfaction is the Y variable, so I fixed every pt.’s case score (average mean for every dimension and total mean score), then we have 540 pts. with (6 scores for every one).

2. Also I assuming that, level of Using Six Sigma Methodology (DMAIC) is the X variable, then I measure the score for every health provider case (total of 328 person), so I have 6 scores for every one (average mean for every 5 dimensions and total mean score).

3. Using bootstrapping technique to generate random samples form the scores of health provider cases that every random sample contain (10) cases of them together which starting with a certain generated no. and calculate the scores, then return back the cases for the origin samples.

4. Repeat previous step (3) starting with a new generated no. to be sure not repeat the same generated random sample.

5. With step (3) and (4), using bootstrap, so we have (1000) random samples for each (540) pt. cases.

6. From the previous steps we will calculate the correlation between (X) and (Y).

My question is that: Is this procedure right to calculate the association between X and Y?, if Yes, which test can I used to perform it?, if No, How to do this right?.

Or I must measure the overall level of using Six Sigma Methodology as will as the pt.’s satisfaction in each ward of hospital alone then match them and do the bootstrap, or do it by gender in every ward then match them as:

Overall score of female (Health provider) in surgery ward (X variable), attach with overall score of female (inpatients) in surgery ward (Y variable).

And overall score of male (Health provider) in surgery ward (X variable), attach with overall score of male (inpatients) in surgery ward (Y variable).

Also the medical and other ward the same as previous.

I’m looking for your kind answer.

best regards;

Amer,

It looks like you have a very important research to undertake and your approach may be a good one to follow. I am happy to answer specific questions (with a limited number of complications), but I don’t have the time necessary to really understand the details of the scenario that you are describing.

Charles

Pingback: Real Statistics Release 5.2 | Real Statistics Using Excel

Thank you!

Dear Dr Zaiontz:

One of my students updated windows 10 using Fall Creators Update. Apparently there is a compatibility issue with the last version of Real Statistics. Do you have any info on this?

Thanks in advance for your help

Jorge

Hello Jorge,

Thanks for the heads-up. So far I haven’t heard of any compatibility issues specifically related to the Fall Creators Update, but various issues have been appearing over the course of the last few months which may be related. I have just added a Troubleshooting section on the webpages from where people download the Real Statistics software that explains how to deal with these issues. I will make the required changes as I learn more.

Charles

Pingback: Real Statistics Release 5.3 | Real Statistics Using Excel

Hello Sir,

Thank you for your site, very useful.

I’m also encountering compatibility issues. I’m running in Windows 10 (64bit) and have recently updated to the Fall Creators Update. It’s my first time to try your real stat add-in though, so I have no comparison with the other versions of Windows 10. I’m using Excel 2016.

I was able to install the add-in just fine. Solver add-in is also installed. But when I try to use any of your functions, KCORREL for example an error appears:

“Compile error in hidden module: Correlation.

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.”

With the add-in installed, I encounter “Automation Error” pop-up everytime I open the Excel.

I also did the troubleshooting instructions mentioned but didn’t work.

Thank you!

Do you also get this error message when you enter the following formula? =VER()

It sounds like you have done all the right things, but I don’t have any experience with the Fall Creators Update to know whether it is causing the problem.

Charles

Hi Charles,

I found out that it’s the solver add-in that’s causing the error. I’ve seen many people raised that issue over the internet but has yet to be resolved. Anyway I was able to run your add-in on a different machine.

However, I was getting the KCORREL for 2 columns (18,000 rows). It was able to compute for the kcorrel, but when I invert the order of the columns, say KCORREL(B,A) instead of KCORREL(A,B), I get #VALUE as the result. Shouldn’t it be somewhat commutative, I mean not order-specific? So I am expecting the same result when I do KCORREL(A,B) and KCORREL(B,A).

Thanks a lot!

1. When you say that Solver is causing the error, do you mean that Solver was not installed (and checked in the list of addins)?

2. Yes, KCORREL(A,B) and KCORREL(B,A) should yield the same result. If you send me an Excel file with your data, I will try to figure out what is going wrong.

Charles

Pingback: Real Statistics Release 5.4 | Real Statistics Using Excel

Dear sir,

Goodafternoon,

I downloaded year new updated RealStats.xlam software for 2013/2016. I installed in my computer. But this software has to be installed time and again for every file. RealStats.xlam works for only one time. Why??

Your old version software did not give me this type of trouble. Please, tell me any solution for new updated RealStats.xlam software for 2013/2016.

Gautam,

Please explain what you mean by “this software has to be installed time and again for every file.” What do you mean by “every file” since there is only one file realstats.xlam? Also what do you mean by having to install “time and again”? Are you saying that when you close Excel and then reopen it, =VER() and Ctrl-m no longer work? If so, this is strange.

Charles