Microsoft excel HW

Newton’s law of cooling is a useful mathematical model for figuring out how hot things will get.

Specifically, I use it for cooking. According to the instructions, a 14 lb turkey takes approximately 3 hrs and 15 minutes to cook (safe temperature: 165 oF) while cooking at 325 oF. For the next Sun Devil’s game, I want to impress my fellow students by smoking that bad boy over hickory for a tender juiciness. I cannot find instructions on how long to cook it, but I know I want to cook it at a low 195 oF. If the turkey starts out at 34 oF, use solver to figure out how long to cook it for.

Along with this file, there is a file called “cooking times” on canvas. These are temperatures measured at 10 minute intervals using a normal oven. Import that as discussed in class and solve for the time constant, r, in the following equation:

Where t is time, T is the temperature, Tenv is the temperature of the environment (e.g., the oven), and T(0) is the initial temperature. In addition, plot the temperature versus time on a graph using good graphing practices. Include both the experimental data and the model equation above.

Game time is 1:00 pm, so you want this ready at noon sharp. Using solver, figure out at what time (within a minute) I should pop the turkey into the smoker (assuming it is at the right temperature to start with).

Be sure to use autofill with a mix of absolute and relative referencing. Put the graph in its own sheet and call that sheet, cookingfigure. Have your answers reported on a sheet called, answers, with the answers clearly highlighted.

The subject of the email (to the TA not me) is:

FSE 100 Excel Practice Section #

Followed by the lab section number.

The due date will be announced in class. But it will be due by 8:00 am, independent of the date.