View Single Post
Old 02-08-2008, 10:59 AM   #62
R4ND0M_AX3
Scooby Newbie
 
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:
2005 WRX STi

Default

The excel error is just letting you know that the formula is different in one cell than it's neighboring cells. Each of your formulas is looking at a different size data set. It's just trying to help you in case you intend them to all have the same formula. Placing $ in front of the cell column and row pointes should fix it.

ex... change
=MODE(E104:E251)

to
=MODE($E$104:$E$251)



OK, I looked at one set of data that I did manually and I ended up using 73% of the data. I'll try to play with STDEV and the other excel functions tonight.
* Registered users of the site do not see these ads.
R4ND0M_AX3 is offline   Reply With Quote