 Hello, this is Professor Stephen Nesheba, and I'm here to help you out with some doing some calculations having to do with the decomposition of hydrogen peroxide in Excel so if you've set up things like this where we've got the stock volumes of the reagents Ki and so forth and and if you've already entered in these these values for the the concentrations of those those reagents in solution as we've done here for these three different runs and if you've also entered in the values for the for the The rate proxy that we've used which is change in pressure with respect to time then We're ready to to do this part now The the equation that we have is that I'm supposed to say that the rate is equal to delta p delta t times the volume of the of the air which this will be different for you, but let's just say that was 15 Mills and then downstairs we we need to divide by the gas constant point oh a2 in this case times the the temperature which you'll have recorded but I'm just going to say for this example 298 Kelvin times the volume of the solution which Was for most of our cases it was 25 mills So that's what that is so now I've just calculated the rate So here's the nice thing about that is that there's this there's this drag I go to the lower right and it changes the the sign here to this plus and if I drag it off to the right It's just going to redo that calculation for for run two and for run three For example, you can kind of see how it referred to B7 to get to get that rate and here and now it referred to C7 and D7 and a similar thing we can do for the rate constant So the rate constant is you know is going to be related to the rate by the rate law so I'm going to Take that rate then and divide it by the concentrations of you know ratio appropriate powers so I'm going to say it's equal to the rate divided by let's see the Ki in solution and in this case, you know The data seemed to be most consistent with first order, so I'm going to raise it to the first power on the Ki and then also To the first power, but you could have you might have a different order in your that came out of your data but anyway, that's kind of the way you do it and So now that's the rate constant and we can do a similar thing which is go to the lower right grab it pull it off to the right And now it has different values You know, it's done the same thing now for for runs two and run three and One last thing since these are the rate constants. It's supposed to be the same number We can say oh well the the I could take an average of those by Using Excel's average function, which I'm just going to grab all three of those and close parentheses and so Right there. So we have this is our average rate constant for runs one two and three Okay, great