Click on one of the icons below for a free download of any 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. Quick Access Toolbar (QAT) : One way to access the Real Statistics data analysis tools is via the QAT. To accomplish this you need to download a file named RS_QAT.xlsm. Click here to download this file and obtain instructions on how to access the data analysis tools via the QAT. 412 thoughts on “Free Download” Hello Charles, I ‘ve been having a problem using this resource pack in my laptop. When I open my excel file it shows automation error and unspecified error but prior to this, I’ve been able to use the Real Statistics add-in in my work. However, after not using my laptop for approximately a week or longer when I open my excel file the dialog box pop ups showing the automation error. Can you please tell me what could have been the problem? Reply Hello Dancieul, Perhaps the following will be helpful: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply I ‘ve been having a problem using this resource pack in my laptop. When I open my excel file it shows automation error and unspecified error but prior to this, I’ve been able to use the Real Statistics add-in in my work. However, after not using my laptop for approximately a week or longer when I open my excel file the dialog box pop ups showing the automation error. Can you please tell me what could have been the problem? Hello Dancieul, Perhaps the following will be helpful: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hello Dancieul, Perhaps the following will be helpful: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles worked great! thanks so much charles 🙂 Reply worked great! thanks so much charles 🙂 it is very good help for us Reply it is very good help for us I Agree. Reply Reply to AlexandreCancel reply Comment Reply Reply to AlexandreCancel reply Comment Reply Reply to AlexandreCancel reply Comment I am unable to download resource pack Reply Hello Vibhav, Which version of the Resource Pack are you trying to download? Charles Reply I am unable to download resource pack Hello Vibhav, Which version of the Resource Pack are you trying to download? Charles Reply Hello Vibhav, Which version of the Resource Pack are you trying to download? Charles download datasets problems Reply Hi David, What problems are you having? Which datasets are you trying to download? Charles Reply 2017 Reply Hi Mamudu, To download the Real Statistics Resource Pack go to the following webpage https://real-statistics.com/free-download/real-statistics-resource-pack/ and click on the link labelled “Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/2024/365 with help” Charles Reply download datasets problems Hi David, What problems are you having? Which datasets are you trying to download? Charles Reply 2017 Reply Hi Mamudu, To download the Real Statistics Resource Pack go to the following webpage https://real-statistics.com/free-download/real-statistics-resource-pack/ and click on the link labelled “Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/2024/365 with help” Charles Reply Hi David, What problems are you having? Which datasets are you trying to download? Charles 2017 Reply Hi Mamudu, To download the Real Statistics Resource Pack go to the following webpage https://real-statistics.com/free-download/real-statistics-resource-pack/ and click on the link labelled “Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/2024/365 with help” Charles Reply Hi Mamudu, To download the Real Statistics Resource Pack go to the following webpage https://real-statistics.com/free-download/real-statistics-resource-pack/ and click on the link labelled “Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/2024/365 with help” Charles Reply Hi Mamudu, To download the Real Statistics Resource Pack go to the following webpage https://real-statistics.com/free-download/real-statistics-resource-pack/ and click on the link labelled “Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/2024/365 with help” Charles We have acces to Page_test? Reply Hello Fernando, Is Page_test the same as Page’s Trend Test? Charles Reply We have acces to Page_test? Hello Fernando, Is Page_test the same as Page’s Trend Test? Charles Reply Hello Fernando, Is Page_test the same as Page’s Trend Test? Charles Why does NOTHING download when I click the download indicator on your website? I HAVE TRIED TO DOWNLOAD THIS SOFTWARE 3 TIMES AND ALL I GET IS A LOT OF WINDOWS OPEN ON MY COMPUTER. Wow I THINK you could make this MORE difficult if you tried harder. Reply Theresa, Sorry about the trouble you have had. I didn’t make this difficult on purpose. I will look into simplifying the process. In the meantime, if you click on the Free Download button it should take you to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ You now have two options: Version 1 or Version 2. You need to click on one of these links. If you have a Mac instead of Windows then you need to go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/ Charles Reply Why does NOTHING download when I click the download indicator on your website? I HAVE TRIED TO DOWNLOAD THIS SOFTWARE 3 TIMES AND ALL I GET IS A LOT OF WINDOWS OPEN ON MY COMPUTER. Wow I THINK you could make this MORE difficult if you tried harder. Theresa, Sorry about the trouble you have had. I didn’t make this difficult on purpose. I will look into simplifying the process. In the meantime, if you click on the Free Download button it should take you to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ You now have two options: Version 1 or Version 2. You need to click on one of these links. If you have a Mac instead of Windows then you need to go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/ Charles Reply Theresa, Sorry about the trouble you have had. I didn’t make this difficult on purpose. I will look into simplifying the process. In the meantime, if you click on the Free Download button it should take you to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ You now have two options: Version 1 or Version 2. You need to click on one of these links. If you have a Mac instead of Windows then you need to go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/ Charles Hello, Charles. I’m having trouble executing the tool. I click in Real Statistics -> Data Analysis Tools -> Select Any option in the list -> Click OK. I get this error: “Run-time Error ‘424’ Object required”. Do you know how I can fix that? Reply Hello Rodrigo, This error started appearing in the past few weeks. The solution that has worked for most people appears in https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hello, Charles. I’m having trouble executing the tool. I click in Real Statistics -> Data Analysis Tools -> Select Any option in the list -> Click OK. I get this error: “Run-time Error ‘424’ Object required”. Do you know how I can fix that? Hello Rodrigo, This error started appearing in the past few weeks. The solution that has worked for most people appears in https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hello Rodrigo, This error started appearing in the past few weeks. The solution that has worked for most people appears in https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles I hope to ust ConvexHull to treat data. Reply Real Statistics doesn’t support convex hull, although it has some related capabilities. Charles Reply I hope to ust ConvexHull to treat data. Real Statistics doesn’t support convex hull, although it has some related capabilities. Charles Reply Real Statistics doesn’t support convex hull, although it has some related capabilities. Charles very interesting Reply very interesting Good morning, I would have a question. When trying to add the realstats-2007 file, a dialog box shows as follows: Excel has encountered a serious problem with realstats-2007. If the message appears many times, disable this add-on and check whether an update is available. Do you want to disable this add-on? I would like to point out that I am using 2007 Microsoft Office, to which it is dedicated. At the same time, system throws out the Solver file from add-ons. Do you have any recommendations what to do in this case? Thank you for your help in advance. Kind regards, Greg. Reply Hi Greg, Are you saying that you can’t use Solver? Charles Reply Good morning, I would have a question. When trying to add the realstats-2007 file, a dialog box shows as follows: Excel has encountered a serious problem with realstats-2007. If the message appears many times, disable this add-on and check whether an update is available. Do you want to disable this add-on? I would like to point out that I am using 2007 Microsoft Office, to which it is dedicated. At the same time, system throws out the Solver file from add-ons. Do you have any recommendations what to do in this case? Thank you for your help in advance. Kind regards, Greg. Hi Greg, Are you saying that you can’t use Solver? Charles Reply Hi Greg, Are you saying that you can’t use Solver? Charles Dear Charles I was able to use RealStats to do a MANOVA. Thank you so much. But now when I start Excel it crashes due I think to some problem with the Solver add-in. I never use the Solver add-in other than when I use RealStats. The issue only occurs when Solver and RealStats are enabled on start up of Excel, and dissapears when only RealStats is checked, so I can just check the Solver checkbox when I want to use Realstats and uncheck it afterwards, or just let Excel crash once since the next time I start up Excel, Solver is unchecked. But I report this issue just in case you or anyone else wants to know. As usual I am using Japanese Excel (2013) and Solver is called “ソルバー” in two byte Japanese characters, which may well have something to do with it. Thanks again! Tim Reply Dear Timothy, This is the first time that I have heard of this problem. I changed the name of the Real Statistics file from Realstats.xlam to XRealstats.xlam so that it would load after Solver. I wonder if this is still happening in the Japanese version. Charles Reply I was able to use RealStats to do a MANOVA. Thank you so much. But now when I start Excel it crashes due I think to some problem with the Solver add-in. I never use the Solver add-in other than when I use RealStats. The issue only occurs when Solver and RealStats are enabled on start up of Excel, and dissapears when only RealStats is checked, so I can just check the Solver checkbox when I want to use Realstats and uncheck it afterwards, or just let Excel crash once since the next time I start up Excel, Solver is unchecked. But I report this issue just in case you or anyone else wants to know. As usual I am using Japanese Excel (2013) and Solver is called “ソルバー” in two byte Japanese characters, which may well have something to do with it. Dear Timothy, This is the first time that I have heard of this problem. I changed the name of the Real Statistics file from Realstats.xlam to XRealstats.xlam so that it would load after Solver. I wonder if this is still happening in the Japanese version. Charles Reply Dear Timothy, This is the first time that I have heard of this problem. I changed the name of the Real Statistics file from Realstats.xlam to XRealstats.xlam so that it would load after Solver. I wonder if this is still happening in the Japanese version. Charles JÁ INSTALEI O SUPLEMENTO, MAS NÃO CONSIGO FAZER ELE FUNCIONAR, APARECER AS FUNÇÕES NA PLANILHA. ESTOU INSTALANDO NO MAC. VI QUE TBM TEM QUE COLOCAR EM OUTRO LOCAL A EXTENSÃO (DENTRO DE UMA PASTA), MAS TBM NÃO ACHEI ISSO Reply Hello Luciana, You can place the file containing the Real Statistics add-in almost anywhere. You don’t need to put it in the recommended place. What do you see when you place the formula =VER() in any cell? Charles Reply JÁ INSTALEI O SUPLEMENTO, MAS NÃO CONSIGO FAZER ELE FUNCIONAR, APARECER AS FUNÇÕES NA PLANILHA. ESTOU INSTALANDO NO MAC. VI QUE TBM TEM QUE COLOCAR EM OUTRO LOCAL A EXTENSÃO (DENTRO DE UMA PASTA), MAS TBM NÃO ACHEI ISSO Hello Luciana, You can place the file containing the Real Statistics add-in almost anywhere. You don’t need to put it in the recommended place. What do you see when you place the formula =VER() in any cell? Charles Reply Hello Luciana, You can place the file containing the Real Statistics add-in almost anywhere. You don’t need to put it in the recommended place. What do you see when you place the formula =VER() in any cell? Charles If i click on the free download on your home page then it takes me to https://real-statistics.com/free-download/ and here if i click on the download it takes me to the home page . Please help ! Reply Hello Souvik, When I click on the Download button on the Free Download page, I go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ In any case, please go to this web page to downlaod the software. Charles Reply Same Problem too Reply What is the problem? Charles Reply If i click on the free download on your home page then it takes me to https://real-statistics.com/free-download/ and here if i click on the download it takes me to the home page . Please help ! Hello Souvik, When I click on the Download button on the Free Download page, I go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ In any case, please go to this web page to downlaod the software. Charles Reply Same Problem too Reply What is the problem? Charles Reply Hello Souvik, When I click on the Download button on the Free Download page, I go to the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ In any case, please go to this web page to downlaod the software. Charles Same Problem too Reply What is the problem? Charles Reply Same Problem too What is the problem? Charles Reply What is the problem? Charles Hi Charles, I am a Chinese supply chain manager and am very interested in your time series prediction templates and formulas. Can you download the learning and simulation exercises? Please reply. Thank you! Reply Hi Jack, You can download the examples templates from https://real-statistics.com/free-download/real-statistics-examples-workbook/ Charles Reply Broken link to the examples. Reply Hi Chad, There aren’t any examples on this webpage. Are you referring to the examples on a different webpage? Charles Reply Hi Chad, Now I understand your comment. I see that there is a broken link to all of the examples. I need to figure out why this is happening, all of a sudden. Charles Reply Hi Charles, I am a Chinese supply chain manager and am very interested in your time series prediction templates and formulas. Can you download the learning and simulation exercises? Please reply. Thank you! Hi Jack, You can download the examples templates from https://real-statistics.com/free-download/real-statistics-examples-workbook/ Charles Reply Broken link to the examples. Reply Hi Chad, There aren’t any examples on this webpage. Are you referring to the examples on a different webpage? Charles Reply Hi Chad, Now I understand your comment. I see that there is a broken link to all of the examples. I need to figure out why this is happening, all of a sudden. Charles Reply Hi Jack, You can download the examples templates from https://real-statistics.com/free-download/real-statistics-examples-workbook/ Charles Broken link to the examples. Reply Hi Chad, There aren’t any examples on this webpage. Are you referring to the examples on a different webpage? Charles Reply Hi Chad, Now I understand your comment. I see that there is a broken link to all of the examples. I need to figure out why this is happening, all of a sudden. Charles Reply Broken link to the examples. Hi Chad, There aren’t any examples on this webpage. Are you referring to the examples on a different webpage? Charles Reply Hi Chad, There aren’t any examples on this webpage. Are you referring to the examples on a different webpage? Charles Hi Chad, Now I understand your comment. I see that there is a broken link to all of the examples. I need to figure out why this is happening, all of a sudden. Charles Reply Hi Chad, Now I understand your comment. I see that there is a broken link to all of the examples. I need to figure out why this is happening, all of a sudden. Charles Hi Charles, I’m on a course which uses your plug-in but I can’t get it to work. Microsoft is disabling for security reasons. I get a message that the file Xrealstats.xlam is untrusted. Any idea how to fix this please? Reply Hi Stavros, Follow the instructions in the Troubleshooting section on the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ Charles Reply

