BRIDGES MATH 115B NAME ___________________________UP-DATED JUNE 2010 IndHw 1.docx Team # ________Individual-Homework #1THIS IS AN INDIVIDUAL HOMEWORK ASSIGNMENT! YOU MUST DO YOUR OWN WORK -- YOU MAY NOT SHARE A COMPUTER WITH ANYONE ELSE. IF YOURWORK SEEMS TO LOOK LIKE SOMEONE ELSE’S, THEN YOU WILL BOTH RECEIVE A SCORE OF ‘0’. THE ENTIRE ASSIGNMENT MUST BE TYPED.1. Open your course file MBD 2 Proj 1.pptx and carefully study slides 2 - 9. Be sure to study Example 1. Now carefully study slides 12 – 15; be sure to study Example 2.Let F(q)=−0.000095 q2+300 and G(q)={200 if q ≤ 750100 if q>750}.Use a blank excel sheet to graph F(q) and G(q) on the same set of axes and on the interval [0, 2100] using 701 data points. Then do the following:(1) Into a word document, copy and paste thefollowing:(a) The column titles: q , F(q),G(q)(b) The first five numbers under these columns(c) The last three numbers under these columnsArrange your work in a chart like the one to the right.(2) Into the same word document, copy the and pastethe graph. Be sure the graph has a main title and titles for each axis. Also construct vertical and horizontal gridlines. (3) In your word document, write each equation as you entered it in excel. q F(q) G(q)BRIDGES MATH 115B NAME ___________________________UP-DATED JUNE 2010 IndHw 1.docx Team # ________2. In MBD 2 Proj 1.pptx, read slides 17-20 – carefully.Use graphing.xlsm to graph the equation y={0 if x <012.7e−x /2.7if x ≥ 0} on the interval [-5, 15].Then do the following:(1) Use the computation boxes to find the value of y when x = 15.(2) Copy and paste the indicators Computation and Plot Interval into your word document.(3) Copy and paste the graph into your word document.(4) In your word document, write the equation as you entered it in excel. 3. In MBD 2 Proj 1.pptx, read slides 21-30. Carefully study Example 1 that begins on slide #21.Below is a chart giving the length of the takeoff roll in feet for a Beechcraft Debonaire at various airport elevations and at a temperature of 20o C.Elevation (ft) sea level 1000 2000 3000 4000Takeoff roll (ft) 670 764 862 972 1096Do the following:(1) Use a blank excel sheet to plot these data points. (2) Find an exponential trend line equation to fit these data points. Display this trend lineon your graph [tap on your graph, then right click and select Format Trendline, then THINK or follow the instructions in slides #24 and #25.(3) Format your trendline to have 5 decimal places [tap on your graph, then right click and select Format Trendline Label / Number / Decimal Places].(4) Extrapolate [see slide #27] your trend line forward 1000 feet [tap on your graph, then right click and select Format Trendline / Forcast / Forward].(5) Give a title to your graph and to each axis. Construct vertical and horizontal gridlines.(6) Copy your completed graph onto your word document. (7) In your word document, use the equation of the trend line to calculate the takeoff roll if the airport elevation is 5000 feet. Show all work. Round your final answer to the nearest 5 decimal places. Do not round numbers in the process of working the problem.(8) Is your answer to part (7) consistent with your graph? Place your answer to this question in a complete sentence.BRIDGES MATH 115B NAME ___________________________UP-DATED JUNE 2010 IndHw 1.docx Team # ________STAPLE YOUR WORK AND HAND IN YOUR WORD DOCUMENT AT THE BEGINNING OF CLASS ON WED JUNE
View Full Document
Unlocking...