Quote:
Originally Posted by Buegie
the .47 number only represents the area to the right of the mean, you need to add .5 to it if you want the cumulative percentage (note: .47+.5=.97). Excel returns the whole thing, but with the formula, you need to "finish it off" so to speak. See if the graph below makes it clear, if not I'll try to explain more tomorrow.
|
Ahh you can just add .5 to .47 to get the answer! My prof wants us to subtract .47 from .5 which gives us .03 and then subtract that from 1, which then gives us .97 lol. I can't believe I didn't notice the shortcut.