|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
M6032550G2Diode
|
|
|
|
|
|
|
Group impossible
|
|
|
|
|
|
|
name
|
M
|
No.
|
|
|
|
|
นายณรัฐ วิโรจนวัธน์
|
603
|
10
|
|
|
|
|
นายณัฎฐพรหิรัตนพันธุ์
|
603
|
12
|
|
|
|
|
นายธนวัฒน์ ขุราษี
|
603
|
15
|
|
|
|
|
|
|
|
|
|
|
|
TABLE1
|
|
|
|
|
|
|
NO.
|
V(V)
|
I(mA)
|
I(A)
|
logV
|
logI
|
|
1
|
0.50
|
0.10
|
1.00E-04
|
-3.01E-01
|
-4.00E+00
|
|
2
|
0.56
|
0.25
|
2.50E-04
|
-2.52E-01
|
-3.60E+00
|
|
3
|
0.60
|
0.50
|
5.00E-04
|
-2.22E-01
|
-3.30E+00
|
|
4
|
0.70
|
0.75
|
7.50E-04
|
-1.55E-01
|
-3.12E+00
|
|
5
|
0.75
|
1.00
|
1.00E-03
|
-1.25E-01
|
-3.00E+00
|
|
6
|
0.82
|
1.40
|
1.40E-03
|
-8.62E-02
|
-2.85E+00
|
|
7
|
0.90
|
1.60
|
1.60E-03
|
-4.58E-02
|
-2.80E+00
|
|
8
|
1.10
|
1.90
|
1.90E-03
|
4.14E-02
|
-2.72E+00
|
|
9
|
1.15
|
2.45
|
2.45E-03
|
6.07E-02
|
-2.61E+00
|
|
10
|
1.23
|
5.00
|
5.00E-03
|
8.99E-02
|
-2.30E+00
|
|
11
|
1.45
|
7.50
|
7.50E-03
|
1.61E-01
|
-2.12E+00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TABLE2
|
|
|
|
|
|
|
Graph Analysis
|
var.
|
value
|
excel_code
|
|
|
|
จาก I=KV^n;logI=logK+nlogV
|
|
|
hypothesis
|
|
|
|
y = 3.4912x - 2.6843
|
|
|
Add Trend_Line
|
|
|
|
Rsq = 0.9339
|
|
6.45E-01
|
=rsq(F3:F13,E3:E13)
|
|
|
|
Intercept
|
logK=
|
-1.45E+00
|
=INTERCEPT(F3:F13,E3:E13)
|
|
|
|
Ans1
|
K=10^(logK)
|
1.00E+00
|
=10^($C$38)
|
|
|
|
Slope
|
n
|
9.33E+00
|
=slope(F3:F13,E3:E13)
|
|
|
|
Ans2
|
I=1.00E+00*V^4.53
|
|
|
|
|
|
สรุป การนำกระแสไฟฟ้าของ Diode ไม่เป็นไปตามกฏของ โอมห์
|
|
|
|
|
|