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, 2024, and 365 for Windows. It also supports Excel 2011, 2016, 2019, 2021, 2024, and 365 for the Mac. The current version is Rel 9.8 (released 8 August 2026). 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 All the webpages on the Real Statistics website that provide Excel examples contain a link to an Excel workbook with those examples. You can click on that link to download the examples workbook. Each example focuses on a specific statistical concept and has been designed to demonstrate simple concepts before moving on to more complicated topics. 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 (click on the link located on the right-side sidebar). 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. 957 thoughts on “Welcome” Charles, Thank so much for your real-statistics add-on excel packages. It is been a big help to use regression and stepwise regression to filter for best subset of inputs to do weather and climate predictions. I have also EasyNN that I use but will download your version of Neural network to learn how to use it. Does the neural network package create predictions and so I can test with the new data? I will read up on your neural network information online. There are those who utilize neural AI or neural networks in weather prediction and if you don’t filter those inputs that play the most important role in giving you the best weather predictions then you can never get the best results due to leverage effects and outliers. Also QA of weather data is important especially if you use stepwise regression. I found out that using stepwise regression can find relationships between different weather data inputs from several weather stations. That is important but QA of data is also important as well. I find sometimes there are a few outliers where some weather sensors on some weather stations sometimes go bad one day or so. In any case any suggestions on how I can practice using your neural network would be great. Not all neural networks work the same I guess it depends on their algorithms. Any helpful suggestions I will appreciate it. Thanks again for your dedicated work.! Reply Hi Paul, The neural network capabilities in Real Statistics are pretty primitive. My goal was to explain the main concepts of neural networks and provide easy access to the underlying technology; i.e. to show what is under the hood and how it works in as simple a way as possible. I do plan to add more capabilities in the future. The regression and stepwise regression capabilities are more robust. Charles Reply Charles, Thank so much for your real-statistics add-on excel packages. It is been a big help to use regression and stepwise regression to filter for best subset of inputs to do weather and climate predictions. I have also EasyNN that I use but will download your version of Neural network to learn how to use it. Does the neural network package create predictions and so I can test with the new data? I will read up on your neural network information online. There are those who utilize neural AI or neural networks in weather prediction and if you don’t filter those inputs that play the most important role in giving you the best weather predictions then you can never get the best results due to leverage effects and outliers. Also QA of weather data is important especially if you use stepwise regression. I found out that using stepwise regression can find relationships between different weather data inputs from several weather stations. That is important but QA of data is also important as well. I find sometimes there are a few outliers where some weather sensors on some weather stations sometimes go bad one day or so. In any case any suggestions on how I can practice using your neural network would be great. Not all neural networks work the same I guess it depends on their algorithms. Any helpful suggestions I will appreciate it. Thanks again for your dedicated work.! Hi Paul, The neural network capabilities in Real Statistics are pretty primitive. My goal was to explain the main concepts of neural networks and provide easy access to the underlying technology; i.e. to show what is under the hood and how it works in as simple a way as possible. I do plan to add more capabilities in the future. The regression and stepwise regression capabilities are more robust. Charles Reply Hi Paul, The neural network capabilities in Real Statistics are pretty primitive. My goal was to explain the main concepts of neural networks and provide easy access to the underlying technology; i.e. to show what is under the hood and how it works in as simple a way as possible. I do plan to add more capabilities in the future. The regression and stepwise regression capabilities are more robust. Charles Hi Charles: I am no longer able to access your Examples Workbooks. I receive a “Cannot Reach This Page” notice. Has something changed at your end, or would you suspect an issue with my computer? Thank you. Rick Reply Hi Rick, This is a problem on my end that just appeared. I am working on addressing this issue, but in the meantime, if you place the cursor above the “Click here” link, you will see the address where the workbook is located. This will look something like https://www.real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx If you open a new tab on your browser, and enter the following link (i.e. the above link with www. removed) https://real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx then you will receive the examples workbook. This may be necessary for a few of the figures and formulas. I hope to fix all of these links in the next week or so. Charles Reply Hi Rick, I was making progress until I lost my Internet connection a couple of days ago. Internet is now back up, and so soon I will start addressing this issue again. Charles Reply Hi Charles: I am no longer able to access your Examples Workbooks. I receive a “Cannot Reach This Page” notice. Has something changed at your end, or would you suspect an issue with my computer? Thank you. Rick Hi Rick, This is a problem on my end that just appeared. I am working on addressing this issue, but in the meantime, if you place the cursor above the “Click here” link, you will see the address where the workbook is located. This will look something like https://www.real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx If you open a new tab on your browser, and enter the following link (i.e. the above link with www. removed) https://real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx then you will receive the examples workbook. This may be necessary for a few of the figures and formulas. I hope to fix all of these links in the next week or so. Charles Reply Hi Rick, This is a problem on my end that just appeared. I am working on addressing this issue, but in the meantime, if you place the cursor above the “Click here” link, you will see the address where the workbook is located. This will look something like https://www.real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx If you open a new tab on your browser, and enter the following link (i.e. the above link with www. removed) https://real-statistics.com/wp-content/uploads/2023/09/Bayesian-Example.xlsx then you will receive the examples workbook. This may be necessary for a few of the figures and formulas. I hope to fix all of these links in the next week or so. Charles Hi Rick, I was making progress until I lost my Internet connection a couple of days ago. Internet is now back up, and so soon I will start addressing this issue again. Charles Reply Hi Rick, I was making progress until I lost my Internet connection a couple of days ago. Internet is now back up, and so soon I will start addressing this issue again. Charles Hi Charles, I’m having trouble getting Real Statistics to work in Excel. I’m using Excel through my university Microsoft 365 Apps for enterprise account, and the add-in appears to be installed, but the controls are not working. In the Excel Trust Center, I noticed that ActiveX settings show “Disable all controls without notification” selected, and “Safe mode (helps limit the control’s access to your computer)” is also selected. I’m wondering if these security settings are preventing Real Statistics from functioning properly. All ActiveX settings are also grayed out, so I cannot change them. I have tried checking the add-in settings, but I’m not sure whether this is an Excel security issue, an Office licensing issue, or something specific to the Real Statistics installation. Do you have any suggestions for what settings I should change or how I can troubleshoot this? Thanks for your help. Reply Hi Pete, The following link provides a solution that works for most people https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply I’m having trouble getting Real Statistics to work in Excel. I’m using Excel through my university Microsoft 365 Apps for enterprise account, and the add-in appears to be installed, but the controls are not working. In the Excel Trust Center, I noticed that ActiveX settings show “Disable all controls without notification” selected, and “Safe mode (helps limit the control’s access to your computer)” is also selected. I’m wondering if these security settings are preventing Real Statistics from functioning properly. All ActiveX settings are also grayed out, so I cannot change them. I have tried checking the add-in settings, but I’m not sure whether this is an Excel security issue, an Office licensing issue, or something specific to the Real Statistics installation. Do you have any suggestions for what settings I should change or how I can troubleshoot this? Thanks for your help. Hi Pete, The following link provides a solution that works for most people https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hi Pete, The following link provides a solution that works for most people https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Dr thank you very much by your new version Reply Dr thank you very much by your new version Hi Charles, I’ve just published a book on Amazon Kindle titled “Applying Multivariate Methods using Excel”. The book relies heavily on Real Statistics. I’ve given you full credit in the Introduction and have clearly cited the source of every Real Statistics function used throughout. It’s no exaggeration to say that without Real Statistics, and all the work you’ve put into it, this book wouldn’t have been possible. Thank you very much for that. Reply I’ve just published a book on Amazon Kindle titled “Applying Multivariate Methods using Excel”. The book relies heavily on Real Statistics. I’ve given you full credit in the Introduction and have clearly cited the source of every Real Statistics function used throughout. It’s no exaggeration to say that without Real Statistics, and all the work you’ve put into it, this book wouldn’t have been possible. Thank you very much for that. Hello, how can I perform the lack-of-fit test in Real Statistics? It’s not available in the Multiple Linear Regression option. Reply Hello Alex, Which lack of fit test are you referring to? The p-value in the regression output is a measure of the fit or lack therof. Charles Reply Hello, how can I perform the lack-of-fit test in Real Statistics? It’s not available in the Multiple Linear Regression option. Hello Alex, Which lack of fit test are you referring to? The p-value in the regression output is a measure of the fit or lack therof. Charles Reply Hello Alex, Which lack of fit test are you referring to? The p-value in the regression output is a measure of the fit or lack therof. Charles hello.. I am having difficulty as to how to use shapley decompositon methodology. pls send me the steps regarding the same. regards Gouri Reply Hello Gouri, See https://real-statistics.com/multiple-regression/shapley-owen-decomposition/ Charles Reply

