Antievolution.org :: Antievolution.org Discussion Board The Critic's Resource on Antievolution

Antievolution.org Discussion Board > From the Panda's Thumb > After the Bar Closes... > Need spreadsheet expert

stevestory Posts: 13407 Joined: Oct. 2005 (Permalink) Posted: July 27 2008,22:24    This is off-topic so I'll post it and then delete it after a few days. Even though it's off-topic there's a good 100 or so people here with science degrees and so this shouldn't be hard for someone. I have here 2 sets of data. Normal minimum temps for a hundred or so cities, and Normal maximum temps for the same cities. At the moment I happen to be using a computer without Mathematica or Excel but I really want to look at this data in graph form. http://www.met.utah.edu/jhorel/html/wx/climate/mintemp.html http://lwf.ncdc.noaa.gov/oa/climate/online/ccd/maxtemp.html Can anyone here do this without too much trouble?

Wesley R. Elsberry Posts: 4991 Joined: May 2002 (Permalink) Posted: July 27 2008,22:46    What do you want graphed, min and max values by months, or an x-y plot of, say, min temp on x and max temp on y? -------------- "You can't teach an old dogma new tricks." - Dorothy Parker

stevestory Posts: 13407 Joined: Oct. 2005 (Permalink) Posted: July 27 2008,23:03    Good question. I left it open ended because I wasn't sure what the best way to present it would be. Maybe like each point on the x axis is a different city, and the y axis is like a a scatterplot with error bars where the bars go from annual lowest temp to annual highest temp, with an overall look like this

Henry J Posts: 5787 Joined: Mar. 2005 (Permalink) Posted: July 27 2008,23:05    I can point to a couple of other BB's that have computer-related forums (i.e., where it's not off-topic), and regulars who would know spreadsheet related stuff. Henry http://www.xprodigy.net/board/viewforum.php?f=4 http://aantares.com/eve/forums/a/frm/f/2786008334

stevestory Posts: 13407 Joined: Oct. 2005 (Permalink) Posted: July 27 2008,23:07    thanks Henry. If nobody here can easily do this--i don't want anyone to put much work into it, because it's just for my personal use--I'll check out those forums.

Quidam Posts: 229 Joined: Mar. 2008 (Permalink) Posted: July 27 2008,23:41    That's easy, I've done that for you.  the only problem is that the number of cities makes the x-axis labels illegible.   -------------- The organized fossils ... and their localities also, may be understood by all, even the most illiterate. William Smith, Strata. 1816

stevestory Posts: 13407 Joined: Oct. 2005 (Permalink) Posted: July 27 2008,23:45    Quidam, U R my Favoritez! any format you can email that to me where i can read the city names? stevestory@gmail.com

stevestory Posts: 13407 Joined: Oct. 2005 (Permalink) Posted: July 27 2008,23:47    That kind of looks like SigmaPlot formatting, btw.

csadams Posts: 124 Joined: June 2007 (Permalink) Posted: July 28 2008,08:08    If you're interested, MyNasaData has some datasets you can configure and display by longitude, latitude, time series, etc.   Datasets include - the atmosphere (Aerosols, Air Quality, Atmospheric Pressure, Atmospheric Radiation, Atmospheric Temperature, Atmospheric Water Vapor, Clouds, Precipitation) - the biosphere (Monthly Leaf Area Index (MISR), Monthly Normalized Difference Vegetation Index (MISR)); - the cryosphere (Monthly Snow/Ice Amount (ISCCP)); - the land surface (Surface, Surface Conditions, Surface Cover, Surface Radiation), and - the oceans (5-day Sea Level Height (TOPEX/POSEIDON), Daily Sea Surface Temperature (MCSST), Monthly Ocean Wind Speed Vectors (NOAA NOMADS), Monthly Wind Speed - Climatology 1995 to 2005 (NOAA NCDC), Weekly Sea Surface Temperature (MCSST)). I know this doesn't answer your spreadsheet question, but if you need to do anything similar in the future maybe this resource might help. -------------- Stand Up For REAL Science!

Quidam Posts: 229 Joined: Mar. 2008 (Permalink) Posted: July 28 2008,10:14    Quote (stevestory @ July 27 2008,22:47) That kind of looks like SigmaPlot formatting, btw. Actually I used the 'Stock Market' chart type with hi, low and close 'prices' I'll save it as a pdf and send it.  It would be a lot easier if you had a spreadsheet software. I can recommend Open Office - the price is right and it's excellent -------------- The organized fossils ... and their localities also, may be understood by all, even the most illiterate. William Smith, Strata. 1816

Track this topic	Email this topic	Print this topic

© 2002-2009 Antievolution.org Powered by Ikonboard 3.0.2a © 2001 Ikonboard