I'm trying to do a chart for a psychology report in Microsoft Excel. I want to do one that shows scores for each group centred around the average score, that hopefully produces a 'normal distribution' or bell-shaped curve.
Is this possible in Excel? Does anyone know how to do it?
2006-11-04 00:56:16 · 3 answers · asked by @>-- Dee --<@ 2 in Computers & Internet ➔ Programming & Design
Have you made a calculation for the average score?
If so, highlight all these cells and click on the chart wizard button.
2006-11-04 00:59:59 · answer #1 · answered by J J 3 · 0⤊ 0⤋
How would you go about doing the thing manually?
Well I guess you need to support each step with calculations. The calculation parts are easy in excel. Now figure out how exactly you would go about plotting a normal curve. I've no knowledge about normal curves!
2006-11-04 01:08:53 · answer #2 · answered by deostroll 3 · 0⤊ 0⤋
Try - Insert Chart with the figures Highlighted and select SURFACE.
You can edit and add labels to the chart later.
2006-11-04 01:17:34 · answer #3 · answered by Anonymous · 0⤊ 0⤋