I am pleased to announce Release 5.0 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013 and 2016 (Windows version) environments. I am still working on Release 5.0 for the Mac, and I expect this to be available in June. The Examples Workbook … Read More
Basic Concepts In Discriminant Analysis, given a finite number of categories (considered to be populations), we want to determine which category a specific data vector belongs to. More specifically, we assume that we have r populations D1, …, Dr consisting of k × 1 vectors. Furthermore, we assume that each population has a multivariate normal distribution N(μi,Σi). … Read More
I am pleased to announce Release 4.6 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2010, 2013 and 2016 (Windows version) environments. It will be available tomorrow for Excel 2007 users. The spreadsheets for all the examples used on the Real Statistics website, including … Read More
Even when the homogeneity of variance assumption is violated the ordinary least squares (OLS) method calculates unbiased, consistent estimates of the population regression coefficients. In this case, these estimates won’t be the best linear estimates since the variances of these estimates won’t necessarily be the smallest. Worse yet the standard errors will be biased and … Read More
The Fligner Killeen test is a non-parametric test for homogeneity of group variances based on ranks. It is useful when the data is non-normal or where there are outliers. We present the median-centering version of this test. Example Example 1: Use the Fligner Killeen test to determine whether the 4 samples in range B3:E11 of Figure … Read More
Given a data set S, there are many situations where we would like to partition the data set into subsets (called clusters) where the data elements in each cluster are more similar to other data elements in that cluster and less similar to data elements in other clusters. Here “similar” can mean many things. In … Read More
I am pleased to announce Release 3.0 of the Real Statistics Resource Pack. The new release is available for free download (Download Resource Pack) and is compatible with Excel 2002, 2003, 2007, 2010 and 2013. The versions for Excel 2007, 2010 and 2013 are available now; those for Excel 2002 and 2003 will be available tomorrow. I hope to make a Macintosh version … Read More
The following is a summary of all the multivariate functions provided in the Real Statistics Resource Pack. These functions are organized into the following categories: Multivariate normal distribution Mahalanobis Distance and Outliers Hotelling T2 One-way MANOVA Two-way MANOVA Permutational MANOVA Box’s Test Extraction Factor Analysis Cluster Analysis Jenks Natural Breaks Discriminant Analysis Correspondence Analysis Multivariate … Read More
Abdi, H. (2009) The Greenhouse-Geisser correction. In Neil Salkind (Ed.), Encyclopedia of Research Design. Sage. Thousand Oaks, CA. http://www.utdallas.edu/~herve/abdi-GreenhouseGeisser2010-pretty.pdf Abdi, H. (2010) Coefficient of variation. Encyclopedia of Research Design. Sage. Thousand Oaks, CA https://www.utdallas.edu/~herve/abdi-cv2010-pretty.pdf Abdi, H. & Molin, P. (2007) Lilliefors/Van Soest’s test of normality. Encyclopedia of measurement and statistics. Neil Salkind (Ed.). Sage, Thousand … Read More
Although all the statistical analyses described on this website can be done with standard Excel capabilities, it is often easier to use the supplemental functions and data analysis tools provided in the Real Statistics Resource Pack. The functions provided in the Real Statistics Resource Pack are summarized in Real Statistics Functions. Here we briefly review … Read More