I need help creating a graph in Excel for the tables below. It needs to be Vce vs Ic and plots the Ib average for each table. The averages are below. Please show step by step. V1 = 4V V2 (V) Ib (µA) Ic (mA) Ie (mA) Vce (mV) Beta 0 11.5 -0.00794 -0.00356 7.94 -0.000690434783 1 11.1 0.701 -0.712 299 0.0631531532 2 11.1 0.711 -0.722 1290 0.0640540541 Table 1: V1 = 4, V2= 0-2 V V1 = 6V V2 (V) Ib (µA) Ic (mA) Ie (mA) Vce (mV) Beta 0 18.1 -0.0105 -0.00761 10.5 -0.000580110497 1 17.8 0.856 -0.874 144 0.0480898876 2 17.8 1.20 -1.22 797 0.0674157303 3 17.8 1.22 -1.25 1780 0.0685393258 Table 2: V1 = 6, V2= 0-3 V V1 = 8V V2 (V) Ib (µA) Ic (mA) Ie (mA) Vce (mV) Beta 0 24.7 -0.0123 -0.0125 12.3 -0.000497975709 1 24.5 0.878 -0.903 122 0.0358367347 2 24.4 1.71 -1.73 291 0.0700819672 4 24.4 1.76 -1.78 2240 0.0721311475 Table 3: V1 = 8, V2= 0-4 V V1 = 10V V2 (V) Ib (µA) Ic (mA) Ie (mA) Vce (mV) Beta 0 31.4 -0.0136 -0.0178 13.6 -0.000433121019 1 31.1 0.89 -0.921 110 0.0286173633 2 31.1 1.84 -1.87 162 0.0591639871 5 31.0 2.31 -2.34 2690 0.074516129 Table 4: V1 = 10, V2= 0-5 V Table 1 ~ Ib = (11.5+11.1+11.1)/3 = 11.23 Table 2 ~ Ib = (18.1+17.8+17.8+17.8)/4 = 17.875 Table 3 ~ Ib = (24.7+24.5+24.4+24.4)/4 = 19.6 Table 4 ~ Ib = (31.4+31.1+31.1+31.0)/4 = 31.15 It needs to look something like the graph attached

Introductory Circuit Analysis (13th Edition)

13th Edition

ISBN:9780133923605

Author:Robert L. Boylestad

Publisher:Robert L. Boylestad

Chapter1: Introduction

Section: Chapter Questions

Problem 1P: Visit your local library (at school or home) and describe the extent to which it provides literature...

See similar textbooks

Related questions

Concept explainers

Question

I need help creating a graph in Excel for the tables below. It needs to be Vce vs Ic and plots the Ib average for each table. The averages are below. Please show step by step.

V1 = 4V
V2 (V)	Ib (µA)	Ic (mA)	Ie (mA)	Vce (mV)	Beta
0	11.5	-0.00794	-0.00356	7.94	-0.000690434783
1	11.1	0.701	-0.712	299	0.0631531532
2	11.1	0.711	-0.722	1290	0.0640540541

Table 1: V1 = 4, V2= 0-2 V

V1 = 6V
V2 (V)	Ib (µA)	Ic (mA)	Ie (mA)	Vce (mV)	Beta
0	18.1	-0.0105	-0.00761	10.5	-0.000580110497
1	17.8	0.856	-0.874	144	0.0480898876
2	17.8	1.20	-1.22	797	0.0674157303
3	17.8	1.22	-1.25	1780	0.0685393258

Table 2: V1 = 6, V2= 0-3 V

V1 = 8V
V2 (V)	Ib (µA)	Ic (mA)	Ie (mA)	Vce (mV)	Beta
0	24.7	-0.0123	-0.0125	12.3	-0.000497975709
1	24.5	0.878	-0.903	122	0.0358367347
2	24.4	1.71	-1.73	291	0.0700819672
4	24.4	1.76	-1.78	2240	0.0721311475

Table 3: V1 = 8, V2= 0-4 V

V1 = 10V
V2 (V)	Ib (µA)	Ic (mA)	Ie (mA)	Vce (mV)	Beta
0	31.4	-0.0136	-0.0178	13.6	-0.000433121019
1	31.1	0.89	-0.921	110	0.0286173633
2	31.1	1.84	-1.87	162	0.0591639871
5	31.0	2.31	-2.34	2690	0.074516129

Table 4: V1 = 10, V2= 0-5 V

Table 1 ~ I_b = (11.5+11.1+11.1)/3 = 11.23

Table 2 ~ I_b = (18.1+17.8+17.8+17.8)/4 = 17.875

Table 3 ~ I_b = (24.7+24.5+24.4+24.4)/4 = 19.6

Table 4 ~ I_b = (31.4+31.1+31.1+31.0)/4 = 31.15

It needs to look something like the graph attached

Ic (mA)
10
8
2
0
0
lb 11.23 mA
2.5
Plotted lb
lb 17.8 mA
5
Vce (V)
lb = 24.5 mA
7.5
lb = 31.1 mA
10

Expert Solution

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

P-channel Metal-Oxide Semiconductor (PMOS), N-channel Metal-Oxide Semiconductor (NMOS), and Complementary Metal-Oxide Semiconductor (CMOS)

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