•1 min read•from 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
Our take
When working with trendlines in Excel, it can be frustrating when the results do not align with your expectations. In your case, with x values ranging from 0 to 0.5 and corresponding y values also from 0 to 0.5, you would anticipate a linear relationship represented by y = 1x. However, if Excel is suggesting y = 0.1x, there may be a misconfiguration or a need for adjustment in your data input or trendline settings.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
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