Worksheet Functions Real Statistics Functions: The following are array functions where R1 contains data in either raw or summary form. ProbitCoeff(R1, lab, raw, head, alpha, iter, guess) – calculates the probit regression coefficients for data in raw or summary form. Output includes the standard errors, Wald statistic, p-value, and 1 – α confidence interval. If … Read More
Basic Concepts The logit function (see Logistic Regression Basic Concepts) maps a probability, which takes discrete values of 0 or 1, into a continuous value between -∞ and ∞. A function with this property is called a link function. The inverse standard normal distribution function is another link function and is the basis for a … Read More
Basic Concepts To determine whether there is a significant difference between the effect on two groups (e.g. a treatment group and a control group), we normally randomly select a sample from the population being studied and then randomly assign subjects in the sample to the two groups. This is called an experimental study. Sometimes it … Read More
I am pleased to announce Release 7.9 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments. The examples workbooks will be updated shortly for compatibility with the new release. Over the course … Read More
Scope On this webpage, we provide a more detailed description of the Logistic and Probit Regression data analysis tool. In addition, we describe some worksheet functions used by the data analysis tool. These functions provide faster processing as well as support for larger data sets than capabilities described elsewhere on the website. Data Analysis Tool … Read More
I am pleased to announce Release 7.7 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments. The Multivariate, Basics, Distributions, ANOVA 1, ANOVA 2, Regression 1, and Regression 2 examples workbooks will be … Read More
I am pleased to announce Release 7.1 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments. Over the course of the next several days, the website will be updated for compatibility … Read More
The following is a summary of the Regression and ANOVA worksheet functions provided in the Real Statistics Resource Pack. These functions are organized into the following categories: Linear Regression Heteroskedasticity Autocorrelation Bootstrapping Regression Power and Sample Size Stepwise Regression Exponential Regression Polynomial Regression Least Absolution Deviation (LAD) Regression Deming Regression Total Least Squares Regression Passing-Bablok … Read More
I am pleased to announce Release 4.13 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. Also the Examples Workbook Parts 1 and 2 and the Multivariate Examples files have been updated for compatibility with the new release. … Read More
Scope On this webpage, we describe some of the worksheet functions that the Real Statistics Resource Pack provides for binary logistic regression. See the following webpages for descriptions of other worksheet functions that support binary logistic regression. HOSMER and HLTEST: Hosmer-Lemeshow Test LogitCov, LogitConverge, LogitLL, LogitCorrect, LogitROC: Real Statistics Support for Logistic Regression Also, click … Read More