Use the Solver function to minimize the sum of squared residuals (obtained from comparing calculated and known values of Nu) by adjusting input values of C and p. You will need to set up the data into columns and start with intelligent guesses for the values of C and p. You may need to introduce constraints in the Solver tool to obtain reasonable values.

Use the Solver function to minimize the sum of squared residuals (obtained from comparing calculated and known values of Nu) by adjusting input values of C and p. You will need to set up the data into columns and start with intelligent guesses for the values of C and p. You may need to introduce constraints in the Solver tool to obtain reasonable values.

Assuming that you have experimental data of Nu at different Re the simplest way to correlate your equation is by linear regression of log-log transformation. That is, your equation can be written log(Nu/(Pr^1/3))=log(C) + p*log(Re). The parameters “log(C)” and “p” (and therefore C=10^log(C)) can be estimated by linear regression in Excel.

Dr Garcia expalined it very well. But if u still need any support please email me