Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scatter plot where I need to log the scale otherwise the outliars make the visual extremely unappealing (however these values still need to be included)
Without logging the scale the trendline (for "average) works perfectly fine; however once I log the scale the trendline goes way below all of the other values.
Once logged, the trendline is at at the value for 20 when 95% of values are between 700-1200, only one or two are even below 20.
Is this a glitch? How can I fix it?
I'd like to add that when I click show equation it shows that Y = 1100.3, yet the line is still at the 20 level, well below everything on the chart.