Excel's Power trendline formula?

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 3K views
lownlazy
Messages
13
Reaction score
0
Can you please tell me what MS Excel uses to find a Power trendline?

I have been experiment with data from my PunchBot project and it seems the Power Trendline fits the best. The plan is the used the data from my machine (an array of time intervals) to find the curve of the acceleration and used that to work out angular velocity and then torque.

If you could tell me the maths that would great. If you could point me towards a library or some code (preferably c#) that would be superb.

This links will hold some clues for those that can decifer...
http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/

Many thanks!
 
Physics news on Phys.org
Thanks for the post! Sorry you aren't generating responses at the moment. Do you have any further information, come to any new conclusions or is possible to reword the post?
 
From the Excel documentation:
A power trendline uses this equation to calculate the least squares fit through points:
http://officeimg.vo.msecnd.net/en-us/files/897/240/ZA006051090.gif
where c and b are constants.
 
Last edited by a moderator: