real-statistics.com Open in urlscan Pro
45.60.22.32 Public Scan

Back to summary

Submitted URL:
http://real-statistics.com/
Effective URL:
https://real-statistics.com/
Submission: On October 15 via manual (October 15th 2024, 5:57:39 am UTC) from GB — Scanned from GB

Form analysis
4 forms found in the DOM

POST https://real-statistics.com/wp-comments-post.php

<form action="https://real-statistics.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
  <p class="comment-form-comment"><label for="comment" class="screen-reader-text">Comment</label><textarea id="comment" name="comment" cols="45" rows="8" required=""></textarea></p><label for="author" class="screen-reader-text">Name</label><input
    placeholder="Name *" id="author" name="author" type="text" value="" size="30" required="">
  <label for="email" class="screen-reader-text">Email</label><input placeholder="Email *" id="email" name="email" type="email" value="" size="30" required="">
  <label for="url" class="screen-reader-text">Website</label><input placeholder="Website" id="url" name="url" type="url" value="" size="30">
  <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="11" id="comment_post_ID">
    <input type="hidden" name="comment_parent" id="comment_parent" value="0">
  </p>
  <p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="9ad7110c39"></p>
  <p style="display: none !important;" class="akismet-fields-container" data-prefix="ak_"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js"
      value="1728971854650">
    <script>
      document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
    </script>
  </p>
</form>

GET https://real-statistics.com/

<form method="get" class="search-form" action="https://real-statistics.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s" title="Search for:">
  </label>
  <button class="search-submit" aria-label="Search"><span class="gp-icon icon-search"><svg viewBox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em">
        <path fill-rule="evenodd" clip-rule="evenodd"
          d="M208 48c-88.366 0-160 71.634-160 160s71.634 160 160 160 160-71.634 160-160S296.366 48 208 48zM0 208C0 93.125 93.125 0 208 0s208 93.125 208 208c0 48.741-16.765 93.566-44.843 129.024l133.826 134.018c9.366 9.379 9.355 24.575-.025 33.941-9.379 9.366-24.575 9.355-33.941-.025L337.238 370.987C301.747 399.167 256.839 416 208 416 93.125 416 0 322.875 0 208z">
        </path>
      </svg></span></button>
</form>

GET https://real-statistics.com/

<form method="get" class="search-form" action="https://real-statistics.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s" title="Search for:">
  </label>
  <button class="search-submit" aria-label="Search"><span class="gp-icon icon-search"><svg viewBox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em">
        <path fill-rule="evenodd" clip-rule="evenodd"
          d="M208 48c-88.366 0-160 71.634-160 160s71.634 160 160 160 160-71.634 160-160S296.366 48 208 48zM0 208C0 93.125 93.125 0 208 0s208 93.125 208 208c0 48.741-16.765 93.566-44.843 129.024l133.826 134.018c9.366 9.379 9.355 24.575-.025 33.941-9.379 9.366-24.575 9.355-33.941-.025L337.238 370.987C301.747 399.167 256.839 416 208 416 93.125 416 0 322.875 0 208z">
        </path>
      </svg></span></button>
</form>

GET https://real-statistics.com/

<form method="get" class="search-form" action="https://real-statistics.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s" title="Search for:">
  </label>
  <button class="search-submit" aria-label="Search"><span class="gp-icon icon-search"><svg viewBox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em">
        <path fill-rule="evenodd" clip-rule="evenodd"
          d="M208 48c-88.366 0-160 71.634-160 160s71.634 160 160 160 160-71.634 160-160S296.366 48 208 48zM0 208C0 93.125 93.125 0 208 0s208 93.125 208 208c0 48.741-16.765 93.566-44.843 129.024l133.826 134.018c9.366 9.379 9.355 24.575-.025 33.941-9.379 9.366-24.575 9.355-33.941-.025L337.238 370.987C301.747 399.167 256.839 416 208 416 93.125 416 0 322.875 0 208z">
        </path>
      </svg></span></button><input type="hidden" name="swpmfe" value="652ea0d21b1427a1bfa685e40d9bc1de">
</form>

Text Content

Real Statistics Using Excel

