Tutorials on the basics of statistics in the Excel environment using the Real Statistics website and free downloadable software.
Topics
- Introduction
- Excel Environment
- Real Statistics Environment
- Probability Functions
- Descriptive Statistics
- Hypothesis Testing
- General Properties of Distributions
References
Howell, D. C. (2010) Statistical methods for psychology (7th ed.). Wadsworth, Cengage Learning.
https://labs.la.utexas.edu/gilden/files/2016/05/Statistics-Text.pdf
Zar. J. H. (2010) Biostatistical analysis 5th Ed. Pearson
https://bayesmath.com/wp-content/uploads/2021/05/Jerrold-H.-Zar-Biostatistical-Analysis-5th-Edition-Prentice-Hall-2009.pdf
Hello,
Thanks for this amazing tool.
Do you plan to release a version for LibreOffice 7?
Thanks
Mas
Thomas,
Glad that you like the Real Statistics add-in.
Sorry, but I have no immediate plans to support LibreOffice 7. I may change my view on this once VBA support in more developed on LibreOffice 7.
Charles
The row is “experts vs non experts”, while the columns are “age range” (1 for age 30-34, 2 for 35-39, 3 for 40-44 and so on until more than 70).
Joan,
I suggest that you use fewer age ranges. E.g. age 30-39, 40-49, 50-59, 60-69, 70 or more. In this case perhaps all cells will have values of 5 or more. With a 2 x 5 contingency table you can use Fisher’s Exact test (Real Statistics supports this).
Charles
Thanks, Charles. I’ll try to regroup this. Alternatively would a Mann-Whitney work?
Joan,
This depends on the nature of your data. Generally, Mann-Whitney is used to compare the medians of two groups — e.g. median age between men and women.
Charles
Hi Charles,
I have a problem which seems easy but I can’t quite resolve.
I have a survey which has categorical data, aiming to compare two groups where the general group has 56 respondents and the expert group has 6.
I tried to use a Chi squared test on SPSS but more than 20% of my cells have an expected frequency of less than 5. Somehow I can’t see the Fishers exact test results and I understand it’s because data was not in a 2×2 form.
What should I do? Chi square doesn’t work because the rules have been violated but there is no option for a Fishers exact test?
Thanks for your advice!
Joan
Joan,
You say that the contingency table is not 2 x 2. What is the dimension? Fisher can be used with contingency tables other than 2 x 2.
Charles
hi
I have one variable which is function of four or five variables and I want to fined a relation between them using the statistic program
and I have a data between the dependent variable and the independent variables
so can you help me please ???
Hi,
I am afraid that you need to give me more information. Are you looking for a correlation coefficient?
Charles