Forecasting for managers

profilePrakash agrawal
HBAT_Data.xls

HBAT Data

id x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15 x16 x17 x18 x19 x20 x21 x22 x23
1 2 0 1 1 1 8.5 3.9 2.5 5.9 4.8 4.9 6.0 6.8 4.7 4.3 5.0 5.1 3.7 8.2 8.0 8.4 65.1 1
2 3 1 0 0 0 8.2 2.7 5.1 7.2 3.4 7.9 3.1 5.3 5.5 4.0 3.9 4.3 4.9 5.7 6.5 7.5 67.1 0
3 3 0 1 1 1 9.2 3.4 5.6 5.6 5.4 7.4 5.8 4.5 6.2 4.6 5.4 4.0 4.5 8.9 8.4 9.0 72.1 1
4 1 1 1 1 0 6.4 3.3 7.0 3.7 4.7 4.7 4.5 8.8 7.0 3.6 4.3 4.1 3.0 4.8 6.0 7.2 40.1 0
5 2 0 1 0 1 9.0 3.4 5.2 4.6 2.2 6.0 4.5 6.8 6.1 4.5 4.5 3.5 3.5 7.1 6.6 9.0 57.1 0
6 1 1 0 1 0 6.5 2.8 3.1 4.1 4.0 4.3 3.7 8.5 5.1 9.5 3.6 4.7 3.3 4.7 6.3 6.1 50.1 0
7 1 1 1 1 0 6.9 3.7 5.0 2.6 2.1 2.3 5.4 8.9 4.8 2.5 2.1 4.2 2.0 5.7 7.8 7.2 41.1 0
8 2 0 1 1 0 6.2 3.3 3.9 4.8 4.6 3.6 5.1 6.9 5.4 4.8 4.3 6.3 3.7 6.3 5.8 7.7 56.1 0
9 2 1 1 1 0 5.8 3.6 5.1 6.7 3.7 5.9 5.8 9.3 5.9 4.4 4.4 6.1 4.6 7.0 7.5 8.2 56.1 1
10 1 0 1 1 0 6.4 4.5 5.1 6.1 4.7 5.7 5.7 8.4 5.4 5.3 4.1 5.8 4.4 5.5 5.9 6.7 59.1 0
11 3 0 1 0 1 8.7 3.2 4.6 4.8 2.7 6.8 4.6 6.8 5.8 7.5 3.8 3.7 4.0 7.4 7.0 8.4 68.1 0
12 1 0 1 1 0 6.1 4.9 6.3 3.9 4.4 3.9 6.4 8.2 5.8 5.9 3.0 4.9 3.2 6.0 6.3 6.6 53.1 0
13 1 1 0 0 1 9.5 5.6 4.6 6.9 5.0 6.9 6.6 7.6 6.5 5.3 5.1 4.5 4.4 8.4 8.4 7.9 58.1 1
14 3 1 0 0 1 9.2 3.9 5.7 5.5 2.4 8.4 4.8 7.1 6.7 3.0 4.5 2.6 4.2 7.6 6.9 8.2 72.1 1
15 2 0 1 1 1 6.3 4.5 4.7 6.9 4.5 6.8 5.9 8.8 6.0 5.4 4.8 6.2 5.2 8.0 7.0 7.6 62.1 1
16 3 0 0 0 0 8.7 3.2 4.0 6.8 3.2 7.8 3.8 4.9 6.1 5.0 4.3 3.9 4.5 6.6 6.4 7.1 71.1 0
17 2 1 0 1 1 5.7 4.0 6.7 6.0 3.3 5.5 5.1 6.2 6.7 5.4 4.2 6.2 4.5 6.4 7.5 7.2 50.1 1
18 2 0 1 1 0 5.9 4.1 5.5 7.2 3.5 6.4 5.5 8.4 6.2 6.3 5.7 5.8 4.8 7.4 6.9 8.2 58.1 1
19 2 1 1 1 0 5.6 3.4 5.1 6.4 3.7 5.7 5.6 9.1 5.4 6.1 5.0 6.0 4.5 6.8 7.5 7.9 55.1 0
20 3 0 1 1 0 9.1 4.5 3.6 6.4 5.3 5.3 7.1 8.4 5.8 6.7 4.5 6.1 4.4 7.6 8.5 8.8 67.1 1
21 1 0 0 1 0 5.2 3.8 7.1 5.2 3.9 4.3 5.0 8.4 7.1 4.6 3.3 4.9 3.3 5.4 5.5 7.0 50.1 0
22 3 1 1 1 1 9.6 5.7 6.8 5.9 5.4 8.3 7.8 4.5 6.4 6.5 4.3 3.0 4.3 9.9 9.6 9.9 70.1 1
23 2 0 0 0 1 8.6 3.6 7.4 5.1 3.5 7.3 4.7 3.7 6.7 6.0 4.8 3.4 4.0 7.0 7.1 8.1 60.1 0
24 3 0 1 1 1 9.3 2.4 2.6 7.2 2.2 7.2 4.5 6.2 6.4 4.2 6.7 4.4 4.5 8.6 8.1 8.0 65.1 1
25 1 0 0 1 0 6.0 4.1 5.3 4.7 3.5 5.3 5.3 8.0 6.5 3.9 4.7 5.3 4.0 4.8 4.9 5.5 55.1 0
26 2 0 1 1 0 6.4 3.6 6.6 6.1 4.0 3.9 5.3 7.1 6.1 3.7 5.6 6.6 3.9 6.6 6.8 7.0 58.1 0
27 3 0 0 0 0 8.5 3.0 7.2 5.8 4.1 7.6 3.7 4.8 6.9 6.7 5.3 3.8 4.4 6.3 7.1 7.0 70.1 0
28 1 1 0 1 0 7.0 3.3 5.4 5.5 2.6 4.8 4.2 9.0 6.5 5.9 4.3 5.2 3.7 5.4 5.5 5.6 55.1 0
29 3 0 0 0 0 8.5 3.0 5.7 6.0 2.3 7.6 3.7 4.8 5.8 6.0 5.7 3.8 4.4 6.3 6.9 7.2 70.1 0
30 1 1 1 1 0 7.6 3.6 3.0 4.0 5.1 4.2 4.6 7.7 4.9 7.2 4.7 5.5 3.5 5.4 5.5 6.2 52.1 0
31 1 1 0 0 1 6.9 3.4 8.5 4.3 4.5 6.4 4.7 5.2 7.7 3.3 3.7 2.7 3.3 6.1 6.8 7.1 44.1 0
32 1 0 1 1 0 8.1 2.5 7.2 4.5 2.3 5.1 3.8 6.6 6.8 6.1 3.0 3.5 3.0 6.4 5.8 6.2 51.1 0
33 1 1 1 1 0 6.7 3.7 6.5 5.3 5.3 5.1 4.9 9.2 5.7 4.2 3.5 4.5 3.4 5.4 6.5 7.6 44.1 0
34 2 1 1 1 0 8.0 3.3 6.1 5.7 5.5 4.6 4.7 8.7 5.9 3.8 4.7 6.6 4.2 7.3 7.5 9.0 62.1 1
35 1 0 1 1 0 6.7 4.0 5.2 3.9 3.0 5.4 6.8 8.4 6.2 6.0 2.5 4.3 3.5 6.3 6.6 6.7 54.1 0
36 1 0 0 0 0 8.7 3.2 6.1 4.3 3.5 6.1 2.9 5.6 6.1 6.5 3.1 2.9 2.5 5.4 4.6 7.1 51.1 0
37 2 0 0 0 1 9.0 3.4 5.9 4.6 3.9 6.0 4.5 6.8 6.4 4.3 3.9 3.5 3.5 7.1 8.0 7.2 57.1 0
38 3 0 1 1 1 9.6 4.1 6.2 7.3 2.9 7.7 5.5 7.7 6.1 4.4 5.2 4.6 4.9 8.7 9.9 9.9 77.1 1
39 2 1 1 1 0 8.2 3.6 3.9 6.2 5.8 4.9 5.0 9.0 5.2 7.1 4.7 6.9 4.5 7.6 6.9 7.6 65.1 1
40 1 0 0 1 0 6.1 4.9 3.0 4.8 5.1 3.9 6.4 8.2 5.1 6.8 4.5 4.9 3.2 6.0 5.5 5.8 53.1 0
41 2 1 1 1 0 8.3 3.4 3.3 5.5 3.1 4.6 5.2 9.1 4.1 1.7 4.6 5.8 3.9 7.0 7.5 8.4 61.1 1
42 2 1 0 0 1 9.4 3.8 4.7 5.4 3.8 6.5 4.9 8.5 4.9 6.2 4.1 4.5 4.1 7.6 8.0 7.9 61.1 1
43 3 0 1 0 1 9.3 5.1 4.6 6.8 5.8 6.6 6.3 7.4 5.1 4.1 4.6 4.6 4.3 8.9 7.8 7.6 72.1 1
44 2 1 1 1 1 5.1 5.1 6.6 6.9 4.4 5.4 7.8 5.9 7.2 5.2 4.9 6.3 4.5 7.6 7.9 8.4 55.1 1
45 3 1 0 0 0 8.0 2.5 4.7 7.1 3.6 7.7 3.0 5.2 5.1 3.9 4.3 4.2 4.7 5.5 5.6 6.5 65.1 0
46 2 0 1 1 0 5.9 4.1 5.7 5.9 5.8 6.4 5.5 8.4 6.4 5.1 5.2 5.8 4.8 7.4 8.6 7.7 58.1 1
47 3 1 0 0 1 10.0 4.3 7.1 6.3 2.9 5.4 4.5 3.8 6.7 3.7 5.0 4.0 3.5 7.1 8.8 8.0 67.1 1
48 2 1 1 1 0 5.7 3.8 6.8 7.5 5.7 5.7 6.0 8.2 6.6 4.8 6.5 7.3 5.2 7.6 7.6 7.1 60.1 0
49 3 0 0 1 1 9.9 3.7 3.7 6.1 4.2 7.0 6.7 6.8 5.9 7.2 4.5 3.4 3.9 8.7 8.1 8.5 67.1 1
50 3 1 1 0 1 7.9 3.9 4.3 5.8 4.4 6.9 5.8 4.7 5.2 3.6 4.1 4.2 4.3 8.6 7.8 7.6 61.1 1
51 1 0 1 1 0 6.7 3.6 5.9 4.2 3.4 4.7 4.8 7.2 5.7 5.3 4.0 3.6 2.8 5.4 7.5 7.2 48.1 0
52 3 1 0 0 0 8.2 2.7 3.7 7.4 2.7 7.9 3.1 5.3 5.3 5.0 4.5 4.3 4.9 5.7 7.1 8.2 67.1 1
53 3 0 1 1 1 9.4 2.5 4.8 6.1 3.2 7.3 4.6 6.3 6.3 9.2 4.7 4.6 4.6 8.7 9.0 9.0 66.1 1
54 1 1 0 0 1 6.9 3.4 5.7 4.4 3.3 6.4 4.7 5.2 6.4 4.4 3.2 2.7 3.3 6.1 7.0 7.2 44.1 0
55 2 1 1 1 0 8.0 3.3 3.8 5.8 3.2 4.6 4.7 8.7 5.3 4.2 4.9 6.6 4.2 7.3 8.1 8.1 62.1 1
56 3 1 0 0 0 9.3 3.8 7.3 5.7 3.7 6.4 5.5 7.4 6.6 5.9 4.1 3.2 3.4 7.7 7.6 8.9 59.1 1
57 2 0 1 1 1 7.4 5.1 4.8 7.7 4.5 7.2 6.9 9.6 6.4 7.4 5.7 6.5 5.5 9.0 7.9 8.8 74.1 1
58 3 1 0 0 0 7.6 3.6 5.2 5.8 5.6 6.6 5.4 4.4 6.7 6.4 4.6 3.9 4.0 8.2 7.5 7.5 58.1 1
59 3 1 0 0 0 10.0 4.3 5.3 3.7 4.2 5.4 4.5 3.8 6.7 4.5 3.7 4.0 3.5 7.1 6.5 7.0 67.1 0
60 3 1 1 1 0 9.9 2.8 7.2 6.9 2.6 5.8 3.5 5.4 6.2 7.0 5.6 4.9 4.0 7.9 8.5 8.5 61.1 1
61 3 0 0 0 0 8.7 3.2 8.4 6.1 2.8 7.8 3.8 4.9 7.2 4.5 5.4 3.9 4.5 6.6 6.9 7.2 71.1 1
62 2 0 1 1 1 8.4 3.8 6.7 5.0 4.5 4.7 5.9 6.7 5.1 4.2 2.7 5.0 3.6 8.0 7.6 8.8 63.1 1
63 1 0 0 0 1 8.8 3.9 3.8 5.1 4.3 4.7 4.8 5.8 5.0 7.2 4.4 3.7 2.9 6.3 5.5 8.0 44.1 0
64 1 0 1 1 0 7.7 2.2 6.3 4.5 2.4 4.7 3.4 6.2 6.0 4.7 3.3 3.1 2.6 6.0 6.0 8.1 47.1 0
65 1 0 1 1 0 6.6 3.6 5.8 4.1 4.9 4.7 4.8 7.2 6.5 3.9 3.5 3.6 2.8 5.4 6.9 7.1 48.1 0
66 2 1 1 1 0 5.7 3.8 3.5 6.7 5.4 5.7 6.0 8.2 5.4 5.0 4.7 7.3 5.2 7.6 6.9 9.0 60.1 1
67 2 1 0 1 0 5.7 4.0 7.9 6.4 2.7 5.5 5.1 6.2 7.5 6.4 5.0 6.2 4.5 6.4 5.6 6.2 50.1 0
68 2 1 0 1 1 5.5 3.7 4.7 5.4 4.3 5.3 4.9 6.0 5.6 2.5 4.5 5.9 4.3 6.1 6.3 8.2 48.1 0
69 1 1 1 1 0 7.5 3.5 3.8 3.5 2.9 4.1 4.5 7.6 5.1 5.2 4.0 5.4 3.4 5.2 5.8 5.8 51.1 0
70 2 0 1 1 0 6.4 3.6 2.7 5.3 3.9 3.9 5.3 7.1 5.2 5.5 4.7 6.6 3.9 6.6 6.6 8.0 58.1 1
71 3 0 0 1 0 9.1 4.5 6.1 5.9 6.3 5.3 7.1 8.4 7.1 5.7 5.4 6.1 4.4 7.6 7.5 7.7 67.1 0
72 1 1 0 0 1 6.7 3.2 3.0 3.7 4.8 6.3 4.5 5.0 5.2 2.5 2.9 2.6 3.1 5.8 6.0 7.0 43.1 0
73 2 0 1 1 0 6.5 4.3 2.7 6.6 6.5 6.3 6.0 8.7 4.7 6.3 4.6 5.6 4.6 7.9 6.6 7.9 66.1 0
74 3 0 1 1 1 9.9 3.7 7.5 4.7 5.6 7.0 6.7 6.8 7.2 4.6 4.1 3.4 3.9 8.6 8.8 9.8 66.1 1
75 2 0 1 1 1 8.5 3.9 5.3 5.5 5.0 4.9 6.0 6.8 5.7 3.6 4.4 5.1 3.7 8.2 7.0 8.4 65.1 1
76 3 0 0 0 0 9.9 3.0 6.8 5.0 5.4 5.9 4.8 4.9 7.3 7.6 3.1 4.3 3.8 7.1 6.6 8.9 63.1 1
77 1 0 0 1 1 7.6 3.6 7.6 4.6 4.7 4.6 5.0 7.4 8.1 6.6 4.5 5.8 3.9 6.4 6.9 7.5 49.1 0
78 2 1 0 0 1 9.4 3.8 7.0 6.2 4.7 6.5 4.9 8.5 7.3 2.4 4.3 4.5 4.1 7.6 7.3 8.0 61.1 1
79 3 0 0 0 1 9.3 3.5 6.3 7.6 5.5 7.5 5.9 4.6 6.6 3.1 5.2 4.1 4.6 8.9 7.3 8.1 72.1 1
80 1 1 1 1 0 7.1 3.4 4.9 4.1 4.0 5.0 5.9 7.8 6.1 3.5 2.6 3.1 2.7 5.7 5.8 7.6 44.1 0
81 3 0 1 0 0 9.9 3.0 7.4 4.8 4.0 5.9 4.8 4.9 5.9 6.9 3.2 4.3 3.8 7.1 7.9 8.8 63.1 0
82 3 0 0 0 0 8.7 3.2 6.4 4.9 2.4 6.8 4.6 6.8 6.3 5.1 4.3 3.7 4.0 7.4 7.3 8.0 68.1 1
83 2 0 0 0 1 8.6 2.9 5.8 3.9 2.9 5.6 4.0 6.3 6.1 4.0 2.7 3.0 3.0 6.6 6.1 8.5 53.1 0
84 1 1 0 1 0 6.4 3.2 6.7 3.6 2.2 2.9 5.0 8.4 7.3 6.5 2.0 3.7 1.6 5.0 5.1 6.5 37.1 0
85 2 0 0 0 1 7.7 2.6 6.7 6.6 1.9 7.2 4.3 5.9 6.5 4.1 4.7 3.9 4.3 8.2 7.5 7.7 52.1 1
86 1 1 1 1 0 7.5 3.5 4.1 4.5 3.5 4.1 4.5 7.6 4.9 2.8 3.4 5.4 3.4 5.2 6.0 7.2 51.1 0
87 1 0 0 1 0 5.0 3.6 1.3 3.0 3.5 4.2 4.9 8.2 4.3 7.6 2.4 4.8 3.1 5.2 5.5 6.0 48.1 0
88 2 0 0 0 1 7.7 2.6 8.0 6.7 3.5 7.2 4.3 5.9 6.9 7.7 5.1 3.9 4.3 8.2 7.6 8.2 52.1 0
89 2 1 0 0 1 9.1 3.6 5.5 5.4 4.2 6.2 4.6 8.3 6.5 4.1 4.6 4.3 3.9 7.3 6.5 7.4 59.1 0
90 2 1 0 1 1 5.5 5.5 7.7 7.0 5.6 5.7 8.2 6.3 7.4 4.9 5.5 6.7 4.9 8.2 7.6 9.3 59.1 1
91 3 1 0 0 0 9.1 3.7 7.0 4.1 4.4 6.3 5.4 7.3 7.5 4.6 4.4 3.0 3.3 7.4 7.9 7.9 58.1 1
92 1 1 0 1 0 7.1 4.2 4.1 2.6 2.1 3.3 4.5 9.9 5.5 3.5 2.0 4.0 2.4 4.8 5.0 6.5 51.1 0
93 3 1 1 0 1 9.2 3.9 4.6 5.3 4.2 8.4 4.8 7.1 6.2 6.6 4.4 2.6 4.2 7.6 7.5 8.6 72.1 0
94 3 0 1 1 1 9.3 3.5 5.4 7.8 4.6 7.5 5.9 4.6 6.4 4.9 4.8 4.1 4.6 8.9 7.6 8.9 72.1 1
95 3 1 1 0 0 9.3 3.8 4.0 4.6 4.7 6.4 5.5 7.4 5.3 4.8 3.6 3.2 3.4 7.7 7.3 8.4 59.1 1
96 1 1 0 0 1 8.6 4.8 5.6 5.3 2.3 6.0 5.7 6.7 5.8 3.6 4.9 3.6 3.6 7.3 8.1 8.1 50.1 1
97 1 0 0 1 1 7.4 3.4 2.6 5.0 4.1 4.4 4.8 7.2 4.5 6.4 4.2 5.6 3.7 6.3 5.5 7.2 48.1 0
98 1 0 0 0 1 8.7 3.2 3.3 3.2 3.1 6.1 2.9 5.6 5.0 4.3 3.1 2.9 2.5 5.4 7.0 7.7 51.1 0
99 2 1 0 1 1 7.8 4.9 5.8 5.3 5.2 5.3 7.1 7.9 6.0 5.7 4.3 4.9 3.9 6.4 7.1 7.4 61.1 0
100 2 1 1 1 0 7.9 3.0 4.4 5.1 5.9 4.2 4.8 9.7 5.7 5.8 3.4 5.4 3.5 6.4 7.3 7.0 57.1 0
101 1 1 1 1 0 7.6 3.6 4.8 4.9 3.4 4.2 4.6 7.7 6.1 5.1 3.1 5.5 3.5 5.4 5.5 6.1 52.1 0
102 3 0 0 1 1 9.2 5.0 6.5 5.2 5.2 6.5 6.2 7.3 6.8 8.6 5.1 4.6 4.2 8.7 9.1 7.1 71.1 1
103 2 1 0 1 1 7.7 4.7 4.7 4.7 5.2 5.2 7.0 7.7 5.9 5.4 4.0 4.7 3.7 6.1 7.0 7.6 59.1 1
104 1 1 1 0 1 9.5 5.6 0.4 5.5 5.6 6.9 6.6 7.6 3.8 4.4 5.6 4.5 4.4 8.4 9.4 9.0 58.1 1
105 2 0 1 1 0 6.5 4.3 5.0 6.8 4.7 6.3 6.0 8.7 6.1 6.9 5.0 5.6 4.6 7.9 8.4 8.9 66.1 1
106 2 1 1 1 0 8.3 3.4 2.8 5.9 3.4 4.6 5.2 9.1 5.8 5.2 4.2 5.8 3.9 7.0 7.0 7.5 61.1 0
107 3 0 1 0 1 9.6 4.1 5.5 6.5 4.8 7.7 5.5 7.7 6.9 5.5 4.4 4.6 4.9 8.7 7.6 9.3 77.1 1
108 2 1 1 1 0 5.9 4.0 6.8 8.7 6.0 5.9 6.2 8.4 6.3 5.3 5.8 7.5 5.4 7.9 7.9 8.0 62.1 0
109 2 0 0 0 1 8.7 3.7 1.5 5.5 4.6 7.4 4.8 3.8 3.9 5.7 4.6 3.5 4.2 7.1 7.3 7.6 61.1 0
110 1 1 0 0 0 6.7 3.2 3.4 5.5 2.3 6.3 4.5 5.0 5.4 6.5 3.8 2.6 3.1 5.8 5.3 7.1 43.1 0
111 3 1 0 0 1 9.7 5.0 5.5 7.1 3.4 7.5 6.1 6.7 6.9 5.2 3.7 3.4 4.1 8.4 7.1 8.1 66.1 0
112 3 1 0 0 1 8.8 3.5 6.7 6.6 3.3 8.1 4.5 6.7 7.2 2.7 4.0 2.3 3.9 7.1 6.3 7.9 69.1 0
113 2 1 1 1 0 8.2 3.6 8.9 5.2 4.5 4.9 5.0 9.0 7.8 4.3 4.5 6.9 4.5 7.6 8.3 7.2 65.1 1
114 3 0 1 1 1 8.9 4.3 4.8 5.6 6.3 5.1 6.9 8.2 5.6 6.7 4.2 5.9 4.2 7.3 7.0 7.7 65.1 0
115 2 0 1 1 1 8.4 3.8 8.6 4.9 3.2 4.7 5.9 6.7 7.9 6.6 4.0 5.0 3.6 8.0 8.8 7.9 63.1 1
116 2 1 0 1 1 7.7 4.7 4.1 5.4 4.3 5.2 7.0 7.7 5.3 7.4 5.1 4.7 3.7 6.1 6.9 6.9 59.1 0
117 3 0 1 1 1 9.2 5.0 5.9 6.4 4.9 6.5 6.2 7.3 6.7 8.9 4.2 4.6 4.2 8.7 8.0 9.5 71.1 1
118 1 1 1 1 0 7.3 3.6 4.5 4.1 5.4 5.2 6.1 8.0 5.4 3.7 2.8 3.3 2.9 5.8 6.4 7.5 46.1 0
119 1 0 1 0 1 9.0 4.1 5.3 4.2 3.0 4.8 5.0 6.0 5.7 4.9 3.3 3.9 3.1 6.4 8.5 8.0 45.1 1
120 1 0 1 1 0 8.1 2.5 3.2 3.9 4.1 5.1 3.8 6.6 5.4 6.2 2.6 3.5 3.0 6.4 5.9 7.1 51.1 0
121 2 0 1 1 1 7.4 5.1 5.0 8.3 5.0 7.2 6.9 9.6 6.3 4.3 5.7 6.5 5.5 9.0 7.5 8.8 74.1 1
122 2 1 1 1 0 7.9 3.0 5.5 6.2 4.3 4.2 4.8 9.7 5.5 4.6 4.8 5.4 3.5 6.4 6.5 8.0 57.1 0
123 1 0 1 1 0 7.7 2.2 6.8 3.4 2.4 4.7 3.4 6.2 6.7 4.3 3.2 3.1 2.6 6.0 6.4 7.7 47.1 0
124 3 0 1 1 1 9.4 2.5 6.4 7.0 3.2 7.3 4.6 6.3 6.5 5.4 5.8 4.6 4.6 8.7 7.9 8.2 66.1 1
125 1 1 1 1 0 7.2 4.3 4.1 4.2 3.9 3.4 4.7 10.0 5.5 3.6 3.2 4.1 2.5 5.0 6.1 6.5 52.1 0
126 2 0 0 0 1 8.3 3.7 4.9 4.0 5.3 6.1 6.1 5.3 5.8 7.4 4.1 2.9 3.1 7.4 8.0 8.1 54.1 1
127 3 1 0 0 0 7.9 3.9 4.1 6.6 4.9 6.9 5.8 4.7 6.0 6.7 4.6 4.2 4.3 8.6 6.5 8.1 61.1 1
128 1 1 1 1 0 7.3 3.6 8.5 4.0 3.6 5.2 6.1 8.0 7.3 2.9 3.3 3.3 2.9 5.8 6.0 6.9 46.1 0
129 3 1 1 1 1 9.6 5.7 6.1 6.2 5.6 8.2 7.8 4.5 7.1 4.8 4.4 3.0 4.3 9.8 8.1 9.3 70.1 1
130 1 0 0 0 0 8.3 2.8 4.8 2.6 3.0 5.7 2.5 5.2 5.4 2.8 1.2 2.5 2.1 4.8 5.0 6.2 47.1 0
131 2 0 0 0 1 8.6 3.6 7.5 6.1 2.9 7.3 4.7 3.7 7.3 5.2 5.0 3.4 4.0 7.0 6.9 8.0 60.1 1
132 3 1 0 0 0 8.0 2.5 3.9 6.9 3.4 7.7 3.0 5.2 5.4 6.8 4.6 4.2 4.7 5.5 5.6 7.1 65.1 0
133 1 1 0 1 0 6.4 3.2 4.3 1.5 2.2 2.9 5.0 8.4 6.0 7.0 2.4 3.7 1.6 5.0 5.1 6.5 37.1 0
134 1 0 1 1 0 6.6 3.8 5.1 6.3 3.2 5.3 6.6 8.2 6.4 2.9 4.3 4.1 3.3 6.0 6.9 7.1 53.1 0
135 2 0 1 0 1 7.6 2.5 5.1 6.0 3.2 7.1 4.2 5.8 5.4 6.2 3.6 3.8 4.2 8.0 7.5 8.2 51.1 0
136 3 1 0 0 1 9.4 4.1 6.0 5.6 3.4 7.8 4.7 7.6 6.5 6.0 5.1 3.7 4.4 7.9 7.1 7.0 75.1 1
137 1 0 0 0 0 8.3 2.8 2.4 3.1 3.0 5.7 2.5 5.2 4.8 4.2 1.8 2.5 2.1 4.8 5.8 6.7 47.1 0
138 2 1 0 1 1 7.8 4.9 6.4 5.7 5.8 5.3 7.1 7.9 6.4 5.2 4.1 4.9 3.9 6.4 6.6 7.5 61.1 1
139 1 1 1 1 0 7.1 4.2 5.8 3.3 2.8 3.3 4.5 9.9 6.2 3.1 2.8 4.0 2.4 4.8 6.1 7.4 51.1 0
140 1 0 0 1 1 7.6 3.6 4.5 4.8 2.2 4.6 5.0 7.4 6.4 5.3 4.4 5.8 3.9 6.4 6.8 7.4 49.1 0
141 2 1 1 1 0 5.6 3.4 3.8 6.3 5.2 5.7 5.6 9.1 5.8 6.0 4.5 6.0 4.5 6.8 6.5 7.9 55.1 0
142 3 1 1 0 0 9.9 2.8 6.1 5.8 1.5 5.8 3.5 5.4 5.9 6.8 4.0 4.9 4.0 7.9 8.3 8.0 61.1 1
143 3 0 1 1 1 9.2 3.4 7.7 6.9 4.9 7.4 5.8 4.5 7.2 6.1 4.2 4.0 4.5 8.9 9.4 8.0 72.1 1
144 3 1 0 0 0 9.1 3.8 4.9 5.1 3.1 7.5 4.5 7.3 5.7 5.2 4.5 3.4 4.2 7.4 6.6 8.4 72.1 0
145 3 1 0 0 0 9.9 4.2 5.2 5.4 3.4 5.4 4.5 3.8 6.2 8.0 3.8 4.0 3.5 7.0 7.6 8.8 66.1 1
146 3 1 0 0 1 9.9 4.2 1.2 4.1 3.2 5.4 4.5 3.8 4.9 6.2 4.1 4.0 3.5 7.0 7.8 7.9 66.1 1
147 1 0 0 1 0 6.6 3.8 3.0 4.7 4.5 5.3 6.6 8.2 5.8 3.5 4.6 4.1 3.3 6.0 6.0 6.0 53.1 0
148 3 1 0 0 0 9.1 3.7 3.5 4.7 4.1 6.3 5.4 7.3 5.9 6.5 3.7 3.0 3.3 7.4 6.0 8.2 58.1 1
149 2 1 1 1 1 5.1 5.1 4.4 6.2 5.8 5.4 7.8 5.9 5.4 3.9 5.1 6.3 4.5 7.6 9.1 8.4 55.1 1
150 1 0 1 1 0 6.0 4.1 7.2 5.8 4.8 5.3 5.3 8.0 6.4 3.6 4.3 5.3 4.0 4.8 5.0 7.4 55.1 0
151 3 0 0 1 0 8.9 4.3 6.5 5.7 4.3 5.1 6.9 8.2 7.1 3.8 5.0 5.9 4.2 7.3 5.8 8.0 65.1 0
152 2 0 1 1 0 6.2 3.3 3.5 5.4 4.0 3.6 5.1 6.9 4.8 4.7 4.0 6.3 3.7 6.3 5.9 6.6 56.1 0
153 1 1 0 1 0 7.2 4.3 3.7 3.8 3.6 3.4 4.7 10.0 4.5 2.9 3.0 4.1 2.5 5.0 5.3 7.6 52.1 0
154 3 1 0 0 1 8.8 3.5 8.5 5.4 2.8 8.1 4.5 6.7 8.0 5.6 4.1 2.3 3.9 7.1 6.8 7.5 69.1 0
155 1 0 1 1 0 6.3 5.1 4.7 5.3 3.7 4.1 6.6 8.4 6.3 4.2 4.4 5.1 3.4 6.3 6.1 7.1 55.1 0
156 3 0 0 0 0 9.7 2.8 3.7 5.8 3.7 5.7 4.7 4.8 4.8 1.6 4.0 4.1 3.6 6.8 5.9 7.9 61.1 0
157 1 0 1 1 0 5.0 3.6 6.7 4.4 4.1 4.2 4.9 8.2 6.4 4.0 3.7 4.8 3.1 5.2 5.3 7.6 48.1 0
158 1 0 0 1 1 7.4 3.4 6.1 4.3 5.8 4.4 4.8 7.2 6.1 5.1 4.0 5.6 3.7 6.3 5.6 7.1 48.1 0
159 2 1 0 1 1 5.5 3.7 7.4 5.7 4.5 5.3 4.9 6.0 7.6 6.0 4.3 5.9 4.3 6.1 6.1 7.6 48.1 0
160 2 1 0 0 1 9.1 3.6 6.4 4.8 3.0 6.2 4.6 8.3 7.0 6.1 4.6 4.3 3.9 7.3 7.4 8.2 59.1 1
161 1 1 0 1 0 6.7 3.7 6.0 4.9 5.1 5.1 4.9 9.2 6.5 5.6 3.7 4.5 3.4 5.4 5.3 6.9 44.1 0
162 2 0 1 1 1 6.3 4.5 8.6 6.4 4.9 6.8 5.9 8.8 8.4 6.5 6.4 6.2 5.2 8.0 7.0 8.1 62.1 1
163 2 0 0 0 1 8.3 3.7 6.0 4.9 5.7 6.1 6.1 5.3 6.6 5.5 3.6 2.9 3.1 7.4 7.0 7.6 54.1 0
164 2 0 0 0 1 8.2 3.6 4.9 4.0 4.7 6.0 6.0 5.2 5.6 5.9 4.7 2.8 3.0 7.3 7.1 8.4 53.1 0
165 2 0 0 0 1 8.2 3.6 4.3 4.0 5.8 6.0 6.0 5.2 5.6 6.2 4.0 2.8 3.0 7.3 6.8 7.4 53.1 0
166 1 0 0 0 1 9.0 4.1 6.6 4.4 3.3 4.8 5.0 6.0 6.6 5.6 4.3 3.9 3.1 6.4 5.9 7.9 45.1 0
167 1 1 1 1 0 7.1 3.4 5.9 3.7 3.8 5.0 5.9 7.8 6.1 7.2 3.6 3.1 2.7 5.7 6.1 7.2 44.1 0
168 1 1 1 1 0 6.9 3.7 5.3 3.4 3.3 2.3 5.4 8.9 6.6 3.4 2.7 4.2 2.0 5.7 6.6 7.6 41.1 0
169 2 0 0 0 1 8.6 2.9 4.5 4.0 2.8 5.6 4.0 6.3 6.1 5.1 4.0 3.0 3.0 6.6 6.5 6.7 53.1 0
170 1 0 1 1 0 6.7 4.0 4.5 4.3 4.2 5.4 6.8 8.4 6.1 4.0 3.8 4.3 3.5 6.3 7.1 7.4 54.1 0
171 1 1 1 1 0 7.0 3.3 4.9 5.6 4.0 4.8 4.2 9.0 5.5 5.3 3.3 5.2 3.7 5.4 7.0 6.2 55.1 0
172 3 1 0 0 0 9.7 2.6 6.2 5.8 2.1 5.6 3.3 5.2 6.7 8.4 4.5 4.7 3.8 7.4 7.0 7.5 59.1 1
173 3 0 0 0 1 9.9 3.7 4.8 5.3 4.6 7.0 6.7 6.8 6.7 8.0 5.0 3.4 3.9 8.6 7.3 7.4 66.1 1
174 1 1 0 0 1 8.6 4.8 5.5 4.2 3.3 6.0 5.7 6.7 6.2 2.8 4.8 3.6 3.6 7.3 6.4 7.9 50.1 0
175 1 0 1 1 0 6.3 5.1 5.4 4.7 5.5 4.1 6.6 8.4 5.7 2.4 2.8 5.1 3.4 6.3 5.8 6.5 55.1 0
176 3 0 1 1 1 9.9 3.7 7.3 4.2 6.1 7.0 6.7 6.8 6.4 5.2 4.3 3.4 3.9 8.7 8.5 8.6 67.1 1
177 3 0 1 0 1 9.3 2.4 5.3 5.8 2.6 7.2 4.5 6.2 6.5 4.1 4.0 4.4 4.5 8.6 8.0 8.6 65.1 1
178 3 1 1 0 1 9.7 5.0 6.3 5.8 5.2 7.5 6.1 6.7 7.5 6.1 4.9 3.4 4.1 8.4 7.8 8.0 66.1 1
179 3 1 0 0 0 9.7 2.6 6.1 5.3 2.4 5.6 3.3 5.2 5.5 7.1 4.6 4.7 3.8 7.4 6.0 8.1 59.1 0
180 3 1 1 0 1 9.6 5.7 4.9 6.1 6.9 8.3 7.8 4.5 5.4 6.2 4.0 3.0 4.3 9.9 8.1 8.2 70.1 1
181 2 0 0 0 1 7.6 2.5 6.5 6.3 3.8 7.1 4.2 5.8 6.9 5.5 4.4 3.8 4.2 8.0 7.1 7.2 51.1 0
182 3 1 0 0 0 9.4 4.1 5.2 6.4 4.8 7.8 4.7 7.6 5.8 6.5 4.7 3.7 4.4 7.9 8.1 8.4 75.1 1
183 3 1 1 1 1 9.6 5.7 6.6 6.7 5.1 8.2 7.8 4.5 6.6 5.6 4.6 3.0 4.3 9.8 9.0 9.4 70.1 1
184 3 0 1 1 1 9.3 5.1 5.5 5.8 5.6 6.6 6.3 7.4 6.3 5.7 4.4 4.6 4.3 8.9 8.0 9.4 72.1 1
185 3 0 0 0 0 9.7 2.8 4.4 5.1 3.8 5.7 4.7 4.8 5.8 6.3 4.7 4.1 3.6 6.8 6.3 7.5 61.1 0
186 3 1 0 0 1 9.1 3.8 3.4 7.1 3.0 7.5 4.5 7.3 4.9 5.1 6.0 3.4 4.2 7.4 6.9 6.6 72.1 0
187 1 1 0 1 0 6.5 2.8 0.6 5.2 2.5 4.3 3.7 8.5 4.3 4.8 4.3 4.7 3.3 4.7 4.0 4.3 50.1 0
188 1 0 1 1 0 6.6 3.6 4.0 4.0 1.7 4.7 4.8 7.2 4.7 4.8 3.2 3.6 2.8 5.4 7.4 6.6 48.1 0
189 2 1 1 1 0 5.8 3.6 6.9 6.6 5.1 5.9 5.8 9.3 7.1 3.4 5.9 6.1 4.6 7.0 6.6 7.4 56.1 0
190 2 0 0 0 1 8.7 3.7 3.0 5.6 4.2 7.4 4.8 3.8 5.4 3.6 5.5 3.5 4.2 7.1 6.5 7.1 61.1 1
191 1 0 0 0 1 8.8 3.9 5.4 4.2 3.4 4.7 4.8 5.8 6.9 5.8 3.8 3.7 2.9 6.3 7.9 6.7 44.1 1
192 1 0 1 1 0 6.4 4.5 2.5 5.8 4.0 5.7 5.7 8.4 4.7 5.0 4.0 5.8 4.4 5.5 5.6 6.7 59.1 0
193 1 0 0 1 0 6.7 3.6 0.5 3.2 3.3 4.7 4.8 7.2 4.3 5.0 2.9 3.6 2.8 5.4 4.5 7.2 48.1 0
194 1 0 1 1 0 5.2 3.8 5.5 4.7 3.3 4.3 5.0 8.4 6.1 3.6 4.3 4.9 3.3 5.4 6.5 7.1 50.1 0
195 1 1 0 1 0 6.4 3.3 2.7 4.0 5.3 4.7 4.5 8.8 3.7 7.0 3.6 4.1 3.0 4.8 5.5 6.0 40.1 0
196 3 1 1 0 0 7.6 3.6 2.1 5.2 4.8 6.6 5.4 4.4 4.3 6.8 4.4 3.9 4.0 8.2 6.9 8.4 58.1 1
197 2 1 1 1 0 5.9 4.0 3.3 7.8 3.3 5.9 6.2 8.4 5.2 6.6 6.0 7.5 5.4 7.9 7.8 8.6 62.1 1
198 3 1 1 1 1 9.7 5.0 7.9 6.3 5.3 7.6 6.1 6.8 6.6 5.2 4.4 3.5 4.2 8.6 8.8 7.9 66.1 1
199 2 1 1 1 1 5.5 5.5 6.9 6.6 6.5 5.7 8.2 6.3 7.0 5.3 5.9 6.7 4.9 8.2 7.1 7.6 59.1 1
200 3 1 0 1 1 9.7 5.0 5.6 5.9 5.3 7.6 6.1 6.8 6.9 1.2 4.3 3.5 4.2 8.6 8.1 8.5 66.1 1

