My teacher wants us to solve this using excel. I'll leave out the extra stuff. "Your radar provides the following information about the incoming warhead at time of detection (t=0 seconds): vertical hight= 490,000 feet (about 93 miles) with an incoming vertical velocity= -4,107 feet/second. You know the following information about your Patriot missiles located at sea level: initial upwards velocity if 6,115 ft/second. You also know that each Chinese missile is typically designed to explode at 3 miles (about 16,000 feet) above the ground... armed with this information and using quadratic mathematics and MS Excel, answer the following questions: 1. If your missiles require a minimum of 10 seconds to launch from t=0, calculate the time and altitude of earliest interception. 2. What is the latest time (as measured from t=0) that you can launch the Patriots and still expect to intercept the missile...?" He wants us to put everything, including graphs, in a word document with the answers to the questions. I'd like to know how to get the functions to enter into excel. The early and late Patriot launches are confusing...
in Word Problem Answers by

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

1 Answer

The mathematical equation for the warhead's height after time t seconds is h=490000-4107t. At t=0, h=490000.

The intercepting missiles are delayed by 10 seconds so the equation for their height is h=6115(t-10) so that when t=10, h=0. The warheads and interceptors are assumed to moving at uniform velocity, so graphically the height equations for both missiles are straight lines. Where they cross represents interception, which must take place before the warheads explode at h=16000. t=(490000-16000)/4107=115.41secs.

To find out the earliest time for interception we have 6115(t-10)=490000-4107t, when the missile and interceptor are at the same height. 6115t-61150=490000-4107t; 10222t=551150, t=53.92 secs. (h=268,550.56 ft approx.)

The latest time for interception is t=115.41 secs when the missiles explode. To reach a height of 16000 feet it takes the interceptor 16000/6115=2.62 seconds. Add on the 10 seconds to launch=12.62 secs. It takes the missile 115.41 secs to reach 16000 feet so the interceptor must be launched no later than t=115.41-12.62=102.79 seconds.

To illustrate this using Excel we could draw the two graphs initially, h being the vertical axis and t the horizontal: h=490000-4107t and h=6115(t-10). This represents the earliest time of interception. Then we need to "slide" h=6115(t-10) to the right to cross the other graph where h=16000. Where this shifted graph intercepts the t axis should correspond to 102.79 seconds. Some scaling down will be necessary for h perhaps measuring height in 1000's or 10000's of feet. The t axis should be scaled to accommodate about 120 seconds and of course the origin is on the extreme left.

If a graph is not used, Excel formula should be used to create a table of h and t values suitably spaced.

=IF(A1<10,0,6115*(A1-10)) can be used as a formula for the interceptor.

=IF(490000-4107*A1<16000,16000,490000-4107*A1) can be used as a formula for the missile. The graph can be inserted using the tabulated data.

Cell A1 contains t, so column A contains all the values of t you want to use. B1 and C1 correspondingly contain data for h for the two lines.

by Top Rated User (1.1m points)

Related questions

1 answer
asked Mar 6, 2021 in Algebra 1 Answers by anonymous | 219 views
2 answers
asked Jun 9, 2020 by donnie58744 Level 1 User (120 points) | 710 views
2 answers
asked Aug 22, 2019 in Algebra 1 Answers by stevenscottoddballz Level 1 User (120 points) | 350 views
1 answer
asked Jan 27, 2017 in Algebra 2 Answers by dancing lashes Level 1 User (140 points) | 528 views
1 answer
asked Jan 11, 2015 in Pre-Algebra Answers by anonymous | 496 views
Welcome to MathHomeworkAnswers.org, where students, teachers and math enthusiasts can ask and answer any math question. Get help and answers to any math problem including algebra, trigonometry, geometry, calculus, trigonometry, fractions, solving expression, simplifying expressions and more. Get answers to math questions. Help is always 100% free!

Most popular tags

algebra problems solving equations word problems calculating percentages math problem geometry problems calculus problems math fraction problems trigonometry problems rounding numbers simplifying expressions solve for x order of operations probability algebra pre algebra problems word problem evaluate the expression slope intercept form statistics problems factoring polynomials solving inequalities 6th grade math how to find y intercept equation of a line sequences and series algebra 2 problems logarithmic equations solving systems of equations by substitution dividing fractions greatest common factor square roots geometric shapes graphing linear equations long division solving systems of equations least to greatest dividing decimals substitution method proving trigonometric identities least common multiple factoring polynomials ratio and proportion trig identity precalculus problems standard form of an equation solving equations with fractions http: mathhomeworkanswers.org ask# function of x calculus slope of a line through 2 points algebraic expressions solving equations with variables on both sides college algebra domain of a function solving systems of equations by elimination differential equation algebra word problems distributive property solving quadratic equations perimeter of a rectangle trinomial factoring factors of a number fraction word problems slope of a line limit of a function greater than or less than geometry division fractions how to find x intercept differentiation exponents 8th grade math simplifying fractions geometry 10th grade equivalent fractions inverse function area of a triangle elimination method story problems standard deviation integral ratios simplify systems of equations containing three variables width of a rectangle percentages area of a circle circumference of a circle place value solving triangles parallel lines mathematical proofs solving linear equations 5th grade math mixed numbers to improper fractions scientific notation problems quadratic functions number of sides of a polygon length of a rectangle statistics zeros of a function prime factorization percents algebra 1 evaluating functions derivative of a function equation area of a rectangle lowest common denominator solving systems of equations by graphing integers algebra 2 diameter of a circle dividing polynomials vertex of a parabola calculus problem perpendicular lines combining like terms complex numbers geometry word problems converting fractions to decimals finding the nth term range of a function 4th grade math greatest to least ordered pairs functions radius of a circle least common denominator slope unit conversion solve for y calculators solving radical equations calculate distance between two points area word problems equation of a tangent line multiplying fractions chemistry binomial expansion place values absolute value round to the nearest tenth common denominator sets set builder notation please help me to answer this step by step significant figures simplifying radicals arithmetic sequences median age problem trigonometry graphing derivatives number patterns adding fractions radicals midpoint of a line roots of polynomials product of two consecutive numbers limits decimals compound interest please help pre-algebra problems divisibility rules graphing functions subtracting fractions angles numbers discrete mathematics volume of a cylinder simultaneous equations integration probability of an event comparing decimals factor by grouping vectors percentage expanded forms rational irrational numbers improper fractions to mixed numbers algebra1 matrices logarithms how to complete the square mean statistics problem analytic geometry geometry problem rounding decimals 5th grade math problems solving equations with variables solving quadratic equations by completing the square simplifying trigonometric equation using identities
87,441 questions
99,039 answers
2,422 comments
16,939 users