The following data was acquired during the experiment. Use a spreadsheet such as Logger Pro or Excel to perform the following manipulations on the data. Using a calculator will result in a large rounding error, eading to incorrect answers, wasted time, and frustration. Help with spreadsheets [PDF] 2. Determine the order of the reaction with respect to permanganate. The molar absorptivity of permanganate is 2168cm1M1 a. Enter the time and absorbance data into the spreadsheet. b. Use the absorbances and the value of the molar absorptivity to calculate a column of concentration. c. Construct graphs of ln[KMnO4] vs. t and 1/[KMnO4] vs. t using Logger Pro (detailed directions for using Logger Pro to make these graphs are found in Data Analysis question 1B \& 1C). Based upon the linearity, determine the reaction order. It is not necessary to print the graphs, but you should record the slope and intercept of each graph. Enter the [KMnO4], the ln[KMnO4] and 1/KMnO4 at 30 s. [KMnO4] M ln[KMnO4] [KMnO4]1 1/M Enter the reaction order with respect to permanganate. Reaction order (1 or 2) : 3. What is the value of the rate constant? Hint: 4. What is the initial concentration of permanganate ion, [MnO4]o ? Hint: M b. What is the half life? Hint