Q7) During calibration of an LVDT, the data shown in the accompanying table were obtained. Using a spreadsheet program, plot the relation between the micrometer reading and voltage. What is the linear range of the LVDT? Determine the calibration factor of the LVDT by obtaining the best fit line of the data within the linear range. Micrometer Voltage, Micrometer Voltage, Reading, inches Volts Reading, inches Volts -0.118 -10.12 0.012 0.985 -0.108 -10.12 0.022 1.99 -0.098 -10.121 0.032 3.023 -0.088 -9.134 0.042 4.035 -0.078 -8.131 0.052 5.071 -0.068 -7.111 0.062 6.098 -0.058 -6.1 0.072 7.115 -0.048 -5.108 0.082 8.143 -0.038 -4.089 0.092 9.144 -0.028 -3.097 0.102 10.157 -0.018 -2.059 0.112 10.156 -0.008 -1.053 0.122 10.156 0 0

During calibration of an LVDT, the data shown in the accompanying table were obtained. Using a spreadsheet
program, plot the relation between the micrometer reading and voltage. What is the linear range of the LVDT? Determine
the calibration factor of the LVDT by obtaining the best fit line of the data within the linear range.