View Single Post
Old 02-09-2008, 07:25 AM   #71
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region: MAIC
Location: Virginia - hate it
3 Jeeps
And a Saab


so I piddled with it some more, trying to plot the last part... My plot looks like arse, as I can't figure out the graphing functions. Yes, it is true, I'm not well-versed in Excel.. But here's a screenshot of my Mean/Mode columns, after re-reading the directions, and using the Cor% column for my data, rather than the MAFv column....

the LEFT Mead/Mode columns are where I used the incorrect MAFv column for calcs. The RIGHT Mean/Mode is using Cor% column.

The one with #N/A, I've got no idea why. It's =MODE(E5:E6). Cells E5 and E6 are the Cor% column, containing 17.96 & 16.4, respectively. It's a "value not available" error, so I've got no idea..

But as for the scatter plot, using Cor%, Mean, and Mode, I can't get that to work for crap..
* Registered users of the site do not see these ads.
Rogan is offline   Reply With Quote