T
teh2heartedale
Hello all
First time poster, so I apologize for any formatting issues.
I am working on an assignment, and am posting here because I couldn
make it to class to learn the material.
I was given very simple data with X ranging from 1-5, and Y ranging fro
.4-.9.
x y
1 0.4016458
2 0.5747817
3 0.7313313
4 0.8457159
5 0.9169331
How do I fit a logistic curve f(x) = 1/(1+e^(-a*(x-c))) to this made u
data?
plotting these points gives me a somewhat linear relationship but th
instructions say that it is 1) not the same as a log curve, and 2) tha
i cant simply do this using a trendline.
What does he mean when he says that i require setting up decisio
variables, predicted values, residuals, and a objective function cell.
Iam suppose to use the Solver add-in.
== My questions ==
How do I identify the variable a and c?
Do I attain a, c and my predicted values from using the Analysi
function over the y variable?
I am really confused about this topic. Ive been searching for "fi
logistic curve excel" on google and youtube and many of thes
descriptions do not come close to what I am asking (i think). Usually
find some guidance in these help tutorials, however this time I can no
find anything.
Any guidance would be wonderful
Much Appreciated
teh2heartedal
First time poster, so I apologize for any formatting issues.
I am working on an assignment, and am posting here because I couldn
make it to class to learn the material.
I was given very simple data with X ranging from 1-5, and Y ranging fro
.4-.9.
x y
1 0.4016458
2 0.5747817
3 0.7313313
4 0.8457159
5 0.9169331
How do I fit a logistic curve f(x) = 1/(1+e^(-a*(x-c))) to this made u
data?
plotting these points gives me a somewhat linear relationship but th
instructions say that it is 1) not the same as a log curve, and 2) tha
i cant simply do this using a trendline.
What does he mean when he says that i require setting up decisio
variables, predicted values, residuals, and a objective function cell.
Iam suppose to use the Solver add-in.
== My questions ==
How do I identify the variable a and c?
Do I attain a, c and my predicted values from using the Analysi
function over the y variable?
I am really confused about this topic. Ive been searching for "fi
logistic curve excel" on google and youtube and many of thes
descriptions do not come close to what I am asking (i think). Usually
find some guidance in these help tutorials, however this time I can no
find anything.
Any guidance would be wonderful
Much Appreciated
teh2heartedal