Table 5.5, page 126 of LSTM

	A	B	C	D	E
1	This cannot be solved using Google's solver, since it is non-linear. Using the Solver tool in Microsoft Excel 2003, I got a different solution. Why? What settings must I use, and must I drop Play #2 from the Solver inputs to reach the same conclusions as the book?
2
3	Play #	Observed	Calculated	Difference	Difference Squared
4	2	0.250000	0.200066	0.049934	0.002493
5	3	0.250000	0.236647	0.013353	0.000178
6	4	0.250000	0.268515	-0.018515	0.000343
7	5	0.312500	0.296279	0.016221	0.000263
8	6	0.312500	0.320466	-0.007966	0.000063
9	7	0.367188	0.341538	0.025650	0.000658
10	8	0.367188	0.359896	0.007292	0.000053
11	9	0.367188	0.375889	-0.008701	0.000076
12	10	0.389648	0.389823	-0.000175	0.000000
13	11	0.389648	0.401961	-0.012313	0.000152
14	12	0.413818	0.412536	0.001282	0.000002
15	13	0.413818	0.421749	-0.007931	0.000063
16	14	0.436829	0.429775	0.007054	0.000050
17	15	0.436829	0.436767	0.000062	0.000000
18	16	0.436829	0.442859	-0.006030	0.000036
19	17	0.447441	0.448166	-0.000725	0.000001
20	18	0.447441	0.452789	-0.005348	0.000029
21	19	0.459791	0.456817	0.002974	0.000009
22	20	0.459791	0.460326	-0.000535	0.000000
23	21	0.459791	0.463383	-0.003592	0.000013
24	22	0.466089	0.466047	0.000042	0.000000
25	23	0.466089	0.468367	-0.002278	0.000005
26	24	0.473830	0.470388	0.003442	0.000012
27	25	0.473830	0.472149	0.001681	0.000003
28	26	0.482092	0.473683	0.008409	0.000071
29
30
31	Minimize	0.004572
32	Asymptote	0.48406
33	Variable A	0.37418
34	Variable B	0.137892
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