dailygrind wrote:NYC Law wrote:I used a mini z table and 6.8 wasn't included. 6.8 has been added, so try it now.
Oh, I think I see how you're doing it. Did you use normsinv? The formula's straightforward:
=(data point gpa - mean gpa)/normsinv(1-(data point rank/100)
I just ended up using NORMDIST to get the final rank, I figured thats what you were talking about since I was missing that last step. But I see what you mean, it's pretty rudimentary atm. The thing about those google docs is they ensure chaos since everything everyone does is updated real time for everyone else, but its the only thing I've found for making public spreadseets. I'll use that norminv formula though, give me a sec