ICA: Coffee Cooling Profile

\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch % NOTE: do NOT define \bar -- it is the built-in LaTeX accent used by \bar{x}, % \bar{y} (sample means). Redefining it made those render as the word "bar". \newcommand\barunit{\unit{bar}} \end{aligned}\end{align} \]

Nov 16, 2026 | 366 words | 4 min read

4.2.1. ICA: Coffee Cooling Profile#

You enjoy drinking coffee but are particular about the temperature (\(T\)) of your beverage. If the temperature is greater than or equal to \(70^ ext{C}\), the coffee is too hot to drink. If it is less than or equal to \(45^ ext{C}\), it is too cold for your taste.

Your coffee pot produces coffee at a specific initial temperature (\(T_0\)). The cooling of your coffee over time can be modeled by the following exponential decay equation, where time (\(t\)) and the cooling factor (\(k\)) are measured in units per second: $\(T = T_0e^{-kt}\)$

Required Files#

Download the activity template.

Instructions#

Download the provided Excel spreadsheet template and complete the following tasks.

  1. Set Up User Inputs: At the top of your worksheet, locate Table 1, where a user can easily modify the four coffee properties. Enter the following test case data:

    • Initial Temperature (\(T_0\)): \(80^\circ\text{C}\)

    • Cooling Factor (\(k\)): \(0.001\text{ s}^{-1}\)

    • Hot Threshold (\(T_{hot}\)): \(70^\circ\text{C}\)

    • Cold Threshold (\(T_{cold}\)): \(45^\circ\text{C}\)

  2. Generate a Time Array: In Column A, create a time range from 0 to 300 seconds in 15-second intervals. Use relative cell referencing (for example, =A9+15) and drag the formula down to automatically fill the range instead of typing the values manually.

  3. Calculate the Temperature: In Column B, calculate the temperature of the coffee at each 15-second interval using the exponential decay formula shown above.

    • Hint: You will need to use Excel’s =EXP() function. You must also use absolute cell referencing (using the $ symbol or the F4 key) to lock the \(T_0\) and \(k\) reference cells so you can drag your formula down the column cleanly.

  4. Nested Logic Categorization: In Column C, write a nested logical function to evaluate the coffee’s drinkability at each timestamp.

    • Using a nested =IF() statement, tell Excel to output “Too Hot” if the temperature is \(\ge 70^\circ\text{C}\) and “Too Cold” if it is \(\le 45^\circ\text{C}\). If the temperature falls between those values, it should output “Drinkable”.

    • Important: Do not hard-code the numbers 70 and 45 into your formula. Use absolute cell references to point to the values in Table 1: User Input that you filled out in Task 1.

  5. Count the Outcomes: In Table 3, use the =COUNTIF() function to determine how many 15-second intervals the coffee spent in the “Too Hot”, “Drinkable”, and “Too Cold” phases.

Expected Value Check#

After completing your calculations:

  • Too Hot: 9

  • Drinkable: 12

  • Too Cold: 0

If your results differ significantly, check your formulas and cell references, or ask for help.