In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Investigation Distribution Analysis Tool

tlewis
7 - Meteor

I am getting an error when running the Data Investigation Distribution Analysis Tool. Will this work with a Double data type?

 

My error reads "error in fitdist(the.data,"norm",method="mle")

 

Perhaps my data is too small? It ranges from around 0.000044 to 0.000116.

3 REPLIES 3
TrevorS
Alteryx Alumni (Retired)

Hello @tlewis


Can you please include a copy of your workflow and some sample data?

This will help the Community to troubleshoot your issue for you!


Thanks,
TrevorS

Community Moderator
PhilipMannering
16 - Nebula
16 - Nebula

Hi @tlewis ,

Having recreated the error I think it is because you're values are too small. You could try using a formula tool to multiply all your data by, say, 10000. This should do the trick. The goodness of fit statistics should be the same. The distribution parameters may need dividing by 10000 afterwards.

CharlieS
17 - Castor
17 - Castor

I did find that the Distribution Analysis tool has trouble with small values. In the attached example, I generate 100 random numbers [0,1]. The Distribution Analysis tool works fine on those values, but if I divide those values by 10000, the tool errors.

 

Perhaps there are limitations documented in the R packages used by this tool: "MASS", "fitdistrplus", and "stats".

Labels
Top Solution Authors