# Help required with this question

• Dec 1st 2009, 05:08 PM
Munnag
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.
• Dec 1st 2009, 10:56 PM
CaptainBlack
Quote:

Originally Posted by Munnag
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.

Quote:

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
• Dec 2nd 2009, 04:12 AM
Munnag
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

Regards,
Munnag
• Dec 2nd 2009, 04:18 AM
CaptainBlack
Quote:

Originally Posted by Munnag
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