topic Re: How to make contour plots with colored bands, based on DOE prediction formula ? in Discussions

How to make contour plots with colored bands, based on DOE prediction formula ?

Ken_Liljegren — Thu, 12 Oct 2017 10:50:31 GMT

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

txnelson — Thu, 12 Oct 2017 15:13:07 GMT

If you have the DOE data table, all you have to do, is to run the model, and under the red triangle in the output, select

Save Columns==>Save Predicted Formula

It will create a new column in your data table that has the predicted values in it.

Then all you have to do is to run the Contour Plot Platform

Graph==>Contour Plot

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

ih — Thu, 12 Oct 2017 15:15:20 GMT

I am not 100% sure what you are trying to do, but if you save the prediction formula (red triangle -> Save Columns -> Save prediction formula) from a Fit Model that has two continuous inputs, you can then open the Contour Plot, under graph, and see predicted values across the whole design space.

An example script is attached.

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

ih — Thu, 12 Oct 2017 15:16:34 GMT

Ha, I guess I should have looked for replies before I hit post. :)

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

Ken_Liljegren — Fri, 13 Oct 2017 11:08:31 GMT

txnelson and ih

Thanks a lot for the inputs.

However, when I do this I get a contour plot where the contours are not smooth curves, but lines with "kinks".

That is why I tried using the contour profiler - but in contour profiler I can't make the mulitycolored contour "bands" - i.e where a contour map goes from a red band over yellow, green blue to purple if you do a chromatic contour color.

I am looking for a contour map where I can read the predicted response value off the map. Since the Contour Plot has "lines with kinks" and not "smooth curves", the contours can't be following the prediction formula.

Instead, I plot some predicted values (thank for help with that !) but then the Contour plot just lays a poor approximation of contours over it.

Does this make sense ?

br Ken

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

txnelson — Fri, 13 Oct 2017 11:13:38 GMT

Your "Kinky" plot is due to the small number of data points. All you have to do to smooth out the plot is to generate more data points between the max and min values for your X1 and X2 columns. The prediction column will automatically generate the Y values, since it is a formula based upon the X1 and X2 column.

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

Ken_Liljegren — Fri, 13 Oct 2017 11:20:55 GMT

He he, I tried to avoid the term kinky ;)

Do you have any easy way to generate a lot more X values ?

Or do I have to enter manually ?

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

txnelson — Fri, 13 Oct 2017 11:36:45 GMT

Here is a simple script that will create a new data table and will generate whatever range of X1 and X2 values you want.

Names Default To Here( 1 );
dt = New Table( "More Points", New Column( "X1" ), New Column( "X2" ) );

// Change the desired min and max for the X1
For( X1Vals = .1, X1Vals <= 2, X1Vals = X1Vals + .1,
	// Change the desired min and max for the X2
	For( X2Vals = .1, X2Vals <= 2, X2Vals = X2Vals + .1,
		dt << Add Rows( 1 );
		dt:X1[N Rows( dt )] = X1Vals;
		dt:X2[N Rows( dt )] = X2Vals;
	)
);

// Now manually add your Y column and paste in the formula 
// into the column

Or if you just want to add more rows to your current data table, the script below is just a very simple change to the above script

Names Default To Here( 1 );
dt = Current Data Table();

// Change the desired min and max for the X1
For( X1Vals = .1, X1Vals <= 2, X1Vals = X1Vals + .1,
	// Change the desired min and max for the X2
	For( X2Vals = .1, X2Vals <= 2, X2Vals = X2Vals + .1,
		dt << Add Rows( 1 );
		dt:X1[N Rows( dt )] = X1Vals;
		dt:X2[N Rows( dt )] = X2Vals;
	)
);

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

ih — Fri, 13 Oct 2017 12:29:59 GMT

Building on Jim's comment that you need more data points, you can also use the contour plot platform to create this grid for you:

Re: How to make contour plots with colored bands, based on DOE prediction formula ?

Ken_Liljegren — Fri, 13 Oct 2017 14:28:03 GMT

Thanks ih and Jim !

The contour plot "expansion" illustrated by ih helps me a lot - then I don't need to generate a lot of extra points.

Thanks again for the help !

br Ken