Re: How to change x axis values by another column?

[<Gunter.Hartel@csl.com.au>]

there is a workaround that might be close enough to what you want:  make Col_1 a label column and then select all the rows and select label and then when you plot col_2 vs Col_3 each point is labnelled with Col_1. 

 

:Col_1 << Label( 1 );
For Each Row( Labeled( Row State() ) = 1 );
Bivariate( Y( :Name( "   Col_3" ) ), X( :Col_2 ), Fit Line() );

Cheers

Gunter

---

From: jmp-l-owner@lists.biostat.wustl.edu [mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of Fred Zhang
Sent: Thursday, 19 February 2009 8:24 AM
To: jmp-l@lists.biostat.wustl.edu
Subject: Re: [jmp-l] How to change x axis values by another column?

Mark

 

Sorry not to get your point.

Given this example, which column property to add?

How to do this in JSL?

 

Thanks,

Feng

On Wed, Feb 18, 2009 at 3:56 PM, Mark Bailey <mark4flies@aol.com> wrote:

Did you try adding the Value Labels column property? This way you associate the desired label with each numeric value.

Mark

On Feb 18, 2009, at 2:17 PM, Fred Zhang <ieaggie2009@gmail.com> wrote:

Hi, I have the following 3 columns:

Col_1          Col_2            Col_3
00Qtr1         1                   1.4
00Qtr2         2                   1.5
00Qtr3         3                   1.46
00Qtr4         4                   1.6
01Qtr1         5                   1.54
01Qtr2         6                   1.58
01Qtr3         7                   1.69
01Qtr4         8                    1.6
02Qtr1         9                    1.62
...                ....                 ...
08Qtr4        28                   2.48
I have tried Fit Y(Col_3) by X(Col_2), because both are numeric data type, for linear regression.
In the picture box or plot, I want to repley X axis values {1, 2, 3, 4, ....} by
the values of Col_1, i.e. {00Qtr1, 00Qtr2, 00Qtr3, ...}

So how to revise the following JSL code to do that?

Thanks,
Fred
-----------------------------------------------------------------------------------------------
 biv Bivariate(
 Y( : Col_3 ),
 X( : Col_2 ),
 Fit Line( {Line Color( "Red" )} ),
 SendToReport(
 Dispatch(
  {},
  "1",
  ScaleBox,
  {Scale( Linear ), Format( "Best" ), Min( 1 ), Max( 28 ),
  Inc( 4 )}
 ),
 Dispatch(
  {},
  "2",
  ScaleBox,
  {Scale( Linear ), Format( "Numeric" ), Min( 0 ),
  Max( 2.5 ), Inc( .5 )}
 ),
 Dispatch( {}, "Bivar Plot", FrameBox, Marker Size( 2 ) )
 )
);

 

***************************************************************************************************************

 

This email and any attachments are confidential and may be subject to legal or other professional privilege. Any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. You should not read, copy, adapt, use or disclose them or their contents without authorisation. Any personal information in this email must be handled in accordance with the Privacy Act 1988 (Cth).

If you are not an intended recipient, please contact us at once by return email and then delete both messages.

 

 

CSL Limited A.C.N. 051 588 348

45 Poplar Road Parkville Victoria 3052 Australia

Phone: +61 3 9389 1911 Fax: +61 3 9389 1434

***************************************************************************************************************