Posted October 06, 2011
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.
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.