指定单元格的值作为区域索引范围:
例如: E34单元格值为 2 E35单元格值为 10
INDIRECT(“p”&$EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("p"&̲E$35) 表示选中 p2:p10
线性相关系数R平方CORREL(p2:p10,c2:c10)^2 与以下等效
CORREL(INDIRECT(“p”&$EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("p"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 18: …), INDIRECT("c"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("c"&̲E$35))^2
同理,相关函数斜率 k 也可表示为:
SLOPE(INDIRECT(“p”&$EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("p"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 17: …5),INDIRECT("c"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("c"&̲E$35))
同理,相关函数截距 b 也可表示为:
=INTERCEPT(INDIRECT(“p”&$EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("p"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 18: …), INDIRECT("c"&̲EKaTeX parse error: Expected 'EOF', got '&' at position 17: …4):INDIRECT("c"&̲E$35))