Empirical Estimate Forecaster
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
EMPIRICAL ESTIMATE FORECASTER
2
3
Estimate30
4
5
Forecasts
6
Target LikelihoodForecastTrue Likelihood
7
10%30.09.91%
8
25%39.424.77%
9
50%65.150.00%
10
75%96.074.77%
11
90%152.789.64%
12
13
INSTRUCTIONS:
14
Only edit yellow cells.
15
This spreadsheet forecasts when an estimate will actually be done based on
16
historical estimate accuracy.
17
1. Duplicate this spreadsheet by choosing "Make a Copy" from the "File" menu.
18
(You'll need to log in in order for the option to be available.) It doesn't work in Excel.
19
2. Erase the example data in the Historical Estimates table below. Only erase yellow cells.
20
Fill in your own historical data, in terms of time remaining from when the estimate was made.
21
3. Enter the estimate to forecast above, in the "Estimate" cell. Use the same units as in step 2.
22
4. Read the forecasts from the "Forecasts" table. The "Target Likelihood" column describes
23
the desired chance of meeting or beating the forecast. (The "True Likelihood" column describes
24
the actual chance, which may be different than the "Target Likelihood" column, depending on
25
how much historical data you have.)
26
5. (Optional) You may change the "Target Likelihood" column to see forecasts with different
27
levels of accuracy.
28
29
HISTORICAL ESTIMATES
ESTIMATE DISTRIBUTION
30
EstimateActual
Actual/Estimate
Actual/Estimate
Cumulative %Forecast
31
363610.54545454550.45%16.36363636
32
31461.4838709680.66666666670.90%20
33
313110.68751.35%20.625
34
35762.1714285710.91666666671.80%27.5
35
40411.02512.25%30
36
30561.86666666712.70%30
37
35361.02857142913.15%30
38
29311.06896551713.60%30
39
1616114.05%30
40
9111.22222222214.50%30
41
16110.687514.95%30
42
321715.41%30
43
16563.515.86%30
44
34361.05882352916.31%30
45
34611.79411764716.76%30
46
36561.55555555617.21%30
47
26511.96153846217.66%30
48
35561.618.11%30
49
1616118.56%30
50
31411.32258064519.01%30
51
36461.27777777819.46%30
52
35862.45714285719.91%30
53
34361.058823529110.36%30
54
34361.058823529110.81%30
55
34762.235294118111.26%30
56
32912.84375111.71%30
57
15513.4112.16%30
58
31712.290322581112.61%30
59
16311.9375113.06%30
60
28662.357142857113.51%30
61
23512.217391304113.96%30
62
35762.1714285711.02514.41%30.75
63
36812.251.02857142914.86%30.85714286
64
35511.4571428571.0515.32%31.5
65
21713.3809523811.05882352915.77%31.76470588
66
212111.05882352916.22%31.76470588
67
38461.2105263161.05882352916.67%31.76470588
68
175131.06896551717.12%32.06896552
69
29862.9655172411.117.57%33
70
36411.1388888891.12518.02%33.75
71
161611.13888888918.47%34.16666667
72
181811.14285714318.92%34.28571429
73
11565.0909090911.14285714319.37%34.28571429
74
464611.219.82%36
75
6518.51.21052631620.27%36.31578947
76
21562.6666666671.22222222220.72%36.66666667
77
27511.8888888891.22222222221.17%36.66666667
78
21612.9047619051.22222222221.62%36.66666667
79
212111.23809523822.07%37.14285714
80
31461.4838709681.2422.52%37.2
81
212111.2422.97%37.2
82
31461.4838709681.27777777823.42%38.33333333
83
16261.6251.312523.87%39.375
84
10363.61.312524.32%39.375
85
44811.8409090911.312524.77%39.375
86
15362.41.32258064525.23%39.67741935
87
25461.841.33333333325.68%40
88
30461.5333333331.37526.13%41.25
89
14463.2857142861.4426.58%43.2
90
21462.190476191.45454545527.03%43.63636364
91
6162.6666666671.45454545527.48%43.63636364
92
13765.8461538461.45454545527.93%43.63636364
93
20562.81.45454545528.38%43.63636364
94
6111.8333333331.45454545528.83%43.63636364
95
11464.1818181821.45714285729.28%43.71428571
96
363611.47619047629.73%44.28571429
97
5112.21.47619047630.18%44.28571429
98
21462.190476191.48387096830.63%44.51612903
99
6416.8333333331.48387096831.08%44.51612903
100
5265.21.48387096831.53%44.51612903