Standard Deviation (bell graph) in excel

AI Thread Summary
Creating a cumulative frequency graph or bell curve in Excel for Mac can be challenging for users unfamiliar with the software. The user has successfully calculated the mean and standard deviation but struggles with graphing the data. Suggestions include organizing the data by frequency and utilizing online forums specific to Excel for assistance. It is recommended to explore resources like Microsoft’s dedicated Excel forums for quicker solutions. Proper guidance can lead to effectively visualizing the 80 measurements of cone populations.
Svensken
Messages
28
Reaction score
0

Homework Statement



Homework Statement



Hello everyone!
I have been having trouble with cumulative frequency graphs in excel for some time now. I wonder how you make the "bell graph" or cumulative frequency graphs or standard deviation graphs in microsoft excel. I have excel for mac. I know how to find the mean and the standard deviation but i don't know how to express all the results in a graph.
I have 80 different measurements of cone populations and i would like to express them.

Please guys and girls, i wonder how i go about in doing this?

-Niklas

Homework Equations





The Attempt at a Solution



I have tried to organize it according to frequency but can't seem to arrange it in the right order, as said i can find mean and sd.

Homework Equations





The Attempt at a Solution


 
Physics news on Phys.org
I don't know if this is the right place to post this but i assumed so. If not please tell me where.

Niklas
 
If you have access to usenet, there is a very helpful forum microsoft.public.excel. Also Microsoft has an excel board at msnews.microsoft.com called m.p.excel. You will almost certainly get an answer in hours, especially at the microsoft one.
 
Thank you, i will look into it!
 
Back
Top