24小时热门版块排行榜

返回列表

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.

回复此楼