•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Wildly inaccurate trendline equations
I'm trying to add trendlines to my line graph, and then use the equations to do further calculations, but the trendline equation is completely off. Equation should be y=-1.37x+102, but excel is giving me y=-27.433x+129.83
All I did was right-click, add trendline, add equations and r squared
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#trendline
#equation
#Excel
#calculations
#r squared
#line graph
#inaccurate
#add trendline
#right-click
#data visualization
#statistical analysis
#y=-1.37x+102
#y=-27.433x+129.83
#graphing
#regression
#off
#error