[UW-GIS-L] scatterplot in excel

[Phil Hurvitz]

Don't Imagine and ENVI do band scatterplots natively?

-P.

  **************************************************************
   Phil Hurvitz, MFR | PhD Student, Urban Planning | Gould 317
     College of Architecture and Urban Planning | Box 355726
  University of Washington, Seattle, Washington  98195-5726, USA
  phurvitz at u.washington.edu | http://gis.washington.edu/phurvitz
  "What is essential is invisible to the eye." -de Saint-Exupéry
  **************************************************************

On Mon, 21 Aug 2006, Harvey Greenberg wrote:

> Are you trying to get an ascii file with 2 values for each pixel?  To do 
> that, you would dump each band to ascii (assuming that the TM bands are 
> separate grids) with GRIDASCII at the arc prompt in the black command window. 
> Then at the unix prompt (If you don't have one get one.):
> tr -s '\012\015 ' '\012\012\012' < first_gridascii_dump |  sed 1,12d  > tmp1
> tr -s '\012\015 ' '\012\012\012' < second_gridascii_dump | sed 1,12d  > tmp2
> paste tmp1 tmp2 > file_for_excel.txt
>
> Of course, a large geographic area would be overwhelming.
> And this technique would not support the frequency of identical pairs.  For 
> that, you would combine (The grid COMBINE function will do this.) two bands 
> in one grid, enter "tables" from the arc command, and UNLOAD the VAT.
>
> I could flesh this out in detail, but I suspect that someone will convince 
> you that excel is not the best tool for spectral analysis.
>
> harvey
>
>
> KT wrote:
>> Hi all,
>> I want to prepare a scatterplot of Landfsat TM bands, for instance, band 5 
>> versus band 7 in Excel. Is it possible? If not, how can I plot this graph 
>> in excel?
>> Thanks all
>> 
>> ------------------------------------------------------------------------
>> Do you Yahoo!?
>> Next-gen email? Have it all with the all-new Yahoo! Mail Beta. 
>> <http://us.rd.yahoo.com/evt=42241/*http://advision.webevents.yahoo.com/handraisers> 
>> ------------------------------------------------------------------------
>> 
>> _______________________________________________
>> Uw-gis-l mailing list
>> Uw-gis-l at u.washington.edu
>> http://mailman1.u.washington.edu/mailman/listinfo/uw-gis-l
>> 
>
> -- 
> hgreen at u.washington.edu  374 Johnson Hall 206-685-7981 
> http://gis.ess.washington.edu/
>
> 	Harvey Greenberg
> 	University of Washington
> 	Department of Earth and Space Sciences
> 	Box 351310
> 	Seattle WA 98195-1310
>
> _______________________________________________
> Uw-gis-l mailing list
> Uw-gis-l at u.washington.edu
> http://mailman1.u.washington.edu/mailman/listinfo/uw-gis-l
>