Hey brother, my students have seen your videos and you have saved them a lot of time and confusion. I really appreciate your help and please continue to keep up the good work.
Wow! I am alternating between "this is idiotic" for the situation and "Brilliant" for the workaround. My thanks- though I suspect my students will *not* thank you right away.
Oh wow, that was painful. I think I won't bother now! I got here because I thought picking "standard deviation" would help me - like it would compute the standard deviation of my series and use that for each point, but no. Wouldn't it be nice if they allowed you to just pick another column for error bars values? Did some more research on this - when you use "Standard deviation" it computes STDDEV of the entire series and the plots the error bars for each point centered around the median of the series. The number you enter is a multiplier on STDDEV so 1 for +- 1 standard deviation. This only works for a normally distributed series about a mean. You can't use it for an X-Y plot of a variable and a dependent value. There is a feature of charts where you enter two columns of values for X and Y, highlight those for a scatter plot and select aggregate values on the X-axis. So then if a row has the same X as another row then it can aggregate those values as min, max, mean, median, sum, count. You'd THINK that for that set up then stddev for error bars could do the stddev of all the rows with the same X. But no, it doesn't work like that - it is still series based. So you still need to turn each X-Y point into its own series.
I fully agree with you. It would be nice if Sheets would have picked the brain of the excel folks and adapted their software to make this a one click feature. In the end it's not too bad for the kinds of graphs my students in grade 11 and 12 are working with but I'd have to have larger data sets and try to pull this off. -Thanks for the comment and thoughts on this.
This is a nice workaround for five data points. But how would you deal with 1,000 data points? Or the need to have asymmetrical error bars, with a different + and - value? It's sad that Google hasn't done anything about this for years.
The values you've inputted were values of standard deviation. Why did you click constant? Thanks for making our to separate the series clearer, by the way!
Sorry for such a late reply but this might help someone out there... I've done this for MS Excel but haven't done it yet with google sheets. If that helps anyone, here is the link: th-cam.com/video/GxqJQI5jBZw/w-d-xo.html
So what you're saying is basically "use Excel". It's good to know that it's technically possible and it's a good explanation, but this method is simply not sustainable for large sets of data.
This (th-cam.com/video/B-zKcSoYMq0/w-d-xo.html ) is an older version of excel I used to work with (pre google sheets) and I thought it was quite a bit easier for this type of task. Might be what you are looking for.
Come back here at least once a year for my physics lab reports. Thanks!
Hey brother, my students have seen your videos and you have saved them a lot of time and confusion. I really appreciate your help and please continue to keep up the good work.
my guy coming in clutch
I've got your back!
This video is saving my day Thank you!!
Cheers- glad it helped.
Seriously helpful, and quite understandable! Thanks for saving my lab report!
You’ve helped me sooo much! THANKYOU 👏🏻
this video saved my ass ive been trying to do this for a few hours💀 I ❤ PETER STANLEY !THANK YOU SO MUCH!
thank you so much! you saved me so much time from trying to figure this out on my own!
Thank you so much! I would not have been able to figure this out without this video
Thank you so much !!! you saved my lab report !!
Glad it helped!
Great Video I was trying to figure out how to do this in sheets.
Wow! I am alternating between "this is idiotic" for the situation and "Brilliant" for the workaround. My thanks- though I suspect my students will *not* thank you right away.
Couldn't agree with you more. Wish they made this a bit easier for us all.
Thank you! You saved me!
Oh wow, that was painful. I think I won't bother now! I got here because I thought picking "standard deviation" would help me - like it would compute the standard deviation of my series and use that for each point, but no. Wouldn't it be nice if they allowed you to just pick another column for error bars values?
Did some more research on this - when you use "Standard deviation" it computes STDDEV of the entire series and the plots the error bars for each point centered around the median of the series. The number you enter is a multiplier on STDDEV so 1 for +- 1 standard deviation. This only works for a normally distributed series about a mean. You can't use it for an X-Y plot of a variable and a dependent value.
There is a feature of charts where you enter two columns of values for X and Y, highlight those for a scatter plot and select aggregate values on the X-axis. So then if a row has the same X as another row then it can aggregate those values as min, max, mean, median, sum, count. You'd THINK that for that set up then stddev for error bars could do the stddev of all the rows with the same X. But no, it doesn't work like that - it is still series based. So you still need to turn each X-Y point into its own series.
I fully agree with you. It would be nice if Sheets would have picked the brain of the excel folks and adapted their software to make this a one click feature. In the end it's not too bad for the kinds of graphs my students in grade 11 and 12 are working with but I'd have to have larger data sets and try to pull this off. -Thanks for the comment and thoughts on this.
THANK YOU, it seriously saved me
Fantastic. Simple and it works. You have saved me hours.
life save thank you so much
Thank youuuuu! Very helpful.
You're welcome!
Thank you!
I appreciate your effort, thank you.
thanks yo this saved my bio grade
This is a nice workaround for five data points. But how would you deal with 1,000 data points? Or the need to have asymmetrical error bars, with a different + and - value? It's sad that Google hasn't done anything about this for years.
totally agree with you this √
Thank you so much!
KING 👑
The values you've inputted were values of standard deviation. Why did you click constant? Thanks for making our to separate the series clearer, by the way!
Hello, this video was really great. Do you know how to do the same thing with a graph that has multiple lines ?
Sorry for such a late reply but this might help someone out there... I've done this for MS Excel but haven't done it yet with google sheets. If that helps anyone, here is the link: th-cam.com/video/GxqJQI5jBZw/w-d-xo.html
Thank you so much
Thank u this was so helpful
great to hear, cheers √
thanks that was so helpful!!!!
thanks for the comment, I'm glad it helped.
Why we do have to insert STD manually? I really don't understand why I cant mark a cells with STD, like in excel.
Thanks bro 👍
Thank you
So what you're saying is basically "use Excel". It's good to know that it's technically possible and it's a good explanation, but this method is simply not sustainable for large sets of data.
I definitely agree with you and hope the techs at google keep making these much needed improvements.
manually?
thanks for the tuto! this system is garbage :( there should be an option to apply error bar to a serie given another serie
Agreed that it should be a lot easier. Hopefully one day soon my video will be redundant.
ty
You can’t customize error bars on excel
This (th-cam.com/video/B-zKcSoYMq0/w-d-xo.html ) is an older version of excel I used to work with (pre google sheets) and I thought it was quite a bit easier for this type of task. Might be what you are looking for.
Thank you!