11th February 2007, 04:15 PM
|
|
Member
|
|
Join Date: Sep 2006
Posts: 1,070
|
|
Quote:
|
Originally Posted by AngryPixie
Put the resulting probability into Excel like this
=1-CHIDIST(probability,1)
You should end with a figure between 0 and 100%.
|
Sorry, of course you'll only get a figure between 0 and 100% if you format the cell as a percentage. Otherwise you get a number between 0 and 1. Same diff though.  ops: |