ECE 201L Circuit Analysis Laboratory
Prelab 1
This lab provides experience with resistors and multimeter measurements.
- Bring your laptop computer to the lab
- Look up the terms Resistor, Multimeter, and Breadboard on the internet. Be prepared to discuss,
describe, and demonstrate what you have learned.
- If you wanted to buy resistors, a multimeter, and a small electronics breadboard, how much would you likely spend and
where would you buy them from?
- Given the following set of numbers, use Excel to find the average, the standard deviation, the median, and the 10-90% range.
| 20.3
|
| 19.8
|
| 20.7
|
| 21.2
|
| 20.5
|
| 20
|
| 19.9
|
| 21.1
|
| 20.7
|
| 20.4
|
| 20.7
|
| 20.5
|
| 20.7
|
| 20.8
|
- Given the following table of values, use Excel to plot the data and a linear trend line.
Do not connect the data points themselves. Find the slope and intercept using Excel formulas.
| Voltage (V) | Current (mA)
|
| 1.02 | 22.81
|
| 2.06 | 45.95
|
| 3.09 | 68.77
|
| 4.05 | 89.59
|
| 5.03 | 110.84
|
| 6.04 | 147.90
|