Question: 2.00 can you help me solve this with excel? please :) 2. (50 pts) The esterification of cyciohexanol (B) with acetic acid (A) can be
2.00 can you help me solve this with excel? please :)

2. (50 pts) The esterification of cyciohexanol (B) with acetic acid (A) can be catalyzed by sulfuric acid according to the stoichiometrv: An experiment was done to determine the rate law of the reaction, which is expected to be of the form: r=kCn ME 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: C=[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 you do not need to round it. 2. (50 pts) The esterification of cyciohexanol (B) with acetic acid (A) can be catalyzed by sulfuric acid according to the stoichiometrv: An experiment was done to determine the rate law of the reaction, which is expected to be of the form: r=kCn ME 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: C=[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 you 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
