Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys.
I try to create my first boxplot and i have some issues.
The results of the measurements (sample) below:
Order | Mean value | Lower specif. limit | Upper specif. limit |
1 | 9,5 | 6,0 | 16,0 |
1 | 14,2 | 6,0 | 16,0 |
1 | 12,1 | 6,0 | 16,0 |
1 | 15,3 | 6,0 | 16,0 |
1 | 13,6 | 6,0 | 16,0 |
1 | 14,0 | 6,0 | 16,0 |
1 | 13,5 | 6,0 | 16,0 |
2 | 12,5 | 6,0 | 16,0 |
2 | 10,5 | 6,0 | 16,0 |
2 | 13,1 | 6,0 | 16,0 |
2 | 12,3 | 6,0 | 16,0 |
2 | 12,6 | 6,0 | 16,0 |
2 | 12,3 | 6,0 | 16,0 |
2 | 10,3 | 6,0 | 16,0 |
2 | 12,5 | 6,0 | 16,0 |
3 | 13,5 | 6,0 | 16,0 |
3 | 15,1 | 6,0 | 16,0 |
3 | 13,4 | 6,0 | 16,0 |
3 | 14,6 | 6,0 | 16,0 |
3 | 10,3 | 6,0 | 16,0 |
3 | 12,3 | 6,0 | 16,0 |
4 | 15,1 | 6,0 | 16,0 |
4 | 15,4 | 6,0 | 16,0 |
4 | 15,4 | 6,0 | 16,0 |
4 | 15,4 | 6,0 | 16,0 |
4 | 15,4 | 6,0 | 16,0 |
5 | 15,4 | 6,0 | 16,0 |
6 | 15,4 | 6,0 | 16,0 |
7 | 15,4 | 6,0 | 16,0 |
I want to create a box plot of the Mean values per Order with the limits at the table.
i can not figure out the expressions i must write
Best regards.
Hello guys. I have start built something.
Here is the new data :
P.O | Des | M.V | LSL | USL |
1 | γ | 9,5 | 6,0 | 16,0 |
1 | γ | 14,2 | 6,0 | 16,0 |
1 | γ | 12,1 | 6,0 | 16,0 |
1 | γ | 15,3 | 6,0 | 16,0 |
1 | γ | 13,6 | 6,0 | 16,0 |
1 | γ | 14,0 | 6,0 | 16,0 |
1 | γ | 13,5 | 6,0 | 16,0 |
1 | φ | 30,1 | 28,0 | 32,0 |
1 | φ | 30,2 | 28,0 | 32,0 |
1 | φ | 30,3 | 28,0 | 32,0 |
1 | φ | 30,4 | 28,0 | 32,0 |
1 | φ | 30,5 | 28,0 | 32,0 |
1 | φ | 30,6 | 28,0 | 32,0 |
1 | φ | 30,7 | 28,0 | 32,0 |
2 | γ | 12,5 | 6,0 | 16,0 |
2 | γ | 10,5 | 6,0 | 16,0 |
2 | γ | 13,1 | 6,0 | 16,0 |
2 | γ | 12,3 | 6,0 | 16,0 |
2 | γ | 12,6 | 6,0 | 16,0 |
2 | γ | 12,3 | 6,0 | 16,0 |
2 | γ | 10,3 | 6,0 | 16,0 |
2 | γ | 12,5 | 6,0 | 16,0 |
2 | φ | 31,1 | 28,0 | 32,0 |
2 | φ | 31,2 | 28,0 | 32,0 |
2 | φ | 31,3 | 28,0 | 32,0 |
2 | φ | 31,4 | 28,0 | 32,0 |
2 | φ | 31,5 | 28,0 | 32,0 |
2 | φ | 31,6 | 28,0 | 32,0 |
2 | φ | 31,7 | 28,0 | 32,0 |
3 | γ | 13,5 | 6,0 | 16,0 |
3 | γ | 15,1 | 6,0 | 16,0 |
3 | γ | 13,4 | 6,0 | 16,0 |
3 | γ | 14,6 | 6,0 | 16,0 |
3 | γ | 10,3 | 6,0 | 16,0 |
3 | γ | 12,3 | 6,0 | 16,0 |
3 | γ | 32,1 | 28,0 | 32,0 |
3 | φ | 31,2 | 28,0 | 32,0 |
3 | φ | 31,3 | 28,0 | 32,0 |
3 | φ | 31,4 | 28,0 | 32,0 |
3 | φ | 31,5 | 28,0 | 32,0 |
3 | φ | 31,6 | 28,0 | 32,0 |
3 | φ | 31,7 | 28,0 | 32,0 |
4 | γ | 15,1 | 6,0 | 16,0 |
4 | γ | 15,4 | 6,0 | 16,0 |
4 | γ | 15,4 | 6,0 | 16,0 |
4 | γ | 15,4 | 6,0 | 16,0 |
4 | γ | 15,4 | 6,0 | 16,0 |
For the reference :
Y axis: the measurements
X axis : P.O per γ (Des)
According to box plot wizard i have create the below chart
Expressions:
Box Plot Middle
Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.5)
Box Plot Bottom
Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.25)
and etc.
The problem is that in current state the box plate takes all the values from Des.
I want to create two separates box plots one for γ & one for φ.
i have try to add the If function but with no results.
Box Plot Middle
If(Des='φ',Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.5))
Box Plot Bottom
If(Des='φ',Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.25))
Any ideas?
Best regards.
Maybe better