Question:
(Asked again) I need the full equation for mph, given distance and time.?
jeffpa
2006-11-19 09:53:12 UTC
Basically time is appx 4-8 seconds, distance is
fixed at 150 feet.

I need to make an equation to plug into excel so I can use collected video to compute MPH of cars traveling across my property.
Nine answers:
actuator
2006-11-19 10:09:55 UTC
D = distance in feet

t = time in seconds

S = speed in miles per hour



[D feet x (1 mile/5280 feet)] / [t seconds x (1 hour/3600 seconds)]

= S miles per hour



Doing the arithmetic, we get:

0.6818 D / t = S mph



If D is 150 feet and t is 4 seconds,

0.6818 (150)/ 4 = 25.56 mph



If the time is 8 seconds, the speed would be half as much, or

12.78 mph
2006-11-19 10:20:31 UTC
150 feet in 8 seconds;

150/8 x 60 x 60 / 5280 = 12.78 mph



150 feet in 7 seconds;

150/7 x 60 x 60 / 5280 = 14.61 mph



150 feet in 6 seconds;

150/6 x 60 x 60 / 5280 = 17.05 mph



150 feet in 5 seconds;

150/5 x 60 x 60 / 5280 = 20.45 mph



150 feet in 4 seconds;

150/4 x 60 x 60 / 5280 = 25.57 mph
Aurelius
2006-11-19 10:01:06 UTC
If you are talking in feet and seconds, since there are 5280 feet per mile, and 3600 seconds per hour, the formula would be:



3600/5280 * feet/seconds



For your general numbers:



=(3600*150)/(5280*x)



At 4 seconds, 25 mph, at 8 seconds, nearly 13mph.
Steve
2006-11-19 10:01:41 UTC
Divide the time in seconds into 102.272



This will give the speed in MPH



Assumptions: 3600 sec/hr, 5280 ft/mi, distance = 150 ft
ve1luv
2006-11-19 10:08:36 UTC
your joking right?



MPH = miles/hours



150feet/5280feet/mile = 0.028409 miles



hours = x seconds/3600 seconds/hour



eg 8 seconds = 8/3600 = 0.0022222 hours



So take the miles and divide it by time.



For 150 feet in 8 seconds is 0.028409/0.0022222 = 12.78 MPH
2016-05-22 07:35:53 UTC
If I gave you a suitcase full of bacon, but you had to come to California to pick it up...... .....what time could I expect you at? And another one: POLL: It's OK to steal material from your contacts, as long as you say a prayer first asking that the contact not recognize their own material.
locomonohijo
2006-11-19 09:57:03 UTC
well, the equation for rate is



r=d/t



(r=rate, d=distance, t=time)



To get mph, you need to convert your seconds to hours and your feet to miles, then plug in the varibales and solve.
Professor
2006-11-19 10:08:27 UTC
+102.2727/Seconds



If the time is 4 seconds, then the answer is +102.2727/4 = 25.568



Put the seconds in the cell for example in A1.

The formula in A2 for the answer is +102.2727/A1

Change the seconds in A1 - you will get the answer in A2.
razburch
2006-11-19 10:00:12 UTC
The formula Distance = Rate x Time expresses one of the most frequently used relations in algebra.

Since an equation remains true as long as you divide through by the same non-zero element on each side, this formula can be written in different ways:





To find rate, divide through on both sides by time:

Distance

Rate = -----------

Time



Rate is distance (given in units such as miles, feet, kilometers, meters, etc.) divided by time (hours, minutes, seconds, etc.). Rate can always be written as a fraction that has distance units in the numerator and time units in the denominator, e.g., 25 miles/1 hour.



To find time, divide through on both sides by rate:

Distance

Time = -----------

Rate



When using this equation, it's important to keep the units straight. For instance, if the rate the problem gives is in miles per hour (mph), then the time needs to be in hours, and the distance in miles. If the time is given in minutes, you will need to divide by 60 to convert it to hours before you can use the equation to find the distance in miles. Always make your units match: if the time is given in fortnights and the distance in furlongs, then the rate should be given in furlongs per fortnight.

You can see why this is true if you look carefully at how the units are expressed. Say a car is travelling at 30 mph and you want to figure out how far it will go in 2 hours. You can use the formula:



Rate x Time = Distance



miles

30 ------- x 2 hours = 60 miles

hour





