I have to do this problem using Microsoft Excel. A motorboat leaves the dock and travels in a direction 15 degrees East of North for 20 minutes at a constant speed of 20 miles/hour. At that point the boat abruptly changes its direction to 20 degrees South of West and its speed to 25 miles/hour and continues on that new course for 35 minutes. Assuming that the lake is still, calculate the answers to the following questions: (a) What is the boat's displacement (magnitude and direction) after 55 minutes? (b) What is the total distance travelled by the boat? (c) What is the boat's average velocity (magnitude and direction) after 55 minutes? (d) What is the boat's average speed after 55 minutes? First leg: (15 degrees East of North) Time ? minutes Speed ? miles/hr Magnitude of displacement #1 ? miles Second leg: (20 degrees South of West) Time ? minutes Speed ? miles/hr Magnitude of displacement #2 ? miles Choose the +x coordinate as East and the +y coordinate as North. Find the x and y components of the two displacement vectors. x-comp. y-comp. displacement #1 ? ? displacement #2 ? ? total displacement ? ? magnitude direction total displacement ? ? total distance travelled ? average velocity ? ? average speed ? Obviously each area with a ? needs data or an equation filled in there. If some people can guide me through this, it'd be greatly appreciated.