What is Real Statistics Using Excel?
Real Statistics Using Excel is a practical guide for how to do statistical analysis in Excel plus free statistics software. This software package extends Excel’s built-in statistical capabilities. In particular, it will enable you to more easily perform a wide variety of statistical analyses in Excel.
What does Real Statistics Using Excel consist of?
Real Statistics Using Excel is comprised of the following four components:
Real Statistics Resource Pack
An Excel add-in that extends Excel’s standard statistics capabilities. It provides you with advanced worksheet functions and data analysis tools. This will enable you to more easily perform a wide variety of practical statistical analyses. The software supports Excel 2007, 2010, 2013, 2016, 2019, 2021, and 365 for Windows. It also supports Excel 2011, 2016, 2019, 2021, and 365 for the Mac. The current version is Rel 9.3 (released 1 December 2024). There is also limited support for Excel 2002 and 2003.
Real Statistics Website (i.e. this site)
- Lets you download a free copy of the Real Statistics Resource Pack
- Provides tutorials and descriptions of how to perform a variety of statistical analyses using built-in Excel capabilities. You will also learn how to use the supplemental capabilities provided by the Real Statistics Resource Pack.
- Presents numerous examples in the form of Excel worksheets which you can download to your computer
For the student and the novice, the Real Statistics website is an excellent tutorial for learning the basic concepts of statistics and how to do statistical analysis. For all users, it provides a step-by-step guide for how to do statistical analysis in the Excel environment and the tools necessary to carry out these analyses.
You can use this website to learn how to perform statistical analyses in Excel even without using the Real Statistics Resource Pack. But we recommend that you download the resource pack so that you can have access to its powerful capabilities.
Real Statistics Examples Workbooks
Consists of fourteen Excel files that contain all the examples shown on the website. These example files can be downloaded for free (click here). Each example focuses on a specific statistical concept and has been designed to demonstrate simple concepts before moving on to more complicated topics.
Over time, the webpages on the Real Statistics website are being updated so that you will be able to download an Excel file with any of the examples found on that particular webpage.
Real Statistics Community
Each webpage has a Comments section where you can make suggestions, identify errors, ask questions to others in the community, or request their advice.
You can also get updates about new releases and other information via the @Real1Statistics twitter feed.
How do I get started?
Step 1: If you elect to use the Real Statistics Resource Pack, click on the following icon. You will be given the opportunity to download and install for free the Real Statistics Resource Pack.
Once you have downloaded and installed the Real Statistics Resource Pack, you will be able to use the supplemental capabilities with your copy of Excel. This is described throughout the rest of the website and is summarized in Using Real Statistics Functions and Real Statistics Data Analysis Tools.
If you choose not to download the resource pack or examples now, you can do so later at any time.
Step 2: Browse through the website to learn how to perform a wide range of statistical analyses in Excel using standard built-in as well as supplemental Real Statistics capabilities. We suggest that you begin by clicking on the Website Introduction (and especially Organization of the Website). These will explain how to navigate the website to get the information you need to run any specific statistical test or learn about any particular topic.
Why do statistical analysis in Excel?
The reasons for choosing Excel are as follows:
- It is widely available and many people already know how to use it
- It is not necessary to incur the cost of yet another tool
- There is no need to learn new methods of manipulating data and drawing graphs
- It already contains some basic statistics functions and data analysis tools
- It is much easier to see what is going on since unlike the more popular statistical analysis tools very little is hidden from the user
- Excel provides the user with a lot of control and flexibility
This makes Excel an ideal tool for learning statistical concepts and performing some basic statistical analyses. Unfortunately, its built-in statistics capabilities are limited. As a result, many prefer to use statistical tools such as R, SPSS, or SAS for carrying out more advanced statistical analyses.
We created the Real Statistics Resource Pack to address these shortcomings. This software package contains various supplemental tools that enable you to carry out a wide range of advanced statistical analyses without leaving the Excel environment. You can download the Real Statistics Resource Pack free of charge from this website.
Hello, I would like to know how to solve this problem.
In a study of 150 male and 200 female internet users, 30% of males and 35% of females said they plan to shop online at least once a month. At 0.10 significant level, is there a difference in proportion of internet user between male and female internet user who plan to shop on line?
Banz,
You could try to use a chi-square independence test, knowing that 45 males shop online and 105 don’t, while 70 females shop online and 130 don’t.
Charles
Dear charles,
Sir i need a Help from you. I am basically a Statistics student.
now presently I am working in a Shrimp feed(fish feed) production company.
So this feed is produced in 5 types generally based on a formula. now we have launched a new formula with a minor change. We have fed this new feeds and previous feeds in different ponds independently. It means the shrimp in 10 ponds are fed with 10 feeds. The growth of shrimp is noted every week and the data for 6 weeks of these growth rates of 10 ponds are collected. Now my task is to analyse and report weather the previous formula of feed is better or the new formula. Sir please help me out how to perform this statistical task in excel.
It sounds like you need to use some form of ANOVA (repeated measures, split-plot, etc.), but it is difficult for me to determine which type of ANOVA model is best based on the limited information that you have supplied.
I suggest that you look at the ANOVA portion of the website to help you determine which is the best form to use.
Charles
Hi Charles,
I have run a few tests using real stats and they worked perfectly. Thankyou! I however keep getting an error when I try to run a repeated measures ANOVA. It says ‘Run-time error ‘1004’ Application defined or object defined error.
Do you know why this might be the case?
Many thanks,
Na
Na,
If you send me an Excel file with your data and analysis I will try to figure out what is going wrong.
You can find my email address at Contact Us.
Charles
Hello Charles, I don’t want to look a gift horse in the mouth, but just wanted to understand your rationale for providing this fantastic resource for free. Apologies if this is written somewhere on the site but I couldn’t find it. Many thanks, I find the articles a very good, clear, and practical introduction to the topics (which tend to be covered, unnecessarily, in a much more elaborate and confusing way elsewhere!).
Jim,
I appreciate your kind remarks about the site. I am always pleased to learn whether I have been successful in providing useful but simple-to-use information with the right combination of utility and explanation.
This might sound corny, but my goal is to give something back to the world. I started out in my career as a research mathematician and professor, but have worked as an executive in business for most of my career. Now that I am semi-retired I wanted to return to mathematics. I am having fun putting together the website and the software resources, and at the same time I feel that I am doing something to help people all around the world. I am also enjoying the challenge of making the website as good as I know how to make it.
My goal is not to make money, but shortly I will begin to publish a series of ebooks (as mentioned on the website) to help defray some of the costs of the site. I also plan to add a donation button for the same reason, but even after almost four years of creating the website, I still haven’t gotten around to adding this.
Charles
The add-in seems to have a problem with Independent variables less than 1 and greater than 0. Why is this?
Chris,
If you are referring to values that you put in the dialog boxes (e.g. for Alpha), then this is due to how decimals are handled in some versions of Excel (comma versus period). I have added a % option with does away with the problem. If you click on the Config button on the main dialog box (the one that appear when you press Ctrl-m) and choose this option, then instead of entering .05 (or ,05) for Alpha, you would enter 5 for Alpha %, thereby eliminating the problem.
If you are referring to some other problem, then please send me an Excel file with the data that you are using. You can send it to the email address in Contact Us.
Charles
Checking the % in the Alpha caused a different issue. The tool is looking for a Classification Cutoff between 0 and 1, inclusive.
My question was about my raw data and if the tool had issues with independent variable values between 0 and 1. I was able to answer my own question when I tested just 2 of my independent variables that have values between 0 and 1. The tool was able to perform the calculations as expected.
However…There seems to be a limit on the number of independent variable values the tool can use to perform a Binary Logistic regression. I have 14 independent variables and after some testing, the tool “chokes” when you set the range to 6 or more independent values. I will send you my data for your review. Thanks.
Hi Again,
Seems I’ve been able to move on past 6 independent variables and now the tool can work all 14. I’m still working on the arrangement of the data in the sheet so I can be confident when the Regression returns results, they are as accurate as possible.
Is there any way to dictate the sorting of the data that is returned in output range? By default, it appears to sort the data in ascending order by the first two variables in my dataset. I would like the data returned in the output range in the same order as it is in the input range.
Chris,
I don’t fully understand your question. If you would like the data returned in the output range in the same order as it is in the input range, then you don’t need to sort at all. Clearly I am missing something.
Also which sorting approach are you referring to (since there are Excel procedures for sorting and various Real Statistics functions).
Charles
______________________
[1] – The Earth is Round (p>.05), Dec. 1994.
If a person . . .
J. Cohen [1] was lead to “prove” that the NHST procedure is wrong do choose the sequence:
__1) If a person is an American (A), then he is probably Member of the Congress, (MC)
__2) The person is Member of the Congress
__3) Therefore he is probably not American.
It is astonishing that an element of a subset (MC) be questioned to belong to its proper set (A), when a MC must be from A, necessarily, without exception.
!!! Do intend the Psychologists took us by idiots stoned? Or they are only kidding?
Luis
Hi! Many thanks for this cool site!
I’ve a little problem: My Excel is 2016.
When ever I activate the real stats add-in, save the file an re-open it I cannot see the add-in tab though the Add-In is shown up as activated. I have once again to deactivate the check box for Real Stats, leave the add-in check box list, go back and check it again. Then the add-In tab is shown up whare I find the real stats menu – but only for the actual session. When I save the excel file and re-open it again the add-In tab has vanished.
Any ideas?
Gabor Törö
Gabor,
This is a problem that has recently appeared due to some security upgrade that Microsoft just made. It affects any Excel addin including Real Statistics. Fortunately one of the users has identified a solution, which you can find at
Blog
Charles
Thank you!
Just tried it. It does not work for me. Well, it is only a bit annoying. Real Stats works. So forget it. Thank you.
Gabor Törö
Hi,
thank you very much for these powerful tools!
Is there a way to put these function into a Macro in a way to be able to repeat the function in different sheets, without have to do it every time in each sheet?
I tried with a normal macro in Excel 2016 and it doesn’t work and I didn’t find info in this website.
Thank you in advance for the answer!
Have a nice day!
Asnicar,
How to do this is explained on the following webpage>
Calling Real Statistics Functions in VBA
Charles
Hi
This really is a fantastic resource.
I have produced an employee engagement survey using Likert scales.
I have averaged a group of Likert responses to form an overall engagement score.
I have different engagement scores for different population groups eg from staff at different offices, staff with different job titles etc. I want to know if these differences are significantly different from each other.
I only have a basic understanding of statistics so if you’re able to respond as you would to a newbie it would be much appreciated.
Thanks and much appreciated.
Richard,
It really depends on the details, but you might want to start by looking at one-way ANOVA. See
One-way ANOVA
Charles
Apreciado Dr. Charles, me gustaria saber si hay una nueva version del paquete Realeal Statistics, dado que ultimamente he tenido que instalarlo por add ins cada vez que voy a usarle en excel.
Muchas gracias
Dear Dr. Charles, I wonder if there’s a new version of the package Real Statistics, since lately I had to install it add ins every time I’m going to use this one in Excel.
Thank you very much
Gerardo,
I expect to issue a new version sometime before the end of July.
Charles
Thank very much Sr.
Hi, Im a professor at Del Valle University in Guatemala City. I want my students to use Real Statistics in Statistics 101, which is a course that I teach. I have never had a problem installing the software however some of my students have been having some problems installing it. How can I contact you guys for further assistance? By the way, your program rocks! Thank you for doing it.
Gabriella,
Thanks for your kind remarks. You can contact us by going to Contact Us.
Charles
Hi Charles and Gabriella,
Microsoft has installed lots of Microsoft Office patches on 15th July. After that, I have run into the same problem. I can’t get Real-Statistics up and running through any of the methods. Charles, if you happen to find a solution, please do post it 🙂
Great tool! Hope to be able to get it back up and running again.
Best,
Wolfgang
Wolfgang,
I have had no problems running the Real Statistics software on my computer. What sort of error messages are you seeing?
Charles
Hi Charles, I have figured out the solution. All I had to do is go to Developer-AddIns, click on RealStats and ok. Excel asked me if I want to reinstall/overwrite, confirm, and it’s working again. Just in case anyone else encounters the same problem.
Let me just say that your tool is absolutely great; I do ALL my data analysis with it (well, with the exception of SEM).
Best, Wolfgang
Wolfgang,
Thanks for sharing this.
Glad to see that the software is useful for you. Eventually I will also add SEM support.
Charles
Hello I’m trying help my son who’s a pre-med student doing a summer research internship at a local hospital. We’re struggling to figure out which statistical test(s) are best for the given data collected. Is there some way to post a question regarding his data, to maybe get some suggestions from Statistic-minded people? I realize this is asking a lot, but figured I’d at least throw it out there, so maybe someone could make a useful suggestion for us. Btw we’ve been experimenting with the tools provided here and everything works great! It’s just that again, we’re not sure we’re asking the right question for the various stat’s tests. If that makes any sense.
Thank you!
Scott,
Please describe the hypothesis that you are trying to test and the nature of the data.
Charles
Apreciado Dr. Zaionits, reciba un cordial saludo, Dr excuseme una pregunta, si yo hago una tranformación de Box Cox Normal para mis datos, como calculo la inversa de la tranformación para interpretarlos?
Dear Dr. Zaionits, Yours sincerely, Dr Excuse me a question, if I make a transformation of Box Cox Normal for my data, as I do calculating the inverse of the transformation in order to interpret?
Great Work……..We are thankful to you.
NICE Charles!
Thank you for all the recent functions in the updates. It saves me a lot of time to perform forecasting.
Every time i download an updated version I am surprised by all the features in the AddIn. Probably the most comprehensive Excel AddIn for stats I’ve ever come across.
Y’all have a good one!
Marc,
Thanks for your comment. I am pleased that the software is saving you time and helping you with your activities.
I add more features all the time, although the output may slow a bit during the summer.
Charles
Does your product work with Excel 365? (windows)
Alex,
My understanding is that it works on the desktop version of Excel 365.
Charles
I’ve been doing scientific research for quite some time and some of the high level statistics used to always impede things (using python or matlab) and take away the fun of the general picture.
I have to say this is the best, most intuitive, and straight forward statistics analysis pack I know. Your explanations are also very good, not too over my head, but also not too dumbed down.
Thank you and keep up the good work!
Dear Charles
I can only echo the comments thanking you for this resource
Your clarity and examples have revealed the mystery of statistics to a less than numerate student ‘of a certain age’
For me the best advantage over ‘black box’ stats packages is that you demonstrate very clearly the relationship between the data and the results and the processes which generate those results
Kindest of regards
Rod
Rod,
Thank you very much for your kind remarks. I am trying hard to make the subject accessible to a wide audience.
Charles
Hi, can someone help me? I am trying to use the Jenks Natural Breaks option. It kept freezing. So, I reinstalled, but now I can’t find the Multivariate Analysis option on the menu. It worked before beautifully, but now it seems to be gone. Any help is much appreciated. Tom
Thomas,
The Multivariate Analysis option is still supported by the software. Which version of the software are you using? You can enter the formula =VER() to find out.
Charles
Thank you, Charles. I’ve reinstalled. I’m using 2013, and I now see the option. But, it seems to freeze when I try to use Jenks. Is it supposed to process for a long time? Any advice is most appreciated.
Tom
Tom,
If you leave the Number of Iterations field blank then the algorithm will evaluate all possible partitions, which depending on the size of your data could take a long time. You can specify the number of iterations to reduce the processing time. See the following webpage for more infor:
Jenks Natural Breaks
Charles
Yes, I started to think that. I only would like 5 classes for 253 rows of two variables. The instructions seem to imply leaving it blank. It’s been processing for about 15 minutes now. Is there a best practice? Maybe 100K, how long would that wait? Should I just wait for this to finish?
Thomas,
15 minutes is a long time. Leaving the field blank means that you will get the best answer, while if you put in a value you might not get the best value, but you may get a good-enough value. In any case, I would suggest that you put in some low value, say 1,000, and see how long it takes. If not too long increase the number until it looks like it is taking too long.
Charles
Hi Charles,
I stumbled upon this site: http://www.statisticsmentor.com/ … i wonder if this is also yours.
Best,
Kris
Kristina, no it is not my site.
Charles
Thanks for your attribution!
I am using it as Add-in for Excel. But in “k-means Clustering Analysis”, I get different results with the same data set after 10 times repeat.
Can you tell me what the reason is?
I’m sorry to bother you.
The problem was solved. There was some trouble with my computer. ^^
Hello Charles,
I just came across your powerful Excel site and I can say that I have been richly blessed. I am an online student of one of the US universities studying quantitative finance.
Thank you for your ingenuity in making this freely available.
Hello Charles,
Thanks for putting this online, but I’m already stuck in the installation process (maybe because I’m on the corporate network). I’ve copied the .xlam (for Office 2007) to my “C:\Users\username\AppData\Roaming\Microsoft\Invoegtoepassingen\” (Invoegtoepassingen=AddIns in Dutch), made sure the Solver add in is loaded but it tells me it has no access to the file.
I made sure it’s there (by browsing to check if its really there and not deleted or what). All rights seem okay (SYSTEM and my user have full control except “Special permissions”) and also restarting Excel didn’t help. Suggestions? Thanks!
Ben,
I don’t know why you are getting this message. The following comment from a user who uses the name “Cyberpreneur” may be helpful
“to correct the password problem requires installing the Real Stat addin in proper manner. Copy the downloaded file to /Microsoft Office/Office12/Library/Analysis , then restart excel. Then install in normal way.”
I don’t know whether this will work, but it might.
Charles
Wonderful resource! Thank you for freely providing this add-in and all your tutorials.
Many thanks for providing this great addition to Excel!
Sir,I have installed it but what is the password ?
You don’t need a password, but you do need to follow the instructions for how to install the resource pack. These instructions are listed on the same webpage from which you downloaded the resource pack.
Charles
Thanks for this program! I have upgraded from Excel 2010 to Excel 2016. I have updated the Real States to ver 4.6 in the same location as the older version (C:\Users\user-name\AppData\Roaming\Microsoft\AddIns).
I use realstats for KS 2-sample tests and really like it!
Realstats is asking for a password, and excel is throwing a “solver error” . Then excel crashes. Any ideas about what might be going on? Thanks.
Dave,
Glad to see that you are using the Real Statistics software.
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
Thank you for the prompt response.
I have solved the issue. You cannot check/install at the same time the Solver, RealStats, and Data Analysis AddIns. If you do, then there are problems. If you install the Solver, then make sure it’s working, then RealStats everything appears to run smooth.
Dave,
Thanks for the clarification. I will pass this on to others.
Charles
I am running El Capitan 10.11.3 on a Macbook Pro Retina. I have Office 2016. I installed this software and then deleted it, because it did not have some capabilities that the Windows version has. The problem is that the add-in still appears in my “available add-ins” in Excel, even though I deleted the program. Does this program have an uninstaller? How do I get rid of it so it does not show up under my “available add-ins.”? Should I reinstall it, then “uninstall” it as opposed to moving it to trash like before? Thank you for any help.
It probably doesn’t harm anything by doing nothing, but you should be able to “uninstall” it via the following steps:
1. From the Tools menu choose Add-Ins.
2. Uncheck the Realstats 2011 option on the dialog box that appears and click the OK button.
Charles
Hello,
i downloaded the booklet from syncfusion and i noticed an error on page 23, where it says:
“…such that (1+????)^4= 1.334. Thus, ???? is equal to .334(1/4) = .0747”
That is wrong. The correct procedure to find ???? is first to calculate (1.334)^(1/4) and then subtract 1: r=(1.334)^(1/4) – 1.
Also, .334(1/4) = 0.760, very far from 0.0747
Thanks Stefano for finding this error. I will try to get the publishers to correct the error.
Charles
I work in finance and regularly do statistical work, largely involving regression and correlation. In particular, I have used various tools, including importing datasets into R in order to get RSE regressions in order to satisfy regulators when doing loan loss analysis. What I don’t know is how I didn’t know of your site and tools earlier. Let me just say that you are my personal hero. Thank you so much for your articles and work. Do you have an area or way to accept contributions? I’d be happy to contribute something for this pack of awesomeness.
Thank you very much Mel for your kind words about the website.
My philosophy has been to provide all the statistical capabilities free of charge (except for some upcoming books which I will sell for some minimal fee). I want people to have access to these capabilities without having to pay. I am considering adding a voluntary donation capability to cover some of my costs, but so far I have focused on adding new capabilities to the site and software.
Charles
Really great plugin – was going to do some of the most basic stuff myself (e.g. Shapiro-Wilk and frequency reports), but this saved me loads of time and i’d never be able to do the advanced stuff you have.
ONE REQUEST….
Could you please make the “input range” used on most of your forms default to the current selection. This would be really great!
keep up the amazing work.
Graham,
Good to read that the plugin has helped you.
Please explain why making the input range default to the current selection would be helpful. Currently I have the output default to the current cell. What would you have me do when there are two input ranges?
Charles
Hi, here is my case, given purely with the intention for you to decide on the merits of my suggestion.
.
I’ll present two workflows to illustrate – my start position is my worksheet with the data (which I invariable have as a ListObject) and my selected cell is within my data (not an unreasonable assumption, as ive probably been data munging it).
Note:I’ve added in defaulting the output to a new worksheet, which I didnt mention previously, but which makes the most sense as a default under this scenario (microsoft defaults to that for inserting a pivot table for eg).
Scenario 1 – First input range defaults to selection
1) select a cell in my column of interest
2) Press ctrl-space to select all column data (or ctrl-shift-space for entire row)
3) select your test
4) select additional range if required (e.g, for correlation) – (manual or user range selection – but see optional enhancement suggestion)
5) Have default output to new worksheet, enter cell in current sheet (ie type 2 character, e.g L2,L4 etc)
6) Run test.
Optional enhancement – where a test requires two ranges, use range of selection.columns(1) and selection.columns(2) – these defaults would not mean any extra user clicks should they wish to override these as the default.
Advantages:
a) The user range browser (Application.inputbox(,,Type:=8)?) does not support ctrl-space shortcut – on large sheets you have to jump to start of worksheet to use the ctrl-shift-down cursor option to select entire col range (or row range).
b) If i’m typing in the range manually I don’t have to remember my data range if I cant see the start and end of it, or if I have chosen a new worksheet to paste my data
c) Defaulting to new worksheet is probably the preferred user option – guarentees do not overwrite data (appreciate you have the check which is v. good). Mixed data on my main data spreadsheet breaks data imports SPSS, SigmaPlot, SQL Server … etc etc … (Extra data leads to misdetection of datatypes etc)
e) For single vector test I do not have any additional key presses – click ok and its done. For 2 range tests, one range is already complete. (but see optional suggestion above)
Disadvantage
a) Unclear if majority prefer defaulting test output to current worksheet. If they do though, then all they have to do is type in a simple single cell reference.
Current scenario
1) Review my worksheet and make a note of my input range(s) [optional] – may involve scrolling and sheet navigation on large dataset.
2) Select a cell where I want the output (or click the new option)
3) select your test
4) manually enter first input range from (1) or use the user range selection tool.
5) manually enter second input range from (1) or use the user range selection tool.
6) Click new for new worksheet (optional)
7) Run test.
Hope you dont take this as a criticism, its merely well intentioned feedback.
all the best,
Graham
Under the scenario of doing different tests on the same range, defaulting the input box to current selection is better as well.
Hello,
I am conducting a survey with a sampling of about 800. The survey has four categories as dependent variables. A few of my hypotheses range from comparing gender (IV) to a particular category (dv). The other hypotheses compare education, player experience and coaching experience (IV) to the total of all categories.
I used t test paired samples with my pilot test with only 9 samples….but I was looking at the MANOVA and was wondering if this was a better data analysis. And if so, is MANOVA easy to do on your excel program?
Deanna,
If you have multiple dependent variables that are correlated with each other, then MANOVA may be a better choice.
The Real Statistics Resource Pack does support MANOVA and there is a MANOVA data analysis tool in the resource pack that should be relatively easy to use.
See MANOVA for more details.
Charles
Dear Charles,
Does your software package include the ability to apply statistical process control analysis to data, specifically as developed by Dr Walter Shewhart?
I ask because only Shewhart’s method adjusts sigma limits to allow for handling real time data as a basis for predicting if a system is stable or unstable with the limits calculated from the data collected. Dr Shewhart also worked very closely with Edward Deming to help him develop his method of continual quality improvement.
I mention this because I want to apply this spc software prospectively to make inductive decisions in real time not deductive decisions based on traditional statistical analysis.
Best wishes
Terry Fox
Terry,
I don’t support Shewhart’s statistical process control analysis, although I will add this to the list of possible future enhancements.
Charles
Dear Dr.
have one problem in use the CHI square test.
the valor alpha must be a number between 0 and .5
as I solve this?
best regards
Carlos Adriano
Carlos,
I don’t know you would want to use a value outside the range 0 to .5, but in this case, you can choose any valid number, say .05, run the data analysis tool and then change the value of alpha in the output and the output will then be revised to use whatever value of alpha that you used.
Charles
Found my crib notes—no problem !
JMB
Dear Charles,
I am trying ti use the Scheirer Ray Hare test. I succeed un testing with your exemple on the web site.
Nevertheless, in you exemple with 3 fertilizer, number of rows by sample is the same (5). How can i do when i have 3 samples with different numbers of subjetcs?
Thank you for your help!
François
François,
Caution: There is an error in the Scheirer Ray Hare test described on the website and from the data analysis tool. This will be corrected in the next release of the Real Statistics Resource Pack.
The Scheirer Ray Hare test requires that the group sizes be the same.
Charles
Has anyone tried this with Excel 2016 yet? I’m downloading Office 2016 now and concerned that RealStats won’t work… Charles, or anyone else, if you can share experiences or tips on using this with Excel 2016 I’d appreciate it.
Update: So far so good – RealStats opens fine, and initial tests seem to yield expected results. Will upate again if I find any problems.
Others have told me that Real Statistics works fine with Excel 2016.
Charles
I appreciate your comment
Dear Dr Zaiontz, Yours faithfully. Of like you, I’m using this spectacular statistical tool developed by you and your collaborators in order to dictate my statistics classes and Biostatistics, thus are increasing the number of followers to your page. Dr. respectfully I would like to know what the last version has the Real statistics, I have 4.2 version; if I already came a new and updates implemented.
Thank you
Dear Charles,
Thank you for your guidance.
I have a problem in sample size for running MANOVA. I have an independent variable and five dependent variables. I wonder whether 20 is enough. I really need your help.
Mina,
I don’t see how you can run MANOVA with only one independent variable.
Assuming that you have at least two independent variables, the answer depends on what sort of statistical power you need. This will depend on the expected effect size. In any case, 20 is a pretty low number to expect much power from the statistical test.
Charles
Dear Charles –
I’m trying to cite your website for a paper I have written. Would you mind providing a complete citation for your website? I want to be sure that I have specified it correctly.
Thank you,
Karen
Hi Karen,
You can get the recommended citation information on the webpage Citation.
Charles
Hello,
I downloaded the R-stat but cluster analysis is not showing in the add-in table. What seems to be the problem?
Thanks,
Liliya
Hello Liliya,
Choose the Multivariate option and you will see Cluster Analysis on the dialog box that appears.
Charles
Dear Charles,
Great website, thank you very much. Do you cover Data Envelopment Analysis in your website? Please send me the link if you do, because I can’t find it and it does not appear with a simple search over your website.
Thank you and regards,
DBM
DBM,
Sorry, but I don’t cover DEA at this time.
Charles
Check out http://deafrontier.net/. They have a free version of DEAFrontier, which is an Excel add-in to do DEA. Of course, the free version has limitations on DMUs, inputs, and outputs.
Dr Charles, good afternoon, please do not not work properly because Cohen’s kappa, which molestrale worth, I attached the file so please tell me I’m doing wrong, I use the tool, and sometimes it works and sometimes not.
Thank you very much, and again I apologize for the inconvenience.
Dr I offer apologies and I found what my error.
Thank you
GAD
Thanks for this toolpack, Charles.
I was excited to see Fleiss’ Kappa in the Reliability section. However, after setting up my data, I ran the test and got the error #N/A. I looked at the output and see that KAPPA is listed in the output cells as the array function (e.g. =KAPPA(B3:Q25,0,TRUE,B30,B31) ). Searching the function terms in Excel fails to identify a function called KAPPA. Is this the reason for the output failing? I am using Excel 2010 (windows based).
thanks for any help.
Mark,
Excel identifies KAPPA as a user-defined function.
You can also access Fleiss’ Kappa via Real Statistics’ Reliability data analysis tool (press Ctrl-m to access this option).
If you send me an Excel file with your data I will try to figure out why you are getting an error output. See Contact Us for the email address.
Charles
This is a superb website for newbies. So much invaluable information..Thank you !!
Is there an intention to add a time series section ?
Keep up the good work.
I intend to add time series later this year.
Charles
Hello!
Thank you for putting this package together. It is very useful!
I was wondering if this is also compatible with Excel 2016? And if so, are the download instructions different for Excel 2016?
Thank you!
Alyssa
Alyssa,
I have not tested the software with Excel 2016, but I expect that it will work using the same download instructions. I plan to do some testing shortly.
Charles
Hi Charles,
Thanks so much for your recent help. I’ve learned a lot from your website and your suggestions for me last couple of times.
Nonetheless, I am still stuck with my problem these days. I have nine groups of data each containing millions of numbers. Obviously it does not work for SPSS or excel to compare these nine groups of data simultaneously. So I chose another way: calculated means of these nine groups and compared these means. Could you please give any suggestion that compare these nine means to see whether they are significantly different?
Thank you so much, Charles.
Best,
Stacey
Stacey,
I don’t know of any test that can tell whether 9 means are significantly different from each other, without looking at the samples from where they came from.
Charles
Got it, thanks a lot!
Dear Dr Zaiontz, Yours faithfully.
Dr. is possible to conduct a canonical correlation analysis with Real Statistics? How could it?
Thank you
GAD
Not yet. I plan to implement this capability shortly.
Charles
Dr very kind thank you very much