Transforming skewed count data for analysis

[#1]

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!

[#2]

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.

[#3 · Accepted solution]

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

[#4]

Thanks Peter! I will check out the GLM link.