Help creating bell curve graph for minutes

[teggl97]

Hi All

I'm trying to create a bell curve graph for the total minutes per month. I'm having a bit of trouble with the 99.7% min and max, as they are exceeding 100%. I'm not sure where I've gone wrong and can't seem to find anything on Google, as all the guides I can find are based on scores out of 100.

Any help would be amazing, thank you, geniuses!

Attempt below:

DRAFT bell curve minutes.xlsx
	A	B	C	D	E	F
1	Date	Minutes
2	18/02/2021	0			Mean	25.28
3	07/02/2021	2			Std Dev	52.81
4	03/02/2021	3			99.7% min	-133.15
5	13/02/2021	0			99.7% max	183.71
6	02/02/2021	229			Interval Count	20
7	03/02/2021	1			Interval Value	15.84
8	20/02/2021	4
9	06/02/2021	0
10	19/02/2021	8
11	06/02/2021	0
12	15/02/2021	0
13	22/02/2021	8
14	01/02/2021	0
15	12/02/2021	24
16	12/02/2021	4
17	23/02/2021	30
18	06/02/2021	54
19	17/02/2021	0
20	22/02/2021	5
21	16/02/2021	138
22	17/02/2021	0
23	07/02/2021	7
24	20/02/2021	0
25	17/02/2021	96
26	13/02/2021	19
Sheet1

Cell Formulas
Range	Formula
F2	F2	=AVERAGE(B:B)
F3	F3	=STDEV.P(B:B)
F4	F4	=F2-3*F3
F5	F5	=F2+3*F3
F7	F7	=(F5-F4)/F6

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$B$1:$B$26	F2:F3

Thanks,
Liam

 

[StephenCrump]

Welcome to the Forum!

Your raw data looks nothing like a bell curve.

Are you sure a bell curve is the appropriate fit? What does the data represent?