Week 2 notes - R2 as dubble) (enter 2 times) Dim Pie as...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Volume for a right circular cone R1: radius of Lower Base R2: radius of Upper Base h: height Function: h (m) R1 (m) R2 (m) 10 12 9 3487.17 10 13 8 3529.06 12 15 12 6898.94 6 18 4 2588.67 Given the diameter and height of a cylinder find the volume and surface area D: diameter r: radius A: Circular area C: Circumference V: Volume S: Surface Area h: height h(ft) 12 d(ft) r(ft) C(ft) S (ft) 0 0 0.00 0.00 0.00 0.00 1 0.5 0.79 3.14 9.42 37.70 2 1 3.14 6.28 37.70 75.40 3 1.5 7.07 9.42 84.82 113.10 4 2 12.57 12.57 150.80 150.80 5 2.5 19.63 15.71 235.62 188.50 6 3 28.27 18.85 339.29 226.19 7 3.5 38.48 21.99 461.81 263.89 8 4 50.27 25.13 603.19 301.59 9 4.5 63.62 28.27 763.41 339.29 10 5 78.54 31.42 942.48 376.99 V (m 3 ) V (m 3 ) A(ft 2 ) V(ft 3 )
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Save (excel maco enabled work book) code: get the developer tab Visual basic > insert > modual >  Public Function VolCylinder (h as dubble, R1 as dubble,
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: R2 as dubble) (enter 2 times) Dim Pie as dubble Pie=3.141592 (enter 2 times) (make sure option explicit is there then typeVolCylinder=(1/3)*Pie*h*(R1^2+R2^2+R1*R2) Save "= "(formulas > insert functions > User defigned > find your function) select data first (hold control to select more then one row when now next to eachother) select graph (scatterplot) you can edit everything and add labels. 0.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 0.0 10.0 20.0 30.0 40.0 50.0 60.0 70.0 80.0 Cylinder Area Radius, r, ft Area, a, ft^2 0.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 0.0 10.0 20.0 30.0 40.0 50.0 60.0 70.0 80.0 Cylinder Area Radius, r, ft Area, a, ft^2...
View Full Document

This note was uploaded on 09/05/2011 for the course ENG CIV 160 taught by Professor Staff during the Spring '11 term at Iowa State.

Page1 / 3

Week 2 notes - R2 as dubble) (enter 2 times) Dim Pie as...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online