Matlab compared with Excel

For comparison, the values computed above are compared with the values obtained using different software in Table 1.6. It can be seen that each software package can compute the same value differently. In all cases, the median will be computed the same way, since it is a fixed value. As was previously mentioned, this verifies that quartile. inc function in Excel is equivalent to the values obtained manually based on Eq. (1.7), while quart i 1 e. exc function in Excel is based on option 1 for Eq. (1.7). Einally, MATLAB uses option 2 for Eq. (1.7). Nevertheless, all values are relatively close to each other and would not impact too greatly the overall results. 

You can also use the process simulator Aspen Plus to solve chemical reaction equil-brium problems. It has a huge advantage over Excel and MATLAB Aspen Plus contains the Gibbs free energies of many chemicals, and it can calculate them as a function of temperature. Thus, the data-gathering aspect of the problem is handled for you. Your job is to compare the results and the predicted A -values with experimental information. 

Use Excel with a starting point (1,0) to find values of ti and T2 that minimize the sum of squares of the errors. Compare your answer with that obtained using MATLAB. 

---