Spreadsheet

	B	C	D	E	F
1
2				R-squared metrics
3	Month	Sales Forecast ($ million)	Actual Sales ($ million)	Num	Denom
4	Jan	28	31	9	132
5	Feb	35	37	4	30
6	Mar	38	34	16	72
7	Apr	42	40	4	6
8	May	45	43	4	0
9	June	48	49	1	42
10	July	49	52	9	90
11	Aug	51	54	9	132
12	Average		42.5	56	506
13
14	Calculation
15	R-squared	0.89
16
17		0.89
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100