Do calculations for the lab report

profilekoe4mecxaniud
lab1_data_w_calcs.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>Do calculations for the lab report

Group A

Group A gamma
density 996.5 kg/m^3
Area 0.0000785 m^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) = liters/ s 1000 u(m/s) U0(m/s) mdot*U0 Fexp = 4gx Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 90 1 15.00 87.4 1.72E-04 2.186 2.023 0.3460550574 0.392 0.346 n
2 90 2 15.00 56.5 2.65E-04 3.382 3.279 0.867500629 0.784 0.868 a
3 90 3 15.00 46.29 3.24E-04 4.128 4.044 1.3058630572 1.175 1.306 b
4 90 4 15.00 42.7 3.51E-04 4.475 4.398 1.539463347 1.567 1.539
5 90 5 15.00 40.67 3.69E-04 4.698 4.625 1.6997700128 1.959 1.700
6 90 6 15.00 46.53 3.22E-04 4.107 4.022 1.2921449234 2.351 1.292 bias
7 90 7 15.00 35.1 4.27E-04 5.444 5.381 2.2913591107 2.743 2.291
8 90 8 15.00 32.65 4.59E-04 5.852 5.794 2.6523619675 3.134 2.652
sum xi yi xiyi xi^2 yi^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) u(m/s) U0(m/s) mdot*U0 Fexp Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 180 2 15 83.6 1.79E-04 2.286 2.130 0.3809141397 0.784 0.762 n
2 180 4 15 60 2.50E-04 3.185 3.075 0.7661049164 1.567 1.532 a
3 180 6 15 48.17 3.11E-04 3.967 3.879 1.2038237222 2.351 2.408 b
4 180 8 15 40.79 3.68E-04 4.685 4.611 1.6896235555 3.134 3.379
5 180 10 15 37.28 4.02E-04 5.126 5.058 2.0281306774 3.918 4.056
6 180 12 15 33.98 4.41E-04 5.623 5.562 2.4467148808 4.702 4.893
7 180 14 15 30.72 4.88E-04 6.220 6.165 2.9996117757 5.485 5.999
8 180 16 15 29.4
sum xi yi xiyi xi^2 yi^2

Group B

Group B gamma 9777
density 998.1623277182 kg/m^3
Area 0.0000785 m^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) = liters/ s 1000 u(m/s) U0(m/s) mdot*U0 Fexp = 4gx Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 90 1 15.00 65.2 2.30E-04 2.931 2.811 0.6455849324 0.392 0.646 n
2 90 2 15.00 49 3.06E-04 3.900 3.811 1.1644042362 0.784 1.164 a
3 90 3 15.00 41.9 3.58E-04 4.560 4.485 1.6025312347 1.175 1.603 b
4 90 4 15.00 39.5 3.80E-04 4.838 4.766 1.8066023607 1.567 1.807
5 90 5 15.00 35.7 4.20E-04 5.352 5.288 2.2177747597 1.959 2.218
6 90 6 15.00 33.1 4.53E-04 5.773 5.713 2.5843057834 2.351 2.584 bias
7 90 7 15.00 30.5 4.92E-04 6.265 6.210 3.0485096157 2.743 3.049
8 90 8 15.00
sum xi yi xiyi xi^2 yi^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) u(m/s) U0(m/s) mdot*U0 Fexp Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 180 2 15 74.7 2.01E-04 2.558 2.420 0.4851057564 0.784 0.970 n
2 180 4 15 54 2.78E-04 3.539 3.440 0.9538894476 1.567 1.908 a
3 180 6 15 45.2 3.32E-04 4.227 4.146 1.3732268255 2.351 2.746 b
4 180 8 15 39.1 3.84E-04 4.887 4.816 1.8443157782 3.134 3.689
5 180 10 15 35.7 4.20E-04 5.352 5.288 2.2177747597 3.918 4.436
6 180 12 15 31.5 4.76E-04 6.066 6.009 2.8563319413 4.702 5.713
7 180 14 15 29.7 5.05E-04 6.434 6.380 3.2164301922 5.485 6.433
8 180 16 15
sum xi yi xiyi xi^2 yi^2

Group C

Group C gamma 9776
density 998.0602348137 kg/m^3
Area 0.0000785 m^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) = liters/ s 1000 u(m/s) U0(m/s) mdot*U0 Fexp = 4gx Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 90 1 15.00 76 1.97E-04 2.514 2.374 0.4676401814 0.392 0.468 n
2 90 2 15.00 53 2.83E-04 3.605 3.509 0.9911753675 0.784 0.991 a
3 90 3 15.00 46 3.26E-04 4.154 4.071 1.3247973932 1.175 1.325 b
4 90 4 15.00 41 3.66E-04 4.661 4.586 1.6746991252 1.567 1.675
5 90 5 15.00 35 4.29E-04 5.460 5.396 2.3082349478 1.959 2.308
6 90 6 15.00 33 4.55E-04 5.790 5.731 2.5998907743 2.351 2.600 bias
7 90 7 15.00 32 4.69E-04 5.971 5.914 2.7666450247 2.743 2.767
8 90 8 15.00 29 5.17E-04 6.589 6.537 3.3745581639 3.134 3.375
sum xi yi xiyi xi^2 yi^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) u(m/s) U0(m/s) mdot*U0 Fexp Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 180 2 15 83 1.81E-04 2.302 2.148 0.3874642066 0.784 0.775 n
2 180 4 15 57 2.63E-04 3.352 3.248 0.8531985869 1.567 1.706 a
3 180 6 15 47 3.19E-04 4.066 3.980 1.2678682785 2.351 2.536 b
4 180 8 15 42 3.57E-04 4.550 4.474 1.5946161745 3.134 3.189
5 180 10 15 37 4.05E-04 5.164 5.098 2.062580025 3.918 4.125
6 180 12 15 33 4.55E-04 5.790 5.731 2.5998907743 4.702 5.200
7 180 14 15 31 4.84E-04 6.164 6.108 2.9497946413 5.485 5.900
8 180 16 15
sum xi yi xiyi xi^2 yi^2

