Question: how do I do this problem in excel? 2. (50 pts) The esterification of cyclohexanol (B) with acetic acid (A) can be catalyzed by sulfuric
how do I do this problem in excel?

2. (50 pts) The esterification of cyclohexanol (B) with acetic acid (A) can be catalyzed by sulfuric acid according to the stoichiometry: An experiment was done to determine the rate law of the reaction, which is expected to be of the form: r=kCAn CME 1202. Introduction to Chemical Engineering Spring 2023 where n is the reaction order with respect to A, and k is the rate constant. The experimental data in the table below must be fit to the equation: CA=[CAO1n(1n)kt]1/(1n) The initial concentration of A is CAO=1.0M, and t is time in (h). Use the least-squares method to fit the non-linear equation 4, and find the constants n and k. You must also graph CA vs. Time. The graph should look like the one below. NOTE: This method does not work if n=1. For this reaction n=1. Also, the values of n are typically rounded to an integer, however, for this problem vou do not need to round it. 2. (50 pts) The esterification of cyclohexanol (B) with acetic acid (A) can be catalyzed by sulfuric acid according to the stoichiometry: An experiment was done to determine the rate law of the reaction, which is expected to be of the form: r=kCAn CME 1202. Introduction to Chemical Engineering Spring 2023 where n is the reaction order with respect to A, and k is the rate constant. The experimental data in the table below must be fit to the equation: CA=[CAO1n(1n)kt]1/(1n) The initial concentration of A is CAO=1.0M, and t is time in (h). Use the least-squares method to fit the non-linear equation 4, and find the constants n and k. You must also graph CA vs. Time. The graph should look like the one below. NOTE: This method does not work if n=1. For this reaction n=1. Also, the values of n are typically rounded to an integer, however, for this problem vou do not need to round it
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
