nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting Fitted Distribution Results to a New Table

wzimmerman

Hello,

I watched a recent video (Using JMP® to Assess Risk in Financial Predictions by Using Monte Carlo Simulations - YouTube)

At the end of the video a gentleman asked the very question that I had: If you have a LOT of distributions how do I get the results from this window into a table to add rows and thus make a Monte Carlo. I have daily temperature data that I'd like to have a MC done on per day to construct a daily distribution.

I can go about this manually as the video shows - but I know there must be a quicker method.

Any help on this would be most appreciated!

Accepted answers

jules

Hi wzimmerman,

You can save some time, especially for those distributions with many parameters, but selecting "Save Density Formula" under the Red Triangle for the fitted distribution. This isn't exactly what you want, but gets you much of the way there. For example, selecting this next to "Fitted Normal" saves the following to a formula column:

Normal Density( :height, 62.55, 4.24233849397192 )

This is very close to what you want, so you could go into the formula and replace "Normal Density" with "Random Normal" and delete the reference to the original column, leaving:

Random Normal( 62.55, 4.24233849397192 )

This will work for more complicated distributions. For example, with a Johnson Su, "Save Density Formula" will save:

Johnson Su Density(

:height,

67.8038036468075,

3.96840876806022,

78.5033678146444,

0.0000011762144700618

)

which needs the same change to be the formula you want:

Random Johnson Su(

67.8038036468075,

3.96840876806022,

78.5033678146444,

0.0000011762144700618

)

I hope this helps!

Julian

All comments

wzimmerman

Bump.

Does no one have a solution to this?

Jeff_Perkinson

You can right click on any report table and choose "Make into Data Table" or "Make Combined Data Table" to get the results into a data table.

I think I need some more details about exactly how you want to do your simulation to help you with how to take that information into the simulation.

-Jeff

wzimmerman

Hi Jeff,

I'm looking to nab the distribution formulas. For example if I open a table and make a formula in a column: Random Normal (x, y) and then add rows I'll end up with a Monte Carlo simulation of sorts as it will pick a random number along the distribution I just specified.

If I could do that or something similar by taking the distribution formulas or results to another table to create a distribution for each day of data.

The video shows the way to do this with few variables and at the end of the video someone from the audience asks - well how do you do this with many variables. The class decides to do this after the lecture and the video ends without answering it...

jules

Hi wzimmerman,

Normal Density( :height, 62.55, 4.24233849397192 )

This is very close to what you want, so you could go into the formula and replace "Normal Density" with "Random Normal" and delete the reference to the original column, leaving:

Random Normal( 62.55, 4.24233849397192 )

This will work for more complicated distributions. For example, with a Johnson Su, "Save Density Formula" will save:

Johnson Su Density(

:height,

67.8038036468075,

3.96840876806022,

78.5033678146444,

0.0000011762144700618

)

which needs the same change to be the formula you want:

Random Johnson Su(

67.8038036468075,

3.96840876806022,

78.5033678146444,

0.0000011762144700618

)

I hope this helps!

Julian