Chem R-5
docx
keyboard_arrow_up
School
The University of Oklahoma *
*We aren’t endorsed by this school
Course
1415
Subject
Mathematics
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by DeaconTreeMagpie37
Recitation: Submit this worksheet Name: Megan Salyer Recitation (R5): Graphing and Analysis: Worksheet
Exercise 1:
Using the graph of mass and volume (Sheet 1 of the excel sheet) and the best fit line equation, answer the following on this worksheet
: Please attach your graph for Sheet 1 here (copy and paste from excel)
.
0
200
400
600
800
1000
1200
1400
1600
0.00
20.00
40.00
60.00
80.00
100.00
120.00
140.00
160.00
180.00
f(x) = 0.11 x
R² = 1
Mass & Volume
Mass (g)
Volume (cm3) a.
In a visual inspection of the line and data, how confident are you in your ability to make predictions from this data? Explain how you reached this conclusion in a complete sentence. I am very confident in my ability to make predictions from this data because the value is completely linear with an r-squared value equal to exactly one. This means that the mass and volume have a linear relationship making it very easy to predict future values. b.
Given your graph, identify what mass you would expect if the volume is 200 cm
3
? (Extrapolate the line to make this prediction.)
If the volume was 200 cm
3
, I would expect the mass to be 1784.12 grams. c.
What is the density of this metal? (Density is the slope of the line.)
The density of this metal is 8.9206 grams/cm
3
.
d.
Consider the error associated with the data point (165, 1473), the highest data point on the graph. What is the range* of ‘acceptable’ values for the volume and for the mass if you were to do the experiment again?
i.
Volume = 156.75 cm
3
– 173.25 cm
3
ii.
Mass = 1669.35 g – 1816.65 g
*Range includes lowest to highest values. For example, if the value is 10.0 cm and acceptable error is 5%, then 9.5-10.5 cm would be the range.
1
Recitation: Submit this worksheet Name: Megan Salyer Exercise 2: S
ubmit your properly labeled graph
of mass v. heat (Sheet 2 of your excel spreadsheet) and answer accompanying questions.
I. Label the graph with a Title and the axes names, including the units. Be sure to include the error bars. Insert (copy and paste from excel) here:
2
2.5
3
3.5
4
4.5
5
5.5
0
500
1000
1500
2000
2500
3000
3500
f(x) = 490.31 x
R² = 0.96
Mass of KOH vs. Heat
Mass of KOH (g)
Heat (J)
II. Using the graph and the best fit line equation, answer the following on this worksheet, : a.
From a visual inspection: How confident are you in the equation of the line? After looking at the graph, I am not very confident in the equation of the line as it is not completely linear and there is an r
2
value of .9647. b.
Would you call this class data precise? Explain
I would not call this data very precise as there are not any data points on the trendline and there are many masses of KOH that account for the same heat values. c.
Do you know whether the line and the equation of the line are accurate representations? I think that the line and the equation of the line are not accurate representations as there are large error bars. If the error bars were smaller, I would trust that the equation and line were more accurate. d.
Do you think the error bars generated by Excel represent the precision or the accuracy?
I think that the error bars generated by Excel represent precision because it shows how far away the observed value is from the expected. 2
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