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

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

you can add property value labels to Col_2 where 1=00Qtr1, 2=00Qtr2, etc, but they will only show up in a scatter plot if you change the modelling type to ordinal or use oneway for the plot

eg

:Col_2 << set property(
 "Value Labels",
 {1 = "00Qtr1", 2 = "00Qtr2", 3 = "00Qtr3", 4 = "00Qtr4", 5 = "01Qtr1", 6 = "01Qtr2", 7 = "01Qtr3", 8 = "01Qtr4", 9 = "02Qtr1"}
) << use value labels( 1 );
//  labels
Oneway( Y( :Col_3 ), X( :Col_2 ) );
// numbers
Bivariate( Y( :Col_3 ), X( :Col_2 ) );

 

 

PS this is under version  8.0 WinXP

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

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