💻 Software
Use a Trendline Formula to Get Values for Any Given X with Excel
Fresh7 days ago
Mar 15, 202626893 viewsConfidence Score0%
0%
Problem
Is there an easy way to apply the trend line formula from a chart to any given X value in Excel? For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and retyped it out be: =-0.000000000008*X^3 - 0.00000001*X^2 + 0.0003*X - 0.0029 I am continually making …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Use a Trendline Formula to Get Values for Any Given X with Excel
Low Risk
You can solve this with a simple formula (without charting) For a 3rd degree array enter into four horizontal cells to get your equation coefficients (aX^3+bX^2+cX+D), and then just substitute for X for more complex regressions is covered here
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix