Table 1 shows the variation of dynamic viscosities of water with absolute temperature. Table 1: Dynamic viscosity of water with absolute temperature. Viscosity µ, Pa.s x 10-³ 1.787 Temperature, K 273.15 278.15 283.15 293.15 303.15 1 313.15 333.15 353.15 373.15 4G 1.519 1.307 1.002 0.7975 0.6529 0.4665 0.3547 0.2828 a) Using excel software, develop a relationship of for viscosity in the form of μ=A+BT+CT² + DT³ + ET. Done Show your trend line regression and standard deviation for linear and polynomial index (quadratic T², cubic T³ and T). b) Using the relationship developed, predict the dynamic viscosity of water at 50 °C at which the reported value is 5.468 x 10 Pa.s. Compare your result with the results of Andrade's equation which is given in the form of μ = D.e BT where D and B are constants whose values are to be determined using viscosity data given.
Table 1 shows the variation of dynamic viscosities of water with absolute temperature. Table 1: Dynamic viscosity of water with absolute temperature. Viscosity µ, Pa.s x 10-³ 1.787 Temperature, K 273.15 278.15 283.15 293.15 303.15 1 313.15 333.15 353.15 373.15 4G 1.519 1.307 1.002 0.7975 0.6529 0.4665 0.3547 0.2828 a) Using excel software, develop a relationship of for viscosity in the form of μ=A+BT+CT² + DT³ + ET. Done Show your trend line regression and standard deviation for linear and polynomial index (quadratic T², cubic T³ and T). b) Using the relationship developed, predict the dynamic viscosity of water at 50 °C at which the reported value is 5.468 x 10 Pa.s. Compare your result with the results of Andrade's equation which is given in the form of μ = D.e BT where D and B are constants whose values are to be determined using viscosity data given.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 8 images