coding

Variable Name Definition Coding
X1 Customer Duration Length of time a particular customer has been buying from HBAT 1 = Less than 1 year;
2 = Between 1 and 5 years;
3 = Longer than 5 years
X2 Customer Type Type of industry that purchases HBAT’s paper products 0 = Magazine;
1 = Newsprint
X3 Customer Size Based on number of employees 0 = Small firm, < 500 employees;
1 = Large firm, ≥ 500 employees
X4 Customer Region Customer location 0 = EU;
1 = Outside EU
X5 Distribution System Sales and services are provided through this distribution system 0 = Indirectly through a broker; 1 = Directly through salesforce
X6 Product Quality Perceived level of quality of HBAT’s paper products
X7 E-Commerce Activities/Website Overall image of HBAT’s website, especially its user-friendliness
X8 Technical Support Extent to which technical support is offered to help solve product/service issues
X9 Complaint Resolution Extent to which any complaints are resolved in a timely and complete manner
X10 Advertising Perceptions of HBAT’s advertising campaign in all types of media
X11 Product Line Depth and breadth of HBAT’s product line to meet customer needs
X12 Salesforce Image Overall image of HBAT’s salesforce
X13 Competitive Pricing Extent to which HBAT offers competitive prices
X14 Warranty & Claims Extent to which HBAT stands behind its product/service warranties and claims
X15 New Products Extent to which HBAT develops and sells new products
X16 Ordering & Billing Perception that ordering and billing is handled efficiently and correctly
X17 Price Flexibility Perceived willingness of HBAT sales representatives to negotiate price on purchases of paper products
X18 Delivery Speed Amount of time it takes to deliver the paper products once an order has been confirmed
Customer satisfaction with past purchases from HBAT 0 – 10 graphic scale, where ‘0’ indicates "Not at All" and ‘10’ indicates "Completely Satisfied"
X19 Satisfaction
Likely to Recommend Likelihood of recommending HBAT to other firms as a supplier of paper products 0 – 10 graphic scale, where ‘0’ indicates "Not at All Likely" and ‘10’ indicates "Definitely"
X20
Likelihood of purchasing paper products from HBAT in the future 0 – 10 graphic scale, where ‘0’ indicates "Not at All Likely" and ‘10’ indicates "Definitely"
X21 Likely to Purchase
Percentage of the responding firm’s paper needs purchased from HBAT Measured on a 100-point percentage scale
X22 Purchase Level
Consider Strategic Alliance Extent to which the customer/respondent perceives his or her firm would engage in strategic alliance/partnership with HBAT 0 = No, would not consider; 1 = Yes, would consider
X23