Pressure and Weight in Cryogenic Flow Meters
In the following data pairs
X = pressure (lb/sq in) of liquid nitrogen
Y = weight in pounds of liquid nitrogen passing through flow meter each second
Reference: Technometrics, Vol. 19, p353-379
X Y Population Of Interst
75.1 577.8 All of the measured pressure of liquid nitrogen and weight passing through a flow m
74.3 577
88.7 570.9 Representative Sample
114.6 578.6 Consists of 30 measurments, for pressure of liquid nitrogen and the weight of liquid
98.5 572.4
112 411.2 This chart isn't available in your version of Excel.
114.8 531.7
62.2 563.9 Editing this shape or saving this workbook into a different file format will permanently break
107 406.7 chart.
90.5 507.1
73.8 496.4
115.8 505.2
99.4 506.4
93 510.2
73.9 503.9
65.7 506.2
66.2 506.3
77.9 510.2
109.8 508.6
105.4 510.9
88.6 505.4
89.6 512.8
73.8 502.8
101.3 493
120 510.8
75.9 512.8
76.2 513.4
81.9 510
84.3 504.3
98 522
ght passing through a flow meter .
gen and the weight of liquid nitrogen passing through a flow meter.
Shape
The graph is symmetrically distributed because both sides
rmat will permanently break the of the graph are approximately the same
Probability of data being in the highest column
0.1666667
Probability of data being in the smallest column
0.1333333
Probability of data falling in the largest or the smallest column
0.3
Bins Frequency Relative Frequency
62-69 3 0.1 Frequency P
69-75 4 0.1333333333
75-81 4 0.1333333333 13.33% 10.00
81-88 2 0.0666666667
88-94 5 0.1666666667 6.67%
94-101 3 0.1
101-107 3 0.1
107-114 10.00%
2 0.0666666667
114-120 4 0.1333333333
10.00%
6.
16.67%
X Axis Y Axis
Mean 90.2733333333 Mean 514.9633 X
Standard Error 3.1012193869 Standard Error 7.218088 Y
Median 89.15 Median 510.1
Mode 73.8 Mode 510.2
Standard Deviation 16.9860781399 Standard Deviation 39.5351
Sample Variance 288.5268505747 Sample Variance 1563.024 X
Kurtosis -1.1886413206 Kurtosis 2.341169 Y
Skewness 0.1565014272 Skewness -0.70623
Range 57.8 Range 171.9
Minimum 62.2 Minimum 406.7
Maximum 120 Maximum 578.6
Sum 2708.2 Sum 15448.9
Count 30 Count 30
X Y
Frequency Pie Chart 75.1 577.8
74.3 577
13.33% 10.00% 88.7 570.9
62-69
69-75
114.6 578.6
6.67% 13.33% 75-81 98.5 572.4
81-88 112 411.2
88-94 114.8 531.7
10.00% 94-101
101-107 62.2 563.9
107-114 107 406.7
13.33%
114-120 90.5 507.1
10.00% 73.8 496.4
6.67% 115.8 505.2
16.67% 99.4 506.4
93 510.2
73.9 503.9
Five Number Summary 65.7 506.2
Min Max Median Q1 Q3 66.2 506.3
62.2 120 89.15 75.3 104.375 77.9 510.2
406.7 578.6 510.1 505.25 519.85 109.8 508.6
105.4 510.9
88.6 505.4
Range Standard Deviation 89.6 512.8
57.8 16.9860781399 73.8 502.8
171.9 39.5350955685 101.3 493
120 510.8
75.9 512.8
76.2 513.4
81.9 510
84.3 504.3
98 522
X Y
75.1 577.8
74.3 577 This chart isn't available in your version of Excel.
88.7 570.9
114.6 578.6 Editing this shape or saving this workbook into a different file format will
98.5 572.4 permanently break the chart.
112 411.2
114.8 531.7
62.2 563.9
107 406.7
90.5 507.1
73.8 496.4
115.8 505.2
99.4 506.4
93 510.2
73.9 503.9
65.7 506.2
66.2 506.3
77.9 510.2
109.8 508.6
105.4 510.9
88.6 505.4
89.6 512.8
73.8 502.8
101.3 493
120 510.8
75.9 512.8
76.2 513.4
81.9 510
84.3 504.3
98 522
This chart isn't available in your version of Excel.
at will Editing this shape or saving this workbook into a different file format will permanently
break the chart.
Pressure and Weight in Cryogenic Flow Meters
In the following data pairs
X = pressure (lb/sq in) of liquid nitrogen
Y = weight in pounds of liquid nitrogen passing through flow meter each second
Reference: Technometrics, Vol. 19, p353-379
X Y 95% Confidence Interval
75.1 577.8 95% Confidence Level Lower Upper
74.3 577 83.93063 96.61603915
88.7 570.9 Mean 90.27333
114.6 578.6 Standard Error 3.101219
98.5 572.4 Median 89.15 90% Confidence Interval
112 411.2 Mode 73.8 Lower Upper
114.8 531.7 Standard Deviation 16.98608 85.00397 95.542699009
62.2 563.9 Sample Variance 288.5269
107 406.7 Kurtosis -1.18864
90.5 507.1 Skewness 0.156501 Interpretation for 95%
73.8 496.4 Range 57.8 Approximately 95% of samples will contain the
115.8 505.2 Minimum 62.2
99.4 506.4 Maximum 120
93 510.2 Sum 2708.2
73.9 503.9 Count 30 Interpretation for 90 %
65.7 506.2 Confidence Level(95.0%) 6.342706 The mean will be within the confidence interval
66.2 506.3
77.9 510.2 90% Confidence Level
109.8 508.6
105.4 510.9 Mean 90.27333
88.6 505.4 Standard Error 3.101219
89.6 512.8 Median 89.15
73.8 502.8 Mode 73.8
101.3 493 Standard Deviation 16.98608
120 510.8 Sample Variance 288.5269
75.9 512.8 Kurtosis -1.18864
76.2 513.4 Skewness 0.156501
81.9 510 Range 57.8
84.3 504.3 Minimum 62.2
98 522 Maximum 120
Sum 2708.2
Count 30
Confidence Level(90.0%) 5.269366
Margin of Error for 95%
6.078278
Margin of Error for 90%
5.101052
y 95% of samples will contain the mean , even if it's large number of samples.
be within the confidence interval of a large number of samples, for about 90% of them.
Scatter Plot
700
600
500 f(x) = - 0.5418630733x + 563.8791191688
R² = 0.0542000592
400
300
200
100
0
50 60 70 80 90 100 110 120 130
Step 7. As the pressure of liquid nitrogen increases (x), the weight of it passing through a flow meter decreases (y)
The reason why this conclusion can be made is because the graph depicts a negative linear correlation with it's tre
R= 0.232809
n= 30
α= 0.05
Critical value= 0.364
There is not enough evidence to conclude that the correlation is significant at α=0.05 because R=0.233<
120 130
ough a flow meter decreases (y).
ve linear correlation with it's trend line and equatio
α=0.05 because R=0.233<0.364
