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..