How to create a Negatively Skewed Distribution in Excel

[peterlaw2003]

Hi Guys,

With the function (NORM.DIST), I was able to create a traditional bell shape with the data set below. But is there any function or way we could adjust the skewness of the distribution, such that it transforms into a negatively/positively skewed distribution, please?

Thank you so much

(Normal Distribution) (Negatively Skewed Distribution)

-->

Sample	1
Score	80
STDEV	7
Expected Number	Probability
30	=NORM.DIST($A5,B$42,B$43,0)
31	=NORM.DIST($A6,B$42,B$43,0)
32	=NORM.DIST($A7,B$42,B$43,0)
33	=NORM.DIST($A8,B$42,B$43,0)
34	=NORM.DIST($A9,B$42,B$43,0)
35	=NORM.DIST($A10,B$42,B$43,0)
36	=NORM.DIST($A11,B$42,B$43,0)
37	=NORM.DIST($A12,B$42,B$43,0)
38	=NORM.DIST($A13,B$42,B$43,0)
39	=NORM.DIST($A14,B$42,B$43,0)
40	=NORM.DIST($A15,B$42,B$43,0)
41	=NORM.DIST($A16,B$42,B$43,0)
42	=NORM.DIST($A17,B$42,B$43,0)
43	=NORM.DIST($A18,B$42,B$43,0)
44	=NORM.DIST($A19,B$42,B$43,0)
45	=NORM.DIST($A20,B$42,B$43,0)
46	=NORM.DIST($A21,B$42,B$43,0)
47	=NORM.DIST($A22,B$42,B$43,0)
48	=NORM.DIST($A23,B$42,B$43,0)
49	=NORM.DIST($A24,B$42,B$43,0)
50	=NORM.DIST($A25,B$42,B$43,0)
51	=NORM.DIST($A26,B$42,B$43,0)
52	=NORM.DIST($A27,B$42,B$43,0)
53	=NORM.DIST($A28,B$42,B$43,0)
54	=NORM.DIST($A29,B$42,B$43,0)
55	=NORM.DIST($A30,B$42,B$43,0)
56	=NORM.DIST($A31,B$42,B$43,0)
57	=NORM.DIST($A32,B$42,B$43,0)
58	=NORM.DIST($A33,B$42,B$43,0)
59	=NORM.DIST($A34,B$42,B$43,0)
60	=NORM.DIST($A35,B$42,B$43,0)
61	=NORM.DIST($A36,B$42,B$43,0)
62	=NORM.DIST($A37,B$42,B$43,0)
63	=NORM.DIST($A38,B$42,B$43,0)
64	=NORM.DIST($A39,B$42,B$43,0)
65	=NORM.DIST($A40,B$42,B$43,0)
66	=NORM.DIST($A41,B$42,B$43,0)
67	=NORM.DIST($A42,B$42,B$43,0)
68	=NORM.DIST($A43,B$42,B$43,0)
69	=NORM.DIST($A44,B$42,B$43,0)
70	=NORM.DIST($A45,B$42,B$43,0)
71	=NORM.DIST($A46,B$42,B$43,0)
72	=NORM.DIST($A47,B$42,B$43,0)
73	=NORM.DIST($A48,B$42,B$43,0)
74	=NORM.DIST($A49,B$42,B$43,0)
75	=NORM.DIST($A50,B$42,B$43,0)
76	=NORM.DIST($A51,B$42,B$43,0)
77	=NORM.DIST($A52,B$42,B$43,0)
78	=NORM.DIST($A53,B$42,B$43,0)
79	=NORM.DIST($A54,B$42,B$43,0)
80	=NORM.DIST($A55,B$42,B$43,0)
81	=NORM.DIST($A56,B$42,B$43,0)
82	=NORM.DIST($A57,B$42,B$43,0)
83	=NORM.DIST($A58,B$42,B$43,0)
84	=NORM.DIST($A59,B$42,B$43,0)
85	=NORM.DIST($A60,B$42,B$43,0)
86	=NORM.DIST($A61,B$42,B$43,0)
87	=NORM.DIST($A62,B$42,B$43,0)
88	=NORM.DIST($A63,B$42,B$43,0)
89	=NORM.DIST($A64,B$42,B$43,0)
90	=NORM.DIST($A65,B$42,B$43,0)
91	=NORM.DIST($A66,B$42,B$43,0)
92	=NORM.DIST($A67,B$42,B$43,0)
93	=NORM.DIST($A68,B$42,B$43,0)
94	=NORM.DIST($A69,B$42,B$43,0)
95	=NORM.DIST($A70,B$42,B$43,0)
96	=NORM.DIST($A71,B$42,B$43,0)
97	=NORM.DIST($A72,B$42,B$43,0)
98	=NORM.DIST($A73,B$42,B$43,0)
99	=NORM.DIST($A74,B$42,B$43,0)
100	=NORM.DIST($A75,B$42,B$43,0)
101	=NORM.DIST($A76,B$42,B$43,0)
102	=NORM.DIST($A77,B$42,B$43,0)
103	=NORM.DIST($A78,B$42,B$43,0)
104	=NORM.DIST($A79,B$42,B$43,0)
105	=NORM.DIST($A80,B$42,B$43,0)
106	=NORM.DIST($A81,B$42,B$43,0)
107	=NORM.DIST($A82,B$42,B$43,0)
108	=NORM.DIST($A83,B$42,B$43,0)
109	=NORM.DIST($A84,B$42,B$43,0)
110	=NORM.DIST($A85,B$42,B$43,0)

 

[shg]

From Skew normal distribution - Wikipedia:

	B​	C​	D​	E​
2​	Mean​	80​
3​	SD​	7​
4​	Shape​	4​
5​
6​	x​	Normal​	Skew-Normal​
7​	58​	0.0004​	0.0000​	D7: =2 / SD * NORM.S.DIST((x - Mean) / SD, FALSE) * NORM.S.DIST(Shape * (x - Mean) / SD, TRUE)
8​	60​	0.0010​	0.0000​
9​	62​	0.0021​	0.0000​
10​	64​	0.0042​	0.0000​
11​	66​	0.0077​	0.0000​
12​	68​	0.0131​	0.0000​
13​	70​	0.0205​	0.0000​
14​	72​	0.0297​	0.0000​
15​	74​	0.0395​	0.0000​
16​	76​	0.0484​	0.0011​
17​	78​	0.0547​	0.0138​
18​	80​	0.0570​	0.0570​
19​	82​	0.0547​	0.0956​
20​	84​	0.0484​	0.0957​
21​	86​	0.0395​	0.0789​
22​	88​	0.0297​	0.0593​
23​	90​	0.0205​	0.0411​
24​	92​	0.0131​	0.0262​
25​	94​	0.0077​	0.0154​
26​	96​	0.0042​	0.0084​
27​	98​	0.0021​	0.0042​
28​	100​	0.0010​	0.0019​

 

[peterlaw2003]

thank you so much

 

[shg]

You're welcome.

 

[ggt]

Hi many thanks for your help. Is it possible to add Kurtosis as well to your new distribution above?