The hours cancel, leaving only miles.



What if you want to calculate the number of miles a car travelling 30 mph goes in 120 minutes?

Since 120 minutes is equal to two hours (60 minutes in one hour x 2 hours = 120 minutes), we should get the same distance of 60 miles, but we will not get the answer this way:



miles mile minutes

30 ------- x 120 minutes = 3600 --------------

hour hour



Now, 3600 mile minutes per hour isn't very helpful, since we'd like our answer in miles. We need to divide by 60 minutes per hour:

mile minutes 1 hour

3600 -------------- x ------------ = 60 miles

hour 60 minutes



The hours and the minutes cancel, leaving only miles.



Although we can find an answer this way in the correct units, a better method would be to convert minutes to hours before using the formula.





--------------------------------------------------------------------------------



Remembering to be careful about units, let's look at a problem.



Superheroes Liza and Tamar leave the same camp and run in opposite directions. Liza runs 1 mile per second (mps) and Tamar runs 2 mps. How far apart are they in miles after 1 hour?

To begin, we can either convert rates to miles per hour, or we can convert the time to seconds. Let's convert from miles per second to miles per hour.



There are 3600 seconds in an hour, so if Liza runs 1 mile in a second, then she will run at 3600 x 1 = 3600 mph. Similarly, Tamar will run at 3600 x 2 = 7200 mph.



miles 3600 seconds miles

2 -------- x -------------- = 7200 -------

second 1 hour hour



The seconds cancel, leaving miles per hour.

Back to the problem. How far does Liza run in one hour? We know her rate (3600 mph) and the time that she runs (one hour), so we can use the formula:



miles

3600 ------- x 1 hour = 3600 miles

hour



This makes sense because, by definition, if Liza's speed is 3600 miles per hour, then she runs 3600 miles in an hour.

Tamar, whose speed is 7200 miles per hour, will run 7200 miles in an hour.



How far apart will the two runners be after an hour? The answer is simply the sum of the distance each runs in an hour: 3600 + 7200 = 10,800 miles apart.



Since the earth has a circumference of about 24,000 miles at its equator, that's a little less than halfway around the world!





These problems, however, can be tricky:





Karen can row a boat 10 kilometers per hour in still water. In a river where the current is 5 kilometers per hour, it takes her 4 hours longer to row a given distance upstream than to travel the same distance downstream. Find how long it takes her to row upstream, how long to row downstream, and how many kilometers she rows.

One of the best ways to start a problem like this is to make a table that uses all the information you have been given. Let's make one for the information we have about the distance, rate, and time Karen travels when she is going both upstream and downstream. We'll call the time it takes to row downstream x, which means that the time it takes to row upstream is x +4.



We'll start by calculating Karen's rates going upstream and downstream. When she is traveling against the current, she won't be able to row 10 kilometers/hour. Her speed relative to the shore will only be 5 kilometers per hour because the force of the current, which is flowing at 5 kilometers/hour, slows her rate by 5 km/hour. When Karen is rowing downstream, however, the current helps her go faster, so she moves 10 + 5 = 15 km/hour.



We can use the formula, written as Rate x Time = Distance:



Rate (km/hr) Time (hr) Distance (km)



Downstream 15 x 15x



Upstream 5 x+4 5(x+4)



Because Karen goes the same distance upstream and downstream, we know that the two expressions of distance - for upstream and downstream - must be equal; we can set the upstream distance equal to the downstream distance. This produces the following equation, which we solve for x:

Statement of original equation: 15x = 5(x+4)

Distributing on right side: 15x = 5x+20

Subtracting 5x from both sides: 10x = 20

Dividing both sides by 10: x = 2



x equals the time it takes Karen to row downstream, or 2 hours. Since it takes her four hours longer to row upstream, this time will be 2 + 4 = 6 hours.

How many kilometers does she row? Look at the distance column in the table. Since x is in hours, Karen's downstream distance is 15 x 2 = 30 kilometers.



The problem states that Karen rows the same distance upstream as down. Let's check our work... yes, 5(2+4) = 5 x 6 = 30 kilometers.







--------------------------------------------------------------------------------



As is frequently the case with word problems, setting up the equations is the hardest part. Once that's done, the rest is relatively easy. Remember always to answer what the question asks - don't stop once you've solve for x, because that may be only part of what the question asked - and always check your answer.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...