3. Determine the experimental value of Planck's constant, h, from this graph using Excel. 4. Determine an equation of the line. The y-intercept of the line is the work function, p, of the metal. 5. Write the equation of the line in the form y = mx + b: ¥=0.4157 x = 2,3042 6. Convert the work function to eV. 4= 7. Extrapolate the line until it intersects the horizontal axis and vertical axis. 8. The slope of the line is the experimental value of Planck's constant (h). Find the % error for h using the formula below.

College Physics
11th Edition
ISBN:9781305952300
Author:Raymond A. Serway, Chris Vuille
Publisher:Raymond A. Serway, Chris Vuille
Chapter1: Units, Trigonometry. And Vectors
Section: Chapter Questions
Problem 1CQ: Estimate the order of magnitude of the length, in meters, of each of the following; (a) a mouse, (b)...
icon
Related questions
Question
3. Determine the experimental value of Planck's constant, h, from this graph
using Excel.
4. Determine an equation of the line. The y-intercept of the line is the work
function, p, of the metal.
5. Write the equation of the line in the form y = mx + b:
¥=0.4157 x -
6. Convert the work function to eV.
7. Extrapolate the line until it intersects the horizontal axis and vertical axis.
8. The slope of the line is the experimental value of Planck's constant (h). Find
the % error for h using the formula below.
Data Table
Frequency (x10¹4 Hz)
11.8
10.6
9.9
9.1
8.2
6.9
2,3042
4=
Energy (EV)
2.60
2.11
1.81
1.47
1.10
0.57
Transcribed Image Text:3. Determine the experimental value of Planck's constant, h, from this graph using Excel. 4. Determine an equation of the line. The y-intercept of the line is the work function, p, of the metal. 5. Write the equation of the line in the form y = mx + b: ¥=0.4157 x - 6. Convert the work function to eV. 7. Extrapolate the line until it intersects the horizontal axis and vertical axis. 8. The slope of the line is the experimental value of Planck's constant (h). Find the % error for h using the formula below. Data Table Frequency (x10¹4 Hz) 11.8 10.6 9.9 9.1 8.2 6.9 2,3042 4= Energy (EV) 2.60 2.11 1.81 1.47 1.10 0.57
Results
I) Experimental value of Planck's constant, h =
II)
III)
Work Function=p=.
II)
III)
% error = |
6.63 x 10-34-h
6.63 x 10-34
Excel Instructions for Creating a Graph
I)
|x 100
a. Check the box "Trendlines"
i. More Options...
=
Highlight a data point. The data point should have four small circles
around it.
A side bar window ("Format Data Series") should open.
Choose:
ii. Highlight Linear
iii. Choose Display Equation or Chart. The equation will be of the
form:
y = mx + b, where m is the slope and b is the y-intercept
Transcribed Image Text:Results I) Experimental value of Planck's constant, h = II) III) Work Function=p=. II) III) % error = | 6.63 x 10-34-h 6.63 x 10-34 Excel Instructions for Creating a Graph I) |x 100 a. Check the box "Trendlines" i. More Options... = Highlight a data point. The data point should have four small circles around it. A side bar window ("Format Data Series") should open. Choose: ii. Highlight Linear iii. Choose Display Equation or Chart. The equation will be of the form: y = mx + b, where m is the slope and b is the y-intercept
Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Knowledge Booster
Compton effect
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, physics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
College Physics
College Physics
Physics
ISBN:
9781305952300
Author:
Raymond A. Serway, Chris Vuille
Publisher:
Cengage Learning
University Physics (14th Edition)
University Physics (14th Edition)
Physics
ISBN:
9780133969290
Author:
Hugh D. Young, Roger A. Freedman
Publisher:
PEARSON
Introduction To Quantum Mechanics
Introduction To Quantum Mechanics
Physics
ISBN:
9781107189638
Author:
Griffiths, David J., Schroeter, Darrell F.
Publisher:
Cambridge University Press
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Lecture- Tutorials for Introductory Astronomy
Lecture- Tutorials for Introductory Astronomy
Physics
ISBN:
9780321820464
Author:
Edward E. Prather, Tim P. Slater, Jeff P. Adams, Gina Brissenden
Publisher:
Addison-Wesley
College Physics: A Strategic Approach (4th Editio…
College Physics: A Strategic Approach (4th Editio…
Physics
ISBN:
9780134609034
Author:
Randall D. Knight (Professor Emeritus), Brian Jones, Stuart Field
Publisher:
PEARSON