Question: Instructions: 1. Solve these problems using Microsoft Excel. Problem-1 Table 1 shows the data of temperature recorded by four different temperature sensors at certain time

 Instructions: 1. Solve these problems using Microsoft Excel. Problem-1 Table 1

shows the data of temperature recorded by four different temperature sensors at

Instructions: 1. Solve these problems using Microsoft Excel. Problem-1 Table 1 shows the data of temperature recorded by four different temperature sensors at certain time interval. i. Calculate the mean temperature at each time interval. ii. Plot the mean temperature of the four sensors against time. The standard deviation of each reading should also be added to the plot as error bars (y-error). Time (min) Average Std. deviation 0.5 2 4 Table 1 Temperature readings of 4 temperature sensors Temperature (C) Reading-1 Reading-2 Reading-3 Reading-4 25 20 24 23 27 26 22 26 33 34 39 35.5 40 38 43 37 45 46 44 43 47 48 49 46 51 49 51 49 49 50 51 51 6 8 10 12 14 Hint/Self-Study: You may need to find the formula for calculating the standard deviation from internet. Also search for how to add error bars (standard deviation) to a graph/plot

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 Chemical Engineering Questions!