1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

The linear function of my trendline is just straight up wrong

So, I am trying to do a trendline, it has x values from 0 to 0,5 and y values from 0 to 0,5, so it should be roughly y=1x, however excel insists its y=0,1x which is just straight up wrong. How do I fix this?

submitted by /u/Hexagol
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#trendline
#linear function
#Excel
#y=1x
#y=0.1x
#x values
#y values
#regression
#data analysis
#plotting
#function fitting
#graphing
#correlation
#mathematical modeling
#statistical analysis
#slope