Excel Calculations Self-Test

MS Excel( Spreadsheets. ... Create a column with values of k est1 calculated using the m and b values computed from the regression. Graph the experimental data set using markers and the regression values as a line. The thermal conductivity of silicon should vary according to the formula: k = k 0/ (T-T0) ................
................