•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Inaccurate trendline equation for the graph
Our take
It sounds like you're encountering challenges with the trendline equation for your graph, leading to discrepancies between expected and actual Y values. This inaccuracy can stem from various factors, such as the choice of trendline type, data range, or even outliers affecting the calculation. To resolve this, consider revisiting the data points used and ensuring the appropriate trendline is applied based on the distribution of your values.
Can someone tell me why the equation is so inaccurate? Every x value I plug in, the Y value is so off
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#trendline#equation#inaccurate#graph#x value#y value#data#calculation#plug in#submission#comments#analysis#discrepancy#user