EGR_102_Exam_1_Review_Excel_Solutions

# EGR_102_Exam_1_Review_Excel_Solutions - 2.541 0.15 2.577...

This preview shows page 1. Sign up to view the full content.

Exam 1 Review Problem 1 a 1 b 10 c 10 x y -20 210 -18 154 -16 106 -14 66 -12 34 -10 10 -8 -6 -6 -14 -4 -14 -2 -6 0 10 2 34 4 66 6 106 8 154 10 210 12 274 14 346 16 426 18 514 20 610 Goal Seek Result x y -1.127 0.000 -8.873 0.000 Exam 1 Review Problem 2 a 1 c 10 x b y -20 15 110 -18 15 64 -16 15 26 -14 15 -4 -12 15 -26 -10 15 -40 -8 15 -46 -6 15 -44 -4 10 -14 -2 10 -6 0 10 10 2 10 34 4 10 66 6 5 76 8 5 114 10 5 160 12 5 214 14 5 276 16 5 346 18 5 424 20 5 510 Goal Seek Result x b y -1.127 10 0.000 -14.301 15 0.000 Exam 1 Review Problem 3 Constants Given Voltage (V) 1600 Volts Resistance (R) 580 Ohms Inductance (L) 32 Henries Calculated Constants K 2.7586 amps τ 0.0552 sec Current Calculation Time (t) Current (I) sec amps 0 0.000 0.01 0.457 0.02 0.839 0.03 1.157 0.04 1.423 0.05 1.644 0.06 1.829 0.07 1.983 0.08 2.112 0.09 2.219 0.1 2.308 0.11 2.383 0.12 2.445 0.13 2.497 0.14
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2.541 0.15 2.577 0.16 2.607 0.17 2.632 0.18 2.653 0.19 2.670 0.2 2.685 Goal Seek Results Inductance L = 12.255 Henries so that current I = 2.5 amps at t = 0.05 sec-25-20-15-10-5 5 10 15 20 25-100 100 200 300 400 500 600 Quadratic y = a*x^2 + b*x + c x y-25-20-15-10-5 5 10 15 20 25-100 100 200 300 400 500 600 700 Quadratic y = a*x^2 + b*x + c x 0.05 0.1 0.15 0.2 0.25 0.000 0.500 1.000 1.500 2.000 2.500 3.000 Current in Inductance Circuit Time (seconds) Current (amps) ( 29 ( 29 τ / 1 ) ( t e K t I--= R V K = R L =...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online