1510, LAB 2, LAST NAME, FIRST NAME (1)
xlsx
keyboard_arrow_up
School
Ohio University, Main Campus *
*We aren’t endorsed by this school
Course
1510
Subject
Aerospace Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
19
Uploaded by SuperFreedom12669
Lab 2, How To Make A
Cell Colors
All calculations mu
NAME:
Cade Sa
X
Part 1. Den
Table 1. Density of metal by dimension measurement using ruler.
Diameter (mm)
Heigth (mm)
Radius (cm)
1
1
12.1
10.2
0.605
1
1
12.0
15.4
0.600
1
1
11.8
20.5
0.590
1
1
12.4
25.3
0.620
2
2
2
2
Table 2. Density of metal by dimension measurement using digital calip
Diameter (mm)
Heigth (mm)
Radius (cm)
1
1
12.1
10.2
0.605
1
1
12.0
15.4
0.600
1
1
11.8
20.5
0.590
1
1
12.4
25.3
0.620
2
2
2
2
Table 3. Density of metal by immersion using 100 mL graduated cylinde
mL before
mL after
Sample volume (mL)
1
1
1.01450
1
1
1.05400
1
1
1.03400
1
1
1.04700
2
2
2
2
Table 4. Density from specific gravity.
Specific Gravity
Temperature (
)
℃
5
5
Solvent A
0.72
5
5
Solvent B
0.95
This area is for TA only.
INPUT RAW DATA/ANSWERS TO QUESTIONS
INPUT CALCULATED VALUES, NO ROUNDING NECESSARY
INPUT CALCULATED VALUES, CORRECTLY ROUNDED OFF
Point of row
Your Point
PLACE GRAPH IN THIS AREA
By checking the box with an X on the left side, I
Failure to sign this declaration will cost you 10%
Part 2. Density of
WATER
Table 5. Volume and mass of water.
Volume (mL)
Mass (g)
Density (g/mL)
0.00
0.0000
Not Applicable
0.5
0.5
1.00
1.0370
1.037
0.5
0.5
2.00
2.0880
1.044
0.5
0.5
3.00
3.1290
1.043
0.5
0.5
4.00
4.1680
1.042
0.5
0.5
5.00
5.2060
1.0412
0.5
0.5
6.00
6.2430
1.0405
0.5
0.5
7.00
7.2790
1.03985714285714
0.5
0.5
8.00
8.3140
1.03925
0.5
0.5
9.00
9.3560
1.03955555555556
0.5
0.5
10.00
10.3950
1.0395
2
2
Average of Density
1.041
2
2
Std of Density
0.002
1
1
Value of t for 95% CI
2.262
4
4
Density
1.041
5
5
Table 6. Linest output without setting y intercept (b) to 0.
3
3
m
0.962344106341828
-0.005501640395246 b
0.000452899197345
0.00278641828535
0.999998006648148
0.004935908153309
4514999.22223909
9
109.999780731296
0.000219268703681
1
1
Value of t for 95% CI
2.262
4
4
m
0.962344106341828
0.001024457984393
± ts
m
s
m
s
b
R
2
± ts
m
SUGAR/NaCl Solution
Mass of sugar 0.020
Mass of NaCl 30.000
Mass of water 30.000
% m/m sugar (aq). Your actual value 10
Table 7. Volume and mass of the solution
Volume (mL)
Mass (g)
Density (g/mL)
0.00
0.0000
Not Applicable
0.5
0.5
1.00
1.0370
1.037
0.5
0.5
2.00
2.0880
1.044
0.5
0.5
3.00
3.1290
1.043
0.5
0.5
4.00
4.1680
1.042
0.5
0.5
5.00
5.2060
1.0412
0.5
0.5
6.00
6.2430
1.0405
0.5
0.5
7.00
7.2790
1.03985714285714
0.5
0.5
8.00
8.3140
1.03925
0.5
0.5
9.00
9.3560
1.03955555555556
0.5
0.5
10.00
10.3950
1.0395
2
2
Average of Density
1.041
2
2
Std of Density
0.002
1
1
Value of t for 95% CI
2.262
4
4
Density
1.041
5
5
Table 8. Linest output without setting y intercept (b) to 0.
3
3
m
0.962344106341828
-0.005501640395246 b
0.000452899197345
0.00278641828535
0.999998006648148
0.004935908153309
4514999.22223909
9
109.999780731296
0.000219268703681
1
1
Value of t for 95% CI
2.262
4
4
m
1.041
0.005
± ts
m
s
m
s
b
R
2
± ts
m
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Po
Q1.
3
3
Q2.
3
3
3
3
Considering the two measured parameters (h a
the two parameters exerts a bigger influence on
reasoning.
A: The diameter exerts a bigger influence on the
squared in the formula for the volume of a cylind
if both the diameter and height equal 8, the equ
alone would equal 25.13, which is less than 1608
Compare and discuss the three approaches (rule
deviation?
A: The immersion method had the largest standa
measurements and that means it's the least accu
during the experiment, however the caliperwas measurements from the ruler were based on my
Considering the solution that you prepared (10.0 % m/m sugar(aq) and 3.
The % m/m chloride The % Total Dissolved Solids (TDS)
5
5
25
25
THESE ARE YOUR POINTS FROM THE HARDS COPY TOTAL POINTS:
127
POINTS POSSIBLE: 127
What mass of NaCl can be expected from 1.53 gallons of the solution? To
And Report Scientific Measurements
ust be performed only by excel's formula
aunders
Email:
nsity of Metal and Solutions
Height (cm)
Mass (g)
1.210
1.3915611655
3.484
2.50366285462427
1.200
1.357344
5.220
3.84574580946319
1.180
1.290601636
6.721
5.20764875274031
1.240
1.497653152
8.743
5.83780028661803
Average of Density
4.349
Std of Density
1.485
per.
Height (cm)
Mass (g)
1.210
1.3915611655
3.484
2.50366285462427
1.200
1.357344
5.220
3.84574580946319
1.180
1.290601636
6.721
5.20764875274031
1.240
1.497653152
8.743
5.83780028661803
Average of Density
4.349
Std of Density
1.485
er.
Mass (g)
0.985
0.970921636274027
1.056
1.00189753320683
1.032
0.998065764023211
1.024
0.97803247373448
Average of Density
0.987229351809637
Std of Density
0.015089814749064
Density of Water at same Temperature (g/mL)
Density (g/mL)
0.9887
0.711864
0.8777
0.833815
Save this file as 1510, Lab #, Last name, first name.xlsx, then go to blackboard and submit: Data Analysis --> Lab #: xxxx --> Browse for Local File --> Submit --> Ok
Rounding Rule: Round STD to 1 significant figure and round the mean to the same number of decimal places. It may be necessary to use the scientific notation if STD>1. How to: Highlight cell -> Right click -> Format Cell -> Number -> Scientific -> Change decimal places.
cs587222@ohio.edu
I certify that I have not falsified data and that I have not plagiarized any part of this lab report. % points. Volume (cm
3
)
Density (g/cm
3
)
Volume (cm
3
)
Density (g/cm
3
)
Density (g/cm
3
)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
f Water and Density of a Solution
0.005
(5 pts) Place plot of mass versus volume
Adjust size so it fits in this box.
g
g
g
%
0.005
(5 pts) Place plot of mass versus volume
.
Adjust size so it fits in this box.
ost-Lab Questions
and d) and considering the formula for calculating the volume, which of n the accuracy of the measurement, diameter or height? Explain your e accuracy. Even though the diameter is halved the radius, it's then der. Height is multiplied by everything else in the formula. For example, uation would be: pi*(8^2)*8 which equals 1608.5. In the equation, pi(8) 8.5. So overall, diameter has a greater influence than height.
ler, caliper and immersion). Explain the differences in standard ard deviation, meaning that it caused the most variation in urate. The measurements from the caliper and ruler were the same able to make more exact measurements than the ruler because the y opinion and caliper's technology determined the measurements itself.
.00% m/m NaCl(aq)), Calculate
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
TA feedback
get full points, implement dimensional analysis fully. (1 gallon = 3.78 L, density of solution is 1.049 g/mL
This area is for TA only.
=E19*(1/2)*(1/10)=E19*(1/10)
=3.142*(G19^2)*(H19)
=E20*(1/2)*(1/10)=E20*(1/10)
=3.142*(G20^2)*(H20)
=E21*(1/2)*(1/10)=E21*(1/10)
=3.142*(G21^2)*(H21)
=E22*(1/2)*(1/10)=E22*(1/10)
=3.142*(G22^2)*(H22)
=E27*(1/2)*(1/10)=E27*(1/10)
=3.142*(G27^2)*(H27)
=E28*(1/2)*(1/10)=E28*(1/10)
=3.142*(G28^2)*(H28)
=E29*(1/2)*(1/10)=E29*(1/10)
=3.142*(G29^2)*(H29)
=E30*(1/2)*(1/10)=E30*(1/10)
=3.142*(G30^2)*(H30)
#N/A
=H35/G35
#N/A
=H36/G36
#N/A
=H37/G37
#N/A
=H38/G38
=AVERAGE(I35:I38)
=STDEV(I35:I38)
=F44*H44
=F45*H45
Excel Help:
Help for excel 2007 and up (xlsx)
=F57/E57
=F58/E58
=F59/E59
=F60/E60
=F61/E61
=F62/E62
=F63/E63
=F64/E64
=F65/E65
=F66/E66
=AVERAGE(G57:G66)
=STDEV(G57:G66)
=G67
=G70*G68
{=LINEST(E56:E66,F{=LINEST(E56:E66,F56:F66,1,1)}
{=LINEST(E56:E66,F{=LINEST(E56:E66,F56:F66,1,1)}
{=LINEST(E56:E66,F{=LINEST(E56:E66,F56:F66,1,1)}
=E76
=F81*E77
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
=F106/E106
=F107/E107
=F108/E108
=F109/E109
=F110/E110
=F111/E111
=F112/E112
=F113/E113
=F114/E114
=F115/E115
=AVERAGE(G106:G115)
=STDEV(G106:G115)
=G116
=G119*G117
{=LINEST(E105:E11
{=LINEST(E105:E115,F105:F115,1,1)}
{=LINEST(E105:E11
{=LINEST(E105:E115,F105:F115,1,1)}
{=LINEST(E105:E11
{=LINEST(E105:E115,F105:F115,1,1)}
=G116
=F130*G117
=SUM(B:B)
=SUM(A:A)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
=(J19/I19)
=(J20/I20)
=(J21/I21)
=(J22/I22)
=AVERAGE(K19:K22)
=STDEV(K19:K22)
=J27/I27
=J28/I28
=J29/I29
=J30/I30
=AVERAGE(K27:K30)
=STDEV(K27:K30)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help