Finding Trendline with Online Excel and Desktop Version of Excel
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- Finding a trendline using Excel is different depending on the version you are using. This video looks at the different ways to find the trendline and correlation coefficient on the desktop and online version of Microsoft Excel.
Hi Gail,
I am currently enrolled in Applied Statistics at SNHU and I ran into this same problem needing to add a trendline to a scatterplot in the online version of excel. I searched google for about 30 minutes before finding your video. THANK YOU!!!
Thank you!!
you are a life savor thank you soooo much
Hi professor, I have a question , not related to the quiz but from a math perspective. Is it also valid to get the trendline using the regression option in the Data Analysis plugin under the Data tab ? (cause from my experience, doing so will give the intercept and x -coefficient value, which can then be used to plot the trend)
Twisted, I know hehe; but in this way, you get the numbers too.
Yes! Your method works as well!