RECENT ASSIGNMENT

do the first one in excel and copy to word
Time (min) Expt Resistance-1 (Ohms) Expt Resistance-2 (Ohms)
0.50 800 850
1.00 1000 1100
1.50 1200 1280
2.00 1400 1450
2.50 1450 1520
3.00 1450 1550
4.00 1470 1570
4.50 1500 1600
5.00 1500 1600
a) Calculate the average and standard deviation of the two experimental resistance values and the two calculated temperature values at each time
b) Plot the average temperature values in a scatter plot in triangles
(y-axis), and the average resistance values on a secondary y-axis in a scatter plot as square. Feel free to change the color of the data points, but be sure to graph the time on the x-axis
c) The standard deviation values should be used as error bar sin each data set. Additionally, add trendline for each data set. The regression equations and R-squared values for the trendlines should be displayed on the figure
d) Create one to two tables of all of your calculations. Make sure to label your tables and
format them
2) Show how the hydropower equation can be derived from the equation for kinetic energy, when considering the power produced by a hydropower turbine. Also show how the units on each side of the equation are equal for the final power equation. Use the MSWord Equation Editor to type each equation and show all of the units