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?

Explanation:

Step1: Convert hours to minutes

Since 1 hour = 60 minutes, if the value of hours is in cell \(A\), the formula to convert hours to minutes is \(=A*60\). For example, if the value of hours is \(2.92\), then the number of minutes is \(2.92\times60 = 175.2\).

Step2: Calculate minutes per mile

The formula for minutes per mile is \(\text{Minutes per mile}=\frac{\text{Total minutes}}{\text{Marathon distance (miles)}}\). Given the marathon distance \(d = 26.21875\) miles. If total minutes \(t=175.2\), then \(\frac{175.2}{26.21875}\approx6.68\) (rounded to two decimal places).

Step3: Calculate miles per minute

The formula for miles per minute is \(\text{Miles per minute}=\frac{\text{Marathon distance (miles)}}{\text{Total minutes}}\). Using \(d = 26.21875\) miles and \(t = 175.2\) minutes, \(\frac{26.21875}{175.2}\approx0.15\) (rounded to two decimal places).

Step4: Calculate miles per hour

The formula for miles per hour is \(\text{Miles per hour}=\frac{\text{Marathon distance (miles)}}{\text{Total hours}}\). With \(d = 26.21875\) miles and \(h=2.92\) hours, \(\frac{26.21875}{2.92}\approx9.0\) (rounded to two decimal places).

For the Excel formula part:

Step1: Excel formula for converting hours to minutes

Since 1 hour has 60 minutes, if the hours - values are in column \(H\) (starting from row 10), the formula in cell \(I10\) (assuming minutes are to be calculated) is \(=H10*60\). This formula can be filled down for other rows.

Answer:

1.

• a. Minutes per mile: For \(2.92\) hours (\(2.92\times60 = 175.2\) minutes), \(\frac{175.2}{26.21875}\approx6.68\); for \(2.88\) hours (\(2.88\times60=172.8\) minutes), \(\frac{172.8}{26.21875}\approx6.59\); for \(2.78\) hours (\(2.78\times60 = 166.8\) minutes), \(\frac{166.8}{26.21875}\approx6.36\)
• b. Miles per minute: For \(175.2\) minutes, \(\frac{26.21875}{175.2}\approx0.15\); for \(172.8\) minutes, \(\frac{26.21875}{172.8}\approx0.15\); for \(166.8\) minutes, \(\frac{26.21875}{166.8}\approx0.16\)
• c. Miles per hour: For \(2.92\) hours, \(\frac{26.21875}{2.92}\approx9.0\); for \(2.88\) hours, \(\frac{26.21875}{2.88}\approx9.10\); for \(2.78\) hours, \(\frac{26.21875}{2.78}\approx9.43\)

1. a. The Excel formula is \(=H10*60\) (assuming hours - values start from cell \(H10\))