A) In Excel plot Resistance (u?) vs Length/Area, and show the trendline on the g

Question

A) In Excel plot Resistance (u?) vs Length/Area, and show the trendline on the graph. What are the units of the slope of this graph, and what physical quantity does it represent?

B) Calculate the average value of your slopes, then calculate the % error between it, and the accepted value.

L (cm) L/A (cm-1) V(V) i(A) V/i = R(?) R(u?) 5 2466.7 0.028 1.102 0.02541 2.541e-8 10 4933.4 0.047 1.104 0.04257 4.257e-8 15 7400.1 0.066 1.106 0.05967 5.967e-8 20 9866.8 0.085 1.107 0.07678 7.678e-8 gn in 1578.5 1E+11x-1061 y = 2E+11x-2042 R2- 0.7363 2500 1200 1851.2 2000 800 1500 10 394.6 1000 400 200 12 13 14 15 16 0.00E+O0 5.00E-09 100E-08 150E-08 2.00E-08 0.00E+00 5.00E-09 1.00E-08 1.50E-08 2.0OE-08 250E-08 3.00E-08 R vs L/A Brass 0.032 inch diameter R vs L/A Brass 0.020 inch diameter 19 4500 3854.3 12000 20 9866.8 1E+11x-1122.7 R2-0.9988 y 3500 7400.1 2 3000 23 24 2000 25 26 8000 2500 6000 1500 963.6 4000 2000 28 0.00E+005.00E-09 1.00E-08 150E-08 2.00E-08 2 50E-08 3.00E-083.50E-084.00E-08 0.00E+0.00E-082. 00E-08.00E-084.00E-O .0 O0E-088.00E-089.00E-8 Sheet READY +9096

Explanation / Answer

(A) The units of the slop of the graph are u cm. This represents a physical quantity called 'resistivity', which is given by

resistivity = Resistance * (area / length)

(B) The answer is given in below table.

L (cm) L/A (cm-1) V(V) i(A) V/i = R() R(u) Slope m = R / (L/A) Average Slope (ma) % error = (|m-ma|)/ma * 100 5 2466.7 0.028 1.102 0.02541 2.54E-08 1.03E-11 8.69E-12 -1.85E+01 10 4933.4 0.047 1.104 0.04257 4.26E-08 8.63E-12 7.46E-01 15 7400.1 0.066 1.106 0.05967 5.97E-08 8.06E-12 7.25E+00 20 9866.8 0.085 1.107 0.07678 7.68E-08 7.78E-12 -1.05E+01

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.