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?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
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 #
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 #
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Requirement Analysis
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education