Computer Applications Test 1

Computer Applications Test 1 - CEE 3804 Computer...

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CEE 3804 Computer Applications for GEE 9 7 J Test #1 October 4,2006 llonnr Pledge: l have neither given not received unauthorized aid fur this exam a r -‘f ~ fl ‘ l I . —1 -—¥ fl Signature V Name (Print) This exam is ciosed book. Do all work to be graded on these sheets. Them N a lbmaula shun-l un theback page. Good luck! NEATNESS COUNTS! |)(5 ptsflreccntly sewaI-shin with Thereare only [0 types ufpeople in the world - Time who understand binary and those whn dun'l. Very briefly‘ expiain whal Ihis memorwhy i1 is funny. _ , c c 1+ 1; mike api'ey cm womie bl; 50: :2“ >“‘-’ u” “we” ‘ flu-“1936,l | H) - Elm surfing ” (O rypcg 5i peep-E Itiflm‘w‘l“ lo 1, MW lnvufless {u [gauge tub.- t. 17¢ r. A um“, .r v 2) (10 pts) Use an IFO function (0 mum one ufthme possibilities depending on the accclcmmm stored in eel] Al . Inn is positive (greater than 0). return “Accelerating”. lfA] is equal In I). return "Steady". Finally. if Al is negative (less then 0)‘ return "Decelerating‘i Wrilt‘ the formula exactly as iI would appear in 1 DC" on a worksheet. A l >0 Madam-i3," m= o ‘ and," . - an. A (O ’ Uecglu I ‘ ,. . u <- ii—‘(A|>o, 'Auelnw‘fin , {FKAtcoi‘_3_e_c:recn+~- , sieaciv J) 3 'p on \re heen‘as‘km’m cémcmrs from a nit—n linehr rugm N predict C: C =41 explx‘)+yr -,6]2 Where ul 5, and 7 are (he parameters Io be esumatctL and x and [are the madcpendrm variahles :1) Write the l'unmtia in call ’9 using an appropriale mix of absulutc and relative cull addresse> so that the fen-hula can be copied down llIC cohamn (WES/‘06 b) Complete the-steps W10 solve the nonlinear [egressiwn and [iii in the approprime entries ilnhe Solver window. Assume that the Solver Options (e.g. convergence, m]erance}ue m pmpefly. 111m unnamed cells. You amusedouble qunles a: arrows to indicate copyingthefamfladowafiumthnoeflabove. 09/261015 4) (10 pix) Fora given computer with Machine epsilon = 10" . Moo-l Overflow = [0m Underflow= {0‘10 What will the mmpmer mum for each afthe following calculal'mns: / a) 10" * 10’ = I K mm! = “raw am / / d)1234567+1 - H35%”:90 / n b}2*10' = lac/“wow e) 1.234567 + 0.000001 : L1 395 5H5 pm) Them are 2 cliffemm Newton equalion formulas provided nn the equation sheet: . W : _f(I.) x =, 1"li mi'h-r-i-u‘. W 16.: x. and .u mg?" a“ Whatisflm diifezance? What type of him is mach usad In solve? = 9' 1 ‘ ’l Edgy... -_Ma(,+:m4a Engl 4M exiting“? Ul'aty'r'PlLI-PS [luau-La 96F? f . . .7 n, magi-“g; |’_,U";4a(( 10\upt.yta*un1 13 41.4 i ‘4 . mu or a l H_ _ I #- 7 mm (as p13) Ske‘lch a root finding example prublem lhal would cause dill‘iculty fur NL‘Wlfln's Method based on a given sunning value. Briefly explain what the problem is. Clearly label {he sliding value and the first iteration or two (sufficient Ihai the problem is clear) an the gmph. llow canthe problT be annealed? “affine, Vbng 2": rhfiml'a °'- \ \5" “4.14052” 1W; WW (in \ L}? (.31 act luff U1" ( (WJJmQ-‘é MW) (flag-{N5 \‘- 4‘ hi. 09/26/06 mu p15)Youwmaofinfltheromafj(x)=!0"-(H+27) in Excel n) This problem is designed to be simple mammaryau can salve it clixenly. What is the root for this function? E -3 / b) Using Goal Seal; with a mining guessofxflflfland Toolsa‘OpfioWCaimflafiansMaxhnmn Change set to 09mm, 1]): following is obtained : W (5 i:- Flld Um mot If 7 lx 3.1664357? | 8.9431 E-W " ‘ "'1— V._ - 437 DidExneifindawlutiun? lairwrrect? Whyorwhyno EXcel M adeH-m wan-s 110+ can-ed MGM. Correci answefls :5 _‘[‘he rmnza bk fie makchmtbe. Lvafi ga’r 3+ IO" 50 gal-mud) n_+ pm :2? a $9, m'—.I,‘.cffm by kO-‘K (Mam 3+ was «wed-{ii as qgmb A... W - \é be. 4mm“ a]. gem mew; awl\'t"’+""‘ wan go 8.0%):157 (5‘ Nb“. “Mk 'd' has Wrighi- ame a , , Wchga- value 1 50 091261136 {. l0 0) Using Solverwilh a starring guess ofxfllm and convergence set in 0.!)9‘1001, [be following qmpm isoblainecl News the mains value andihe mapping aim-inure the I: as for Goal Seek. Did Soiverfindasoluiion? Bitumen? Whyorwhy nul? V 1‘; K Sduer {came} aSciUi'ifi‘n loci H. fig/nr'corrzch film ‘ 4 Jane. M (dam «Hat Exam 3 arm a .- pg «2313.14. I We com "3 2+“?D lo" Mqu aruue/ 1+ qgj R) W.“ so “eds '+ a u d) Comments; .hnerpmticin cafififixsgek with Cell C4 fmmd a sniuliun."rAnd “Solver famduolutiun.” I ’ _. 33‘) 3f?“ did Lu: swam}. msz \mfiaai --. .1: \Jmcua (‘H’ a La nod-mm since. w‘q pneu- Ikh‘ci 4w r-“élkt answer wk... 8H5 p18)me Simpson Magi-anion methods more aecuratelhanthc id method. if eiflmrcanbeapplied? shy-3,“ "n'i'efiili'im took: nxx tilt: em" r s r. i a pot-h + ref-A“! 3“! punts. Mme 'a".+1’d§.‘£ro f may .JVk-J We ;:k._.~‘_3-. fines m a aging]. W: smwms camp?sz Hue 4w \ mead-ck (Sees. 9) (10 p15) Write a mum Visual Basic for Applicafions userdefincd function named C2F0 lhfll cnnvem deyws Cenfi e to degrees Fahnmhl [“F = 95 “C +32) lfthe “C is stored in Al, an example use bfthe nclion is =C2FlAl) Wfi-fc'an gag-maxi thL RNA”; ('32( K as yLL‘er) a"; -‘, c a: 4%,“ K) +31 \ enrr {unci'iafl 09126196 I I) (10 pix) Us: the trapezoid rule to evalualc the area nffiH (Le. the while open area in the figure below) needed for the following pmblem: 4——u‘0|- 4——50 m——> ‘8 o o-Juoouwo 8 (I‘lflfifflfi ...
View Full Document

This note was uploaded on 04/08/2008 for the course CEE 3804 taught by Professor Aatrani during the Fall '07 term at Virginia Tech.

Page1 / 7

Computer Applications Test 1 - CEE 3804 Computer...

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

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