Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Simulating data with random() formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 9, 2014 9:05 AM
(5996 views)

Hi,

If I have a column of data (A) and want to simulate a test result on that column (from a normal distribution(SD of 10 and mean = the number in column A), can someone confirm it is right to do it with the following formula:

Random norma()*10+A

If it's not, how can I do it?

also, is there a way to enter the SD a RSD(%)??

Thanks!

Agnès

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Hello,

You are on the right track. The Random Normal function by default will use mu =0 and sigma = 1.

This can easily be changed in your formula as shown below:

The Coefficient of Variation is what you need to display the RSD or %RSD. To display the coefficient of variation look under the red triangle of Summary Statistics and select Customize Summary Statistics.

Check the box next to CV and then click OK.

And if you look at the distribution of both A and the simulated A we do indeed now have an normal distribution for the simulated A.

Best,

Stan

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Hello,

You are on the right track. The Random Normal function by default will use mu =0 and sigma = 1.

This can easily be changed in your formula as shown below:

The Coefficient of Variation is what you need to display the RSD or %RSD. To display the coefficient of variation look under the red triangle of Summary Statistics and select Customize Summary Statistics.

Check the box next to CV and then click OK.

And if you look at the distribution of both A and the simulated A we do indeed now have an normal distribution for the simulated A.

Best,

Stan

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Simulating data with random() formula

Oct 16, 2014 6:45 AM
(5534 views)
| Posted in reply to message from stan_koprowski 10/10/2014 10:31 AM

Thanks Stan!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Simulating data with random() formula

Apr 2, 2015 7:21 AM
(5534 views)
| Posted in reply to message from stan_koprowski 10/10/2014 10:31 AM

If you find yourself going to the Customize Summary Statistics options every time you run the Distribution platform, you might be interested in knowing that you can use Platform Preferences to set the summary statistics that show up.

See Re: how to change default summary statistics displayed in distributions.

Michael Crotty

Sr Statistical Writer

JMP Development

Sr Statistical Writer

JMP Development