Answer Happy

The data file for this lab is the MS Excel file "data_Ba137_decay.xlsx". Open this file and do the following: In column C, use the function LNO to calculate the natural logarithm of the "counts (Bq)" data in column B. . • Adjust the number of significant figures shown to 3. • Give this column a short, descriptive title. • Save this file with your last name appended to the original file name. For example, the new filename would be: data_Ba137_decay_JONES In your Excel file, insert a chart. Use the x-y scatter plot with no lines. In this chart: • Plot time on the x-axis • Plot In(counts) on the y-axis • Add a title to the plot . • Add a title with units to each axis . . • Add a linear trendline to the plot • Display the equation and the R^2 value of the trendline on the chart. • Save the file. >The half-life equation is N, N,"e", where n =Vt and tis the time elapsed and is the half-life value. In the space below, use the natural logarithm, In(), to perform a log- transform of the half-life equation into the linear form y= mx+b. In this transformation, y should be the In(N) and x should the time, t. You may insert a picture of a hand written calculation if it is organized and legible. Sign and date the picture for full credit. Consider your linear transformation of the half-life equation. What is the value of the intercept, b? 5) Consider your linear transformation of the half-life equation. What is the value of the slope, m? Use your linear transformation of the half-life equation to calculate the value of the half-life value. Look up the half-life value of barium-137m. Include a citation of your source. Use this value as the true value of the half-life for this experiment and calculate the percent error of the half-life value calculated above. You may insert a picture of a hand written calculation if it is organized and legible. Sign and date the picture for full credit.
Trial Trial Trial #2 #1 #3 4.29 24 2,10 4,53 Record the following in seconds Time in seconds for yellow color to disappear, first time Time in seconds for yellow color to disappear, second time Time in seconds for yellow color to disappear, third time (if necessary) Time in seconds for yellow color to disappear, fourth time (if necessary) Part Two: The Effect of Temperature on the Rate Constant - Complete in the Lab 11E 111 Trial #4 3.31 want these
tnal again Trial # 2 3 4 un HCI (mL) 5 5 5 10 Acetone (mL) 5 5 10 5 I2 (mL) 5 10 5 5 Water (mL) 10 5 5 5 Total Volume (mL) 25.00 25.00 25.00 25.00