Group D

Group D gamma 9785.5
density 999.0301174068 kg/m^3
Area 0.0000785 m^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) = liters/ s 1000 u(m/s) U0(m/s) mdot*U0 Fexp = 4gx Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 90 1 15.00 71.55 2.10E-04 2.671 2.539 0.5317703387 0.392 0.532 n
2 90 2 15.00 50.52 2.97E-04 3.782 3.691 1.0947116484 0.784 1.095 a
3 90 3 15.00 44.84 3.35E-04 4.261 4.180 1.3970204128 1.175 1.397 b
4 90 4 15.00 40.78 3.68E-04 4.686 4.612 1.6947577734 1.567 1.695
5 90 5 15.00 36.82 4.07E-04 5.190 5.123 2.0850867134 1.959 2.085
6 90 6 15.00 34.18 4.39E-04 5.590 5.529 2.4239878975 2.351 2.424 bias
7 90 7 15.00 31.51 4.76E-04 6.064 6.007 2.85698372 2.743 2.857
8 90 8 15.00 29.72 5.05E-04 6.429 6.376 3.2148587561 3.134 3.215
sum xi yi xiyi xi^2 yi^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) u(m/s) U0(m/s) mdot*U0 Fexp Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 180 2 15 72.82 2.06E-04 2.624 2.490 0.512404925 0.784 1.025 n
2 180 4 15 53.89 2.78E-04 3.546 3.448 0.9587332598 1.567 1.917 a
3 180 6 15 45.28 3.31E-04 4.220 4.138 1.3694715749 2.351 2.739 b
4 180 8 15 39.15 3.83E-04 4.881 4.810 1.8411375844 3.134 3.682
5 180 10 15 35.59 4.21E-04 5.369 5.305 2.2336136613 3.918 4.467
6 180 12 15 32.25 4.65E-04 5.925 5.867 2.7261452737 4.702 5.452
7 180 14 15 29.93 5.01E-04 6.384 6.330 3.169524599 5.485 6.339
8 180 16 15
sum xi yi xiyi xi^2 yi^2

Group E

Group E gamma 9781
density 998.5706993364 kg/m^3
Area 0.0000785 m^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) = liters/ s 1000 u(m/s) U0(m/s) mdot*U0 Fexp = 4gx Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 90 1 15.00 65 2.31E-04 2.940 2.821 0.6500022672 0.392 0.650 n
2 90 2 15.00 51 2.94E-04 3.747 3.654 1.0731921847 0.784 1.073 a
3 90 3 15.00 43 3.49E-04 4.444 4.366 1.5208315957 1.175 1.521 b
4 90 4 15.00 38 3.95E-04 5.028 4.960 1.95503711 1.567 1.955
5 90 5 15.00 34 4.41E-04 5.620 5.559 2.4488835104 1.959 2.449
6 90 6 15.00 31 4.84E-04 6.164 6.108 2.9513033334 2.351 2.951 bias
7 90 7 15.00 28 5.36E-04 6.824 6.774 3.6237226154 2.743 3.624
8 90 8 15.00 27 5.56E-04 7.077 7.029 3.89915936 3.134 3.899
sum xi yi xiyi xi^2 yi^2
Run # Deflector Plate Moment Arm (cm) Volume (ltrs) Time (sec) Q(m^3/s) u(m/s) U0(m/s) mdot*U0 Fexp Ftheory xi yi xiyi xi^2 yi^2 ylsf
1 180 2 15 72 2.08E-04 2.654 2.521 0.5245501439 0.784 1.049 n
2 180 4 15 52 2.88E-04 3.675 3.580 1.0312623151 1.567 2.063 a
3 180 6 15 42 3.57E-04 4.550 4.474 1.5954317515 2.351 3.191 b
4 180 8 15 37 4.05E-04 5.164 5.098 2.0636349452 3.134 4.127
5 180 10 15 33 4.55E-04 5.790 5.731 2.6012205057 3.918 5.202
6 180 12 15 30 5.00E-04 6.369 6.315 3.153173652 4.702 6.306
7 180 14 15 28 5.36E-04 6.824 6.774 3.6237226154 5.485 7.247
8 180 16 15
sum xi yi xiyi xi^2 yi^2