Jeff R.

asked • 09/29/15

Exponential Regression model

I have no idea how to complete the below problem and teacher has not gotten back to me. Can someone please show me how to complete this?
 
The data below shows the cooling temperatures of a freshly brewed cup of coffee after it is poured from the brewing pot into a serving cup. The brewing pot temperature is approximately 180 degrees (F).
 
Time (mins)     Temp (Degree F)
       0                     179.5
       5                     168.7
       8                     158.1
       11                   149.2
       15                   141.7
       18                   134.6
       22                   125.4
       25                   123.5
       30                   116.3
       34                   113.2
       38                   109.1
       42                   105.7
       45                   102.2
       50                   100.5
 
a. Find an exponential regression model of the form y=a*b^x to represent the above date, where x is the number of minutes, and y is the temperature of the cup of coffee.
 
b. Graph the exponential regression model.
 
c. Decide whether the model is a "good fit" to represent this data.
 
d. When is the coffee at a temperature of 92 degrees?
 
e. What is the predicted temperature of the cup of coffee after 65 minutes? 

Jim S.

tutor
Jeff,
        If you know how to use MS Excel I can walk you through this problem. 
Jim
Report

09/29/15

Jeff R.

Sir,
  I do know how to use Microsoft excel so if you can give me instructions I will be able to follow and complete it. Thank you.
Report

09/29/15

1 Expert Answer

By:

Jordan K. answered • 09/30/15

Tutor
4.9 (79)

Nationally Certified Math Teacher (grades 6 through 12)

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.