Originally Posted by bchslap
i just sat here, from 9pm-1215am, walking through this 'excel nightmare' LOL
my mean & modes are both positives, and close to each other. so i think ive got something wrong. also, every cell in the two columns, with formulas, has an error stating something about grouped cells having data in adjacent cells..??
Oh, I'm so confused LOL
First of all, I wouldn't worry too much about those numbers, they look ok to me. The mean and mods being close just means that the error is evenly distributed to both sides of the mode, which is probably a good thing. Run with it.
Also, I googled your error and it sounds like it's just excel bitching about the fact that you didn't select all your data. Ignore it.