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

["Friedman, Emil" <efriedman@mannkindcorp.com>]

How about using "date" instead of "quarter" and defining "date" as the middle day of the quarter?  That would give you a continuous X-axis.

 

------------------------------------------

Emil M Friedman, PhD
Statistician
Technical Assessments
MannKind Corporation
One Casper Street
Danbury, CT 06810
efriedman@mannkindcorp.com
http://www.statisticalconsulting.org

---

From: jmp-l-owner@lists.biostat.wustl.edu [mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of Fred Zhang
Sent: Wednesday, February 18, 2009 2:17 PM
To: jmp-l@lists.biostat.wustl.edu
Subject: [jmp-l] How to change x axis values by another column?

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 ) )
 )
);