In the spreadsheet, the prompts for entering data are in column A. The user enters the data in column B.

a. Write the spreadsheet formula that will calculate the radius in cell B4.
b. Write the spreadsheet formula that will calculate the minimum skid speed in cell B5. The formula for finding that speed is found by taking the ˆš15 times the product of the drag factor and the radius.
c. Verify the accuracy of your formula for the following input values: drag factor, 0.97; chord length, 47ft; and middle ordinate, 5 feet.

Transcribed Image Text:

Enter the road surface drag factor 1in B1 Enter the length of the chord connecting two points on the yaw 2 mark in B2 Enter the length of the middle 3 ordinate in B3. 4 Calculated radius 5 Minimum skid speed