It seems that you're using an outdated browser. Some things may not work as they should (or don't work at all).
We suggest you upgrade newer and better browser like: Chrome, Firefox, Internet Explorer or Opera

×
Ok, so I'm taking a Natural Science class and we basically have to learn statistics. Statistics is basic math for the most part, so I'm fine there. I know how to calculate the average and find the standard deviation.

BUT

I cannot for the life of me figure out how to make a bell graph of it in Google Docs OR Excel. For example, here is my data for 10 sets of random objects, let's say fish:

4
3
3
4
2
20
15
16
17
4

I know the average is 8.8, and the standard deviation is 7.19. So how do I translate that visually into a graph? Googling has not solved this. If it's not possible in Google Docs, I have Excel, so if you can tell me how to do it in that if its not possible in Docs, I'd appreciate that as well.
avatar
Wraith: Ok, so I'm taking a Natural Science class and we basically have to learn statistics. Statistics is basic math for the most part, so I'm fine there. I know how to calculate the average and find the standard deviation.

BUT

I cannot for the life of me figure out how to make a bell graph of it in Google Docs OR Excel. For example, here is my data for 10 sets of random objects, let's say fish:

4
3
3
4
2
20
15
16
17
4

I know the average is 8.8, and the standard deviation is 7.19. So how do I translate that visually into a graph? Googling has not solved this. If it's not possible in Google Docs, I have Excel, so if you can tell me how to do it in that if its not possible in Docs, I'd appreciate that as well.

Check this, might help: http://support.microsoft.com/kb/213930