The following data show the temperature vs. resistance for an RTD: Temperature °C 0 10 20 30 40 50 60 70 80 90 100 Resistance ohms 100.0 103.9 107.8 111.7 115.6 119.5 123.4 127.3 131.2 135.1 139.0 a. Use Excel to graph the data and add a trend line to evaluate the linear temperature coefficient. b. Is the RTD of laboratory grade?
The following data show the temperature vs. resistance for an RTD: Temperature °C 0 10 20 30 40 50 60 70 80 90 100 Resistance ohms 100.0 103.9 107.8 111.7 115.6 119.5 123.4 127.3 131.2 135.1 139.0 a. Use Excel to graph the data and add a trend line to evaluate the linear temperature coefficient. b. Is the RTD of laboratory grade?
Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter21: Simulation
Section21.5: Simulations With Continuous Random Variables
Problem 4P
Related questions
Question
100%
Please help me to solve this problem in excel and show the steps and formulas thank you
![or
where
RT Ro[1 + a T],
RT= Ro+ (Roa) T
(in linear-regression form),
Temperature
°℃
O
10
20
30
40
50
60
70
80
90
100
RT is the resistance at the unknown temperature, T,
Ro is the resistance at 0°C (known, one of the RTD specifications), and
a is the linear temperature coefficient (known, one of the RTD specifica-
tions).
Problems 173
The common grade of platinum used for RTDs has an a value equal to
0.00385 ohm/ ohm/°C (sometimes written simply as 0.00385°C-¹), but older RTDs
used a different grade of platinum and operated with a = 0.003902°C-¹, and labora-
tory grade RTDs use very high-purity platinum with a = 0.003923°C. If the wrong
a value is used to compute temperatures from RTD readings, the computed tem-
peratures will be incorrect.
The following data show the temperature vs. resistance for an RTD:
Resistance
ohms
(3.6)
100.0
103.9
107.8
111.7
115.6
119.5
123.4
127.3
131.2
135.1
139.0
(3.7)
a. Use Excel to graph the data and add a trend line to evaluate the linear
temperature coefficient.
b. Is the RTD of laboratory grade?
3.6 Experimentally Determining a Value for #](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe8e7ecd1-00b2-4f87-97f4-1e990180b5ce%2Fe19f2fbe-55e3-4398-bc95-7f3cc7b452fa%2Fejcxc3_processed.jpeg&w=3840&q=75)
Transcribed Image Text:or
where
RT Ro[1 + a T],
RT= Ro+ (Roa) T
(in linear-regression form),
Temperature
°℃
O
10
20
30
40
50
60
70
80
90
100
RT is the resistance at the unknown temperature, T,
Ro is the resistance at 0°C (known, one of the RTD specifications), and
a is the linear temperature coefficient (known, one of the RTD specifica-
tions).
Problems 173
The common grade of platinum used for RTDs has an a value equal to
0.00385 ohm/ ohm/°C (sometimes written simply as 0.00385°C-¹), but older RTDs
used a different grade of platinum and operated with a = 0.003902°C-¹, and labora-
tory grade RTDs use very high-purity platinum with a = 0.003923°C. If the wrong
a value is used to compute temperatures from RTD readings, the computed tem-
peratures will be incorrect.
The following data show the temperature vs. resistance for an RTD:
Resistance
ohms
(3.6)
100.0
103.9
107.8
111.7
115.6
119.5
123.4
127.3
131.2
135.1
139.0
(3.7)
a. Use Excel to graph the data and add a trend line to evaluate the linear
temperature coefficient.
b. Is the RTD of laboratory grade?
3.6 Experimentally Determining a Value for #
Transcribed Image Text:Use this equation to calculate predicted thermocouple outputs at each tempera
ture, and add these to the graph as a second data series. Do the predicted values
appear to agree with the average experimental values?
3.5 Resistance Temperature Detector
The linear temperature coefficient a of a resistance temperature detector (RTD) is a
physical property of the metal used to make the RTD that indicates how the electrical
resistance of the metal changes as the temperature increases. The equation relating
temperature to resistance is
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
Recommended textbooks for you
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole