24小时热门版块排行榜

>论坛更新日志 (1273)
>虫友互识 (34)
>论文投稿 (24)
>导师招生 (23)
>考研 (21)
>基金申请 (17)
>教师之家 (17)
>硕博家园 (17)
>找工作 (17)
>考博 (16)
>公派出国 (16)
>休闲灌水 (15)
>博后之家 (14)
>论文道贺祈福 (11)
>有机交流 (11)
>文献求助 (9)

返回列表

jieer567

新虫 (初入文坛)

应助: 0 (幼儿园)
金币: 31.5
帖子: 13
在线: 43.3小时
虫号: 1658810
注册: 2012-03-02
性别: MM
专业: 环境分析化学

[求助] 急求!! excel怎么求斜率和纵坐标的标准偏差

急求!!哪位大侠知道在excel，怎么求一条直线的斜率和纵坐标的标准偏差，审稿人给我步骤看不懂，哪位能给看看
the standard deviations in both the slope and the ordinate at the origin. You can calculate this from Excel as:
a) load the x- and y values in columns.
b) select with the mouse a square of 5 columns x 2 files.
c) select successively “insert”, “function” and “lineal estimation”.
d) insert in the four folders now appearing, successively the y-values, the x-values, “1” and “1”.
e) place the cursor in the “fx” folder appearing over the main window.
f) then, press “ctrl” “shift” and “enter” simultaneously.
g) In the marked space will appear:
First column, first line: slope.
First column, second line: standard deviation in the slope.
Second column, first line: ordinate at the origin.
Second column, second line: standard deviation in the ordinate at the origin.

回复此楼