Do calculations for the lab report

profilekoe4mecxaniud
lab1_data.xlsx

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 ylsf
1 90 1 15.00 01:27.4 n
2 90 2 15.00 56.5 a
3 90 3 15.00 46.29 b
4 90 4 15.00 42.7
5 90 5 15.00 40.67
6 90 6 15.00 46.53 bias
7 90 7 15.00 35.1
8 90 8 15.00 32.65
sum xi yi xiyi xi^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 ylsf
1 180 2 15 01:23.6 n
2 180 4 15 1:00 a
3 180 6 15 48.17 b
4 180 8 15 40.79
5 180 10 15 37.28
6 180 12 15 33.98
7 180 14 15 30.72
8 180 16 15 29.4
sum xi yi xiyi xi^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 ylsf
1 90 1 15.00 65.2 n
2 90 2 15.00 49 a
3 90 3 15.00 41.9 b
4 90 4 15.00 39.5
5 90 5 15.00 35.7
6 90 6 15.00 33.1 bias
7 90 7 15.00 30.5
8 90 8 15.00
sum xi yi xiyi xi^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 ylsf
1 180 2 15 74.7 n
2 180 4 15 54 a
3 180 6 15 45.2 b
4 180 8 15 39.1
5 180 10 15 35.7
6 180 12 15 31.5
7 180 14 15 29.7
8 180 16 15
sum xi yi xiyi xi^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 ylsf
1 90 1 15.00 76 n
2 90 2 15.00 53 a
3 90 3 15.00 46 b
4 90 4 15.00 41
5 90 5 15.00 35
6 90 6 15.00 33 bias
7 90 7 15.00 32
8 90 8 15.00 29
sum xi yi xiyi xi^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 ylsf
1 180 2 15 83 n
2 180 4 15 57 a
3 180 6 15 47 b
4 180 8 15 42
5 180 10 15 37
6 180 12 15 33
7 180 14 15 31
8 180 16 15
sum xi yi xiyi xi^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 ylsf
1 90 1 15.00 71.55 n
2 90 2 15.00 50.52 a
3 90 3 15.00 44.84 b
4 90 4 15.00 40.78
5 90 5 15.00 36.82
6 90 6 15.00 34.18 bias
7 90 7 15.00 31.51
8 90 8 15.00 29.72
sum xi yi xiyi xi^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 ylsf
1 180 2 15 72.82 n
2 180 4 15 53.89 a
3 180 6 15 45.28 b
4 180 8 15 39.15
5 180 10 15 35.59
6 180 12 15 32.25
7 180 14 15 29.93
8 180 16 15
sum xi yi xiyi xi^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 ylsf
1 90 1 15.00 65 n
2 90 2 15.00 51 a
3 90 3 15.00 43 b
4 90 4 15.00 38
5 90 5 15.00 34
6 90 6 15.00 31 bias
7 90 7 15.00 28
8 90 8 15.00 27
sum xi yi xiyi xi^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 ylsf
1 180 2 15 72 n
2 180 4 15 52 a
3 180 6 15 42 b
4 180 8 15 37
5 180 10 15 33
6 180 12 15 30
7 180 14 15 28
8 180 16 15
sum xi yi xiyi xi^2