--- In [email protected], Will Hopkins <[EMAIL PROTECTED]> wrote: > Here is another stats query and my reply.
Hello Will: Thanks for posting your response to the group. I generally do non-linear regression in excel by using solver to find coefficients that minimize the least squares error term. In the files section you will find a file named Hill Model fit in Excel which I have posted as an example. In columns A and B you will see measured values for muscle shortening velocity (mm/s) and muscle force (g) in a hamster gastroc. In column C you will see the Hill model approximation of force and in column D you will see the squared error term. In cell D1 you will see the sum of the squared error terms. Cells F2 and F3 hold values for Hill coefficients A and B. Use solver to minimize the sum of squared error term in D1 by changing cells F2 and F3. Note that I included F0 as the measured isometric force but I could approximate it by letting solver change the values in F2, F3 and F4. Note to students: Please look long and hard at this example before asking for help! You will probably find everything you need right there in the spreadsheet. Cheers, Jim ------------------------ Yahoo! Groups Sponsor --------------------~--> Give the gift of life to a sick child. Support St. Jude Children's Research Hospital's 'Thanks & Giving.' http://us.click.yahoo.com/5iY7fA/6WnJAA/Y3ZIAA/2_TolB/TM --------------------------------------------------------------------~-> Post messages to [EMAIL PROTECTED] To (un)subscribe, send any message to sportscience-(un)[EMAIL PROTECTED] View all messages at http://groups.yahoo.com/group/sportscience/. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/sportscience/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
