topic Re: Transforming skewed count data for analysis in Discussions

Transforming skewed count data for analysis

KD — Tue, 23 Oct 2018 16:35:14 GMT

Hi Everyone,

I have some heavily skewed count data that I'd like to use to build a model. The data looks much better with a log transform shape wise but being count data, there's an abundance of zeros that won't work with a log model. From reading online, I should be using something like a Poisson distribution but I am not sure how to do so with JMP?

Any guidance would be appreciated, thank you in advanced!

Re: Transforming skewed count data for analysis

Paul_J — Tue, 23 Oct 2018 17:49:19 GMT

I often use the Gamma-Poisson to fit the a count distribution with peak at zero. I like the JMP help on this as well.

Re: Transforming skewed count data for analysis

Peter_Bartell — Tue, 23 Oct 2018 18:16:39 GMT

A couple thoughts for you:

1. You might want to try the Generalized Linear Model personality in the Fit Model platform. You can specify the response distribution (Poisson is an option) and link function (log is one of the options) as part of the model specification window. Here's the link to the JMP online documentation for the Generalized Linear Model personality:

https://www.jmp.com/support/help/14-1/generalized-linear-models.shtml#

2. If you have JMP Pro, within the Fit Model, Generalized Regression personality, there is a zero inflated Poisson distribution option for situations such as you describe...a predominance of zeros within the response population. Here's the link to the JMP Pro online documentation for the Generalized Regression personality distribution notes:

https://www.jmp.com/support/help/14-1/distribution.shtml

Re: Transforming skewed count data for analysis

KD — Tue, 23 Oct 2018 18:37:05 GMT

Thanks Peter! I will check out the GLM link.