Question: Solve using Excel please!!! I will dislike if given a matlab answer!!! Question 1 (25 marks) The Nusselt number (Nu) is given by the following

Solve using Excel please!!! I will dislike if given a matlab answer!!!

Solve using Excel please!!! I will dislike if given a matlab answer!!!

Question 1 (25 marks) The Nusselt number (Nu) is given by the following correlation in terms of the Reynolds number (Re), the Prandtl number (Pr) and the ratio of viscosities at the mean fluid temperature and the wall temperature. d3 u = Nu = a, Re Pr prale How Based on the data given below find the best fit values for the constants ao, aj, aj, az using a linear transformation with multi-linear regression using Microsoft Excels Data analysis Add-in. Answers should be clearly shown Pr Nu 277 348 421 223 177 114.8 95.9 68.3 49.1 56.0 39.9 47.0 94.2 99.9 83.1 35.9 Re 49,000 68,600 84,800 34,200 22,900 1,321 931 518 346 122.9 54.0 84.6 1,249 1,021 465 54.8 2.30 2.28 2.27 2.32 2.36 246 247 251 273 1,518 1,590 1,521 107.4 186 414 1,302 r=(uw) 0.947 0.954 0.959 0.943 0.936 0.592 0.583 0.579 0.290 0.294 0.279 0.267 0.724 0.612 0.512 0.273 Using your results predict and print the value of the Nusselt number for the following values: Re=30,000 Pr=250 r=(u/uw)=0.88

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!