DColin
asked on
Excel sigmoid curve formula
Hi Experts,
Please look at the attached Excel worksheet. I would like to know how to change the formula in column B so that the Y axis goes from 0 to +1 instead of -1 to +1. sigmoid-01.xls
Please look at the attached Excel worksheet. I would like to know how to change the formula in column B so that the Y axis goes from 0 to +1 instead of -1 to +1. sigmoid-01.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=1/(1+EXP(-A1))