????2-2??(??????)

admin

???????2-2??(??????)

Excel????????????? ??: ??????????????????????????????excel?????????????????????????????????????????????????????????

???????? ???? Excel ??????

Excel Software in College Physics Experiment

Abstract?With the development of computer technology for the processing of the experimental data provides a great, easy way to use excel software to processing of complex experimental data thus we can save a lot of time in manual calculation and drawing work, and it will also reduce intermediate links miscalculation, thus saving time and improve accuracy.

Keywords: Errors analysis, Sources of errors, Experimental operation, Excel ?. ??????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????Excel

??????????????????????????

?. Excle????

??Excle??????????????????????????????????????????????

?1? average?????????????????? ?2? stdev????????????????? ?3? VAP????????????????

?4? LINEST??????????????????????????

?????

???????????????�??????�??????????????????????????????????????????????

?????????????????????????????????????excle??????????????????????????????????????�=AVERAGE(X,Y)�?X,Y???????????Excle????????????????????????????????????

?????????????????????? ?Excle??

???????????????Excle??????????????????????????????????????????????????????????

???????�????????????????�??????????

?????????????????????????????????????????????????????????????????????????????????????log

I0I0I013??logAS?5.04?10loglog?????????????

TT2T2TT2

?????

1

?????????????????????????????????T

???????A?S????????????????????????I0???????????????????????????U?????Ia????????????????????????????T?logIa?Ua????????Excel???????????logI0????????????????????????????? ???????1/T???????????????????????????????

???????????

?1.?log

I0T2

-

1

????? T

????????????K=-21977??????????

???????????????????????????????????????????????5?IA?UGK????????????????

?1

??1?excel?????1?

??????????????????????????????????????????????????????????excel??????????????????????????????

?????

Excel????????????????????????????????????????????????????????????????????????????????????????Excel???????????????????????????????????

????

[1]???,???,???.??????[M].??:???????,2012. [2]???,???????.????[???].??????????2009.

[3]?????????.Excel???????????????.????????,2007.

[4]??????????????????????????[J].????????,2001.4 [5]??,??,???.??Excel???????????,????,2013.1 [6]???,??,???.????????????????2011

?????????????????

?????????2-2?????

??

??

??????????????????????????????????????I????????????????????????????????????????????????????????????????????????????????????????????????????????�?????�???????????�?????????????????????I?=AST�..?????????I??A?S?T????????????e???????A?S?????????????????????????????e???????A?S????????????????????A?S?

???

?????????????????????

??

????????????????????????????????????????????????��..??????????????????????????????????????????????????????????????????????????????????????

??

??????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????

????�??????????????????????????�?????? I?=AST�..?1?

??I?????????????A?

S?????????????cm2?

K???????

T?????

e????????

A?????????????

????????I??A?S?T????????????e???????A?S?????????????????????????????e???????A?S????

??????

???1?????T2????????

?I?/T2=?2?

???3???????I?/T2?1/T??????????I?/T2??????1/T??????????????????????????????????e???A?S???????I?/T2��1/T?????

?????????????????

?????

???????????? ????? ??? ??? ??????? ????????

??????????????????????????????????????????????????????????????????????

????????????

[????]

1????????????????? 2??????????????

[????]

?????????????????????????????????????????????????????????????????????????

??1??????????????????????

??????????????????

???????????????????

??????L????D??????????

R??

LS

??

4L

?1?????

?D

2

?1?

???????

R?

?U?I

?2?

????U??I????????????????????????????????

??

?D2?U

4L?I

?3?

?????????????????????????????????????

????�????�???????????????????????

???????????????????????????

[????]

?????????????50�10-10A ???0.1????????10V???1.0??????????????????????0.02mm???????????

????????????????????????????????

????????

[????????????]

1?????????????? 2?????????????

??????????????

? ???????????????

?1 ??????????1/50????? ??:__?__?

16

????

L?

?n

1

6

Li?

(1.122?1.124?1.120?1.126?1.122?1.118)?1.122cm

i?1

????A????

n

2

?

uA?

i?1

(Li?L)n(n?1)

?

0.002

2

?0.002

2

?0.004

2

?0.004

2

6?5

?0.0012cm

???????????1-2????????????????

1/50???????

???0.02mm

????B????

uB?

??

3?0.023

?0.012mm

???????

uL?

uA?uB?

2

2

0.01?0.01

22

?0.016mm

???????

B?

?L

L

?100%?

0.01611.22

?100%?0.14%

??????L??????

?L?(11.22?0.02)(mm)

