Results 1 to 4 of 4

Math Help - Help required with this question

  1. #1
    Newbie
    Joined
    Dec 2009
    Posts
    2

    Help required with this question

    Hi All,

    I am new here, i have got this problem and have no clue to figure it out
    i ll be more than happy if someone gives solution for this, thanks alot in advance



    In order to determine the time since death of a body (t hours), a forensic scientist uses the formula
    P = 1.34e^-0.08t - 0.41e^-0.20t
    2.1 Create a new worksheet in your Excel workbook.
    Rename this worksheet Time Since Death.
    Use the worksheet Time Since Death to enter data and make appropriate calculations to produce a graph of P against t for t over the range 0 to 24 hours in steps of 0.1 with a smooth curve through the points.

    Your graph must be suitably formatted but may be left as an object in the Time Since Death worksheet.
    2.2 For any particular body, P is found by evaluating where each T represents a Temperature in oC.
    Given TRectum = 30.0 oC, TAmbient = 12.7 oC, use Excel to evaluate P in cell D1 of the worksheet Time Since Death.
    By inspecting the values you generated in the worksheet Time Since Death rather than the graph, estimate the time since death to 1 decimal place.
    Note in your written solutions your calculated value for P and your estimate of the time since death. Ensure they are clearly labelled.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Munnag View Post
    Hi All,

    I am new here, i have got this problem and have no clue to figure it out
    i ll be more than happy if someone gives solution for this, thanks alot in advance



    In order to determine the time since death of a body (t hours), a forensic scientist uses the formula

    P = 1.34e^-0.08t - 0.41e^-0.20t

    2.1 Create a new worksheet in your Excel workbook.
    Rename this worksheet Time Since Death.
    Use the worksheet Time Since Death to enter data and make appropriate calculations to produce a graph of P against t for t over the range 0 to 24 hours in steps of 0.1 with a smooth curve through the points.

    Your graph must be suitably formatted but may be left as an object in the Time Since Death worksheet.
    I trust that you can do this yourself, since there is no point in our doing it for you as the intent is evidently for you to practice using Excel.

    2.2 For any particular body, P is found by evaluating where each T represents a Temperature in oC.
    Given TRectum = 30.0 oC, TAmbient = 12.7 oC, use Excel to evaluate P in cell D1 of the worksheet Time Since Death.
    By inspecting the values you generated in the worksheet Time Since Death rather than the graph, estimate the time since death to 1 decimal place.
    Note in your written solutions your calculated value for P and your estimate of the time since death. Ensure they are clearly labelled.
    This part is incomprehensible as you do not provide the information needed to link P to the temprature data in an understandable form.

    CB
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Dec 2009
    Posts
    2
    Hi, I understand what you mean but i have tired, i am not able to understand the question itself, can you please do it in excel sheet and give a copy or explain me it step by step... PLEASE, i ll be delightful

    thanks a billion in advance


    Regards,
    Munnag
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Munnag View Post
    Hi, I understand what you mean but i have tired, i am not able to understand the question itself, can you please do it in excel sheet and give a copy or explain me it step by step... PLEASE, i ll be delightful

    thanks a billion in advance


    Regards,
    Munnag
    I'm afraid not, one thing I do not do here (any more if I ever did so) is construct simple spread sheets for people. Learing to do this stuff in Excel is a hands-on task you either need to try it youself by playing with Excel of have someone with you to guide you.

    CB
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. no. of bombs required to destroy : question
    Posted in the Statistics Forum
    Replies: 1
    Last Post: August 9th 2011, 08:19 AM
  2. Combination Question help required
    Posted in the Discrete Math Forum
    Replies: 0
    Last Post: April 20th 2011, 08:01 AM
  3. Replies: 1
    Last Post: May 25th 2010, 02:32 AM
  4. A Question - Concentration Required
    Posted in the Math Challenge Problems Forum
    Replies: 6
    Last Post: March 16th 2009, 11:34 AM
  5. Help Required
    Posted in the Business Math Forum
    Replies: 1
    Last Post: August 1st 2007, 08:55 AM

Search Tags


/mathhelpforum @mathhelpforum