Menu
Menu
* Home
* Free Download
* Resource Pack
* Examples Workbooks
* QAT Access
* Donation
* Basics
* Introduction
* Excel Environment
* Real Statistics Environment
* Probability Functions
* Descriptive Statistics
* Hypothesis Testing
* General Properties of Distributions
* Distributions
* Normal Distribution
* Sampling Distributions
* Binomial and Related Distributions
* Students t Distribution
* Chi-square and F Distributions
* Other Key Distributions
* Distribution Fitting
* Order Statistics
* Testing for Normality and Symmetry
* ANOVA
* One-way ANOVA
* Factorial ANOVA
* ANOVA with Random or Nested Factors
* Design of Experiments
* ANOVA with Repeated Measures
* Analysis of Covariance (ANCOVA)
* Miscellaneous
* Correlation and Association
* Reliability
* Non-parametric Tests
* Time Series Analysis
* Panel Data Models
* Survival Analysis
* Bayesian Statistics
* Neural Networks
* Winning at Wordle
* Handling Missing Data
* Regression
* Linear Regression
* Multiple Regression
* Logistic Regression
* Multinomial Regression
* Ordinal Regression
* Poisson Regression
* Log-linear Regression
* Multivariate
* Descriptive Multivariate Statistics
* Multivariate Normal Distribution
* Hotelling T-square
* MANOVA
* Repeated Measures Tests
* Box Test
* Factor Analysis
* Cluster Analysis
* Discriminant Analysis
* Correspondence Analysis
* Appendix
* FAQs
* Mathematical Notation
* Excel Capabilities
* Matrices and Iterative Procedures
* Linear Algebra and Advanced Matrix Topics
* Other Mathematical Topics
* Statistics Tables
* Bibliography
* Author
* Citation
* Blogs
* Tools
* Real Stat Function Info
* Distribution Functions
* Non-Parametric Test Functions
* Descriptive Stats and Reformatting Functions
* Regression and ANOVA Functions
* Correlation/Reliability Functions
* Multivariate Functions
* Time Series Functions
* Missing Data Functions
* Mathematical Functions
* Data Analysis Tools
* YouTube Videos
* Contact Us
* Search

Menu
* Home
* Free Download
* Resource Pack
* Examples Workbooks
* QAT Access
* Donation
* Basics
* Introduction
* Excel Environment
* Real Statistics Environment
* Probability Functions
* Descriptive Statistics
* Hypothesis Testing
* General Properties of Distributions
* Distributions
* Normal Distribution
* Sampling Distributions
* Binomial and Related Distributions
* Students t Distribution
* Chi-square and F Distributions
* Other Key Distributions
* Distribution Fitting
* Order Statistics
* Testing for Normality and Symmetry
* ANOVA
* One-way ANOVA
* Factorial ANOVA
* ANOVA with Random or Nested Factors
* Design of Experiments
* ANOVA with Repeated Measures
* Analysis of Covariance (ANCOVA)
* Miscellaneous
* Correlation and Association
* Reliability
* Non-parametric Tests
* Time Series Analysis
* Panel Data Models
* Survival Analysis
* Bayesian Statistics
* Neural Networks
* Winning at Wordle
* Handling Missing Data
* Regression
* Linear Regression
* Multiple Regression
* Logistic Regression
* Multinomial Regression
* Ordinal Regression
* Poisson Regression
* Log-linear Regression
* Multivariate
* Descriptive Multivariate Statistics
* Multivariate Normal Distribution
* Hotelling T-square
* MANOVA
* Repeated Measures Tests
* Box Test
* Factor Analysis
* Cluster Analysis
* Discriminant Analysis
* Correspondence Analysis
* Appendix
* FAQs
* Mathematical Notation
* Excel Capabilities
* Matrices and Iterative Procedures
* Linear Algebra and Advanced Matrix Topics
* Other Mathematical Topics
* Statistics Tables
* Bibliography
* Author
* Citation
* Blogs
* Tools
* Real Stat Function Info
* Distribution Functions
* Non-Parametric Test Functions
* Descriptive Stats and Reformatting Functions
* Regression and ANOVA Functions
* Correlation/Reliability Functions
* Multivariate Functions
* Time Series Functions
* Missing Data Functions
* Mathematical Functions
* Data Analysis Tools
* YouTube Videos
* Contact Us
* Search