?

B?0.14%?

????????????????????????????????

???

? ???????????????

?2 ????????????????:__?__?

????

D?

6

?n

n

1

Di?

16

(4.002?4.003?4.002?4.000?3.998?3.995)?4.000mm

i?1

????A????

2

?

u

A

(Di?D)n(n?1)

?

?

i?1

0.002

2

?0.003

2

?0.002

6?5

2

?0.002

2

?0.005

2

?0.0012mm

0-25mm??????????

???0.004mm

??????B????

uB?

??

3?0.004

3

?0.0023mm

???????

uD?

uA?uB?

2

2

0.0012

2

?0.0023

2

?0.0026mm

???????

B?

uDD

?100%?

0.00264.000

?100%?0.07%

??????D??????

?D?(4.000?0.003)(mm)?

?B?0.07%

3????????

???????????????????????????????????????????

?3 ???????? ??:__?__?

4?????????????

???3?????6/2=3??????????????3??3I????????U=6V???????????

?3I?

??

3

3

I

?

(I4?I1)?(I5?I2)?(I6?I3)

3

?11.92?10

?10

(A)

?3I????A????

uA?

?(?

3

Ii??3I)

2

n(n?1)

?0.09?10

?10

(A)

??????????

???

?????

100

?50?10

?10

?0.1

100

?0.05?10

?10

(A)

B????

?????3I????????3I

uB?

?

(??3I?I4

2

2

?I4?I1????????????

uBI4)?(

2

??3I?I1

uBI1)

2

(uBI4)?(uBI1)

??

uBI4?uBI1?uBI?

??

3

??

uB?

2uBI?

2??

3?

2?

0.05?10

3

?10

?0.04?10

?10

(A)

???????

u?I?

uA?uB?0.0985?10

2

2

?10

?0.10?10

?10

(A)

???????

B?

u?I?I

?100%?

0.098511.92

?100%?0.8%

???I??????

??I?(11.92?0.10)?10?

?B?0.8%

?10

(A)

????U????????

u?U?

2??

3

?

2?

?????

100

3

?

2?

10?1.0100

3

?0.08(V)

???????????U ?????A?????

???3?????????

??

?D2?U

4L?I

?

3.14159?(4.000?104?1.122?10

?2

?3

)

2

?6.00

?10

?11.92?10

?5.64?10(??m)

6

??????????u????????

u?

222

?????22?????????????222????uD???uL???u?U???u?I?

??L????U????I????D????2

???2D?U?

1/2

?2?u?

I??

2

?

??4???

L?I

?uD?

2

?D2?U???L2?I???D22?uL????L?I??

2

??D2?U2

?u???U??L?2I??

2

?

???

1/2

?????????????????

u?

222

??2u?2

?u?U??uL??u?I??D

???????????????

DL?U?I????????????

1/2

???????????????????????

?

?

22??2u?2?u?2?u?u????UDL?I

???????????????

D?L??U??I?????????

1/2

?5.64?10

6

??2?0.003?2?0.02?2?0.08?2?0.10?2?

??????????????

411.22611.92????????????

1/2

?0.07?10(??m)

6

??

B?

u?

?

?100%?

0.075.64

?100%?1.2%

?????????????

???(5.64?0.07)?106(??m)

?

?B?1.2%

5????????????? ??????????????????????Ui-U0?-?Ii-I0????????Ui-U0?=?U1-U0?,?U2-U0?,�� ?Ii-I0?=?I1-I0?,?I2-I0?,��??????????????????????????????

?x1?4.60?y1?2.35?? ?x2?18.60?y2?9.40??

???????????????, ??????????????????????? ???????

K?

y2?y1x2?x1

?5.03?10(V/A)

9

????3?????????????????????

K?

?U?I

?4?L

?D

2

????????

??K

?D

2

4L

9

?5.03?10?5.68?10

?

3.14159?(4.000?10

4?1.122?10

?2

?3

)

2

6

(??m)

6?????? ???3????U

?4?L

?D2

?

?I

?????y?a?bx??????????y??U ?x??I??Ii?I0? ,???????????

??Ui?U0??a?0?b????b????????

4?L

?D

2

b?

?(?U??I)???????I2??(?U??I)???4?

??I

2

?4 ?????????

?I?Ii?I0,?U?Ui?U0??????

b?

?

(?U??I)

?

?I

2

?

438.0872.1

?10

10

?5.022?10

7

(V/A)


?????2-2??(??????)????????
?????http://www.850500.com/news/17653.html
?????,??!