Explore BrainMass

Explore BrainMass

    Use an excel spreadsheet with the data provided

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    (a)Use an excel spreadsheet with the data provided
    activity time (sec)
    4022 38.6
    3424 77.0
    2613 113.8
    2158 152.6
    1590 188.9
    1337 228.6
    940 269.7

    prepare a graph of activity vs. seconds. Use a trend line to produce the best exponential line through the points.

    (b) Use the excel spreadsheet again with the data to prepare a graph of ln(activity) vs. time (seconds) . Use lin fit to produce the best straight line through the graph through the points and have the equation of that line printed on the graph.

    ln (activity)t= _________t+_____________

    (c)
    Use the y-intercept of the line to calculate the activity which was present at the original time t=0

    (d)
    Use the slope of the line to determine the value of the rate of constant or decay constant
    K=____________(sec)_______

    (e)
    Use the equation to calculate the time at which the activity has decreased to 500
    Pleas help with attached problem.
    thanks

    © BrainMass Inc. brainmass.com June 4, 2020, 12:13 am ad1c9bdddf
    https://brainmass.com/math/graphs-and-functions/use-an-excel-spreadsheet-with-the-data-provided-326057

    Attachments

    Solution Summary

    A Complete, Neat and Step-by-step Solution is provided in the attached file.

    $2.19

    ADVERTISEMENT