Question: help on how to solve this with excel 2. ( 50 pts) The esterification of cyclohexanol (B) with acetic acid (A) can be catalyzed by
help on how to solve this with excel

2. ( 50 pts) The esterification of cyclohexanol (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=kCAn E 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 you 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 stoichiometrv: An experiment was done to determine the rate law of the reaction, which is expected to be of the form: r=kCAn E 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 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
