Plot with excel

College Algebra
10th Edition
ISBN:9781337282291
Author:Ron Larson
Publisher:Ron Larson
Chapter3: Polynomial Functions
Section3.5: Mathematical Modeling And Variation
Problem 7ECP: The kinetic energy E of an object varies jointly with the object’s mass m and the square of the...
icon
Related questions
Question
100%

Plot with excel

The resistance (R) of silicon as a function of temperature (T) is given
by the relationship
R = Ro exp(E,/ 2kT)
where Ro is a constant, Eg is the energy gap between the valance band and conduction
band of silicon and k is Boltzmann's constant (k=1.3807×10 2³JK-!)
A student measures the resistance of a silicon sample as a function of temperature and
obtains the following data.
T(K)
R(N)
148.1
570.6
555.9
202.6
549.4
227.1
544.1
255.1
527.3
362.0
522.2
406.1
513.1
502.5
497.6
750.1
484.9
1026.7
The uncertainties in the measured temperature are negligible, but the manufacturer of the
multimeter used to measure the resistance quotes the uncertainty in any measurement as
+1% of the measured value.
(i)
Linearise the above equation relating R and T so that the student's data can be
plotted in a linear form
Plot a graph, in the approved style, showing the linearised data and the appropriate
uncertainties
(ii)
Transcribed Image Text:The resistance (R) of silicon as a function of temperature (T) is given by the relationship R = Ro exp(E,/ 2kT) where Ro is a constant, Eg is the energy gap between the valance band and conduction band of silicon and k is Boltzmann's constant (k=1.3807×10 2³JK-!) A student measures the resistance of a silicon sample as a function of temperature and obtains the following data. T(K) R(N) 148.1 570.6 555.9 202.6 549.4 227.1 544.1 255.1 527.3 362.0 522.2 406.1 513.1 502.5 497.6 750.1 484.9 1026.7 The uncertainties in the measured temperature are negligible, but the manufacturer of the multimeter used to measure the resistance quotes the uncertainty in any measurement as +1% of the measured value. (i) Linearise the above equation relating R and T so that the student's data can be plotted in a linear form Plot a graph, in the approved style, showing the linearised data and the appropriate uncertainties (ii)
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,