Thread: 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.

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.

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

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

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

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