I have to do this problem using Microsoft Excel.(adsbygoogle = window.adsbygoogle || []).push({});

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.

**Physics Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Homework Help: Help with Vector Excel lab

**Physics Forums | Science Articles, Homework Help, Discussion**