H14-050-TrapezoidRule.doc Page 1 of 3 2/28/05 METBD 050 Homework 14 – Finding Areas 1. Select the first worksheet in a new workbook and change its name to “Coordinate Method.” Use the coordinate method to find the area of the polygon shown in the figure below. Your worksheet should look like the one shown below. (0,0) (7,6)(3,6)(3,4)(0,4) (9,4)(11,4) (2,0)(2,1)(11,0) (8,1)(8,0)Use a single concatenated text string in a merged cell. ABCDEFGH I1 METBD 050 - Coordinate Method Your Name2 METBD 050.n3 Hwk. N4 Find the area of a polygon with the coordinate method: Date567XYXiYi+1YiXi+18 1 0000920401210 3 3 4181217 10 8 1 8 218 11 2 1 0 219 12 2 0 0 020 1 0 021 Sum = 222324ProductsCoordinatesArea = 48 sq. in.iSome cells not shown.H14-050-TrapezoidRule.doc Page 2 of 3 2/28/05 2. Select the second worksheet in the workbook and change its name to “Trapezoid Method 1”. Find the area under the curve: y = x2 + 4 for values of x = 0 to 10 using the Trapezoid Method. Your worksheet should look like the one shown below. Be sure to find the percent difference between the number you find and the “exact” solution which is 373 1/3. 020406080100120140160024681012X-ValuesY-Valuesy = x2 + 4 ABCDEFGH I1 METBD 050 - Trapezoid Method Your Name2 METBD 050.n3 Hwk. N4 Find the area under a curve using the trapezoid method: Date5 =0.5*G8*(D8+D18+2*SUM(D9:D17))67XY80.004.00∆x = 1.0091.005.0010 2.00 8.00 Area = 375.0011 3.00 13.0012 4.00 20.00 %Difference = -0.44643 %13 5.00 29.0014 6.00 40.0015 7.00 53.0016 8.00 68.0017 9.00 85.0018 10.00 104.0019Coordinates%ExacteApproximatExactDifference% 100×−=Use a ∆X of .50 to find the area. Show cell formula used to find the area like shown above.H14-050-TrapezoidRule.doc Page 3 of 3 2/28/05 Select the third worksheet in the workbook and change its name to “Trapezoid Method 2”. The figure below shows a graph of two functions: y = 9 – x2 and y = -(5/3)x + 5. 1. Create the graph of the two functions as shown in the figure. Format your axes and chart as shown. You can show your chart in the worksheet as shown. Be sure to add the “cross-hatching” between the two functions by adding additional data series. 2. Find the area between the two curves using the Trapezoid Method discussed in class. 3. Print your worksheet, displaying gridlines and row & column headers. Staple your sheets together, in
View Full Document
Unlocking...