Sheet1
|
|
|
|
|
|
|
|
|
|
Linear 1
|
|
|
|
|
|
|
|
|
y = kx + c
|
|
|
|
|
|
|
|
|
input k(slope)
|
5
|
-5
|
5
|
-5
|
y_intercept
|
|
|
|
input c(Intercept)
|
10
|
10
|
-10
|
-10
|
SLOPE
|
|
|
|
x
|
y1 =+10+5x
|
y2=10-5x
|
y3=-10+5x
|
y4=-10-5x
|
y1_code
|
|
|
|
0
|
10
|
10
|
-10
|
-10
|
=$B$3*A6+$B$4
|
|
|
|
1
|
15
|
5
|
-5
|
-15
|
=$B$3*A7+$B$4
|
|
|
|
2
|
20
|
0
|
0
|
-20
|
=$B$3*A8+$B$4
|
|
|
|
3
|
25
|
-5
|
5
|
-25
|
=$B$3*A9+$B$4
|
|
|
|
4
|
30
|
-10
|
10
|
-30
|
=$B$3*A10+$B$4
|
|
|
|
5
|
35
|
-15
|
15
|
-35
|
=$B$3*A11+$B$4
|
|
|
|
6
|
40
|
-20
|
20
|
-40
|
=$B$3*A12+$B$4
|
|
|
|
x_axis
|
y1_axis
|
y2_axis
|
y3_axis
|
y4_axis
|
graph_analysis_excel_code.
|
|
|
|
intercept=
|
10
|
|
|
|
INTERCEPT(B6:B11,A6:A11)
|
|
|
|
slope=
|
5
|
|
|
|
SLOPE(B6:B11,A6:A11)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
รายชื่อสมาชิกลุ่ม 10
|
|
|
|
|
|
|
|
|
1.นายเขตไท สายปิ่น
|
|
เลขที่3
|
|
|
|
|
|
|
2.นายพงษ์วริศ วิชาญนุวัฒน์
|
|
เลขที่19
|
|
|
|
|
|
|
3.นายปืยพันธ์ ไผ่สนจำลองศรี
|
|
เลขที่18
|
|
|
|
|
|
|
4.นายวรานนท์ เกาะแก้ว
|
|
เลขที่31
|
|
|
|
|
|
|
5.นายอิศริณ อินทรวิเชียร
|
|
เลขที่43
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
physicsmatayom_link
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sheet2
Sheet3
|