Thank you for this great video. Is it possible that high variability will affect the accuracy of the line? I ask because I created mock data in google sheets and compared my results using this method and the trend line google sheets generates. I got a negative trend line when just doing visual analysis, but google sheets said it was trending positively. I checked it many times to make sure that I hadn't errored in the process. Any thoughts or suggestions?
You are so welcome. Well, this is a simple visual method that is generally used by readers and others that don't have access to the data. I'm guessing what google sheets is doing is a different, but more complete calculation. So yes, the two methods can absolutely differ. Also, the visual method can change dramatically depending on the choice of a data point; the google sheets method likely "smooths" things out.
very useful! thank you so much!
This is so helpful - do you happen to have any info on how to calculate improvement rate difference? I can't quite seem to grasp it!!
Sorry, I don't have any videos on IRD; there are so many ways to look changes in level and trend, it's hard to keep up!
Thanks anyways! It's the only one I just can't get my head around!
Thank you for this great video. Is it possible that high variability will affect the accuracy of the line? I ask because I created mock data in google sheets and compared my results using this method and the trend line google sheets generates. I got a negative trend line when just doing visual analysis, but google sheets said it was trending positively. I checked it many times to make sure that I hadn't errored in the process. Any thoughts or suggestions?
You are so welcome. Well, this is a simple visual method that is generally used by readers and others that don't have access to the data. I'm guessing what google sheets is doing is a different, but more complete calculation. So yes, the two methods can absolutely differ. Also, the visual method can change dramatically depending on the choice of a data point; the google sheets method likely "smooths" things out.
Hello
i need help to write ch4 and 5