Standard Deviation (bell graph) in excel

Click For Summary

Discussion Overview

The discussion revolves around creating cumulative frequency graphs, specifically "bell graphs," in Microsoft Excel, with a focus on how to visualize data related to cone populations. The context is primarily homework-related, as the original poster seeks assistance in graphing their statistical results.

Discussion Character

  • Homework-related

Main Points Raised

  • The original poster, Niklas, expresses difficulty in creating cumulative frequency graphs in Excel, despite knowing how to calculate mean and standard deviation.
  • Niklas mentions having 80 measurements of cone populations that he wants to represent graphically.
  • Another participant suggests looking for help in dedicated Microsoft Excel forums, indicating that there are resources available for quicker responses.

Areas of Agreement / Disagreement

There is no disagreement present, but the discussion remains unresolved as no specific solutions or methods for creating the graphs have been provided.

Contextual Notes

The discussion does not address specific steps or methods for graphing in Excel, and it lacks details on the assumptions or definitions related to the data being used.

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!
 

Similar threads

Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
Standard deviation calculators on the Internet are not for grouped data
  • · Replies 2 ·
Replies
2
Views
3K
Engineering Checking a component for a lathe slideway for straightness
  • · Replies 6 ·
Replies
6
Views
2K
Find the standard deviation of the values of ##y##
  • · Replies 3 ·
Replies
3
Views
2K
Excel: Finding deviation from mean
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad Correctly Scaling the Standard Deviation for Scaled Measurements
  • · Replies 5 ·
Replies
5
Views
2K
Standard deviation change problem
  • · Replies 24 ·
Replies
24
Views
2K
How to find standard deviation
  • · Replies 4 ·
Replies
4
Views
3K
C Programming - First assignment not sure how to approach
  • · Replies 10 ·
Replies
10
Views
2K
Plotting the waveforms of the harmonic components
  • · Replies 4 ·
Replies
4
Views
3K