The enthalpy of vaporization (AHvap) is determined from the Clausius-Clapeyron equation: In VP = (-AHvap/R)(1/T) + C (Note: the form of this equation is linear: y = mx + b) Use a Google Sheets to calculate the values for the x and y axis from the data given below and to plot the natural log of vapor pressure (In VP) versus the inverse temperature in Kelvin (1/T). Trial # T(K) VP(mmHg) 1 298.2 116.2 301.1 138.7 305.1 174.2 308.4 205.7 310.8 229.6 313.3 269.5 2 3 14 5 16 Paste the data table into your spreadsheet so that Trial # is in cell A1. A new column is inserted on the spreadsheet between the T(K) and VP(mmHg) columns for the 1/T calculation. What formula to calculate 1/T is typed into the cell directly to the right of 298.2 (cell C2)? =1/B2 How is the calculation completed for Trials 2-6? In column E, calculate In VP. • What formula to calculate In VP is typed into the cell directly to the right of 116.2 (cell E2)? =In(D2) Click on C2, grab square on bv How is the calculation completed for Trials 2-6? Click on E2, grab square on bc

Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
icon
Related questions
Question
Paste the data table into your spreadsheet so that Trial # is in cell A1.
A new column is inserted on the spreadsheet between the T(K) and VP(mmHg) columns for the 1/T
calculation.
What formula to calculate 1/T is typed into the cell directly to the right of 298.2 (cell C2)?
= 1/B2
3
In column E, calculate In VP.
• What formula to calculate In VP is typed into the cell directly to the right of 116.2 (cell E2)?
=In(D2)
#
How is the calculation completed for Trials 2-6? Click on C2, grab square on bv
Plot column C vs column E.
LL
How is the calculation completed for Trials 2-6?
F
The chart type should be Scatter chart. Change if it is something different. In the Chart editor click
on Customize, choose Series. Check the boxes next to Trendline and R2. Under Label change
Custom to Use Equation.
• After highlighting both columns, what is the next step? Both of these
What is the value of the slope? 5100.1
• If the value of R is 8.3145 J/molk, what is the value of AHvap? 42.4
kJ/mol
80
F3
$
4
R
000
000
F4
%
5
Click on E2, grab square on bc v
F5
6
MacBook Air
F6
&
7
F7
8
DII
F8
9
D
F9
>
0
F10
Transcribed Image Text:Paste the data table into your spreadsheet so that Trial # is in cell A1. A new column is inserted on the spreadsheet between the T(K) and VP(mmHg) columns for the 1/T calculation. What formula to calculate 1/T is typed into the cell directly to the right of 298.2 (cell C2)? = 1/B2 3 In column E, calculate In VP. • What formula to calculate In VP is typed into the cell directly to the right of 116.2 (cell E2)? =In(D2) # How is the calculation completed for Trials 2-6? Click on C2, grab square on bv Plot column C vs column E. LL How is the calculation completed for Trials 2-6? F The chart type should be Scatter chart. Change if it is something different. In the Chart editor click on Customize, choose Series. Check the boxes next to Trendline and R2. Under Label change Custom to Use Equation. • After highlighting both columns, what is the next step? Both of these What is the value of the slope? 5100.1 • If the value of R is 8.3145 J/molk, what is the value of AHvap? 42.4 kJ/mol 80 F3 $ 4 R 000 000 F4 % 5 Click on E2, grab square on bc v F5 6 MacBook Air F6 & 7 F7 8 DII F8 9 D F9 > 0 F10
Paste the data table into your spreadsheet so that Trial # is in cell A1.
A new column is inserted on the spreadsheet between the T(K) and VP(mmHg) columns for the 1/T
calculation.
What formula to calculate 1/T is typed into the cell directly to the right of 298.2 (cell C2)?
= 1/B2
3
In column E, calculate In VP.
• What formula to calculate In VP is typed into the cell directly to the right of 116.2 (cell E2)?
=In(D2)
#
How is the calculation completed for Trials 2-6? Click on C2, grab square on bv
Plot column C vs column E.
LL
How is the calculation completed for Trials 2-6?
F
The chart type should be Scatter chart. Change if it is something different. In the Chart editor click
on Customize, choose Series. Check the boxes next to Trendline and R2. Under Label change
Custom to Use Equation.
• After highlighting both columns, what is the next step? Both of these
What is the value of the slope? 5100.1
• If the value of R is 8.3145 J/molk, what is the value of AHvap? 42.4
kJ/mol
80
F3
$
4
R
000
000
F4
%
5
Click on E2, grab square on bc v
F5
6
MacBook Air
F6
&
7
F7
8
DII
F8
9
D
F9
>
0
F10
Transcribed Image Text:Paste the data table into your spreadsheet so that Trial # is in cell A1. A new column is inserted on the spreadsheet between the T(K) and VP(mmHg) columns for the 1/T calculation. What formula to calculate 1/T is typed into the cell directly to the right of 298.2 (cell C2)? = 1/B2 3 In column E, calculate In VP. • What formula to calculate In VP is typed into the cell directly to the right of 116.2 (cell E2)? =In(D2) # How is the calculation completed for Trials 2-6? Click on C2, grab square on bv Plot column C vs column E. LL How is the calculation completed for Trials 2-6? F The chart type should be Scatter chart. Change if it is something different. In the Chart editor click on Customize, choose Series. Check the boxes next to Trendline and R2. Under Label change Custom to Use Equation. • After highlighting both columns, what is the next step? Both of these What is the value of the slope? 5100.1 • If the value of R is 8.3145 J/molk, what is the value of AHvap? 42.4 kJ/mol 80 F3 $ 4 R 000 000 F4 % 5 Click on E2, grab square on bc v F5 6 MacBook Air F6 & 7 F7 8 DII F8 9 D F9 > 0 F10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Knowledge Booster
Matter
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
Chemistry
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Organic Chemistry
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
Chemistry: Principles and Reactions
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
Elementary Principles of Chemical Processes, Bind…
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY