https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607685#M80932 <P>&nbsp;Amazing! 谢谢您的解答！！！</P> Fri, 03 Mar 2023 00:23:59 GMT lehaofeng 2023-03-03T00:23:59Z https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607031#M80881 <P>我有一个表，有2000多行，每行数据都要检验正态性，把PValue放到每行数据的最后，请问有公式吗？</P> Fri, 09 Jun 2023 16:05:48 GMT https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607031#M80881 lehaofeng 2023-06-09T16:05:48Z https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607078#M80887 <P>Create the new column in your data table.&nbsp; Make sure you go into the Col Info, and set the format for the column to "PValue".</P> <P>Then open the Formula Editor for the new column and paste the below column into it</P> <PRE><CODE class=" language-jsl">dt = Current Data Table(); // change the Index value for the starting column number of the columns to be analyzed theRow = dt[Row(), Index( 5, N Col( dt ) - 1 )]; // Create a temporary working data table to calculate the normality on dtTemp = New Table( "temp", private, New Column( "x", values( theRow ) ) ); // Run the Distribution Platform to calculate the normality dis = Distribution( invisible, Continuous Distribution( Column( :x ), Fit Normal( Goodness of Fit( 1 ) ) ) ); // Retrieve the P Value of the Normality statistic pval = (Report( dis )["Goodness-of-Fit Test", Number Col Box( 2 )] &lt;&lt; get)[1]; // Clean up the behind the scenes working table and display dis &lt;&lt; close window; Close( dtTemp, nosave ); // Apply the pvalue to the current row pval;</CODE></PRE> <P>This formula will take several minutes to run on a 2000 row table.</P> <P>The comments in the above formula will not be saved as part of the formula(it;s a JMP efficiency, to keep only the executable part of the formula).</P> <P>Normally, JMP data is formatted 90 degrees from the way your data are structured.&nbsp; The column contain the data to be analyzed, and the rows represent the different instances for the given measurment.</P> Thu, 02 Mar 2023 08:18:35 GMT https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607078#M80887 txnelson 2023-03-02T08:18:35Z https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607685#M80932 <P>&nbsp;Amazing! 谢谢您的解答！！！</P> Fri, 03 Mar 2023 00:23:59 GMT https://community.jmp.com/t5/Discussions/%E4%B8%80%E7%BB%84%E6%95%B0%E6%8D%AE%E7%9A%84%E6%AD%A3%E6%80%81%E6%80%A7%E6%A3%80%E9%AA%8C%E7%9A%84PValue%E5%A6%82%E4%BD%95%E6%B1%82/m-p/607685#M80932 lehaofeng 2023-03-03T00:23:59Z