Question:Assignment #3Submit Assignment

• Due Monday by 11:55pm
• Points 20
• Submitting a file upload
• Available after Apr 17 at 8am

Objective: Create complete mathematical problem solutions

UseEXCELto compute the following problem solutions. You can put all the problems in one worksheet. Each problem should include:

• title
• variable names
• values
• units

NOTE: the best way to enter scientific numbers into Excel is to usescientific notation. Excel recognizes the letter 'E' (or 'e') as meaningexponent. This is the same as many calculators. To enter 457000, use 457E3.To enter 0.00724, enter 7.24e-3Notice that there is no equal sign, no multiply, and no exponentiation operator. 7.24e-3is thenumerical valuethat is calculated if you enter this into Excel: =7.24 * 10 ^ 3,but much more compact.

PROBLEMS:

1) The equivalent resistance of three resistors in parallel is given by the formula below. Compute it for three resistors whose values are 220, 470, and 330 ohms.

1

Req = -----------------------------

(1/ R1+1/ R2=1/ R3)

Answer: 103.0564784ohms

2) The gravitational force of attraction is given by the formula below. Compute it for the values m₁= 44 x 10⁸, m₂= 81.7 x 10¹⁰, and d = 176 x 10⁶.

km1m2

f = ----------

d²

where f = force in dynes

m1, m2 = masses in grams

d = separation distance, cm

k = gravitational constant, 6.67 x 10^-8

Answer: 0.007740611 dynes

3) Compute the body surface area for a height of 5 ft 9 in. and weight of 170lbs by the following formula (BSA is in square meters):

BSA = 0.007184W^0.425H^0.725

where W = body weight, kg

H = height, cm

Note:A user should be able to enter English units feet, inches, and pounds, into the worksheet. There should be a cell for feet, a cell for inches, and a cell for pounds.

Answer: 1.92779163m²

4) The current passing through an n-type semiconductor is given by the equation below. Compute it for m_n= 3600, E = 100, and n_n= 1.75 x 10¹⁵.

i = qm_nn_nE

where i = current, amp/cm²

q = electron charge, 1.6 x 10^-19Columb

m_n= electron mobility, cm²/volt-sec

n_n= electron density, number/cm²

E = electric field, volts/cm

Answer: 100.8 amp/cm²

5) Let (x1, y1) and (x2, y2) denote the coordinates of any two points in the x-y plane. Compute the distance between the points (-3, 1.5) and (4, -5.5) with the following formula:

dis tan ce = In square root (X2- X1)²+ (Y2+Y1)²

Answer: 9.899494937

COPY AND PASTE EACH PROBLEM FOR THESE!

6) Use your solution from problem 3 to compute the body surface area for a height of 6 ft 1 in. and weight of 185 lbs.

7) Use your solution from problem 4 to compute the current passing through an n-type semiconductor for m_n= 3600, E = 3000, and n_n= 1.75 x 10¹³.

8) Use your solution from problem 5 to compute the distance between the points (0, 6.2) and (-1.1, -2.5).

9) Use your solution from problem 1 to compute the equivalent resistance for resistors values of: 3300, 3300, and 3300.

10) Use your solution from problem 2 to compute the gravitational force for the following values: m₁= 2 x 10⁸, m₂= 93 x 10¹¹, and d = 16 x 10⁵.

Grading

/2 point for each correct and complete solution