Crawford Learning Curve

Is there any way to do a Crawford learning curve in excel? I have prior actuals and I only need to do a learning curve for hours. I have actuals for 40 units already and I want to forecast the amount of hours for units 41-91. Anything will help!

Thanks

This is a cross post from

http://www.mrexcel.com/forum/showthread.php?t=349898

Mindyme, please read the forum rules with regards to cross posting.

Hey shg - it looks like you're everywhere. You helped me answer a question about a skewed normal distribution with random number generating a while back.

Mindyme asked me to help on this. I have most of what you did figured out and it looks fine - but I can't get B1 to calculate (#Value error).

Did you use the same linest array formula in A1 and B1? If I simply drag it the references are off.

Thanks.

Thanks shg. I saw that it was an array and had worked with them before - but for some reason I must not have been entering it into B1 correctly. I was able to get it to work this morning. Another clean solution.