Use Excel Solver ad on…
MUST BE DONE USING EXCEL
PLEASE SHOW EACH STEP AND ALL FUNCTIONS USED IN EXCEL
The data below displays heat generated as cement cures. Amodel is proposed to estimate heat as a function of time as follows: H = Ae where H is heat (J/g), t istime (hrs) and A, Band a are constants. Use the Excel solver to find the values for the constants that minimize the sum of residual squares. Keep B 1 and a <= 1 Plot your results as an x-y scatter plot (Modeled H vs Observed H) and fit a linear trendline with the R squared displayed on the plot. Also plot residuals vs ti me (label all axes). You may need to separate the exponential calculation into multiple steps (columns) Of the three parameters, which are the most and least sen si tive? Time (hrs) Heat (J/g) 24.0113 251.3867 24,4805 253.3382 25.1485 256.0056 25.9416 259.0112 26.7124 261.7777 27.3216 263.8643 266.5198 28.1327 28.8217 268.6759 29.5702 270.9255 30.1805 272.6956 30.6960 274.1501 31.1872 275.5039 277.8317 32.0569 32.5394 279.0879 33.3980 281.2679 34.2282 283.3148 35.0722 285.3406 287.0707 35.8102 36.4494 288.5404 290.1060 37.1424 37.7949 291.5542 38.6210 293.3545 294.8444 39.3174 296.1776 39.9499 297.7139 40.6908 41.4766 299.3140 42.2785 300.9138 42.7885 301.9130 43.6441 303.5581 44.4183 305.0133 45.1758 306.4057 45.8233 307.5719 46.7209 309.1519 47.3602 310.2508 48.0247 311.3696 48.6805 312.4511 Show transcribed image text The data below displays heat generated as cement cures. Amodel is proposed to estimate heat as a function of time as follows: H = Ae where H is heat (J/g), t istime (hrs) and A, Band a are constants. Use the Excel solver to find the values for the constants that minimize the sum of residual squares. Keep B 1 and a
Expert Answer
Answer to Use Excel Solver ad on… MUST BE DONE USING EXCEL PLEASE SHOW EACH STEP AND ALL FUNCTIONS USED IN EXCEL…