make a bell curve

%3CLINGO-SUB%20id%3D%22lingo-sub-2246173%22%20slang%3D%22en-US%22%3Emake%20a%20bell%20curve%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246173%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20following%20this%20guide%2C%20trying%20to%20make%20a%20bell%20curve%20based%20upon%20student's%20results%20in%20a%20level%20test%20to%20determine%20their%20class%20placement%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.spreadsheetweb.com%2Fbell-curve-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.spreadsheetweb.com%2Fbell-curve-in-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20know%20if%20I'm%20doing%20this%20right%20(please%20see%20attached%2C%20I've%20created%20a%20graph%20based%20upon%20one%20dataset%2C%20the%20P1%20class).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20I'm%20confident%20that%20the%20graphs%20accurately%20represent%20the%20data%2C%20I'd%20them%20like%20to%20add%20the%20following%20two%20elements%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMEAN%20and%20STDEV%20lines%20to%20the%20graph%2C%20to%20clearly%20illustrate%20what%20portion%20of%20data%20lies%20where.%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22theirlaw_1-1617164510841.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268504iBBCB1FA38DA097E8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22theirlaw_1-1617164510841.png%22%20alt%3D%22theirlaw_1-1617164510841.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CIMG%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20(if%20possible)%20I'd%20like%20the%20ability%20to%20add%2Fremove%20an%20overlay%20of%20the%20threshholds%20to%20visualize%20what%20portion%20of%20students%20are%20going%20to%20be%20placed%20in%20which%20class.%20(This%20is%20more%20a%20desireable%20feature%20more%20than%20an%20essential%20one).%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22theirlaw_1-1617164222492.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268503i831DBC4B7670BA46%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22theirlaw_1-1617164222492.png%22%20alt%3D%22theirlaw_1-1617164222492.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2246173%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I've been following this guide, trying to make a bell curve based upon student's results in a level test to determine their class placement:

 

https://www.spreadsheetweb.com/bell-curve-in-excel/

 

I'd like to know if I'm doing this right (please see attached, I've created a graph based upon one dataset, the P1 class).

 

Once I'm confident that the graphs accurately represent the data, I'd them like to add the following two elements:

 

MEAN and STDEV lines to the graph, to clearly illustrate what portion of data lies where. For example:

 

theirlaw_1-1617164510841.png

 

 

 

Then (if possible) I'd like the ability to add/remove an overlay of the threshholds to visualize what portion of students are going to be placed in which class. (This is more a desireable feature more than an essential one).

  

theirlaw_1-1617164222492.png

0 Replies