2. Using Excel, make a graph of the following data. Plot Mass vs. Volume for the following data on the same graph. Use a linear fit of each set of data and include the equation of the best fit line (2 fits and 2 equations, making sure you can tell which equation is for which set of data). Submit your graph and answer the three questions below. Volume (ml) 5.00 10.00 15.00 20.00 30.00 Mass of Al (g) 43.195 56.053 70.961 82.499 108.988 Mass of Zr (g) 63.797 94.708 127.933 158.580 227.037 For both straight lines, the slope is essentially equal to the density of the element. The y-intercept is equal to the mass of the beaker that held the substance. Answer the following questions. a) For each element, what is the density (slope)? What is the mass of the beaker (y-intercept)? Be sure to include units. b) If you have 120.000 g of Al and beaker, what is the volume? $24.0 c) When the volume of Zr is 25.00 mL, what is the mass?

Introductory Chemistry: An Active Learning Approach
6th Edition
ISBN:9781305079250
Author:Mark S. Cracolice, Ed Peters
Publisher:Mark S. Cracolice, Ed Peters
Chapter3: Measurement And Chemical Calculations
Section: Chapter Questions
Problem 99E
icon
Related questions
Question
2. Using Excel, make a graph of the following data. Plot Mass vs. Volume for the following data on the
same graph. Use a linear fit of each set of data and include the equation of the best fit line (2 fits and 2
equations, making sure you can tell which equation is for which set of data). Submit your graph and
answer the three questions below.
Volume (ml)
5.00
10.00
15.00
20.00
30.00
Mass of Al (g)
43.195
56.053
70.961
82.499
108.988
Mass of Zr (g)
63.797
94.708
127.933
158.580
227.037
For both straight lines, the slope is essentially equal to the density of the element. The y-intercept is
equal to the mass of the beaker that held the substance. Answer the following questions.
a) For each element, what is the density (slope)? What is the mass of the beaker (y-intercept)?
Be sure to include units.
b) If you have 120.000 g of Al and beaker, what is the volume?
21.⁰
c) When the volume of Zr is 25.00 mL, what is the mass?
Transcribed Image Text:2. Using Excel, make a graph of the following data. Plot Mass vs. Volume for the following data on the same graph. Use a linear fit of each set of data and include the equation of the best fit line (2 fits and 2 equations, making sure you can tell which equation is for which set of data). Submit your graph and answer the three questions below. Volume (ml) 5.00 10.00 15.00 20.00 30.00 Mass of Al (g) 43.195 56.053 70.961 82.499 108.988 Mass of Zr (g) 63.797 94.708 127.933 158.580 227.037 For both straight lines, the slope is essentially equal to the density of the element. The y-intercept is equal to the mass of the beaker that held the substance. Answer the following questions. a) For each element, what is the density (slope)? What is the mass of the beaker (y-intercept)? Be sure to include units. b) If you have 120.000 g of Al and beaker, what is the volume? 21.⁰ c) When the volume of Zr is 25.00 mL, what is the mass?
Expert Solution
steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Knowledge Booster
Tools in Analytical Chemistry
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Introductory Chemistry: An Active Learning Approa…
Introductory Chemistry: An Active Learning Approa…
Chemistry
ISBN:
9781305079250
Author:
Mark S. Cracolice, Ed Peters
Publisher:
Cengage Learning
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage
Chemistry In Focus
Chemistry In Focus
Chemistry
ISBN:
9781337399692
Author:
Tro, Nivaldo J.
Publisher:
Cengage Learning,
Pushing Electrons
Pushing Electrons
Chemistry
ISBN:
9781133951889
Author:
Weeks, Daniel P.
Publisher:
Cengage Learning