Contact Us

Welcome to the Real Statistics Using Excel website. As described on the Home page, this website provides the resources (tutorials and statistics software) necessary to perform statistical analysis in the Excel environment.

In order to make this website more valuable to the user community, we welcome your comments, suggestions and feedback. We would especially like to hear about any errors in the website, examples or software. You can contact me as described below or by leaving a comment below or on any of the webpages.

Charles Zaiontz

My email: czaiontz@gmail.com, info@real-statistics.com
My profile: click here 

1,120 thoughts on “Contact Us”

  1. I have installed/uninstalled/reinstalled Real Statistics multiple times but to no avail. After installation, when I call up Real Statistics from the Add-ins tab, the Real Statistics menu appears, but no matter what function I try and use I always receive the message “Run-time error ‘424’; Object required”. I am using 365 on Windows 10.

    Assistance please.

    Reply

  2. Hi Charles,
    After the latest update from Microsoft, I am unable to see the Real-Statistics add-in in excel (even after a reinstall, adding to the trust center, unblocking the download, and trying the quick-access tools). Do you know of a workaround where I can enable the add-in again?
    Thanks!

    Reply

    • Hello Rebecca,
      When you say that you no longer see the Real Statistics add-in, please provide details. Where are you looking? in particular, what do you see when you enter =VER() in any cell? What do you see when you press the key sequence Ctrl-m
      Charles

      Reply

  3. Hi! Thanks so much for the support

    I am encountering a run time error in excel
    – The add in version is compatible with my excel version (2021)
    – I have enabled the add in on excel and also enabled solver

    I am specifically trying to use propensity score matching with the real stats add in
    please help if possible 🙂 thank you!

    Reply

  4. Hi Charles,

    I wanted to thank you for demonstrating how to run a variety of statistical tests in Excel on your website. I’ve used several including the Runs Up/Down Test and found your examples to be quite easy to follow.

    I’m now interested in learning whether Real Statistics using Excel includes statistical tests that evaluate the probability of the following slope related scenarios occuring and if so, which ones.

    1) The slope of a general time point series could be zero.
    2) The slope of an unbiased random walk time point series could be zero.
    3) The slope of a biased random walk time point series could not be equal to zero.

    Thanks,
    Brian Kirshner

    Reply

  5. Hi Charles, Thanks for your help. Just to document for others, it is resolved. My version of Office is 2024 LTSC. The LTSC version has ActiveX controls off by default. The fix is to go to Options..Trust Center.. Trust Center Settings..ActiveX Settings, then choose one of the options other than Disable All Controls without Notification.

    Reply

  6. Hi, Professor,
    I am currently working on my data analysis and was wondering if you could point me toward a how-to guide (or provide brief instructions) on how to perform the following statistical functions using Excel:

    Standard Deviation

    Working with Variables

    ANOVA

    t-Test

    Chi-Square Test

    Kendall’s Tau

    Factor Analysis

    Eigenvalues

    Causal Modeling

    Additionally, I understand that AMOS is used for structural equation modeling—could you let me know if there’s an Excel equivalent or if I should use another software for that part?

    Reply

    • 1. Most of these topics are reviewed on the Real Statistics website. You insert each term on the Search bar on the right sidebar on any of the Real Statistics webpages. Some of the topics listed are somewhat vague (e.g. Working with Variables), and so you may have to refine your search.
      2. Some of these topics require specific Real Statistics capabilities. They will work in Excel, but you will need to install the free Real Statistics software.
      Charles

      Reply

  8. I Need Question Table in Microsoft Excel Format For Practicing “Chi-Square Practice Data”Including Question for Evrey Dimention? Please Helep .

    Reply

  9. Good day!
    I am a teacher from Poland and I am writing a (free) JavaScript application for analyzing data obtained from tests and various exams.
    Can I legally use your table of coefficients for the Shapiro-Wilk normality test, which I found on your website?
    PS, one more digression – your last name sounds like a phonetically written Polish surname Zając – or maybe you have some Polish roots?
    Warmest regards and congratulations on a website full of substantive content.

    Reply

      • Good day!
        Thank you for your quick reply. I have another question for you – I am testing large data samples > 50,000 points using the Jarque-Bera algorithm and I see that the JB test rejects the normality hypothesis despite the fact that the samples are generated from a normal distribution using the Box-Muller transformation – and now is it permissible to, for example, shuffle a large sample array using the fast Fisher-Yates algorithm and take a subsample from this array (e.g. 5,000 items) in order to test it without a significant loss of reliability?
        Warm regards, Robert

        Reply

        • Hello Robert,
          1. There are better algorithms for normality testing. Usually Shapiro-Wilk is a better approach.
          2. You can shuffle a large data set and then take the first 5,000 items. It is likely that if this is normally distributed, then the larger dataset is normally distributed but there is no guarantee especially if you have some outliers.
          3. You can use Real Statistics’ SHUFFLE worksheet function to shuffle the dataset.
          Charles

          Reply

  10. greetings and good day
    I am a teacher and I am interested in the crobnbach calculus and the kuder.
    I saw in your page information that helps me,
    poro I see two functions =CRONBACCH and =@KUDER,
    I can’t explain where they come from.
    can you help me
    oscar ramirez
    tecnoeduka@gmail.com

    Reply

  12. Hello Charles,
    I have downloaded real stats, and ive done everything to have it installed on add in, however while trying to use its function, i am getting an error from Microsoft Visual Basic stating “Run time error 424, Object Required”. What do I do in this case?

    Reply

      • Hello Charles,
        I am getting “9.4.5 Excel 2010/2013/2016/2019/2021/365 Windows w/o descriptors” this as the response.”
        Sam

        Reply

      • Hi Charles, Excel 2024, I am getting the same Run-time error ‘424’: Object required.

        When I do =ver(), I get 9.5 Excel 2010/2013/2016/2019/2021/365 Windows with descriptors.

        I assume this is an Excel 2024 issue?

        Thanks

        Reply

        • Hi Greg,
          I doubt that it is an Excel 2024 issue, but I I don’t have enough information to say for sure.
          If you you email me a spreadsheet with your data and the Real Statistics capability (function or analysis tool) that you were using, then I will try to track down the cause of the error.
          Charles

          Reply

        • Greg,
          Thanks for sending me the requested information and for your follow-up.
          So far, I can’t figure out what is causing the problem. Perhaps in the end it is an incompatibility with Excel 2024, although the error message seems to point in a different direction.
          I am planning to issue a new release, Rel 9.5.5 this weekend. Let’s see if this resolves the problem. Otherwise, I will furnish the Rel 9.4 version to see whether this resolves the problem.
          Charles

          Reply

  14. Hi Charles,
    I have two questions.
    Have you thought about adding a function for standard deviational ellipses (SDE) for scatter plots?
    Also, have you thought about adding adjusted residuals to you chi-square tests of independence?
    This is a great AddIn; I use it frequently.
    Britt

    Reply

  15. Hi Charles,
    Is there any way with RealStatistics to compare a computed t-statistic against a t-distribution? For example, in the Welch’s test, the mean and standard deviations are used to perform the test and compare the t value against a t distribution to get the p-value. Is it possible to do the same, i.e. to get the p-value and the effect size, by providing only the mean, the standard deviation, and the size? Without providing the samples.
    Thank you so much for offering for free such a great software.
    Jean
    P.S. Why don’t you publish a scientific paper aboout RealStatistics that everyone can quote? That would be lovely. 🙂

    Reply

    • Hello Jean,
      Glad you like Real Statistics.
      1. To calculate the p-value for a one-sample t-test for the null hypothesis that mean = 0, you can use the following formula where m = sample mean, s = sample standard deviation and n = sample size: =T.DIST.2T(ABS(m)*SQRT(n)/s,n-1)
      Cohen’s d effect size can be computed by =m/s
      2. Many research papers have been published that reference Real Statistics, but I have not tried to publish a paper specifically on Real Statistics. Do you have a suggestion as to which journal I should publish such a paper in?
      Charles

      Reply

    • Hello Mark,
      Whether or not the download works is a function of your browser (Chrome, etc.), not Real Statistics. If this is the problem, I suggest that you just try again later
      If the problem is the installation, then I suggest that you look at the Troubleshooting information on the webpage from where you downloaded the software.
      Charles

      Reply

      • Hi,

        I think the error message might be caused by a policy that prevents to start an unsigned add- in in Excel in a company. I have been facing the same, rather confusing message since version 9.2.2.

        Thank you very much for your great statistical package, which I use quite regularly!

        Javier

        Reply

        • Hi Javier,
          What exactly is the error message?
          Also, what do you see when you enter the formula =VER() in any cell?
          The usual problem is related to trust, but this can be addressed.
          Charles

          Reply

          • Hi Charles,

            Maybe I found the solution: there is the need to allow to execute macros in a downloaded Excel file.
            The error message (before adjusting this) was – translated by me from the German version I use professionally- “this file type is not supported in the protected view”
            After giving the permission, I can open and use version 9.4 without any problems 😊.

            Hope this feedback is useful.

            Javier

Leave a Comment