topic Re: Sigma Plot of smoother curves in Discussions
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61358#M33244
<P>Why don't you just reverse X and Y in your smoothing splines so don't have to use a solver? That way you should be able to get the predicted values in the same manner I outlined.</P>Tue, 26 Jun 2018 18:25:12 GMTcwillden2018-06-26T18:25:12ZSigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60927#M33125
<P>Hi,</P>
<P> </P>
<P>I want a sigma plot of smoother curves at a time value of 2300 for the upper curves (circled in red, It looks like I have a bi-modal distribution so I just want to focus on the biomodal distrubtion that has more data points). I have no voltage measurements at the circled points (values are between 2.9 and 3.0V). Is there a way to get a sigma plot of these smoother plots at a time of 2300?</P>
<P> </P>
<P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smoother_curves.PNG" style="width: 999px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/11221iC5EF7C4ED79977ED/image-size/large?v=1.0&px=999" title="smoother_curves.PNG" alt="smoother_curves.PNG" /></span></P>Fri, 22 Jun 2018 15:07:04 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60927#M33125tarkan_bih2018-06-22T15:07:04ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60942#M33127
<P>What's a sigma plot? The Google machine just returns a bunch of information about some overpriced graphing software. I'm guessing that's not what you meant.</P>Fri, 22 Jun 2018 16:40:25 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60942#M33127cwillden2018-06-22T16:40:25ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60945#M33129
<P>Here is sigma plot I am trying to create. Yeah I also noticed google giving a bunch of links to buy some software</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sigma_plot.PNG" style="width: 815px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/11225iFC3CC71C8BECE120/image-size/large?v=1.0&px=999" title="sigma_plot.PNG" alt="sigma_plot.PNG" /></span></P>Fri, 22 Jun 2018 17:00:54 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60945#M33129tarkan_bih2018-06-22T17:00:54ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60957#M33130
<P>Ok thanks for the illustration. That helps, but I'm still a bit confused. Is sigma denoting standard deviation here? If so, is it of voltage at a given time point across blocks, or time at a given voltage across blocks? Neither of those actually make sense to me if you are just interested in Time = 2300 since you would just get a single point to plot. If we can get on the same page on what is the Y-axis is measuring, then I think it will be easy enough to get the plot you're after.</P>Fri, 22 Jun 2018 17:54:40 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60957#M33130cwillden2018-06-22T17:54:40ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60968#M33133
<P>Sorry for the confusion. Sigma plot is denoting standard deviation. I want voltage at a given time of 2300 across the blocks. I want to emphasize that I want the sigma plot on the curves that have been smoothed between 2.9 and 3.0V and not on actual data points (I don't have any voltage points between 2.9 and 3.0V). So in other words it is a sigma plot on teh interpolated values.</P>Fri, 22 Jun 2018 17:49:34 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60968#M33133tarkan_bih2018-06-22T17:49:34ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60969#M33134
<P>So, x-axis is Voltage with min at 2.9V and max at 3.0V, and y-axis is standard deviation of <EM>time predictions (interpolated from smoothers) at a given voltage</EM>. Right?</P><P>If that's the case, you'll probably need to re-create those smoothing splines in Fit Y by X for each block and save the predicted values to the table so you can get those predictions. If you have each block as a separate column, you can add a few more rows to the get the predicted time at each voltage value you want. Then, you could compute the standard deviation of the predicted values for each row to get the sigma values for your plot. If you could post your data table, I could show you what I mean.</P>Fri, 22 Jun 2018 18:39:20 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60969#M33134cwillden2018-06-22T18:39:20ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60981#M33136
<P>Yes this is exactly what I want. Attaching data table.</P>Fri, 22 Jun 2018 20:08:10 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60981#M33136tarkan_bih2018-06-22T20:08:10ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60990#M33140
<P>Thanks for posting the data. There's a few splits and stacks to get the data in the right format so we can do the spline fitting, predictions for new values of Voltage, and then compute the standard deviations. Hope this is clear enough to follow along. I attached the results of each step.</P><OL><LI>Do a table split on Time, split by Block, Group by Voltage - Result is Table 2 attached</LI><LI>On Table 2:<OL><LI>Get rid of columns corresponding to block 0 through 8 (these are the lower moded ones you said you didn't want to look at)</LI><LI>Do Fit Y by X with Voltage in X, and all the other columns in Y</LI><LI>Holding Ctrl, click the red-arrow icon next to "Bivariate Fit of 9 by Voltage" > Flexible > Fit Spline > Other. Release Ctrl now and type 0.002 for the smoothness value (this value seemed to work well for me). Check "Standardize X" as well and press OK. This should fit smoothers to all of your blocks.</LI><LI>Below the graph, there is a red-arrow menu that pertains to the smoothing spline titled "Smoothing Spline Fit, lambda = 0.002 Standardized". Hold Ctrl again click the red-arrow icon > Save Predicteds.</LI><LI>Now you have prediction columns for each block based on the splines and we can predict (interpolate) with new values of Voltage. Below the last entry in the Voltage column in Table 2, type in 2.9, 2.91, 2.92, ..., 3. The predicted values will then show up in all of the prediction columns for these voltages.</LI><LI>Select the rows you just added (17 throug 27 if you incremented by tenths) and select Tables > Subset and Subset on the selected rows. This is Table 3.</LI></OL></LI><LI>On Table 3:<OL><LI>Select all the columns with the original time data for each block and delete them. You should only have columns "Voltage" and the Spline Predictor columns left.</LI><LI>Stack the Spline Predictor Columns (Tables > Stack). Highlight all of the Spline Predictor columns and click "Stack Columns". Put "Time Predicted" as the name for the Stacked Data Column. Press "OK". Result is Table 4.</LI></OL></LI><LI>On Table 4:<OL><LI>Create a new column "Sigma". Add the following formula to the column (you can just paste this in):<PRE><CODE class=" language-jsl">Col Std Dev( :Time Predicted, :Voltage )</CODE></PRE></LI><LI>You now have standard deviations for each voltage value, so we can plot the results. Sigma plot looks like so:<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="SigmaPlot.PNG" style="width: 636px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/11235i59DE502255DF0E27/image-size/large?v=1.0&px=999" title="SigmaPlot.PNG" alt="SigmaPlot.PNG" /></span><P> </P></LI></OL></LI></OL>Fri, 22 Jun 2018 22:13:11 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60990#M33140cwillden2018-06-22T22:13:11ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60996#M33145
<P>So this is close but not exactly what I need. In table 2 you give voltage inputs from 2.9 to 3.0V and then from this you can get the corresponding predicted time for every block. What I want is the other way around I want to give a time of 2300 and then see what voltage each block will give me. So in table 2 if I could instead give it a time of 2300 and then it would predict what voltage that corresponds to. Sorry for confusion about this :(</P><P> </P><P>I have done the following and got it to work but I have a lot of data and it is not feasible to do this task in the steps below:</P><OL><LI>Plot of time vs voltage plot and grouped my data by block (like the first image). Then I did fit polynomial --> 6 and then I did a save predicteds to have this now in my data table: block0_predict</LI><LI>Going back to the data table I have a new column called predicted time. Looking at the predicteds formula for this column I copied it into wolframalpha.com website and set it to solve for x variable (voltage), with y variable (time) set to 2300. From this I got 1 real value and a bunch of imaginary values. Then I took this real value and put it into the last row to approximatly get the time of 2300 (please see last row entry). I assume JMP should know how to solve for voltage for a given time across all the blocks, rather then having me copy the equation generated and have it solved in wolframalpha. I assume JMP can also solve such equations but I just don't know how...</LI></OL>Sat, 23 Jun 2018 01:28:31 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/60996#M33145tarkan_bih2018-06-23T01:28:31ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61123#M33211
<P>I see no feedback on this is it fair to say that this cannot be done in JMP?</P>Mon, 25 Jun 2018 23:28:26 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61123#M33211tarkan_bih2018-06-25T23:28:26ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61358#M33244
<P>Why don't you just reverse X and Y in your smoothing splines so don't have to use a solver? That way you should be able to get the predicted values in the same manner I outlined.</P>Tue, 26 Jun 2018 18:25:12 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61358#M33244cwillden2018-06-26T18:25:12ZRe: Sigma Plot of smoother curves
https://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61379#M33252
<P>I have tried that but the fit I want is a reciprocal fit which is giving me a bad fit. This is the main reason why I want to use time vs voltage. Additionally, when running the experiement the voltage was set and teh time was measured. So the voltage measurements are discrete. I agree if I could have a voltage vs time fit (bottom graph) it would make my analysis easier. Maybe the fit I am using is wrong when I do a voltage vs time..</P><P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="time_vs_voltage" style="width: 795px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/11279iD61E78C6EE694F58/image-size/large?v=1.0&px=999" title="time_vs_voltage.PNG" alt="time_vs_voltage" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">time_vs_voltage</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="voltage_vs_time" style="width: 776px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/11280iE0332A28D089452A/image-size/large?v=1.0&px=999" title="voltage_vs_time.PNG" alt="voltage_vs_time" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">voltage_vs_time</span></span></P><P> </P>Tue, 26 Jun 2018 19:59:40 GMThttps://community.jmp.com/t5/Discussions/Sigma-Plot-of-smoother-curves/m-p/61379#M33252tarkan_bih2018-06-26T19:59:40Z