Creating distribution graph from normalized values

billyheanue

Board Regular
Joined
Jul 13, 2015
Messages
109
Hi all,

I have a column of normalized values, with mean 0, and st dev =1.

It looks fishy (much more negative z scores than positive), so I wanted to take the column of values and create a normal distribution graph.

That is, ideally I would want to get something that looks like your standard bell curve. Using my standardized values, I want to try and replicate this bell curve, but I am afraid it might not appear like it when all is said and done.

For example, the values in the column are

[TABLE="width: 97"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]-0.321392512[/TD]
[/TR]
[TR]
[TD="align: right"]-0.253378377[/TD]
[/TR]
[TR]
[TD="align: right"]-0.241654729[/TD]
[/TR]
[TR]
[TD="align: right"]0.025153766[/TD]
[/TR]
[TR]
[TD="align: right"]-0.029586851[/TD]
[/TR]
[TR]
[TD="align: right"]-0.321392512[/TD]
[/TR]
[TR]
[TD="align: right"]0.349166272[/TD]
[/TR]
[TR]
[TD="align: right"]-0.041951697[/TD]
[/TR]
[TR]
[TD="align: right"]-0.321392512[/TD]
[/TR]
[TR]
[TD="align: right"]0.498150214[/TD]
[/TR]
[TR]
[TD="align: right"]-0.321392512
[/TD]
[/TR]
</tbody>[/TABLE]



I have a full column of values like these. Anyone know how to turn it into a bell curve type distribution?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
yes divide the data range into 16 equal sized bins eg -33 to -32 and -31 to -30 through to .49 to .50

ok that is more than 16 bins each will be about 05 wide

count how many fit each bin and plot those counts

note if your data is not normally distributed you are stuck with it.........
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top