Filter
Top Products
65
Statistical Calculation Formulas
In the statistical calculation formulas, an error will occur if:
• The absolute value of an intermediate result or calculation result is equal
to or greater than 1 × 10
100
.
• The denominator is zero.
• An attempt is made to take the square root of a negative number.
• No solution exists for a quadratic regression calculation.
Chapter 4: Statistical Calculations
Type Regression formula
Linear y = a + bx
Exponential y = a • e
bx
Logarithmic y = a + b • ln x
Power y = a • x
b
Inverse y = a + b —
Quadratic y = a + bx + cx
2
1
x
xy = x
1
y
1
+ x
2
y
2
+ ··· + x
n
y
n
y = y
1
+ y
2
+ ··· + y
n
x = x
1
+ x
2
+ ··· + x
n
x
2
= x
1
2
+ x
2
2
+ ··· + x
n
2
y
2
= y
1
2
+ y
2
2
+ ··· + y
n
2
sx =
x
2
– nx
2
n – 1
sy =
y
2
– ny
2
n – 1
y =
y
n
x =
x
n
x =
x
2
– nx
2
n
y =
y
2
– ny
2
n
Σ
Σ
Σ
σ
Σ
Σ
Σ
Σ
Σ
σ
Σ
Σ
Σ