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
- :
- How to calculate mean minus 3 sigma?

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 20, 2011 8:09 AM
(1816 views)

Is there a way to program Jmp 8.0 to calculate mean - 3 standard deviations from a set of data? I use this criteria in my tests and until now have always had to do it in Excel. The problem with that is that I have to validate the spreadsheet I write to do the calculation. Using Jmp, I don't think I'd have to

Thanks,

Greg

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 22, 2011 9:16 AM
(1699 views)

Solution

I would use the control chart platform to generate the mean +/- 3 sigma represented by the UCL and LCL. If you are trying to do it in the JMP table then try using the tabulate platform and drag and drop the statistics of interest. Then make a table and add columns using the formula editor to generate your calculation of interest.

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 22, 2011 9:16 AM
(1700 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 23, 2011 4:35 AM
(1645 views)

initdata = Current Data Table();

sc = initdata << Get Selected Columns();

scn = initdata << Selected Column Names();

for(i=1,i<=length(sc),i++,

values = sc[ i ] << Get as Matrix;

m = mean(values);

s = stddev(values);

tmp = "initdata << New Column(\!"Mean of " || Char(sc[ i ]) || " - 3s\!", Formula(" || Char(m) || " - 3*" || Char(s) || "));";

Eval(Parse(tmp));

);

Message was edited by: mewing