hello.. I am having difficulty as to how to use shapley decompositon methodology. pls send me the steps regarding the same. regards Gouri Hello Gouri, See https://real-statistics.com/multiple-regression/shapley-owen-decomposition/ Charles Reply Hello Gouri, See https://real-statistics.com/multiple-regression/shapley-owen-decomposition/ Charles Hi Charles, I have a D-stat of 2.049 flagged as statistically significant. Would you mind reviewing my data to see what could be going on? Thank you. Reply Hi Frank, If you email me an Excel spreadsheet with your data and calculations, I will review the output. Charles Reply Hi Charles, I have emailed you the data and results. Thank you. Reply Hi Frank, I have received your spreadsheet. Thanks. From your comment from yesterday, it seems like you have some doubt that the D-stat is significant. Is this what you want me to confirm? Charles Reply Yes. I expected a D-stat of 2.04 not to be significant. Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles Hi Charles, I have a D-stat of 2.049 flagged as statistically significant. Would you mind reviewing my data to see what could be going on? Thank you. Hi Frank, If you email me an Excel spreadsheet with your data and calculations, I will review the output. Charles Reply Hi Charles, I have emailed you the data and results. Thank you. Reply Hi Frank, I have received your spreadsheet. Thanks. From your comment from yesterday, it seems like you have some doubt that the D-stat is significant. Is this what you want me to confirm? Charles Reply Yes. I expected a D-stat of 2.04 not to be significant. Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles Hi Frank, If you email me an Excel spreadsheet with your data and calculations, I will review the output. Charles Hi Charles, I have emailed you the data and results. Thank you. Reply Hi Frank, I have received your spreadsheet. Thanks. From your comment from yesterday, it seems like you have some doubt that the D-stat is significant. Is this what you want me to confirm? Charles Reply Yes. I expected a D-stat of 2.04 not to be significant. Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles I have emailed you the data and results. Hi Frank, I have received your spreadsheet. Thanks. From your comment from yesterday, it seems like you have some doubt that the D-stat is significant. Is this what you want me to confirm? Charles Reply Yes. I expected a D-stat of 2.04 not to be significant. Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles Hi Frank, I have received your spreadsheet. Thanks. From your comment from yesterday, it seems like you have some doubt that the D-stat is significant. Is this what you want me to confirm? Charles Yes. I expected a D-stat of 2.04 not to be significant. Yes. I expected a D-stat of 2.04 not to be significant. Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles Hi Frank, Since you are using a Cochrane-Orcutt approach, I imagine that your expectation is that the autocorrelation would be addressed, and so the D-stat should not be significant. Before I look into this further, I want to call your attention to the caution described in the article at the following address. https://online.stat.psu.edu/stat462/node/189/ Namely, “One thing to note about the Cochrane-Orcutt approach is that it does not always work properly. This occurs primarily because if the errors are positively autocorrelated, then r tends to underestimate ρ. When this bias is serious, then it can seriously reduce the effectiveness of the Cochrane-Orcutt procedure.” Please let me know whether this caution is applicable to your data. Charles good greetings, Dr Charles, awesome of you to have this service to humanity, thanks! now, how should i go about analysis of two sample grades of students (STEM (n=185 & non-STEM (n= 80)). obviously, highly unbalanced samples. what test should i use? Reply Hello Joydee, If you are testing whether there is a significant difference in the grades between the two groups, you can use a two indepndent sample t test, See https://real-statistics.com/students-t-distribution/two-independent-samples-t-test/ This test will handle unbalanced samples, but there are assumptions. There are a variety of other tests that handle violations of these assumptions. Charles Reply Hi, Charles, Thank you and noted the feedback. I will go over and take appropriate actions. Again, thanks and have a nice day. Joydee Reply good greetings, Dr Charles, awesome of you to have this service to humanity, thanks! now, how should i go about analysis of two sample grades of students (STEM (n=185 & non-STEM (n= 80)). obviously, highly unbalanced samples. what test should i use? Hello Joydee, If you are testing whether there is a significant difference in the grades between the two groups, you can use a two indepndent sample t test, See https://real-statistics.com/students-t-distribution/two-independent-samples-t-test/ This test will handle unbalanced samples, but there are assumptions. There are a variety of other tests that handle violations of these assumptions. Charles Reply Hi, Charles, Thank you and noted the feedback. I will go over and take appropriate actions. Again, thanks and have a nice day. Joydee Reply Hello Joydee, If you are testing whether there is a significant difference in the grades between the two groups, you can use a two indepndent sample t test, See https://real-statistics.com/students-t-distribution/two-independent-samples-t-test/ This test will handle unbalanced samples, but there are assumptions. There are a variety of other tests that handle violations of these assumptions. Charles Hi, Charles, Thank you and noted the feedback. I will go over and take appropriate actions. Again, thanks and have a nice day. Joydee Reply Hi, Charles, Thank you and noted the feedback. I will go over and take appropriate actions. Again, thanks and have a nice day. Joydee I am getting the following error message when trying to use Real Statistics: Microsoft Visual Basic Run-time error ‘424’: Object required I never had this before. Any ideas and solutions? Thanks. Reply Hello, Recently, many users are getting this message, probably due to some change that Microsoft made. The following webpage provides a solution that works for most people: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply I am getting the following error message when trying to use Real Statistics: Microsoft Visual Basic Run-time error ‘424’: Object required I never had this before. Any ideas and solutions? Thanks. Hello, Recently, many users are getting this message, probably due to some change that Microsoft made. The following webpage provides a solution that works for most people: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hello, Recently, many users are getting this message, probably due to some change that Microsoft made. The following webpage provides a solution that works for most people: https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Hi Charles, Everytime I now run any process I get a VB run-tme error (#424). I have no idea how to correct that, do you have thoughts on this? Reply Hi Britt, This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply i have the same problem, have you fixed it? Reply This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hi Charles, Everytime I now run any process I get a VB run-tme error (#424). I have no idea how to correct that, do you have thoughts on this? Hi Britt, This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply Hi Britt, This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles i have the same problem, have you fixed it? Reply This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply i have the same problem, have you fixed it? This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Reply This problem has come up more often recently probably due to some change that Microsoft has made to Excel. In any case, the solution that has worked for almost everyone is described at https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box Charles Shopzirotti Reply I noticed you recently picked up a backlink from seokicks. Just wanted to flag it because that site is a known link farm & can trigger penalties, kill your rankings, and cause a slow but steady traffic drop. If an agency placed it, you might want to ask them to disavow it. Want me to point out where that link was placed? Reply Hi John, I have no idea which agency would have done this. Are you saying that this was done by Shopzirotti? Why would they do that? Charles Reply I noticed you recently picked up a backlink from seokicks. Just wanted to flag it because that site is a known link farm & can trigger penalties, kill your rankings, and cause a slow but steady traffic drop. If an agency placed it, you might want to ask them to disavow it. Want me to point out where that link was placed? Hi John, I have no idea which agency would have done this. Are you saying that this was done by Shopzirotti? Why would they do that? Charles Reply Hi John, I have no idea which agency would have done this. Are you saying that this was done by Shopzirotti? Why would they do that? Charles Dear Charles, first of all, thanks for your effort to provide us with this magnificent tool. I have a question, in Descriptive Statistics, the values in Outlier Multiplier and Outlier Limit appear with a comma for the decimal separator; is it possible to change to “.” instead of “,”? Thanks in advance Reply Hello Salvador, Real Statistics addresses the issue of using a comma as the decimal symbol. The approach is not to replace 2.2 by 2,2 but to replace it by 220 (as in 220%). This is a configuration option, as explained in https://real-statistics.com/appendix/faqs/comma-as-decimal-symbol/ Charles Reply Thanks Charles. Another issue is the tab “Complements” in Excel, which continuously disappears; sometimes it is corrected by disabling RealStatiscs, and then re-enabling it, but others not. Do you have a solution for this issue? Thanks in advance Reply Salvador, I assume by “Complements” you are referring to the Add-Ins ribbon. Since I never use the Add-Ins tab but instead just use the Ctrl-m key sequence, I hadn’t noticed that it has also disappeared on my computer as well. I tried to restore it, as I have done in the past (via File > Options > Customize Ribbon), but that didn’t seem to work. I need to research this further. Charles Reply Dear Charles, first of all, thanks for your effort to provide us with this magnificent tool. I have a question, in Descriptive Statistics, the values in Outlier Multiplier and Outlier Limit appear with a comma for the decimal separator; is it possible to change to “.” instead of “,”? Thanks in advance Hello Salvador, Real Statistics addresses the issue of using a comma as the decimal symbol. The approach is not to replace 2.2 by 2,2 but to replace it by 220 (as in 220%). This is a configuration option, as explained in https://real-statistics.com/appendix/faqs/comma-as-decimal-symbol/ Charles Reply Thanks Charles. Another issue is the tab “Complements” in Excel, which continuously disappears; sometimes it is corrected by disabling RealStatiscs, and then re-enabling it, but others not. Do you have a solution for this issue? Thanks in advance Reply Salvador, I assume by “Complements” you are referring to the Add-Ins ribbon. Since I never use the Add-Ins tab but instead just use the Ctrl-m key sequence, I hadn’t noticed that it has also disappeared on my computer as well. I tried to restore it, as I have done in the past (via File > Options > Customize Ribbon), but that didn’t seem to work. I need to research this further. Charles Reply Hello Salvador, Real Statistics addresses the issue of using a comma as the decimal symbol. The approach is not to replace 2.2 by 2,2 but to replace it by 220 (as in 220%). This is a configuration option, as explained in https://real-statistics.com/appendix/faqs/comma-as-decimal-symbol/ Charles Thanks Charles. Another issue is the tab “Complements” in Excel, which continuously disappears; sometimes it is corrected by disabling RealStatiscs, and then re-enabling it, but others not. Do you have a solution for this issue? Thanks in advance Reply Salvador, I assume by “Complements” you are referring to the Add-Ins ribbon. Since I never use the Add-Ins tab but instead just use the Ctrl-m key sequence, I hadn’t noticed that it has also disappeared on my computer as well. I tried to restore it, as I have done in the past (via File > Options > Customize Ribbon), but that didn’t seem to work. I need to research this further. Charles Reply Thanks Charles. Another issue is the tab “Complements” in Excel, which continuously disappears; sometimes it is corrected by disabling RealStatiscs, and then re-enabling it, but others not. Do you have a solution for this issue? Thanks in advance Salvador, I assume by “Complements” you are referring to the Add-Ins ribbon. Since I never use the Add-Ins tab but instead just use the Ctrl-m key sequence, I hadn’t noticed that it has also disappeared on my computer as well. I tried to restore it, as I have done in the past (via File > Options > Customize Ribbon), but that didn’t seem to work. I need to research this further. Charles Reply Salvador, I assume by “Complements” you are referring to the Add-Ins ribbon. Since I never use the Add-Ins tab but instead just use the Ctrl-m key sequence, I hadn’t noticed that it has also disappeared on my computer as well. I tried to restore it, as I have done in the past (via File > Options > Customize Ribbon), but that didn’t seem to work. I need to research this further. Charles I want to report that Holt’s Linear is not functioning correctly. I get a runtime error every time, regardless of the different data sets. SES and Holt-Winters are fine. Reply Hello Frank, If you email me an Excel spreadsheet with your data, I will try to figure out what is going wrong. Charles Reply I have emailed the spreadsheet to your Gmail account. Thank you. Reply I want to report that Holt’s Linear is not functioning correctly. I get a runtime error every time, regardless of the different data sets. SES and Holt-Winters are fine. Hello Frank, If you email me an Excel spreadsheet with your data, I will try to figure out what is going wrong. Charles Reply I have emailed the spreadsheet to your Gmail account. Thank you. Reply Hello Frank, If you email me an Excel spreadsheet with your data, I will try to figure out what is going wrong. Charles I have emailed the spreadsheet to your Gmail account. Thank you. Reply I have emailed the spreadsheet to your Gmail account. Thank you. I noticed you recently picked up a backlink from seokicks. Just wanted to flag it because that site is a known link farm & can trigger penalties, kill your rankings, and cause a slow but steady traffic drop. If an agency placed it, you might want to ask them to disavow it. Want me to point out where that link was placed? Best, Nia Soares Tech SEO Analyst The Blueprints Reply Yes Nia, where was the link placed? Charles Reply I noticed you recently picked up a backlink from seokicks. Just wanted to flag it because that site is a known link farm & can trigger penalties, kill your rankings, and cause a slow but steady traffic drop. If an agency placed it, you might want to ask them to disavow it. Want me to point out where that link was placed? Best, Nia Soares Tech SEO Analyst The Blueprints Yes Nia, where was the link placed? Charles Reply Yes Nia, where was the link placed? Charles Leave a Comment Cancel reply