Question

1. fill in the table by converting the marathon times from hours into minutes. then use the distance above to compute the rates (2 decimal places):

a. minutes per mile
b. miles per minute
c. miles per hour

1. the first cell in the table for minutes is h10.

a. what formula can you enter into excel that could be filled down to convert hours to minutes?
b. what formula could be entered into cell i10 to compute the rate in minutes per mile?
c. what formula could be entered into cell j10 to compute the rate in miles per minute?
d. what formula could be entered into cell k10 to compute the rate in miles per hour?

Explanation:

Step1: Convert hours to minutes

Since \(1\) hour \( = 60\) minutes, if the value of hours is in cell \(H10\), the formula to convert hours to minutes is \(=H10*60\).

Step2: Compute minutes per mile

The total distance is \(26.21875\) miles (in cell \(D2\)). If the total minutes is in cell \(H10\), the formula for minutes per mile (\(I10\)) is \(=H10/D2\).

Step3: Compute miles per minute

Using the same distance (\(D2\)) and minutes (\(H10\)), the formula for miles per minute (\(J10\)) is \(=D2/H10\).

Step4: Compute miles per hour

Since we want miles per hour and we have hours in \(H10\) (but actually, if we use the distance \(D2\) and hours \(H10\) (after proper relation, note that if we consider the basic rate formula \(rate=\frac{distance}{time}\)), the formula for miles per hour (\(K10\)) is \(=D2/H10\) (because time in hours is \(H10\) and distance is \(D2\)).

Answer:

a. \(=H10*60\)
b. \(=H10/D2\)
c. \(=D2/H10\)
d. \(=D2/H10\)