WELCOME

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.2.1 (released 26 September 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.

874 THOUGHTS ON “WELCOME”

COMMENT NAVIGATION

← Older Comments

1. 叶
October 7, 2024 at 11:51 am

Hello, can you make a Chinese version? English is not good.

Reply
* Charles
October 7, 2024 at 2:52 pm

My Chinese is non-existent.
Charles

Reply
* 叶
October 8, 2024 at 3:45 am

Hello, can this plugin perform Cochran’s Q test? I couldn’t find this
option in non parametric testing.

Reply
* Charles
October 9, 2024 at 10:10 am

It is an option on Real Statistics’ Other Nonparametric data analysis
tool (on the Misc tab).
Charles

Reply
* 叶
October 10, 2024 at 11:01 am

Dear Professor Charles, could you please provide more specific
steps for the Cochran’s Q Test? A person who has never studied
mathematics and statistics finds it very difficult to learn. If
there were specific steps for operation, it would be much easier to
understand. I look forward to your reply.

* Charles
October 14, 2024 at 8:30 pm

Are you looking for more information about how to use the Real
Statistics data analysis tool to perform Cochran’s Q Test or do you
want to understand how to perform the test without the software
tool? In any case, see
https://real-statistics.com/anova-repeated-measures/cochrans-q-test/real-statistics-cochrans-q-test/
Charles

* 叶
October 11, 2024 at 2:58 am

Oh no, how do I perform multiple comparisons while conducting
Cochran’s Q Test?

* Charles
October 14, 2024 at 9:36 pm

See
https://real-statistics.com/anova-repeated-measures/cochrans-q-test/
Charles

2. Подать Объявление
September 26, 2024 at 9:13 pm

Real Statistics Using Excel is a game-changer for data analysis! This
powerful tool helps users unlock insights and make informed decisions.
What’s your favorite feature or application of Real Statistics

3. lilu
September 17, 2024 at 4:14 am

Is it possible to add solving functions for ordinary differential equations
and partial differential equations

Reply
* Charles
September 18, 2024 at 1:20 pm

I have thought about this previously, and I will add these to my list of
future enhancements.
Charles

4. Jairo Alberto Mora Fernández
September 11, 2024 at 3:02 am

Buenas noches Dr. Zaiontz.
Estoy muy interesado en descargar e instalar en mi equipo los archivos del
Real Statistics Resource Pack, pero el link de descarga no me permite
hacerlo. Como debo proceder para acceder a la descarga? Les agradezco si me
pueden facilitar este proceso.

Feliz noche.

Reply
* Charles
September 11, 2024 at 8:44 am

Hello Jairo,
You can click on the link on the following webpage:
https://real-statistics.com/free-download/real-statistics-resource-pack/
Charles

5. RHWoodman
August 11, 2024 at 6:25 am

I’m studying for Lean Six Sigma as a job requirement. As you undoubtedly
know, it’s heavy on statistics. I’m looking for an add-in that can provide
me with many of the charts and tools Six Sigma requires (such as run
charts, control charts, data stability calculations, and so forth) and also
teach me statistics in more depth than I’m getting from my Six Sigma
courses, which are, so far, mostly rote and repetitive application of
statistical processes and formulas without a strong grasp of statistical
theory. Can RealStatistics meet my needs as described?

Reply
* Charles
August 11, 2024 at 11:07 am

Hello,
Real Statistics has a wealth of information about statistics but I can-t
claim that it provides all the capabilities that you describe.
Charles

Reply
* RHWoodman
August 12, 2024 at 3:24 am

Okay, thanks. After looking over, I should be able to learn the
statistical theory. You offer a lot of information. I’ll work on other
ways to create run and control charts in Excel.

Reply
* Charles
August 12, 2024 at 5:07 pm

If you come up with some charts that might be useful to others, I
would consider adding them.
Charles

6. thank you
July 12, 2024 at 11:15 am

Legend

7. GERARDO ARDILA
May 30, 2024 at 11:27 pm

Dr Zainonitz good afternoon, I hope you are well, Dr, have you thought
about relating Real Statisticistics with Copilot?

Thank you so much

Dr Zainonit buenas tardes, espero se encuentre muy bien, Dr, ha pensado en
relacionar Real Stattististics con Copilot?

Muchas gracias

Reply
* Charles
May 31, 2024 at 6:52 pm

Hello Gerardo,
I haven’t looked into this possibility.
Clearly you can already use Copilot on the output from Real Statistics. I
don’t know how to integrate Copilot with the input to Real Statistics.
Charles

Reply
* GERARDO ARDILA
June 1, 2024 at 3:19 am

Ok Sr Thank you very much.

8. Dinh Thuan
April 12, 2024 at 6:33 pm

Thank you very much to the authors for building a very good website for
users about data analysis.

Reply
* Charles
April 13, 2024 at 4:03 pm

Hello Dinh,
Glad I could help.
Charles

9. Mukesh Gautam
February 10, 2024 at 5:14 am

Hi Charles
Thank you wholeheartedly for putting so much time, effort and hard work in
providing all of us with an amazing website and a free stats software.
You are doing an awesome job and I am grateful of you.

Thank you again

Sincerely
Mukesh

Reply
* Charles
February 10, 2024 at 11:59 am

Hi Mukesh,
Thank you very much. I am trying to do my part.
Charles

10. Dr Terence Warner
February 2, 2024 at 8:41 am

Dear Charles,
In your Polynomial Regression Excel-package, is it possible to force a
quadratic regression to lie at a certain specified fixed point on the
x-axis (where y=0)? For instance, in regular Excel it is possible to set
the y-intercept (where x=0) to a value of one’s own choice.

Reply
* Charles
February 11, 2024 at 9:53 pm

Hello Terence,
No, I haven’t implemented this feature in the analysis tool.
Charles

11. a student struggling with biostatistics
November 30, 2023 at 4:40 pm

Dear Charles
I am using Excel 2021 and I had finished all the adjustment in “Trust
center”.When I key in a formula like”＝QCRIT”, there’s formula bar appearing
to remind other ones like”QDIST”,”QINV”,etc.(Is this meaning I have
successfully installed it?)But when I press “enter”,”#NAME?” appears. Could
you please advise what is going wrong here? Thanks!(and apologize for my
poor English)

Reply
* Charles
December 3, 2023 at 9:36 pm

What do you see when you enter the formula =VER() in any cell?
What do you see when you press the key sequence Ctrl-m ?
Charles

12. Roger
November 8, 2023 at 6:01 pm

Charles,
I am not able to get past Step 1:…
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. Also, click on the icon if you
would like a copy of the examples used throughout the website.

When I try to download nothing happens. I tried downloading other software
and was successful with no problem. I contact IT at my college for
assistance and they were unsuccessful also. If you could help me with this
download I would greatly appreciate it.

Reply
* Charles
November 9, 2023 at 9:16 am

Hi Roger,
I am not sure why you had this problem. I was able to perform Step 1
without any problems. In any case, please go to the following webpage:
https://real-statistics.com/free-download/real-statistics-resource-pack/
Charles

13. Appy
September 20, 2023 at 8:29 am

Dear Charles
I am using Excel 2019. I am getting an error message “This File Type is not
supported in the protected view. Request your help. Thanks Tushar

Reply
* Charles
September 20, 2023 at 11:24 am

Hell Tushar,
What Real Statistics capability (specific data analysis tool or worksheet
function) are you using when you received this message?
If you email me an Excel spreadsheet with your data and explain what you
were doing when you got this message, I will try to figure out why you
are getting this message.
Charles

Reply
* Gerhard Randers=Pehrson
September 21, 2023 at 6:08 pm

The problem is that Microsoft protects you from using addd-ins from the
web. You have to navigate through the “trust Center” to find the Real
Statistics file and thll excel that you trust it. Then the spreadsheet
will not be opened in the “protected mode”
Gerhard

Reply
* Charles
September 22, 2023 at 6:25 pm

Thanks Gerhard for your comment.
This is useful information.
Charles

14. Mark Calnon
August 28, 2023 at 7:09 pm

Hi,

About to buy a new computer – are there any issues with windows 11 (either
home or pro – I am leaning toward pro) and excel (365 or the regular office
suite)?

Thanks – I love the software!!

Reply
* Charles
August 29, 2023 at 10:04 am

Hi Mark,
I am using windows 11 home without any problems. I like office 365
because its version of excel supports dynamic arrays.
Charles

15. GERARDO ARDILA
June 27, 2023 at 2:05 am

Dear Doc Charles, Thanks, thanks and thanks, by the new Version.

16. Sonia Aly Vallani
June 1, 2023 at 5:21 am

Hello Charles,

Initially, I was able to open Real Statistics through ctrl+m in my Excel.
Later, I downloaded Microsoft 365 to get box plots which were not available
on my previous Excel. Since then I have not been able to open Real
Statistics. It shows it in the add-ins but does not show up on ctrl+m. Can
you please advise what’s going wrong here? Thanks!

Reply
* Charles
June 11, 2023 at 9:22 pm

Hello Sonia,
What do you see when you insert the fomula =VER() in any cell?
Charles

17. Chris Victoria
May 18, 2023 at 10:24 pm

Hello, Charles
A quick question that I have asked before: how does one determine the
version currently installed on a particular computer? Thanks.
Regards,
Chris Victoria

Reply
* Charles
May 19, 2023 at 9:05 am

Hello Chris,
You can use the formula =VER() to find out what version of Real
Statistics you have installed.
You can use the formula =ExcelVER() to find out what version of Excel you
have installed.
Charles

Reply
* Chris Victoria
May 19, 2023 at 7:29 pm

Thanks, Charles!

18. Alexander Correa
April 21, 2023 at 2:00 am

Thanks professor Ziaontz for sharing your material.

19. Marc P.
March 29, 2023 at 6:11 pm

Hi Charles,

Thanks for your package, it is awesome!

I have tried the functions LAMB and EVALS, and I have found that the EVALS
function returns a VALUE! error when the number is formatted with a comma
as a decimal separator. I tried with two different Office versions (2013
and 2019) and both of them give the same problem. The function runs well
when fed with integers, but with decimals it only gives the correct result
when the number is introduced as a text string, with a point as a decimal
separator or when changing the format of decimal separator to a point.

Is this a bug or it’s supposed to work this way?

Reply
* Charles
March 30, 2023 at 3:34 pm

Hello Marc,
Let’s suppose that you place the formula =A1+1 in cell A2 and the formula
=EVALS(A2;7,5) in cell C1. I’ll also assume that you are using a version
of Excel where the decimal value 7.5 (in the English-language version) is
expressed as 7,5
Are you saying that cell C1 contains an VALUE! error instead of the value
8,5 ?
In my version of Excel, the formula =EVALS(A2,7.5) does return the value
8.5. I would expect that you would get the value 8,5 (as long as you used
a semi-colon as the separator between A2 and 7,5)
Charles

Reply
* Marc P.
March 30, 2023 at 3:59 pm

That’s exactly what happens, Charles.

The cell C1 gives a VALUE error when fed with a decimal comma separated
value. The only way it gives result is changing 7,5 to 7.5 or writing
the EVALS function this way: =EVALS(A2,”7.5″)

Marc

Reply
* Charles
March 31, 2023 at 10:17 am

Marc,
If a comma is used as a decimal symbol, then the formula should be
=EVALS(A2;”7.5″) and not =EVALS(A2,”7.5″). What am I missing?
Charles

Reply
* Marc P.
March 31, 2023 at 1:03 pm

My mistake Charles,

You’re right, =EVALS(A2;”7.5″) gives the correct result, while
=EVALS(A2;7,5) gives VALUE error. (Using Excel with the decimal
value as a comma).

Marc

* Charles
March 31, 2023 at 6:05 pm

Marc,
I will check this on my Italian-language version of Excel. Looks
like I need to revise the LAMB and EVALS functions to handle this
situation.
Charles

* Charles
April 4, 2023 at 9:58 am

Hello,
I have researched this problem further.
1. Yes, I see the same problem when I use my Italian version of
Excel.
2. I am using a specific feature of VBA that does not recognize a
comma as a decimal symbol. I consider this to be a bug in Excel
VBA.
3. You mentioned that everything works fine when you write the
number as text (i.e. use “3,5” instead of 3,5). Do you see any
reason not to use this approach as the solution to this issue? Can
you find any situation where this doesn’t work?
Charles

* Marc P.
April 4, 2023 at 10:53 am

It’s OK Charles,

I just posted this issue for you to know. I think I can manage to
work with EVALS using text strings instead of numbers without a
problem.

Thanks again for your amazing work!

* Charles
April 4, 2023 at 12:02 pm

Marc,
Thanks. I am going to check whether there are any problems with
this approach. If not, I have a solution, but I would prefer to not
to use it since it might make things more complicated.
Charles

20. PAUL
March 18, 2023 at 1:47 am

Hello – I drop into the site (https://real-statistics.com/) occasionally to
see if there’s new features or bug fixes that I might need or could use.

However, I always have a difficult time actually finding the download URL.
There’s many “Free Download” boxes everywhere that take me to different
pages, but the only link I’ve found is buried in a paragraph “… click here
on Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/365” on
https://real-statistics.com/free-download/real-statistics-resource-pack/

I know that “Free Downloads” from the top of page banner, and then
“Resource Pack” will get me to the above page, but IMHO it’s not
intuitively obvious.

Can I suggest that you consider a site change to use an extremely bare
downloads page and include version and update date for all your products?

Thanks

Reply
* Charles
March 18, 2023 at 10:22 am

Thanks for your suggestion, Paul.
I will try to simplify the download page in a few days.
Charles

21. Stephen J. Alter, PhD
February 21, 2023 at 8:22 pm

Charles,
I am looking for a table of KS2 critical values corresponding to alpha
>0.20, such as 0.25, 0.30… up to 0.50. Most of the tabular data stop at
alpha = 0.20. I am unable to download the functions in Real Statistics that
compute these, and was hoping you might be able to advise.

Most appreciated

Reply
* Charles
February 22, 2023 at 10:33 am

Hello Stephen,
If I understand correctly, Real Statistics’ KSINV worksheet function
would address this issue. What sort of problem are you having in
downloading Real Statistics?
Charles

* Mario Arturo Jimenez Mendoza
March 5, 2023 at 8:48 pm

Hola, Estimado Señor
He bajado los archivos de practica, pero encuentro que las funciones
credas por Ud. No están activadas, es decir, al abrir cualquier libro de
Excel donde hay una función del complemento se describe el Error
¿#Nombre?.
He buscado las funciones en el ambiente VBA y no las he podido encontrar.
Me ayuda por favor y muchas gracias.

Reply
* Charles
March 5, 2023 at 9:31 pm

You need to make sure that you have installed the Real Statistics
software; otherwise, you will get NAME error values.
What do you see when you enter the formula =VER() in any cell?
Charles

22. TeeNa
February 19, 2023 at 8:25 am

Hi Charles,

I have downloaded and installed the Real Statistics Resource Pack into my
Macbook air, but I could not find the extended statistic tools. Please
advice. Thank you for your kind attention.

TeeNa

Reply
* Charles
February 19, 2023 at 11:13 pm

Hi TeeNa,
What do you see when you press the key sequence Ctrl-m ?
What do you see when you enter the formula =VER() in any cell?
Charles

Reply
* TeeNa
February 20, 2023 at 7:05 am

Hi Charles,
I am using Macbook.
So I think your “Ctrl-m” meant to open a new excel page. I used
“command-n” instead.
When I enter the formula =VER, (before typing ()) I saw a long list of
functions (e.g., AVERAGE…) and user-defined functions (e.g., SolverAdd,
SolverChange….).
However, when i click the “Data Analysis”, there are still only the
original choices from excel, and no Wilcoxon Signed-rank test tool.

TeeNa

Reply
* Charles
February 20, 2023 at 9:59 am

Hello TeeNa,
Ctrl-m should open the Real Statistics menu. You can’t use command-n.
You need to enter =VER() with the parentheses. If you get an error
message, then this means that Real Statistics hasn’t been installed.
Charles

23. Andres
January 17, 2023 at 5:26 pm

Hello! Thank you for your wonderful contribution. I have a question. What
is the data limit that RealStatistics currently allows?

Reply
* Charles
January 18, 2023 at 2:51 pm

Hello Andres,
Do you mean the number of rows of data? This varies from test to test.
For most tests, it is a huge number (say one million +). For some tests,
it is limited by array size, namely about 65,000 rows.
Charles

24. Cristian
January 15, 2023 at 6:09 pm

Hello, is there a possibility that you will increase the kalman filter?

Reply
* Charles
January 16, 2023 at 9:50 am

Hi Christian,
Are you asking me to add the kalman filter to the website and software?
Charles

Reply
* Cristian
January 22, 2023 at 2:34 pm

Hi Charles,
yes, as a forecasting tool.
Cristian

Reply
* Charles
January 22, 2023 at 4:37 pm

Hello Cristian,
I will look into Kalman’s filter.
Charles

Reply
* Cristian
February 6, 2023 at 9:54 pm

Thank You!

25. Ernesto
January 8, 2023 at 9:12 pm

Are Bradley-Terry model included?

Reply
* Charles
January 10, 2023 at 11:33 am

Hello Ernesto,
Real Statistics doesn’t currently support the Bradley-Terry model. It
does provide support for Rasch model, which is similar, and for logistics
regression.
I will add support for the Bradley-Terry model in the next release of the
Real Statistics software. This should be available this month.
Charles

* Charles
January 16, 2023 at 11:22 am

Hello Ernesto,
See
https://www.real-statistics.com/multiple-regression/bradley-terry-model/
Charles

Reply
* Ernesto
January 17, 2023 at 3:37 am

So great, Thanks sir!!!

26. WILLY WALDO GONZALES ROJAS
January 6, 2023 at 7:55 pm

Por favor me podrian proporcionar la direccion para descargar un paquete
estadistico…

Reply
* Charles
January 6, 2023 at 9:08 pm

You can download the Real Statistics Pack at
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
Charles

27. WILLY WALDO GONZALES ROJAS
January 6, 2023 at 7:52 pm

Los paquetes estadisticos son herramientas de mucha importancia y utilidad
para aplicar en las invastigaciones

28. Sagrario
January 6, 2023 at 4:13 am

How do I uninstall it?

Reply
* Charles
January 6, 2023 at 11:55 am

Hello Sagrario,
The uninstall instructions can be found at the bottom of the webpage
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
i.e. the webpage from where you downloaded the software.
Charles

29. Luís
January 4, 2023 at 3:06 pm

ewfwagreag

30. Siddique Ahmad
December 15, 2022 at 5:51 am

Respected sir charles
Please calculate degree of freedom for me
Factor A = Nitrogen having 4 levels x phosphorus having 3 levels
Replicated 3 times
Design RCB split plot

Reply
* Siddique Ahmad
December 15, 2022 at 5:52 am

Factor A for main plot
It’s one factor

Reply
* Charles
December 20, 2022 at 11:10 am

Sorry, Siddique, but I don’t understand your design.
Charles

31. Nicos Scordis
December 1, 2022 at 3:03 am

Charles: I have been using your XRealStats add-in to calculate eigenvalues
and eigenvectors. Thank you so very much for this. My computer has
installed a Windows update. As a result, I can no longer use your add-in.
The machine tells me that Microsoft has blocked the macros of the add-in
because it does not recognize the certificate of the add-in (or words to
this effect). I am using Excel 365. Any ideas for a work around?

Reply
* Charles
December 1, 2022 at 9:54 am

Nicos,
I believe that all you need to do is change the trust setting for the
XReakstats.xlam file. This is described in the Troubleshooting section of
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
Charles

Reply
* Estella
December 1, 2022 at 4:31 pm

Charles, when I add the trust certificate, I cannot see the
installation package when browsing my computer, but I have downloaded
it and can see it through direct access. But I just can’t see it when I
add trusted certificates and add ins. What is the solution?

Reply
* Charles
December 2, 2022 at 9:20 am

Hello Estella,
You don’t need a trust certificate to use the Real Statistics
software. You only need to adjust the trust setting as described in
the Troubleshooting section of
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
Charles

* Edmundo Marcano
December 13, 2022 at 1:56 pm

Hola, prueba utilizando excel 2016. Saludos.

32. MALLARD
October 23, 2022 at 12:19 pm

Thanks, rethanks to Charles’s beautiful job
In Excel, now we have also access to the new LET and LAMBDA functions* …
Imagine all the Charles’s tools coming rewritten with these functions, for
young people, easier to read, faster …

*(only in Office insider until now)

Reply
* Charles
October 25, 2022 at 11:01 am

Hello Mallard,
Yes, you could rewrite some of the capabilities using LET and LAMBDA, but
not all.
I have also added a LAMBDA-like capability in Real Statistics that is
available to all Excel users.
Charles

33. Simone Ravetto
October 21, 2022 at 10:34 am

Dear Prof. Charles,
I am using this wonderful add-id with my university students. In this year
many of them received an error when running any function of Real-Stat:
“Compile error in hidden module: frmHist”.
This is apparently due to the incompatibility between their Office version
(64-bit) and the add-id (developped for 32-bit Office), as suggest by
Office help. The Block has already been removed for all of them and no
error occurs when installing the add-id, but just when running whatever
function.
Is there a solution for that?
Many thanks again!!!
simone

Reply
* Charles
October 22, 2022 at 6:08 pm

Hello Simone,
Real Statistics should work for 64-bit Office. In any case, if you email
me an Excel file with your data and results, I will try to figure out why
you are getting a compile error message.
Charles

34. Jesper
October 12, 2022 at 11:14 am

Hi Charles,

Thank you for your awesome tool. I used it some years ago to perform PCA,
so I naturally had your tool in mind when looking for an easy way to
unsmooth a series of quarterly returns from several alternative asset
classes.
Unfortunately for me, it doesn’t seem that unsmoothing is one of the
options in your tool. Is that correct, or am I just not able to find it?

Thanks again,
Jesper

Reply
* Charles
October 12, 2022 at 9:58 pm

Hello Jesper,
Real Statistics doesn’t address this subject.
I see on the Internet the following papers on the subject of unsmoothing
asset classes
https://eres.org/eres2010/contents/papers/id235.pdf
https://www.cliffwater.com/Research/DownloadFile?path=docs%2FForecasting%20Risk%20for%20Illiquid%20Asset%20Classes.pdf&title=Forecasting%20Risk%20for%20Illiquid%20Asset%20Classes&title=Forecasting+Risk+for+Illiquid+Asset+Classes
I don’t know whether either of these papers is useful.
Charles

Reply
* shadrack
October 14, 2022 at 12:21 pm

Is it possible to reach you through inbox for more explanation. I have
a sample size of 29 and am worried on the possible tests ill need to
run

Reply
* Charles
October 14, 2022 at 3:39 pm

Hello Shadrack,
You can send me an email. See Contact Us.
Charles

* Jesper Rindboel
October 19, 2022 at 4:10 pm

Thank you Charles.

35. Didien
October 5, 2022 at 10:36 am

Hi Charles,
i express my salute to you … you have done great in simply way . thank you
so much for this website

is it possible to run real-statistics tools for multiple sku?
e.g time line is monthly basis from B2-P1
actual for SKU A is from B2-P2 need to run statistical tools to get result
on Q2-V2 (6month)
actual for SKU B is from B3-P3 need to run statistical tools to get result
on Q3-V3 (6month)

Reply
* Didien
October 5, 2022 at 10:37 am

sorry time line should be from B1-P1..

* Charles
October 6, 2022 at 9:42 am

Hello Didien,
Glad that you like the Real Statistics website.
What is a SKU? Stock Keeping Unit?
I don’t understand what B1-P1, etc. represent.
Charles

36. Paul
September 16, 2022 at 3:35 pm

i am unable to dowload the pack, every time when Click the download button
a new tab oens instead of dowloading the pack, could you please help me to
solve this issue

Reply
* Charles
September 16, 2022 at 5:09 pm

Hi Paul,
If you are using Windows, then I suggest that you go to the Download
section of the following webpage to download the pack
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
Charles

37. SIDIBE
August 12, 2022 at 12:01 pm

It is a very good site, if you can insert conversion tab of different types
of languages.

Reply
* Charles
August 13, 2022 at 8:39 am

By languages, do you mean Spanish, Russian, etc.?
Charles

38. Alix
July 13, 2022 at 10:54 pm

I would like to cite your work on this software package. What is the best
citation for this work?

Reply
* Charles
July 14, 2022 at 9:05 am

Hello Alix,
See
https://www.real-statistics.com/appendix/citation-real-statistics-software-website/
Charles

COMMENT NAVIGATION

← Older Comments

real-statistics.com Open in urlscan Pro 45.60.22.32 Public Scan

Form analysis 4 forms found in the DOM

POST https://real-statistics.com/wp-comments-post.php

GET https://real-statistics.com/

GET https://real-statistics.com/

GET https://real-statistics.com/

Text Content

real-statistics.com Open in urlscan Pro
45.60.22.32 Public Scan

Form analysis
4 forms found in the DOM