Principal component analysis (PCA) is a dimensionality reduction method that transforms a large set of variables into a smaller one but still containing most of the information in the large set.
Author Archives: admin
XYZ 3D Scatter Plot in Excel using BESH Stat
Excel doesn’t offer a built-in 3D scatter plot. It do offer a 3D line chart (multiple line series presented side by side) but that cannot be easily adapted to scatter plot unless one of the variables is integer with only handful of distinct values. Recently I discovered a Gabor’s Doka the 3D scatter plot for …
Continue reading “XYZ 3D Scatter Plot in Excel using BESH Stat”
BESH Stat version 0.21 released
I’m happy to announce the release of new BESH Stat version 0.21. The main new feature in this version is the Negative Binomial regression model. It fits the NB2 parametrization model. Results match those provided by R glm.nb function.
Negative Binomial Regression model (NB2)
Negative binomial regression is used for modeling count variables, usually for over-dispersed count outcome variables (e.g. accounting for the extra-Poisson variation). BESH Stats fits negative binomial regression with the traditional NB2[1] parametrization
Poisson regression (Generalized linear model GLM)
Poisson regression is fundamental to the modeling of count data. It is the simplest count regression model; and similar to regular multiple linear regression except that the dependent variable is an observed count that follows the Poisson distribution.
Somers’ D
BESH Stat starting version 0.21 offers the computation of the Somers’ d statistics which is a non-parametric measure of the strength and direction of association that exists between an ordinal dependent variable and an ordinal independent variable in contingency table.
BESH Stat version 0.20 released
I’m happy to announce the release of new BESH Stat version 0.20. The main change is the “remember inputs” checkbox option that was added to the most of the userform and can make repetitive analysis more convenient.
BESH Stat version 0.19 released
I’m happy to announce the release of new BESH Stat version 0.19. It’s mainly a maintenance release with some bug fixes.
BESH Stat version 0.18 released
I’m happy to announce the release of new BESH Stat version 0.18. The main change is the implementation of Zero-Inflated Poisson regression as described by Diane Lambert in [1]. BESH Stat results on default settings match on 4 decimal place to the R pscl package zeroinfl function parameter estimates and standard errors (by decreasing the …
BESH Stat version 0.17 released
I’m happy to announce the release of new BESH Stat version 0.17. The main change is the addition of exact p-value computation for the unordered R x C contingency tables (Fisher-Freeman-Halton Exact test). I was working on this on-and-off for several years now. The new procedure implements the network algorithm developed by Mehta and Patel …