Question: 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
In the spreadsheet, the prompts for entering data are in column A. The user enters the data in column B.
.png)
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.
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
Step by Step Solution
3.45 Rating (152 Votes )
There are 3 Steps involved in it
a B228B3B32 b sqrt15B1... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
790-L-A-L-S (1760).docx
120 KBs Word File
