Question: please help me to solve this problem using excel, can you show the steps please 3.5 Resistance Temperature Detector The linear temperature coefficient of a

please help me to solve this problem using excel, can you show the steps please
please help me to solve this problem using excel,
please help me to solve this problem using excel,
3.5 Resistance Temperature Detector The linear temperature coefficient of a resistance temperature detector (RTD) is a physical property of the metal used to make the RTD that indicates how the electrial resistance of the metal changes as the temperature increases. The equation relating tempcrature to resistance is RT=R0[1+T] or RT=R0+(R0)T(inlinear-regressionform), where RT is the resistance at the unknown temperature, T, R0 is the resistance at 0C (known, one of the RTD specifications), and is the linear temperature coefficient (known, one of the RTD specifications). The common grade of platinum used for RTDs has an value equal to 0.00385chm/ohm/C (sometimes written simply as 0.00385C1 ), but older RTDs used a different grade of platinum and operated with =0.003902C1, and laboratory grade RTDs use very high-purity platinum with =0.003923C1. If the wrong x value is used to compute temperatures from RTD readings, the computed temberatures will be incorrect. The following data show the temperature vs. resistance for an RTD: 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!