Make three plots using Excel: 1. Voltage vs current for the linear resistor data (voltage on vertical axis, current or horizontal). Add a linear trendline with the equation and R? value shown. 2. Voltage vs current for the lightbulb data (voltage on vertical axis, current on horizontal). 3. A plot showing both curves on the same set of axes (voltage on vertical axis, current on horizontal).

Delmar's Standard Textbook Of Electricity
7th Edition
ISBN:9781337900348
Author:Stephen L. Herman
Publisher:Stephen L. Herman
Chapter7: Parallel Circuits
Section: Chapter Questions
Problem 4PP: Using the rules for parallel circuits and Ohmslaw, solve for the missing values....
icon
Related questions
Question
Linear Resistor Data
Lightbulb Data
i(mA)
0.0
v(V)
0.000
i(mA)
0.0
v(V)
0.00
19.0
0.50
11.7
0.588
25.4
1.00
19.9
0.998
31.2
1.50
29.8
1.495
36.3
41.0
2.00
39.8
1.997
2.50
49.7
2.490
45.5
3.00
59.8
3.000
49.6
3.50
69.7
3.500
4.00
4.50
53.5
79.7
4.000
57.1
89.8
4.500
60.8
5.00
99.7
5.000
64.2
5.50
109.6
5.500
6.00
6.50
67.4
119.5
6.000
70.6
129.6
6.500
73.7
7.00
139.5
149.5
7.000
76.6
7.50
7.500
79.5
8.00
159.5
8.000
82.3
8.50
169.6
8.500
85.1
9.00
179.5
9.000
87.8
9.50
189.4
9.500
90.4
10.00
199.4
10.000
Transcribed Image Text:Linear Resistor Data Lightbulb Data i(mA) 0.0 v(V) 0.000 i(mA) 0.0 v(V) 0.00 19.0 0.50 11.7 0.588 25.4 1.00 19.9 0.998 31.2 1.50 29.8 1.495 36.3 41.0 2.00 39.8 1.997 2.50 49.7 2.490 45.5 3.00 59.8 3.000 49.6 3.50 69.7 3.500 4.00 4.50 53.5 79.7 4.000 57.1 89.8 4.500 60.8 5.00 99.7 5.000 64.2 5.50 109.6 5.500 6.00 6.50 67.4 119.5 6.000 70.6 129.6 6.500 73.7 7.00 139.5 149.5 7.000 76.6 7.50 7.500 79.5 8.00 159.5 8.000 82.3 8.50 169.6 8.500 85.1 9.00 179.5 9.000 87.8 9.50 189.4 9.500 90.4 10.00 199.4 10.000
Make three plots using Excel:
1. Voltage vs current for the linear resistor data (voltage on vertical axis, current on
horizontal). Add a linear trendline with the equation and R² value shown.
2. Voltage vs current for the lightbulb data (voltage on vertical axis, current on
horizontal).
3. A plot showing both curves on the same set of axes (voltage on vertical axis,
current on horizontal).
Transcribed Image Text:Make three plots using Excel: 1. Voltage vs current for the linear resistor data (voltage on vertical axis, current on horizontal). Add a linear trendline with the equation and R² value shown. 2. Voltage vs current for the lightbulb data (voltage on vertical axis, current on horizontal). 3. A plot showing both curves on the same set of axes (voltage on vertical axis, current on horizontal).
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Solar cell
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, electrical-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Delmar's Standard Textbook Of Electricity
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:
9781337900348
Author:
Stephen L. Herman
Publisher:
Cengage Learning