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.