Excel's Power trendline formula?

Click For Summary
SUMMARY

Microsoft Excel employs a specific mathematical formula to determine a Power trendline, utilizing the least squares method for fitting data points. The formula involves constants 'c' and 'b', which are derived from the dataset. Users can apply this trendline to analyze acceleration data from projects like PunchBot to calculate angular velocity and torque. For implementation in C#, resources and libraries are available to facilitate this process.

PREREQUISITES
  • Understanding of Power trendline equations in Excel
  • Familiarity with least squares fitting method
  • Basic knowledge of C# programming
  • Experience with data analysis and curve fitting techniques
NEXT STEPS
  • Research the mathematical derivation of Power trendline formulas in Excel
  • Explore C# libraries for statistical analysis, such as Math.NET Numerics
  • Learn about least squares regression techniques
  • Investigate methods for calculating angular velocity and torque from acceleration data
USEFUL FOR

Data analysts, engineers working on projects involving motion analysis, and developers implementing statistical models in C# will benefit from this discussion.

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:

Similar threads

MATLAB Converting Excel formulae into Matlab code
  • · Replies 2 ·
Replies
2
Views
4K
Undergrad Polynomial Fit in EXCEL does not work as it should
  • · Replies 1 ·
Replies
1
Views
6K
How can I fix round-off errors in Excel when using trendline equations?
  • · Replies 1 ·
Replies
1
Views
8K
Excel Histogram How does it calculate bin width
  • · Replies 1 ·
Replies
1
Views
13K
ABC reference frame synchronous generator modelling in Ltspice
  • · Replies 1 ·
Replies
1
Views
3K
Understanding the Discrepancy in Power Calculation for a Moving Conveyor Belt
  • · Replies 8 ·
Replies
8
Views
2K
Multimeter Ohms exponential scale; formula?
  • · Replies 8 ·
Replies
8
Views
3K
Graduate The coherence length is much longer than the manufacturer claims
  • · Replies 10 ·
Replies
10
Views
2K
Engineering Advice of pursing two MS degrees given my situation
  • · Replies 2 ·
Replies
2
Views
855
MHB Power Series Problem: Solve f(3x) = 1/(1 - 3x)
  • · Replies 2 ·
Replies
2
Views
2K