I’m on a course which uses your plug-in but I can’t get it to work. Microsoft is disabling for security reasons. I get a message that the file Xrealstats.xlam is untrusted. Any idea how to fix this please? Hi Stavros, Follow the instructions in the Troubleshooting section on the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ Charles Reply Hi Stavros, Follow the instructions in the Troubleshooting section on the following webpage: https://real-statistics.com/free-download/real-statistics-resource-pack/ Charles I agree Reply Agree Reply Hello Charles, I keep receiving the following error message when trying to open the add-on “This file type is not supported in Protected View.” Please advise me on what I need to do to open the information. Reply Hello Siti, You should not open the add-on. Instead, you should install it as instructed and then access it via the key sequence Ctrl-m. Charles Reply I’ve got the same message and i cannot to solve it. Reply Claire, Most likely, you need to fix the trust settings as described in the Troubleshooting section on this webpage. Charles Reply I keep receiving the following error message when trying to open the add-on “This file type is not supported in Protected View.” Please advise me on what I need to do to open the information. Hello Siti, You should not open the add-on. Instead, you should install it as instructed and then access it via the key sequence Ctrl-m. Charles Reply Hello Siti, You should not open the add-on. Instead, you should install it as instructed and then access it via the key sequence Ctrl-m. Charles I’ve got the same message and i cannot to solve it. Reply Claire, Most likely, you need to fix the trust settings as described in the Troubleshooting section on this webpage. Charles Reply I’ve got the same message and i cannot to solve it. Claire, Most likely, you need to fix the trust settings as described in the Troubleshooting section on this webpage. Charles Reply Claire, Most likely, you need to fix the trust settings as described in the Troubleshooting section on this webpage. Charles Charles, I just deployed this to some student workstations & is it normal to see a pop up for visual basic that says can’t find project or library and a pop up that says project locked – project is unviewable. After saying OK to these pop ups – it seems to work OK but i wanted to ask if something is functionally wrong if you see these pop ups at first login to excel after adding the resource pack add in. Thanks for assistance / advice / expertise. Reply Hello Devon, I don’t know why this message popped up. The software should work in any case. The “project locked” message just means that the code can’t be changed, which you probably don’t need to do in any case. Charles Reply Charles, I just deployed this to some student workstations & is it normal to see a pop up for visual basic that says can’t find project or library and a pop up that says project locked – project is unviewable. After saying OK to these pop ups – it seems to work OK but i wanted to ask if something is functionally wrong if you see these pop ups at first login to excel after adding the resource pack add in. Thanks for assistance / advice / expertise. Hello Devon, I don’t know why this message popped up. The software should work in any case. The “project locked” message just means that the code can’t be changed, which you probably don’t need to do in any case. Charles Reply Hello Devon, I don’t know why this message popped up. The software should work in any case. The “project locked” message just means that the code can’t be changed, which you probably don’t need to do in any case. Charles explorando Reply i am student and use this app for paper prepration Reply Agreed Reply i am student and use this app for paper prepration Reply i am student and use this app for paper prepration I recently downloaded real statistics and it is a very powerful tool. However, when I use any of the package’s functions, I don’t get the “suggestions” pointing out the function’s arguments. I would like to know of there’s a way to enable this. As a beginner it makes learning the order of arguments a bit easier. Reply Hello Rodrigo, I agree that suggestions are a useful capability. See the following webpage for how to do this for the Real Statistics worksheet functions: https://www.real-statistics.com/real-statistics-environment/using-real-statistics-functions/ Charles Reply I recently downloaded real statistics and it is a very powerful tool. However, when I use any of the package’s functions, I don’t get the “suggestions” pointing out the function’s arguments. I would like to know of there’s a way to enable this. As a beginner it makes learning the order of arguments a bit easier. Hello Rodrigo, I agree that suggestions are a useful capability. See the following webpage for how to do this for the Real Statistics worksheet functions: https://www.real-statistics.com/real-statistics-environment/using-real-statistics-functions/ Charles Reply Hello Rodrigo, I agree that suggestions are a useful capability. See the following webpage for how to do this for the Real Statistics worksheet functions: https://www.real-statistics.com/real-statistics-environment/using-real-statistics-functions/ Charles Hello Charles, This is a great tool. Thanks a lot. I am looking to use moderation analysis however I am unable to find it under the Reg Tab. Was it removed or renamed to something else? Thank you! Regards, Hemal Reply Hello Hemal, Glad that you like the software. I see it on the Reg tab on my computer. I am using the latest release, Rel 8.4. What release of the Real Statistics software are you using? You can find this out by entering the formula =VER() in any cell. Charles Reply Hello Charles, This is a great tool. Thanks a lot. I am looking to use moderation analysis however I am unable to find it under the Reg Tab. Was it removed or renamed to something else? Thank you! Hello Hemal, Glad that you like the software. I see it on the Reg tab on my computer. I am using the latest release, Rel 8.4. What release of the Real Statistics software are you using? You can find this out by entering the formula =VER() in any cell. Charles Reply Hello Hemal, Glad that you like the software. I see it on the Reg tab on my computer. I am using the latest release, Rel 8.4. What release of the Real Statistics software are you using? You can find this out by entering the formula =VER() in any cell. Charles Hello Dr. Charles, I hope you are doing great. I downloaded and used your RealStats from 2017. It works perfectly. However, I tried to add it to two new PCs, but I couldn’t add it because of the error. I don’t know if the file is not compatible with new Microsoft office version. I hope you can help. By the way, for my previous usage, the file had a conflict with Solver sometimes. I don’t know how to fix it. Thank you so much for your supports Reply Hello William, I am doing well. I hope that you are doing well too. 1. What sort of error are you getting? The usual problem relates to trust. You can address this issue as described in the Troubleshooting section of https://www.real-statistics.com/free-download/real-statistics-resource-pack/ 2.The key is that Solver needs to load before the Real Statistics add-in. Many months ago, I changed the name of the Real Statistics add-in to XRealstats.xlam to ensure that this would happen. Charles Reply Hello Dr. Charles, I hope you are doing great. I downloaded and used your RealStats from 2017. It works perfectly. However, I tried to add it to two new PCs, but I couldn’t add it because of the error. I don’t know if the file is not compatible with new Microsoft office version. I hope you can help. By the way, for my previous usage, the file had a conflict with Solver sometimes. I don’t know how to fix it. Thank you so much for your supports Hello William, I am doing well. I hope that you are doing well too. 1. What sort of error are you getting? The usual problem relates to trust. You can address this issue as described in the Troubleshooting section of https://www.real-statistics.com/free-download/real-statistics-resource-pack/ 2.The key is that Solver needs to load before the Real Statistics add-in. Many months ago, I changed the name of the Real Statistics add-in to XRealstats.xlam to ensure that this would happen. Charles Reply Hello William, I am doing well. I hope that you are doing well too. 1. What sort of error are you getting? The usual problem relates to trust. You can address this issue as described in the Troubleshooting section of https://www.real-statistics.com/free-download/real-statistics-resource-pack/ 2.The key is that Solver needs to load before the Real Statistics add-in. Many months ago, I changed the name of the Real Statistics add-in to XRealstats.xlam to ensure that this would happen. Charles Dear Dr. Charles, Thank you for your develop Real Statistics. We have download and use it well, but we can’t use the OUTLIERS. The output dialogue showed the error named “misc”, we have checked our version of EXCEL and it goes well. Pleas help us to check it. We are looking forward your reply. Thank you very much. Reply Hello April, I just tried it on my computer and it seems to be working fine. If you email me an Excel file with your data and explain the formula (or data analysis tool settings), I will try to figure out why you are getting an error. Charles Reply Dear Dr. Charles, Thank you for your develop Real Statistics. We have download and use it well, but we can’t use the OUTLIERS. The output dialogue showed the error named “misc”, we have checked our version of EXCEL and it goes well. Pleas help us to check it. We are looking forward your reply. Thank you very much. Hello April, I just tried it on my computer and it seems to be working fine. If you email me an Excel file with your data and explain the formula (or data analysis tool settings), I will try to figure out why you are getting an error. Charles Reply Hello April, I just tried it on my computer and it seems to be working fine. If you email me an Excel file with your data and explain the formula (or data analysis tool settings), I will try to figure out why you are getting an error. Charles HOLA ESTOY DESCARGE Y AL PARECER FUNCIONA PERO AL MOMENTO DE INGRESAR MIS VARIABLES EN LA OPCION MULTIVAR- FACTOR ANALYSIS-EXTRACT-COMPONENTES PRINCIPALES. APARECE UN ERROR QUE DICE QUE NO COINCIDEN LOS TIPOS VOLVI A TRATAR LAS VARIBLES Y CAMBIA LA NOMENCLATURA DE LOS DATOS PERO SIGUE APARECIENDO, MI DUDA Y ESPERO ME PUEDAS AYUDAR ES COMO SOLUCIONAR ESTO. TRATE DE DESCARGAR LA VERCION DE 64 BTS TRATANDO DE MANEJARLO COMO UN ERROR DE COMPATIBILIDAD EN LA DESCARGA DE WINDOWS 2016 PERO NO PUEDO ENCONTRAR DONDE LO PUEDO DESCARGAR Reply See my last two responses. Charles Reply HOLA ESTOY DESCARGE Y AL PARECER FUNCIONA PERO AL MOMENTO DE INGRESAR MIS VARIABLES EN LA OPCION MULTIVAR- FACTOR ANALYSIS-EXTRACT-COMPONENTES PRINCIPALES. APARECE UN ERROR QUE DICE QUE NO COINCIDEN LOS TIPOS VOLVI A TRATAR LAS VARIBLES Y CAMBIA LA NOMENCLATURA DE LOS DATOS PERO SIGUE APARECIENDO, MI DUDA Y ESPERO ME PUEDAS AYUDAR ES COMO SOLUCIONAR ESTO. TRATE DE DESCARGAR LA VERCION DE 64 BTS TRATANDO DE MANEJARLO COMO UN ERROR DE COMPATIBILIDAD EN LA DESCARGA DE WINDOWS 2016 PERO NO PUEDO ENCONTRAR DONDE LO PUEDO DESCARGAR See my last two responses. Charles Reply See my last two responses. Charles Hello, some 35 years ago I started working with Statistica. It was a fine program. Since I was retired 12 years ago I have been trying to make my own programs for time series analysis, mainly in VBA for Excel but the development of the statistical know how is going much faster then my abillity to make my (working!) programs so I am happy to find the Real Statistic Resource Software Pack and I am going to download it. At least my recent hobby helps me to understand what it is all about. I should have got this knowledge 45 years ago! Matija Reply Hello Matija, Thank you for your comment. I hope that you find Real Statistics useful. Charles Reply Hello, some 35 years ago I started working with Statistica. It was a fine program. Since I was retired 12 years ago I have been trying to make my own programs for time series analysis, mainly in VBA for Excel but the development of the statistical know how is going much faster then my abillity to make my (working!) programs so I am happy to find the Real Statistic Resource Software Pack and I am going to download it. At least my recent hobby helps me to understand what it is all about. I should have got this knowledge 45 years ago! Matija Hello Matija, Thank you for your comment. I hope that you find Real Statistics useful. Charles Reply Hello Matija, Thank you for your comment. I hope that you find Real Statistics useful. Charles Hello, I have downloaded the add on and have used it but now can’t find it on my mac. Can you help me please? Reply Enter the formula =VER() in any cell. If you get an error value, then I suggest that you download the Real Statistics file and install it from scratch. Charles Reply Hello, I have downloaded the add on and have used it but now can’t find it on my mac. Can you help me please? Enter the formula =VER() in any cell. If you get an error value, then I suggest that you download the Real Statistics file and install it from scratch. Charles Reply Enter the formula =VER() in any cell. If you get an error value, then I suggest that you download the Real Statistics file and install it from scratch. Charles Cuando introduzco mis valores (enteros o decimales) en Imput range me sale el siguiente enunciado “Outlier Multiplier Factor must be a number between 1.0 and 6.0 or blank (default 2.2)” y no me permite calcular lo deseado, que hago? Mi excel es 2019 Windows Reply Hello Teresa, What do you want to do? Is the default of 2.2 not acceptable? Charles Reply Hello I have the same problem … HELP! Reply Can you explain what you want to do? Charles Reply Cuando introduzco mis valores (enteros o decimales) en Imput range me sale el siguiente enunciado “Outlier Multiplier Factor must be a number between 1.0 and 6.0 or blank (default 2.2)” y no me permite calcular lo deseado, que hago? Mi excel es 2019 Windows Hello Teresa, What do you want to do? Is the default of 2.2 not acceptable? Charles Reply Hello Teresa, What do you want to do? Is the default of 2.2 not acceptable? Charles Hello I have the same problem … HELP! Reply Can you explain what you want to do? Charles Reply Hello I have the same problem … HELP! Can you explain what you want to do? Charles Reply Can you explain what you want to do? Charles I successfully loaded the XRealStats add-in. However, when I put in G2:G2168 for Input Range (ARIMA Model and Forecast), I get: Invalid input range selected G2:G2168 is the data range with time-series data (cyclical, seasonal .. ) Same error message with Seasonal ARIMA (SARIMA). Why? How can I input my data range in column G? Reply If you send me an email with an Excel file containing your data, I will try to figure out why you are getting this message. Charles Reply I successfully loaded the XRealStats add-in. However, when I put in G2:G2168 for Input Range (ARIMA Model and Forecast), I get: Invalid input range selected G2:G2168 is the data range with time-series data (cyclical, seasonal .. ) Same error message with Seasonal ARIMA (SARIMA). Why? How can I input my data range in column G? If you send me an email with an Excel file containing your data, I will try to figure out why you are getting this message. Charles Reply If you send me an email with an Excel file containing your data, I will try to figure out why you are getting this message. Charles Hello, thank you very much for sharing this resource. I downloaded it without problems, but unfortunately the KAPPA DE FLEISS does not appear as a formula. Why will it be? Greetings from Chile Christina Reply Hello Cristina, Good to communicate with you in Chile. The worksheet function used to calculate Fleiss’ Kappa is KAPPA. See the following webpage for more information https://www.real-statistics.com/reliability/interrater-reliability/fleiss-kappa/ You can also access this capability via the Interrater Reliability data analysis tool (on the Corr tab). Keep in mind that you need to install the Real Statistics software after you download it in order to use these capabilities. The installation instructions appear on this webpage. Charles Reply Hello, thank you very much for sharing this resource. I downloaded it without problems, but unfortunately the KAPPA DE FLEISS does not appear as a formula. Why will it be? Greetings from Chile Christina Hello Cristina, Good to communicate with you in Chile. The worksheet function used to calculate Fleiss’ Kappa is KAPPA. See the following webpage for more information https://www.real-statistics.com/reliability/interrater-reliability/fleiss-kappa/ You can also access this capability via the Interrater Reliability data analysis tool (on the Corr tab). Keep in mind that you need to install the Real Statistics software after you download it in order to use these capabilities. The installation instructions appear on this webpage. Charles Reply Hello Cristina, Good to communicate with you in Chile. The worksheet function used to calculate Fleiss’ Kappa is KAPPA. See the following webpage for more information https://www.real-statistics.com/reliability/interrater-reliability/fleiss-kappa/ You can also access this capability via the Interrater Reliability data analysis tool (on the Corr tab). Keep in mind that you need to install the Real Statistics software after you download it in order to use these capabilities. The installation instructions appear on this webpage. Charles Hola, muchas gracias por compartir este recurso. Lo descargué sin problemas, pero lamentablemente no me aparece el KAPPA DE FLEISS como formula. Porqué sera? Saludos desde Chile Cristina Reply Hola, muchas gracias por compartir este recurso. Lo descargué sin problemas, pero lamentablemente no me aparece el KAPPA DE FLEISS como formula. Porqué sera? Saludos desde Chile Cristina First thank you for the clear explanation of k-means clustering. I don’t know if this has been addressed in the comments already. I did encounter an issue with a VBA code I wrote. If I start with the same initial Clustering I get exactly the answer you have on your example. But when I start with a different initial clustering then sometimes I get the same answer as your example sometimes a different answer which clusters a couple of data points to a different cluster, these are outliers points so it kind of makes sense that they cloud if the centroid are slightly different. I use the RANDARRAY Excel function the assign the initial cluster. I did 11 trials with trial 0 have the initial clustering from the example. The values I get for the ten other trials are (1.25, 3.00) & (4.00, 1.67 ) 3 times (example values); (1.67, 2.33 )&(4.75, 2.00) 6 times; (1.40, 2.60)& (4.40, 1.80) 1 time. Any insights to why? (I haven’t tried with your file) Reply Hello Angel, Without seeing your code, I can’t say for sure what is happening, but it is quite likely that you will get different clusterings if the initial cluster assignments change. If you use the Real Statistics data analysis tool, then you should pick the version that has the smallest value in the Error field of the output. Charles Reply First thank you for the clear explanation of k-means clustering. I don’t know if this has been addressed in the comments already. I did encounter an issue with a VBA code I wrote. If I start with the same initial Clustering I get exactly the answer you have on your example. But when I start with a different initial clustering then sometimes I get the same answer as your example sometimes a different answer which clusters a couple of data points to a different cluster, these are outliers points so it kind of makes sense that they cloud if the centroid are slightly different. I use the RANDARRAY Excel function the assign the initial cluster. I did 11 trials with trial 0 have the initial clustering from the example. The values I get for the ten other trials are (1.25, 3.00) & (4.00, 1.67 ) 3 times (example values); (1.67, 2.33 )&(4.75, 2.00) 6 times; (1.40, 2.60)& (4.40, 1.80) 1 time. Any insights to why? (I haven’t tried with your file) Hello Angel, Without seeing your code, I can’t say for sure what is happening, but it is quite likely that you will get different clusterings if the initial cluster assignments change. If you use the Real Statistics data analysis tool, then you should pick the version that has the smallest value in the Error field of the output. Charles Reply Hello Angel, Without seeing your code, I can’t say for sure what is happening, but it is quite likely that you will get different clusterings if the initial cluster assignments change. If you use the Real Statistics data analysis tool, then you should pick the version that has the smallest value in the Error field of the output. Charles hey，very wonderful thing，i do not need python or R language anymore。——from China Reply Glad I could help. Charles Reply hey，very wonderful thing，i do not need python or R language anymore。——from China Glad I could help. Charles Reply Glad I could help. Charles Leave a Comment Cancel reply