Question: A heated object was left to cool. The temperature (T) was measured at one minute intervals. III-m II Temperature T 82 (degrees Celsius) It is

 A heated object was left to cool. The temperature (T) was

measured at one minute intervals. III-m II Temperature T 82 (degrees Celsius)

A heated object was left to cool. The temperature (T) was measured at one minute intervals. III-m II Temperature T 82 (degrees Celsius) It is hypothesized that temperature T is related to time t by a linear relationship (a) Record the above data in cells A1 to cell K2. Use Microsoft Excel to do a scatter plot of the data with time t on the horizontal axis and Temperature on the vertical axis. (b) Use Microsoft Excel to fit a linear trend line to this data. (c) Use Microsoft Excel to show the equation of the line of best fit on the scatter plot (d) Use the equation of the line of best fit to estimate the temperature after 12 minutes Excel math question ( MUST BE MICROSOFT EXCEL)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!