cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Malik_se
Level I

size distribution graph with median d SD as vertical lines in graph

µm%
0,2754230,05
0,3162281
0,3630780,812078
0,4168691,2
0,478632
0,5495411,9
0,6309572,2
0,7244362,5
0,8317642,86
0,9549933,2
1,0964783,53
1,2589253,881
1,445444,22
1,6595874,538
1,9054614,81
2,1877625,021
2,5118865,16
2,8840315,220
3,3113115,21
3,8018945,113
4,3651584,947175
5,0118724,706444
5,7543994,40
6,6069344,03
7,5857763,62
8,7096363,18
102,74
11,481542,30
13,182571,90
15,135611,53
17,378011,20
19,952620,91
22,908680,64
26,302680,39
30,199520,102363

hi

i want to create size distribution curve of this data with% column on x axis. and then i would like to see SD and median as vertical line in the graph. can anyone help plz?

1 REPLY 1
Victor_G
Super User

Re: size distribution graph with median d SD as vertical lines in graph

Hi @Malik_se,

 

Welcome in the Community !
Please try to provide data in JMP format, or at least in Excel/CSV format, this saves some time and trouble.

Would this graph be what you're looking for ? :

Victor_G_0-1706188186545.png

If yes, here is the script to generate it :

Graph Builder(
	Size( 522, 456 ),
	Show Control Panel( 0 ),
	Variables( X( :µm ), Y( :"%"n ) ),
	Elements(
		Points( X, Y, Legend( 3 ) ),
		Caption Box(
			X,
			Y,
			Legend( 6 ),
			Summary Statistic( "Median" ),
			Summary Statistic 2( "Std Dev" )
		),
		Line( X, Y, Legend( 7 ) ),
		Bar( X, Y, Legend( 8 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"µm",
			ScaleBox,
			{Add Ref Line(
				2.86,
				"Dashed",
				"Dark Red",
				"Median",
				2,
				1,
				Label Settings( {Opposite Axis( 1 )} )
			), Add Ref Line(
				{1.1701, 4.54999},
				"Solid",
				"Orange",
				"+/- SD",
				1,
				0.25
			)}
		),
		Dispatch(
			{},
			"%",
			ScaleBox,
			{Min( -0.0534175 ), Max( 6.10537188137755 ), Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{},
			"graph title",
			TextEditBox,
			{Set Text( "Size distribution" )}
		),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position( {3, [0], 7, [-1], 8, [1]} )}
		)
	)
)

And you can find attached the datatable used for this graph.

You can do a lot of things on Graph Builder, by combining different graph types with MAJ+click on the graph type you want to have in addition of the original one. The caption box is very useful to show summary statistics. You can also take advantage of axis customization, by right clicking on the axis you want to customize, and then go into "Axis Settings", to add line, range, specify the X and Y ranges and modify them, specifying the intervals, ...

 

Please note that your cumulative sum of percentages is not equal to 100%, but to 101,02106%.

Hope this answer will help you,

Victor GUILLER
Scientific Expertise Engineer
L'Oréal - Data & Analytics