Trendline Analysis.xlsx
Loading…
A
P
D
FD
Print
Download
Find
Reading View
Reading View
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Month
Income
Trend
1
$6,424.33
$5,202.99
2
$6,251.63
$5,818.97
3
$6,008.28
$6,434.95
4
$6,905.47
$7,050.93
5
$6,563.38
$7,666.92
6
$8,805.50
$8,282.90
7
$8,007.92
$8,898.88
8
$9,347.03
$9,514.86
9
$9,278.83
$10,130.85
10
$10,202.61
$10,746.83
11
$11,964.91
$11,362.81
12
$13,330.78
$11,978.79
LINEAR TREND
615.9823
4587.0039
71.9725
529.7035
Multiple R
0.9380
0.8799
860.6663
R Square
0.8799
73.2492
10
Standard Error
860.6663
54259097.2446
7407464.2723
Observations
12
Regression statistics
Simple linear regression model
LINEST function results
Linear
Linear
New Sheet
New Sheet
Header
Loading…
Loading…
FD