ijmatrix.create: Interaction matrix with market shares
In MCI: Multiplicative Competitive Interaction (MCI) Model
Description
Usage
Arguments
Details
Value
Author(s)
References
See Also
Examples
Description
Creation of an interaction matrix with market shares (p_{ij}) of every supplier (j) in every submarket (i) based on the frequencies in the raw data (e.g. household or POS survey).
Usage
1
2
3
ijmatrix.create(rawdataset, submarkets, suppliers, ..., remNA = TRUE,
remSing = FALSE, remSing.val = 1, remSingSupp.val = 1,
correctVar = FALSE, correctVar.val = 1)
Arguments
rawdataset
a data.frame containing the raw data
submarkets
the column in the dataset containing the submarkets (e.g. ZIP codes)
suppliers
the column in the dataset containing the suppliers (e.g. store codes)
...
other numeric variables in the raw data which were observed and shall be used to calculate market shares (e.g. expenditures)
remNA
logical argument that indicates if NA values of the submarkets and suppliers are removed or not (default: remNA = TRUE, otherwise: remNA = FALSE, which means that NA are considered in the interaction matrix, recoded as factor 99999)
remSing
logical argument that indicates if singular instances of the submarkets and suppliers are removed or not (default: remSing = FALSE)
remSing.val
if remSing = TRUE: numeric value that indicates the limit value of singular instances in the submarket set to be removed from the data
remSingSupp.val
if remSing = TRUE: numeric value that indicates the limit value of singular instances in the supplier set to be removed from the data
correctVar
logical argument that indicates if the calculated market shares shall be corrected when they do not match the MCI standards (p_{ij} = 0) (default: correctVar = FALSE)
correctVar.val
if correctVar = TRUE: numeric value which is added to the absolute values before calculating market shares (default: 1)
Details
This function creates an interaction matrix for all i submarkets (e.g. geographical regions) and all j suppliers (e.g. store locations). The function calculates p_{ij} based on the frequencies and, optionally, further market shares calculated from other observed variables in the given raw dataset (e.g. expenditures from submarket i at supplier j).
Single observations with missing submarket or supplier (NA) are removed from the data automatically (unless remNA = FALSE). Optionally, singular instances (e.g. some submarkets or suppliers are only represented once or twice in the whole dataset) can also be removed (remSing = TRUE), where the limit values for extraction can be set by remSing.val and remSingSupp.val (e.g. remSing.val = 2 and remSingSupp.val = 1 removes every submarket from the interaction matrix which was observed ≤ 2 and every supplier observed ≤ 1).
Value
An interaction matrix which is a data.frame containing the i x j combinations ('interaction'), the submarkets (column is named as in raw data), the suppliers (column is named as in raw data), the observed absolute frequencies of every j in every i ('freq_ij_abs'), the observed absolute frequencies in every i ('freq_i_total') and the observed market shares of every j in every i ('p_ij_obs'). If additional variables are stated (e.g. expenditures) which shall be turned into (local) market shares, the output interaction matrix contains absolute values for every interaction, total values for every i submarket and market shares (p_{ij}) for these variables, too, which are automatically named based on the given variable name (e.g. the market shares based on a raw data variable called expen is named p_ij_obs_expen). The first three variables of the output matrix are factors, the calculated values are numeric.
Author(s)
Thomas Wieland
References
Cooper, L. G./Nakanishi, M. (2010): “Market-Share Analysis: Evaluating competitive marketing effectiveness”. Boston, Dordrecht, London : Kluwer (first published 1988). E-book version from 2010: http://www.anderson.ucla.edu/faculty/lee.cooper/MCI_Book/BOOKI2010.pdf
Huff, D. L./McCallum, D. (2008): “Calibrating the Huff Model Using ArcGIS Business Analyst”. ESRI White Paper, September 2008. https://www.esri.com/library/whitepapers/pdfs/calibrating-huff-model.pdf
Wieland, T. (2015): “Raeumliches Einkaufsverhalten und Standortpolitik im Einzelhandel unter Beruecksichtigung von Agglomerationseffekten. Theoretische Erklaerungsansaetze, modellanalytische Zugaenge und eine empirisch-oekonometrische Marktgebietsanalyse anhand eines Fallbeispiels aus dem laendlichen Raum Ostwestfalens/Suedniedersachsens”. Geographische Handelsforschung, 23. 289 pages. Mannheim : MetaGIS.
See Also
ijmatrix.shares, ijmatrix.crosstab
Examples
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
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
# Creating an interaction matrix based on the POS survey in grocery1 #
data(grocery1)
# Loads the data
ijmatrix.create (grocery1, "plz_submarket", "store_code")
# Creates an interaction matrix with local market shares based on frequencies
mynewmcidata <- ijmatrix.create (grocery1, "plz_submarket", "store_code")
# Save results directly in a new dataset
ijmatrix.create (grocery1, "plz_submarket", "store_code", "trip_expen")
# Creates an interaction matrix with local market shares based on frequencies
# and expenditures (Variable "trip_expen")
# MCI analysis for the grocery store market areas based on the POS survey in shopping1 #
data(shopping1)
# Loading the survey dataset
data(shopping2)
# Loading the distance/travel time dataset
data(shopping3)
# Loading the dataset containing information about the city districts
data(shopping4)
# Loading the grocery store data
shopping1_KAeast <- shopping1[shopping1$resid_code %in%
shopping3$resid_code[shopping3$KA_east == 1],]
# Extracting only inhabitants of the eastern districts of Karlsruhe
ijmatrix_gro_adj <- ijmatrix.create(shopping1_KAeast, "resid_code",
"gro_purchase_code", "gro_purchase_expen", remSing = TRUE, remSing.val = 1,
remSingSupp.val = 2, correctVar = TRUE, correctVar.val = 0.1)
# Removing singular instances/outliers (remSing = TRUE) incorporating
# only suppliers which are at least obtained three times (remSingSupp.val = 2)
# Correcting the values (correctVar = TRUE)
# by adding 0.1 to the absolute values (correctVar.val = 0.1)
ijmatrix_gro_adj <- ijmatrix_gro_adj[(ijmatrix_gro_adj$gro_purchase_code !=
"REFORMHAUSBOESER") & (ijmatrix_gro_adj$gro_purchase_code != "WMARKT_DURLACH")
& (ijmatrix_gro_adj$gro_purchase_code != "X_INCOMPLETE_STORE"),]
# Remove non-regarded observations
ijmatrix_gro_adj_dist <- merge (ijmatrix_gro_adj, shopping2, by.x="interaction",
by.y="route")
# Include the distances and travel times (shopping2)
ijmatrix_gro_adj_dist_stores <- merge (ijmatrix_gro_adj_dist, shopping4,
by.x = "gro_purchase_code", by.y = "location_code")
# Adding the store information (shopping4)
mci.transvar(ijmatrix_gro_adj_dist_stores, "resid_code", "gro_purchase_code",
"p_ij_obs")
# Log-centering transformation of one variable (p_ij_obs)
ijmatrix_gro_transf <- mci.transmat(ijmatrix_gro_adj_dist_stores, "resid_code",
"gro_purchase_code", "p_ij_obs", "d_time", "salesarea_qm")
# Log-centering transformation of the interaction matrix
mcimodel_gro_trips <- mci.fit(ijmatrix_gro_adj_dist_stores, "resid_code",
"gro_purchase_code", "p_ij_obs", "d_time", "salesarea_qm")
# MCI model for the grocery store market areas
# shares: "p_ij_obs", explanatory variables: "d_time", "salesarea_qm"
summary(mcimodel_gro_trips)
# Use like lm
Example output
interaction plz_submarket store_code freq_ij_abs freq_i_total
1 PLZ_37073-ALDI1 PLZ_37073 ALDI1 0 45
2 PLZ_37073-ALDI3 PLZ_37073 ALDI3 0 45
3 PLZ_37073-ALDI6 PLZ_37073 ALDI6 0 45
4 PLZ_37073-ALDI7 PLZ_37073 ALDI7 1 45
5 PLZ_37073-ALNATURA PLZ_37073 ALNATURA 2 45
6 PLZ_37073-EDEKA1 PLZ_37073 EDEKA1 1 45
7 PLZ_37073-EDEKA2 PLZ_37073 EDEKA2 0 45
8 PLZ_37073-EDEKA3 PLZ_37073 EDEKA3 0 45
9 PLZ_37073-EDEKA4 PLZ_37073 EDEKA4 0 45
10 PLZ_37073-EDEKA5 PLZ_37073 EDEKA5 0 45
11 PLZ_37073-KAUFLAND1 PLZ_37073 KAUFLAND1 0 45
12 PLZ_37073-KAUFLAND2 PLZ_37073 KAUFLAND2 11 45
13 PLZ_37073-LIDL1 PLZ_37073 LIDL1 1 45
14 PLZ_37073-LIDL2 PLZ_37073 LIDL2 0 45
15 PLZ_37073-NAHKAUF1 PLZ_37073 NAHKAUF1 0 45
16 PLZ_37073-NAHKAUF4 PLZ_37073 NAHKAUF4 0 45
17 PLZ_37073-NAHKAUF5 PLZ_37073 NAHKAUF5 0 45
18 PLZ_37073-NETTO1 PLZ_37073 NETTO1 5 45
19 PLZ_37073-NETTO6 PLZ_37073 NETTO6 0 45
20 PLZ_37073-PENNY1 PLZ_37073 PENNY1 0 45
21 PLZ_37073-PENNY2 PLZ_37073 PENNY2 0 45
22 PLZ_37073-REAL1 PLZ_37073 REAL1 1 45
23 PLZ_37073-REAL2 PLZ_37073 REAL2 0 45
24 PLZ_37073-REWE1 PLZ_37073 REWE1 8 45
25 PLZ_37073-REWE2 PLZ_37073 REWE2 0 45
26 PLZ_37073-REWE3 PLZ_37073 REWE3 3 45
27 PLZ_37073-REWE4 PLZ_37073 REWE4 2 45
28 PLZ_37073-REWE6 PLZ_37073 REWE6 0 45
29 PLZ_37073-TEGUT1 PLZ_37073 TEGUT1 9 45
30 PLZ_37073-TEGUT2 PLZ_37073 TEGUT2 1 45
31 PLZ_37073-TEGUT3 PLZ_37073 TEGUT3 0 45
32 PLZ_37073-TEGUT4 PLZ_37073 TEGUT4 0 45
33 PLZ_37075-ALDI1 PLZ_37075 ALDI1 3 42
34 PLZ_37075-ALDI3 PLZ_37075 ALDI3 0 42
35 PLZ_37075-ALDI6 PLZ_37075 ALDI6 0 42
36 PLZ_37075-ALDI7 PLZ_37075 ALDI7 0 42
37 PLZ_37075-ALNATURA PLZ_37075 ALNATURA 3 42
38 PLZ_37075-EDEKA1 PLZ_37075 EDEKA1 0 42
39 PLZ_37075-EDEKA2 PLZ_37075 EDEKA2 0 42
40 PLZ_37075-EDEKA3 PLZ_37075 EDEKA3 0 42
41 PLZ_37075-EDEKA4 PLZ_37075 EDEKA4 2 42
42 PLZ_37075-EDEKA5 PLZ_37075 EDEKA5 0 42
43 PLZ_37075-KAUFLAND1 PLZ_37075 KAUFLAND1 0 42
44 PLZ_37075-KAUFLAND2 PLZ_37075 KAUFLAND2 4 42
45 PLZ_37075-LIDL1 PLZ_37075 LIDL1 2 42
46 PLZ_37075-LIDL2 PLZ_37075 LIDL2 0 42
47 PLZ_37075-NAHKAUF1 PLZ_37075 NAHKAUF1 0 42
48 PLZ_37075-NAHKAUF4 PLZ_37075 NAHKAUF4 0 42
49 PLZ_37075-NAHKAUF5 PLZ_37075 NAHKAUF5 0 42
50 PLZ_37075-NETTO1 PLZ_37075 NETTO1 1 42
51 PLZ_37075-NETTO6 PLZ_37075 NETTO6 1 42
52 PLZ_37075-PENNY1 PLZ_37075 PENNY1 3 42
53 PLZ_37075-PENNY2 PLZ_37075 PENNY2 0 42
54 PLZ_37075-REAL1 PLZ_37075 REAL1 1 42
55 PLZ_37075-REAL2 PLZ_37075 REAL2 2 42
56 PLZ_37075-REWE1 PLZ_37075 REWE1 2 42
57 PLZ_37075-REWE2 PLZ_37075 REWE2 0 42
58 PLZ_37075-REWE3 PLZ_37075 REWE3 10 42
59 PLZ_37075-REWE4 PLZ_37075 REWE4 1 42
60 PLZ_37075-REWE6 PLZ_37075 REWE6 0 42
61 PLZ_37075-TEGUT1 PLZ_37075 TEGUT1 6 42
62 PLZ_37075-TEGUT2 PLZ_37075 TEGUT2 1 42
63 PLZ_37075-TEGUT3 PLZ_37075 TEGUT3 0 42
64 PLZ_37075-TEGUT4 PLZ_37075 TEGUT4 0 42
65 PLZ_37077-ALDI1 PLZ_37077 ALDI1 0 15
66 PLZ_37077-ALDI3 PLZ_37077 ALDI3 0 15
67 PLZ_37077-ALDI6 PLZ_37077 ALDI6 0 15
68 PLZ_37077-ALDI7 PLZ_37077 ALDI7 0 15
69 PLZ_37077-ALNATURA PLZ_37077 ALNATURA 0 15
70 PLZ_37077-EDEKA1 PLZ_37077 EDEKA1 1 15
71 PLZ_37077-EDEKA2 PLZ_37077 EDEKA2 1 15
72 PLZ_37077-EDEKA3 PLZ_37077 EDEKA3 0 15
73 PLZ_37077-EDEKA4 PLZ_37077 EDEKA4 0 15
74 PLZ_37077-EDEKA5 PLZ_37077 EDEKA5 0 15
75 PLZ_37077-KAUFLAND1 PLZ_37077 KAUFLAND1 0 15
76 PLZ_37077-KAUFLAND2 PLZ_37077 KAUFLAND2 1 15
77 PLZ_37077-LIDL1 PLZ_37077 LIDL1 0 15
78 PLZ_37077-LIDL2 PLZ_37077 LIDL2 0 15
79 PLZ_37077-NAHKAUF1 PLZ_37077 NAHKAUF1 2 15
80 PLZ_37077-NAHKAUF4 PLZ_37077 NAHKAUF4 0 15
81 PLZ_37077-NAHKAUF5 PLZ_37077 NAHKAUF5 0 15
82 PLZ_37077-NETTO1 PLZ_37077 NETTO1 0 15
83 PLZ_37077-NETTO6 PLZ_37077 NETTO6 0 15
84 PLZ_37077-PENNY1 PLZ_37077 PENNY1 0 15
85 PLZ_37077-PENNY2 PLZ_37077 PENNY2 0 15
86 PLZ_37077-REAL1 PLZ_37077 REAL1 4 15
87 PLZ_37077-REAL2 PLZ_37077 REAL2 0 15
88 PLZ_37077-REWE1 PLZ_37077 REWE1 0 15
89 PLZ_37077-REWE2 PLZ_37077 REWE2 0 15
90 PLZ_37077-REWE3 PLZ_37077 REWE3 0 15
91 PLZ_37077-REWE4 PLZ_37077 REWE4 0 15
92 PLZ_37077-REWE6 PLZ_37077 REWE6 0 15
93 PLZ_37077-TEGUT1 PLZ_37077 TEGUT1 4 15
94 PLZ_37077-TEGUT2 PLZ_37077 TEGUT2 2 15
95 PLZ_37077-TEGUT3 PLZ_37077 TEGUT3 0 15
96 PLZ_37077-TEGUT4 PLZ_37077 TEGUT4 0 15
97 PLZ_37079-ALDI1 PLZ_37079 ALDI1 0 12
98 PLZ_37079-ALDI3 PLZ_37079 ALDI3 0 12
99 PLZ_37079-ALDI6 PLZ_37079 ALDI6 0 12
100 PLZ_37079-ALDI7 PLZ_37079 ALDI7 0 12
101 PLZ_37079-ALNATURA PLZ_37079 ALNATURA 1 12
102 PLZ_37079-EDEKA1 PLZ_37079 EDEKA1 0 12
103 PLZ_37079-EDEKA2 PLZ_37079 EDEKA2 0 12
104 PLZ_37079-EDEKA3 PLZ_37079 EDEKA3 2 12
105 PLZ_37079-EDEKA4 PLZ_37079 EDEKA4 0 12
106 PLZ_37079-EDEKA5 PLZ_37079 EDEKA5 0 12
107 PLZ_37079-KAUFLAND1 PLZ_37079 KAUFLAND1 1 12
108 PLZ_37079-KAUFLAND2 PLZ_37079 KAUFLAND2 1 12
109 PLZ_37079-LIDL1 PLZ_37079 LIDL1 0 12
110 PLZ_37079-LIDL2 PLZ_37079 LIDL2 0 12
111 PLZ_37079-NAHKAUF1 PLZ_37079 NAHKAUF1 0 12
112 PLZ_37079-NAHKAUF4 PLZ_37079 NAHKAUF4 1 12
113 PLZ_37079-NAHKAUF5 PLZ_37079 NAHKAUF5 0 12
114 PLZ_37079-NETTO1 PLZ_37079 NETTO1 0 12
115 PLZ_37079-NETTO6 PLZ_37079 NETTO6 0 12
116 PLZ_37079-PENNY1 PLZ_37079 PENNY1 0 12
117 PLZ_37079-PENNY2 PLZ_37079 PENNY2 0 12
118 PLZ_37079-REAL1 PLZ_37079 REAL1 1 12
119 PLZ_37079-REAL2 PLZ_37079 REAL2 3 12
120 PLZ_37079-REWE1 PLZ_37079 REWE1 0 12
121 PLZ_37079-REWE2 PLZ_37079 REWE2 1 12
122 PLZ_37079-REWE3 PLZ_37079 REWE3 0 12
123 PLZ_37079-REWE4 PLZ_37079 REWE4 0 12
124 PLZ_37079-REWE6 PLZ_37079 REWE6 0 12
125 PLZ_37079-TEGUT1 PLZ_37079 TEGUT1 0 12
126 PLZ_37079-TEGUT2 PLZ_37079 TEGUT2 1 12
127 PLZ_37079-TEGUT3 PLZ_37079 TEGUT3 0 12
128 PLZ_37079-TEGUT4 PLZ_37079 TEGUT4 0 12
129 PLZ_37081-ALDI1 PLZ_37081 ALDI1 0 13
130 PLZ_37081-ALDI3 PLZ_37081 ALDI3 0 13
131 PLZ_37081-ALDI6 PLZ_37081 ALDI6 1 13
132 PLZ_37081-ALDI7 PLZ_37081 ALDI7 0 13
133 PLZ_37081-ALNATURA PLZ_37081 ALNATURA 0 13
134 PLZ_37081-EDEKA1 PLZ_37081 EDEKA1 0 13
135 PLZ_37081-EDEKA2 PLZ_37081 EDEKA2 0 13
136 PLZ_37081-EDEKA3 PLZ_37081 EDEKA3 0 13
137 PLZ_37081-EDEKA4 PLZ_37081 EDEKA4 0 13
138 PLZ_37081-EDEKA5 PLZ_37081 EDEKA5 0 13
139 PLZ_37081-KAUFLAND1 PLZ_37081 KAUFLAND1 1 13
140 PLZ_37081-KAUFLAND2 PLZ_37081 KAUFLAND2 1 13
141 PLZ_37081-LIDL1 PLZ_37081 LIDL1 0 13
142 PLZ_37081-LIDL2 PLZ_37081 LIDL2 1 13
143 PLZ_37081-NAHKAUF1 PLZ_37081 NAHKAUF1 0 13
144 PLZ_37081-NAHKAUF4 PLZ_37081 NAHKAUF4 0 13
145 PLZ_37081-NAHKAUF5 PLZ_37081 NAHKAUF5 0 13
146 PLZ_37081-NETTO1 PLZ_37081 NETTO1 2 13
147 PLZ_37081-NETTO6 PLZ_37081 NETTO6 0 13
148 PLZ_37081-PENNY1 PLZ_37081 PENNY1 0 13
149 PLZ_37081-PENNY2 PLZ_37081 PENNY2 0 13
150 PLZ_37081-REAL1 PLZ_37081 REAL1 0 13
151 PLZ_37081-REAL2 PLZ_37081 REAL2 0 13
152 PLZ_37081-REWE1 PLZ_37081 REWE1 2 13
153 PLZ_37081-REWE2 PLZ_37081 REWE2 0 13
154 PLZ_37081-REWE3 PLZ_37081 REWE3 0 13
155 PLZ_37081-REWE4 PLZ_37081 REWE4 0 13
156 PLZ_37081-REWE6 PLZ_37081 REWE6 2 13
157 PLZ_37081-TEGUT1 PLZ_37081 TEGUT1 2 13
158 PLZ_37081-TEGUT2 PLZ_37081 TEGUT2 0 13
159 PLZ_37081-TEGUT3 PLZ_37081 TEGUT3 1 13
160 PLZ_37081-TEGUT4 PLZ_37081 TEGUT4 0 13
161 PLZ_37083-ALDI1 PLZ_37083 ALDI1 0 25
162 PLZ_37083-ALDI3 PLZ_37083 ALDI3 1 25
163 PLZ_37083-ALDI6 PLZ_37083 ALDI6 0 25
164 PLZ_37083-ALDI7 PLZ_37083 ALDI7 0 25
165 PLZ_37083-ALNATURA PLZ_37083 ALNATURA 0 25
166 PLZ_37083-EDEKA1 PLZ_37083 EDEKA1 0 25
167 PLZ_37083-EDEKA2 PLZ_37083 EDEKA2 0 25
168 PLZ_37083-EDEKA3 PLZ_37083 EDEKA3 0 25
169 PLZ_37083-EDEKA4 PLZ_37083 EDEKA4 0 25
170 PLZ_37083-EDEKA5 PLZ_37083 EDEKA5 2 25
171 PLZ_37083-KAUFLAND1 PLZ_37083 KAUFLAND1 3 25
172 PLZ_37083-KAUFLAND2 PLZ_37083 KAUFLAND2 5 25
173 PLZ_37083-LIDL1 PLZ_37083 LIDL1 1 25
174 PLZ_37083-LIDL2 PLZ_37083 LIDL2 0 25
175 PLZ_37083-NAHKAUF1 PLZ_37083 NAHKAUF1 0 25
176 PLZ_37083-NAHKAUF4 PLZ_37083 NAHKAUF4 0 25
177 PLZ_37083-NAHKAUF5 PLZ_37083 NAHKAUF5 0 25
178 PLZ_37083-NETTO1 PLZ_37083 NETTO1 1 25
179 PLZ_37083-NETTO6 PLZ_37083 NETTO6 0 25
180 PLZ_37083-PENNY1 PLZ_37083 PENNY1 0 25
181 PLZ_37083-PENNY2 PLZ_37083 PENNY2 2 25
182 PLZ_37083-REAL1 PLZ_37083 REAL1 0 25
183 PLZ_37083-REAL2 PLZ_37083 REAL2 1 25
184 PLZ_37083-REWE1 PLZ_37083 REWE1 1 25
185 PLZ_37083-REWE2 PLZ_37083 REWE2 0 25
186 PLZ_37083-REWE3 PLZ_37083 REWE3 0 25
187 PLZ_37083-REWE4 PLZ_37083 REWE4 6 25
188 PLZ_37083-REWE6 PLZ_37083 REWE6 0 25
189 PLZ_37083-TEGUT1 PLZ_37083 TEGUT1 2 25
190 PLZ_37083-TEGUT2 PLZ_37083 TEGUT2 0 25
191 PLZ_37083-TEGUT3 PLZ_37083 TEGUT3 0 25
192 PLZ_37083-TEGUT4 PLZ_37083 TEGUT4 0 25
193 PLZ_37085-ALDI1 PLZ_37085 ALDI1 0 27
194 PLZ_37085-ALDI3 PLZ_37085 ALDI3 0 27
195 PLZ_37085-ALDI6 PLZ_37085 ALDI6 0 27
196 PLZ_37085-ALDI7 PLZ_37085 ALDI7 0 27
197 PLZ_37085-ALNATURA PLZ_37085 ALNATURA 1 27
198 PLZ_37085-EDEKA1 PLZ_37085 EDEKA1 0 27
199 PLZ_37085-EDEKA2 PLZ_37085 EDEKA2 0 27
200 PLZ_37085-EDEKA3 PLZ_37085 EDEKA3 0 27
201 PLZ_37085-EDEKA4 PLZ_37085 EDEKA4 2 27
202 PLZ_37085-EDEKA5 PLZ_37085 EDEKA5 0 27
203 PLZ_37085-KAUFLAND1 PLZ_37085 KAUFLAND1 2 27
204 PLZ_37085-KAUFLAND2 PLZ_37085 KAUFLAND2 4 27
205 PLZ_37085-LIDL1 PLZ_37085 LIDL1 1 27
206 PLZ_37085-LIDL2 PLZ_37085 LIDL2 0 27
207 PLZ_37085-NAHKAUF1 PLZ_37085 NAHKAUF1 0 27
208 PLZ_37085-NAHKAUF4 PLZ_37085 NAHKAUF4 0 27
209 PLZ_37085-NAHKAUF5 PLZ_37085 NAHKAUF5 3 27
210 PLZ_37085-NETTO1 PLZ_37085 NETTO1 3 27
211 PLZ_37085-NETTO6 PLZ_37085 NETTO6 0 27
212 PLZ_37085-PENNY1 PLZ_37085 PENNY1 0 27
213 PLZ_37085-PENNY2 PLZ_37085 PENNY2 0 27
214 PLZ_37085-REAL1 PLZ_37085 REAL1 1 27
215 PLZ_37085-REAL2 PLZ_37085 REAL2 1 27
216 PLZ_37085-REWE1 PLZ_37085 REWE1 3 27
217 PLZ_37085-REWE2 PLZ_37085 REWE2 0 27
218 PLZ_37085-REWE3 PLZ_37085 REWE3 0 27
219 PLZ_37085-REWE4 PLZ_37085 REWE4 2 27
220 PLZ_37085-REWE6 PLZ_37085 REWE6 0 27
221 PLZ_37085-TEGUT1 PLZ_37085 TEGUT1 2 27
222 PLZ_37085-TEGUT2 PLZ_37085 TEGUT2 1 27
223 PLZ_37085-TEGUT3 PLZ_37085 TEGUT3 0 27
224 PLZ_37085-TEGUT4 PLZ_37085 TEGUT4 1 27
p_ij_obs
1 0.00000000
2 0.00000000
3 0.00000000
4 0.02222222
5 0.04444444
6 0.02222222
7 0.00000000
8 0.00000000
9 0.00000000
10 0.00000000
11 0.00000000
12 0.24444444
13 0.02222222
14 0.00000000
15 0.00000000
16 0.00000000
17 0.00000000
18 0.11111111
19 0.00000000
20 0.00000000
21 0.00000000
22 0.02222222
23 0.00000000
24 0.17777778
25 0.00000000
26 0.06666667
27 0.04444444
28 0.00000000
29 0.20000000
30 0.02222222
31 0.00000000
32 0.00000000
33 0.07142857
34 0.00000000
35 0.00000000
36 0.00000000
37 0.07142857
38 0.00000000
39 0.00000000
40 0.00000000
41 0.04761905
42 0.00000000
43 0.00000000
44 0.09523810
45 0.04761905
46 0.00000000
47 0.00000000
48 0.00000000
49 0.00000000
50 0.02380952
51 0.02380952
52 0.07142857
53 0.00000000
54 0.02380952
55 0.04761905
56 0.04761905
57 0.00000000
58 0.23809524
59 0.02380952
60 0.00000000
61 0.14285714
62 0.02380952
63 0.00000000
64 0.00000000
65 0.00000000
66 0.00000000
67 0.00000000
68 0.00000000
69 0.00000000
70 0.06666667
71 0.06666667
72 0.00000000
73 0.00000000
74 0.00000000
75 0.00000000
76 0.06666667
77 0.00000000
78 0.00000000
79 0.13333333
80 0.00000000
81 0.00000000
82 0.00000000
83 0.00000000
84 0.00000000
85 0.00000000
86 0.26666667
87 0.00000000
88 0.00000000
89 0.00000000
90 0.00000000
91 0.00000000
92 0.00000000
93 0.26666667
94 0.13333333
95 0.00000000
96 0.00000000
97 0.00000000
98 0.00000000
99 0.00000000
100 0.00000000
101 0.08333333
102 0.00000000
103 0.00000000
104 0.16666667
105 0.00000000
106 0.00000000
107 0.08333333
108 0.08333333
109 0.00000000
110 0.00000000
111 0.00000000
112 0.08333333
113 0.00000000
114 0.00000000
115 0.00000000
116 0.00000000
117 0.00000000
118 0.08333333
119 0.25000000
120 0.00000000
121 0.08333333
122 0.00000000
123 0.00000000
124 0.00000000
125 0.00000000
126 0.08333333
127 0.00000000
128 0.00000000
129 0.00000000
130 0.00000000
131 0.07692308
132 0.00000000
133 0.00000000
134 0.00000000
135 0.00000000
136 0.00000000
137 0.00000000
138 0.00000000
139 0.07692308
140 0.07692308
141 0.00000000
142 0.07692308
143 0.00000000
144 0.00000000
145 0.00000000
146 0.15384615
147 0.00000000
148 0.00000000
149 0.00000000
150 0.00000000
151 0.00000000
152 0.15384615
153 0.00000000
154 0.00000000
155 0.00000000
156 0.15384615
157 0.15384615
158 0.00000000
159 0.07692308
160 0.00000000
161 0.00000000
162 0.04000000
163 0.00000000
164 0.00000000
165 0.00000000
166 0.00000000
167 0.00000000
168 0.00000000
169 0.00000000
170 0.08000000
171 0.12000000
172 0.20000000
173 0.04000000
174 0.00000000
175 0.00000000
176 0.00000000
177 0.00000000
178 0.04000000
179 0.00000000
180 0.00000000
181 0.08000000
182 0.00000000
183 0.04000000
184 0.04000000
185 0.00000000
186 0.00000000
187 0.24000000
188 0.00000000
189 0.08000000
190 0.00000000
191 0.00000000
192 0.00000000
193 0.00000000
194 0.00000000
195 0.00000000
196 0.00000000
197 0.03703704
198 0.00000000
199 0.00000000
200 0.00000000
201 0.07407407
202 0.00000000
203 0.07407407
204 0.14814815
205 0.03703704
206 0.00000000
207 0.00000000
208 0.00000000
209 0.11111111
210 0.11111111
211 0.00000000
212 0.00000000
213 0.00000000
214 0.03703704
215 0.03703704
216 0.11111111
217 0.00000000
218 0.00000000
219 0.07407407
220 0.00000000
221 0.07407407
222 0.03703704
223 0.00000000
224 0.03703704
interaction plz_submarket store_code freq_ij_abs freq_i_total
1 PLZ_37073-ALDI1 PLZ_37073 ALDI1 0 45
2 PLZ_37073-ALDI3 PLZ_37073 ALDI3 0 45
3 PLZ_37073-ALDI6 PLZ_37073 ALDI6 0 45
4 PLZ_37073-ALDI7 PLZ_37073 ALDI7 1 45
5 PLZ_37073-ALNATURA PLZ_37073 ALNATURA 2 45
6 PLZ_37073-EDEKA1 PLZ_37073 EDEKA1 1 45
7 PLZ_37073-EDEKA2 PLZ_37073 EDEKA2 0 45
8 PLZ_37073-EDEKA3 PLZ_37073 EDEKA3 0 45
9 PLZ_37073-EDEKA4 PLZ_37073 EDEKA4 0 45
10 PLZ_37073-EDEKA5 PLZ_37073 EDEKA5 0 45
11 PLZ_37073-KAUFLAND1 PLZ_37073 KAUFLAND1 0 45
12 PLZ_37073-KAUFLAND2 PLZ_37073 KAUFLAND2 11 45
13 PLZ_37073-LIDL1 PLZ_37073 LIDL1 1 45
14 PLZ_37073-LIDL2 PLZ_37073 LIDL2 0 45
15 PLZ_37073-NAHKAUF1 PLZ_37073 NAHKAUF1 0 45
16 PLZ_37073-NAHKAUF4 PLZ_37073 NAHKAUF4 0 45
17 PLZ_37073-NAHKAUF5 PLZ_37073 NAHKAUF5 0 45
18 PLZ_37073-NETTO1 PLZ_37073 NETTO1 5 45
19 PLZ_37073-NETTO6 PLZ_37073 NETTO6 0 45
20 PLZ_37073-PENNY1 PLZ_37073 PENNY1 0 45
21 PLZ_37073-PENNY2 PLZ_37073 PENNY2 0 45
22 PLZ_37073-REAL1 PLZ_37073 REAL1 1 45
23 PLZ_37073-REAL2 PLZ_37073 REAL2 0 45
24 PLZ_37073-REWE1 PLZ_37073 REWE1 8 45
25 PLZ_37073-REWE2 PLZ_37073 REWE2 0 45
26 PLZ_37073-REWE3 PLZ_37073 REWE3 3 45
27 PLZ_37073-REWE4 PLZ_37073 REWE4 2 45
28 PLZ_37073-REWE6 PLZ_37073 REWE6 0 45
29 PLZ_37073-TEGUT1 PLZ_37073 TEGUT1 9 45
30 PLZ_37073-TEGUT2 PLZ_37073 TEGUT2 1 45
31 PLZ_37073-TEGUT3 PLZ_37073 TEGUT3 0 45
32 PLZ_37073-TEGUT4 PLZ_37073 TEGUT4 0 45
33 PLZ_37075-ALDI1 PLZ_37075 ALDI1 3 42
34 PLZ_37075-ALDI3 PLZ_37075 ALDI3 0 42
35 PLZ_37075-ALDI6 PLZ_37075 ALDI6 0 42
36 PLZ_37075-ALDI7 PLZ_37075 ALDI7 0 42
37 PLZ_37075-ALNATURA PLZ_37075 ALNATURA 3 42
38 PLZ_37075-EDEKA1 PLZ_37075 EDEKA1 0 42
39 PLZ_37075-EDEKA2 PLZ_37075 EDEKA2 0 42
40 PLZ_37075-EDEKA3 PLZ_37075 EDEKA3 0 42
41 PLZ_37075-EDEKA4 PLZ_37075 EDEKA4 2 42
42 PLZ_37075-EDEKA5 PLZ_37075 EDEKA5 0 42
43 PLZ_37075-KAUFLAND1 PLZ_37075 KAUFLAND1 0 42
44 PLZ_37075-KAUFLAND2 PLZ_37075 KAUFLAND2 4 42
45 PLZ_37075-LIDL1 PLZ_37075 LIDL1 2 42
46 PLZ_37075-LIDL2 PLZ_37075 LIDL2 0 42
47 PLZ_37075-NAHKAUF1 PLZ_37075 NAHKAUF1 0 42
48 PLZ_37075-NAHKAUF4 PLZ_37075 NAHKAUF4 0 42
49 PLZ_37075-NAHKAUF5 PLZ_37075 NAHKAUF5 0 42
50 PLZ_37075-NETTO1 PLZ_37075 NETTO1 1 42
51 PLZ_37075-NETTO6 PLZ_37075 NETTO6 1 42
52 PLZ_37075-PENNY1 PLZ_37075 PENNY1 3 42
53 PLZ_37075-PENNY2 PLZ_37075 PENNY2 0 42
54 PLZ_37075-REAL1 PLZ_37075 REAL1 1 42
55 PLZ_37075-REAL2 PLZ_37075 REAL2 2 42
56 PLZ_37075-REWE1 PLZ_37075 REWE1 2 42
57 PLZ_37075-REWE2 PLZ_37075 REWE2 0 42
58 PLZ_37075-REWE3 PLZ_37075 REWE3 10 42
59 PLZ_37075-REWE4 PLZ_37075 REWE4 1 42
60 PLZ_37075-REWE6 PLZ_37075 REWE6 0 42
61 PLZ_37075-TEGUT1 PLZ_37075 TEGUT1 6 42
62 PLZ_37075-TEGUT2 PLZ_37075 TEGUT2 1 42
63 PLZ_37075-TEGUT3 PLZ_37075 TEGUT3 0 42
64 PLZ_37075-TEGUT4 PLZ_37075 TEGUT4 0 42
65 PLZ_37077-ALDI1 PLZ_37077 ALDI1 0 15
66 PLZ_37077-ALDI3 PLZ_37077 ALDI3 0 15
67 PLZ_37077-ALDI6 PLZ_37077 ALDI6 0 15
68 PLZ_37077-ALDI7 PLZ_37077 ALDI7 0 15
69 PLZ_37077-ALNATURA PLZ_37077 ALNATURA 0 15
70 PLZ_37077-EDEKA1 PLZ_37077 EDEKA1 1 15
71 PLZ_37077-EDEKA2 PLZ_37077 EDEKA2 1 15
72 PLZ_37077-EDEKA3 PLZ_37077 EDEKA3 0 15
73 PLZ_37077-EDEKA4 PLZ_37077 EDEKA4 0 15
74 PLZ_37077-EDEKA5 PLZ_37077 EDEKA5 0 15
75 PLZ_37077-KAUFLAND1 PLZ_37077 KAUFLAND1 0 15
76 PLZ_37077-KAUFLAND2 PLZ_37077 KAUFLAND2 1 15
77 PLZ_37077-LIDL1 PLZ_37077 LIDL1 0 15
78 PLZ_37077-LIDL2 PLZ_37077 LIDL2 0 15
79 PLZ_37077-NAHKAUF1 PLZ_37077 NAHKAUF1 2 15
80 PLZ_37077-NAHKAUF4 PLZ_37077 NAHKAUF4 0 15
81 PLZ_37077-NAHKAUF5 PLZ_37077 NAHKAUF5 0 15
82 PLZ_37077-NETTO1 PLZ_37077 NETTO1 0 15
83 PLZ_37077-NETTO6 PLZ_37077 NETTO6 0 15
84 PLZ_37077-PENNY1 PLZ_37077 PENNY1 0 15
85 PLZ_37077-PENNY2 PLZ_37077 PENNY2 0 15
86 PLZ_37077-REAL1 PLZ_37077 REAL1 4 15
87 PLZ_37077-REAL2 PLZ_37077 REAL2 0 15
88 PLZ_37077-REWE1 PLZ_37077 REWE1 0 15
89 PLZ_37077-REWE2 PLZ_37077 REWE2 0 15
90 PLZ_37077-REWE3 PLZ_37077 REWE3 0 15
91 PLZ_37077-REWE4 PLZ_37077 REWE4 0 15
92 PLZ_37077-REWE6 PLZ_37077 REWE6 0 15
93 PLZ_37077-TEGUT1 PLZ_37077 TEGUT1 4 15
94 PLZ_37077-TEGUT2 PLZ_37077 TEGUT2 2 15
95 PLZ_37077-TEGUT3 PLZ_37077 TEGUT3 0 15
96 PLZ_37077-TEGUT4 PLZ_37077 TEGUT4 0 15
97 PLZ_37079-ALDI1 PLZ_37079 ALDI1 0 12
98 PLZ_37079-ALDI3 PLZ_37079 ALDI3 0 12
99 PLZ_37079-ALDI6 PLZ_37079 ALDI6 0 12
100 PLZ_37079-ALDI7 PLZ_37079 ALDI7 0 12
101 PLZ_37079-ALNATURA PLZ_37079 ALNATURA 1 12
102 PLZ_37079-EDEKA1 PLZ_37079 EDEKA1 0 12
103 PLZ_37079-EDEKA2 PLZ_37079 EDEKA2 0 12
104 PLZ_37079-EDEKA3 PLZ_37079 EDEKA3 2 12
105 PLZ_37079-EDEKA4 PLZ_37079 EDEKA4 0 12
106 PLZ_37079-EDEKA5 PLZ_37079 EDEKA5 0 12
107 PLZ_37079-KAUFLAND1 PLZ_37079 KAUFLAND1 1 12
108 PLZ_37079-KAUFLAND2 PLZ_37079 KAUFLAND2 1 12
109 PLZ_37079-LIDL1 PLZ_37079 LIDL1 0 12
110 PLZ_37079-LIDL2 PLZ_37079 LIDL2 0 12
111 PLZ_37079-NAHKAUF1 PLZ_37079 NAHKAUF1 0 12
112 PLZ_37079-NAHKAUF4 PLZ_37079 NAHKAUF4 1 12
113 PLZ_37079-NAHKAUF5 PLZ_37079 NAHKAUF5 0 12
114 PLZ_37079-NETTO1 PLZ_37079 NETTO1 0 12
115 PLZ_37079-NETTO6 PLZ_37079 NETTO6 0 12
116 PLZ_37079-PENNY1 PLZ_37079 PENNY1 0 12
117 PLZ_37079-PENNY2 PLZ_37079 PENNY2 0 12
118 PLZ_37079-REAL1 PLZ_37079 REAL1 1 12
119 PLZ_37079-REAL2 PLZ_37079 REAL2 3 12
120 PLZ_37079-REWE1 PLZ_37079 REWE1 0 12
121 PLZ_37079-REWE2 PLZ_37079 REWE2 1 12
122 PLZ_37079-REWE3 PLZ_37079 REWE3 0 12
123 PLZ_37079-REWE4 PLZ_37079 REWE4 0 12
124 PLZ_37079-REWE6 PLZ_37079 REWE6 0 12
125 PLZ_37079-TEGUT1 PLZ_37079 TEGUT1 0 12
126 PLZ_37079-TEGUT2 PLZ_37079 TEGUT2 1 12
127 PLZ_37079-TEGUT3 PLZ_37079 TEGUT3 0 12
128 PLZ_37079-TEGUT4 PLZ_37079 TEGUT4 0 12
129 PLZ_37081-ALDI1 PLZ_37081 ALDI1 0 13
130 PLZ_37081-ALDI3 PLZ_37081 ALDI3 0 13
131 PLZ_37081-ALDI6 PLZ_37081 ALDI6 1 13
132 PLZ_37081-ALDI7 PLZ_37081 ALDI7 0 13
133 PLZ_37081-ALNATURA PLZ_37081 ALNATURA 0 13
134 PLZ_37081-EDEKA1 PLZ_37081 EDEKA1 0 13
135 PLZ_37081-EDEKA2 PLZ_37081 EDEKA2 0 13
136 PLZ_37081-EDEKA3 PLZ_37081 EDEKA3 0 13
137 PLZ_37081-EDEKA4 PLZ_37081 EDEKA4 0 13
138 PLZ_37081-EDEKA5 PLZ_37081 EDEKA5 0 13
139 PLZ_37081-KAUFLAND1 PLZ_37081 KAUFLAND1 1 13
140 PLZ_37081-KAUFLAND2 PLZ_37081 KAUFLAND2 1 13
141 PLZ_37081-LIDL1 PLZ_37081 LIDL1 0 13
142 PLZ_37081-LIDL2 PLZ_37081 LIDL2 1 13
143 PLZ_37081-NAHKAUF1 PLZ_37081 NAHKAUF1 0 13
144 PLZ_37081-NAHKAUF4 PLZ_37081 NAHKAUF4 0 13
145 PLZ_37081-NAHKAUF5 PLZ_37081 NAHKAUF5 0 13
146 PLZ_37081-NETTO1 PLZ_37081 NETTO1 2 13
147 PLZ_37081-NETTO6 PLZ_37081 NETTO6 0 13
148 PLZ_37081-PENNY1 PLZ_37081 PENNY1 0 13
149 PLZ_37081-PENNY2 PLZ_37081 PENNY2 0 13
150 PLZ_37081-REAL1 PLZ_37081 REAL1 0 13
151 PLZ_37081-REAL2 PLZ_37081 REAL2 0 13
152 PLZ_37081-REWE1 PLZ_37081 REWE1 2 13
153 PLZ_37081-REWE2 PLZ_37081 REWE2 0 13
154 PLZ_37081-REWE3 PLZ_37081 REWE3 0 13
155 PLZ_37081-REWE4 PLZ_37081 REWE4 0 13
156 PLZ_37081-REWE6 PLZ_37081 REWE6 2 13
157 PLZ_37081-TEGUT1 PLZ_37081 TEGUT1 2 13
158 PLZ_37081-TEGUT2 PLZ_37081 TEGUT2 0 13
159 PLZ_37081-TEGUT3 PLZ_37081 TEGUT3 1 13
160 PLZ_37081-TEGUT4 PLZ_37081 TEGUT4 0 13
161 PLZ_37083-ALDI1 PLZ_37083 ALDI1 0 25
162 PLZ_37083-ALDI3 PLZ_37083 ALDI3 1 25
163 PLZ_37083-ALDI6 PLZ_37083 ALDI6 0 25
164 PLZ_37083-ALDI7 PLZ_37083 ALDI7 0 25
165 PLZ_37083-ALNATURA PLZ_37083 ALNATURA 0 25
166 PLZ_37083-EDEKA1 PLZ_37083 EDEKA1 0 25
167 PLZ_37083-EDEKA2 PLZ_37083 EDEKA2 0 25
168 PLZ_37083-EDEKA3 PLZ_37083 EDEKA3 0 25
169 PLZ_37083-EDEKA4 PLZ_37083 EDEKA4 0 25
170 PLZ_37083-EDEKA5 PLZ_37083 EDEKA5 2 25
171 PLZ_37083-KAUFLAND1 PLZ_37083 KAUFLAND1 3 25
172 PLZ_37083-KAUFLAND2 PLZ_37083 KAUFLAND2 5 25
173 PLZ_37083-LIDL1 PLZ_37083 LIDL1 1 25
174 PLZ_37083-LIDL2 PLZ_37083 LIDL2 0 25
175 PLZ_37083-NAHKAUF1 PLZ_37083 NAHKAUF1 0 25
176 PLZ_37083-NAHKAUF4 PLZ_37083 NAHKAUF4 0 25
177 PLZ_37083-NAHKAUF5 PLZ_37083 NAHKAUF5 0 25
178 PLZ_37083-NETTO1 PLZ_37083 NETTO1 1 25
179 PLZ_37083-NETTO6 PLZ_37083 NETTO6 0 25
180 PLZ_37083-PENNY1 PLZ_37083 PENNY1 0 25
181 PLZ_37083-PENNY2 PLZ_37083 PENNY2 2 25
182 PLZ_37083-REAL1 PLZ_37083 REAL1 0 25
183 PLZ_37083-REAL2 PLZ_37083 REAL2 1 25
184 PLZ_37083-REWE1 PLZ_37083 REWE1 1 25
185 PLZ_37083-REWE2 PLZ_37083 REWE2 0 25
186 PLZ_37083-REWE3 PLZ_37083 REWE3 0 25
187 PLZ_37083-REWE4 PLZ_37083 REWE4 6 25
188 PLZ_37083-REWE6 PLZ_37083 REWE6 0 25
189 PLZ_37083-TEGUT1 PLZ_37083 TEGUT1 2 25
190 PLZ_37083-TEGUT2 PLZ_37083 TEGUT2 0 25
191 PLZ_37083-TEGUT3 PLZ_37083 TEGUT3 0 25
192 PLZ_37083-TEGUT4 PLZ_37083 TEGUT4 0 25
193 PLZ_37085-ALDI1 PLZ_37085 ALDI1 0 27
194 PLZ_37085-ALDI3 PLZ_37085 ALDI3 0 27
195 PLZ_37085-ALDI6 PLZ_37085 ALDI6 0 27
196 PLZ_37085-ALDI7 PLZ_37085 ALDI7 0 27
197 PLZ_37085-ALNATURA PLZ_37085 ALNATURA 1 27
198 PLZ_37085-EDEKA1 PLZ_37085 EDEKA1 0 27
199 PLZ_37085-EDEKA2 PLZ_37085 EDEKA2 0 27
200 PLZ_37085-EDEKA3 PLZ_37085 EDEKA3 0 27
201 PLZ_37085-EDEKA4 PLZ_37085 EDEKA4 2 27
202 PLZ_37085-EDEKA5 PLZ_37085 EDEKA5 0 27
203 PLZ_37085-KAUFLAND1 PLZ_37085 KAUFLAND1 2 27
204 PLZ_37085-KAUFLAND2 PLZ_37085 KAUFLAND2 4 27
205 PLZ_37085-LIDL1 PLZ_37085 LIDL1 1 27
206 PLZ_37085-LIDL2 PLZ_37085 LIDL2 0 27
207 PLZ_37085-NAHKAUF1 PLZ_37085 NAHKAUF1 0 27
208 PLZ_37085-NAHKAUF4 PLZ_37085 NAHKAUF4 0 27
209 PLZ_37085-NAHKAUF5 PLZ_37085 NAHKAUF5 3 27
210 PLZ_37085-NETTO1 PLZ_37085 NETTO1 3 27
211 PLZ_37085-NETTO6 PLZ_37085 NETTO6 0 27
212 PLZ_37085-PENNY1 PLZ_37085 PENNY1 0 27
213 PLZ_37085-PENNY2 PLZ_37085 PENNY2 0 27
214 PLZ_37085-REAL1 PLZ_37085 REAL1 1 27
215 PLZ_37085-REAL2 PLZ_37085 REAL2 1 27
216 PLZ_37085-REWE1 PLZ_37085 REWE1 3 27
217 PLZ_37085-REWE2 PLZ_37085 REWE2 0 27
218 PLZ_37085-REWE3 PLZ_37085 REWE3 0 27
219 PLZ_37085-REWE4 PLZ_37085 REWE4 2 27
220 PLZ_37085-REWE6 PLZ_37085 REWE6 0 27
221 PLZ_37085-TEGUT1 PLZ_37085 TEGUT1 2 27
222 PLZ_37085-TEGUT2 PLZ_37085 TEGUT2 1 27
223 PLZ_37085-TEGUT3 PLZ_37085 TEGUT3 0 27
224 PLZ_37085-TEGUT4 PLZ_37085 TEGUT4 1 27
p_ij_obs freq_ij_abs_trip_expen freq_i_total_trip_expen
1 0.00000000 0.00 893.91
2 0.00000000 0.00 893.91
3 0.00000000 0.00 893.91
4 0.02222222 17.00 893.91
5 0.04444444 43.00 893.91
6 0.02222222 5.00 893.91
7 0.00000000 0.00 893.91
8 0.00000000 0.00 893.91
9 0.00000000 0.00 893.91
10 0.00000000 0.00 893.91
11 0.00000000 0.00 893.91
12 0.24444444 222.70 893.91
13 0.02222222 14.00 893.91
14 0.00000000 0.00 893.91
15 0.00000000 0.00 893.91
16 0.00000000 0.00 893.91
17 0.00000000 0.00 893.91
18 0.11111111 64.00 893.91
19 0.00000000 0.00 893.91
20 0.00000000 0.00 893.91
21 0.00000000 0.00 893.91
22 0.02222222 55.00 893.91
23 0.00000000 0.00 893.91
24 0.17777778 198.00 893.91
25 0.00000000 0.00 893.91
26 0.06666667 45.00 893.91
27 0.04444444 69.00 893.91
28 0.00000000 0.00 893.91
29 0.20000000 131.21 893.91
30 0.02222222 30.00 893.91
31 0.00000000 0.00 893.91
32 0.00000000 0.00 893.91
33 0.07142857 92.00 865.49
34 0.00000000 0.00 865.49
35 0.00000000 0.00 865.49
36 0.00000000 0.00 865.49
37 0.07142857 47.50 865.49
38 0.00000000 0.00 865.49
39 0.00000000 0.00 865.49
40 0.00000000 0.00 865.49
41 0.04761905 47.00 865.49
42 0.00000000 0.00 865.49
43 0.00000000 0.00 865.49
44 0.09523810 36.00 865.49
45 0.04761905 29.00 865.49
46 0.00000000 0.00 865.49
47 0.00000000 0.00 865.49
48 0.00000000 0.00 865.49
49 0.00000000 0.00 865.49
50 0.02380952 15.00 865.49
51 0.02380952 10.00 865.49
52 0.07142857 58.49 865.49
53 0.00000000 0.00 865.49
54 0.02380952 22.00 865.49
55 0.04761905 165.00 865.49
56 0.04761905 38.00 865.49
57 0.00000000 0.00 865.49
58 0.23809524 146.50 865.49
59 0.02380952 20.00 865.49
60 0.00000000 0.00 865.49
61 0.14285714 117.00 865.49
62 0.02380952 22.00 865.49
63 0.00000000 0.00 865.49
64 0.00000000 0.00 865.49
65 0.00000000 0.00 601.59
66 0.00000000 0.00 601.59
67 0.00000000 0.00 601.59
68 0.00000000 0.00 601.59
69 0.00000000 0.00 601.59
70 0.06666667 30.00 601.59
71 0.06666667 40.00 601.59
72 0.00000000 0.00 601.59
73 0.00000000 0.00 601.59
74 0.00000000 0.00 601.59
75 0.00000000 0.00 601.59
76 0.06666667 6.00 601.59
77 0.00000000 0.00 601.59
78 0.00000000 0.00 601.59
79 0.13333333 3.09 601.59
80 0.00000000 0.00 601.59
81 0.00000000 0.00 601.59
82 0.00000000 0.00 601.59
83 0.00000000 0.00 601.59
84 0.00000000 0.00 601.59
85 0.00000000 0.00 601.59
86 0.26666667 135.00 601.59
87 0.00000000 0.00 601.59
88 0.00000000 0.00 601.59
89 0.00000000 0.00 601.59
90 0.00000000 0.00 601.59
91 0.00000000 0.00 601.59
92 0.00000000 0.00 601.59
93 0.26666667 319.50 601.59
94 0.13333333 68.00 601.59
95 0.00000000 0.00 601.59
96 0.00000000 0.00 601.59
97 0.00000000 0.00 231.00
98 0.00000000 0.00 231.00
99 0.00000000 0.00 231.00
100 0.00000000 0.00 231.00
101 0.08333333 20.00 231.00
102 0.00000000 0.00 231.00
103 0.00000000 0.00 231.00
104 0.16666667 20.00 231.00
105 0.00000000 0.00 231.00
106 0.00000000 0.00 231.00
107 0.08333333 29.00 231.00
108 0.08333333 20.00 231.00
109 0.00000000 0.00 231.00
110 0.00000000 0.00 231.00
111 0.00000000 0.00 231.00
112 0.08333333 25.00 231.00
113 0.00000000 0.00 231.00
114 0.00000000 0.00 231.00
115 0.00000000 0.00 231.00
116 0.00000000 0.00 231.00
117 0.00000000 0.00 231.00
118 0.08333333 10.00 231.00
119 0.25000000 37.00 231.00
120 0.00000000 0.00 231.00
121 0.08333333 5.00 231.00
122 0.00000000 0.00 231.00
123 0.00000000 0.00 231.00
124 0.00000000 0.00 231.00
125 0.00000000 0.00 231.00
126 0.08333333 65.00 231.00
127 0.00000000 0.00 231.00
128 0.00000000 0.00 231.00
129 0.00000000 0.00 221.25
130 0.00000000 0.00 221.25
131 0.07692308 8.00 221.25
132 0.00000000 0.00 221.25
133 0.00000000 0.00 221.25
134 0.00000000 0.00 221.25
135 0.00000000 0.00 221.25
136 0.00000000 0.00 221.25
137 0.00000000 0.00 221.25
138 0.00000000 0.00 221.25
139 0.07692308 18.00 221.25
140 0.07692308 15.00 221.25
141 0.00000000 0.00 221.25
142 0.07692308 25.00 221.25
143 0.00000000 0.00 221.25
144 0.00000000 0.00 221.25
145 0.00000000 0.00 221.25
146 0.15384615 45.00 221.25
147 0.00000000 0.00 221.25
148 0.00000000 0.00 221.25
149 0.00000000 0.00 221.25
150 0.00000000 0.00 221.25
151 0.00000000 0.00 221.25
152 0.15384615 35.00 221.25
153 0.00000000 0.00 221.25
154 0.00000000 0.00 221.25
155 0.00000000 0.00 221.25
156 0.15384615 30.00 221.25
157 0.15384615 10.25 221.25
158 0.00000000 0.00 221.25
159 0.07692308 35.00 221.25
160 0.00000000 0.00 221.25
161 0.00000000 0.00 552.61
162 0.04000000 4.50 552.61
163 0.00000000 0.00 552.61
164 0.00000000 0.00 552.61
165 0.00000000 0.00 552.61
166 0.00000000 0.00 552.61
167 0.00000000 0.00 552.61
168 0.00000000 0.00 552.61
169 0.00000000 0.00 552.61
170 0.08000000 16.00 552.61
171 0.12000000 130.00 552.61
172 0.20000000 123.68 552.61
173 0.04000000 25.00 552.61
174 0.00000000 0.00 552.61
175 0.00000000 0.00 552.61
176 0.00000000 0.00 552.61
177 0.00000000 0.00 552.61
178 0.04000000 11.00 552.61
179 0.00000000 0.00 552.61
180 0.00000000 0.00 552.61
181 0.08000000 21.00 552.61
182 0.00000000 0.00 552.61
183 0.04000000 18.00 552.61
184 0.04000000 25.00 552.61
185 0.00000000 0.00 552.61
186 0.00000000 0.00 552.61
187 0.24000000 155.93 552.61
188 0.00000000 0.00 552.61
189 0.08000000 22.50 552.61
190 0.00000000 0.00 552.61
191 0.00000000 0.00 552.61
192 0.00000000 0.00 552.61
193 0.00000000 0.00 518.64
194 0.00000000 0.00 518.64
195 0.00000000 0.00 518.64
196 0.00000000 0.00 518.64
197 0.03703704 35.00 518.64
198 0.00000000 0.00 518.64
199 0.00000000 0.00 518.64
200 0.00000000 0.00 518.64
201 0.07407407 21.00 518.64
202 0.00000000 0.00 518.64
203 0.07407407 45.00 518.64
204 0.14814815 112.00 518.64
205 0.03703704 30.00 518.64
206 0.00000000 0.00 518.64
207 0.00000000 0.00 518.64
208 0.00000000 0.00 518.64
209 0.11111111 29.00 518.64
210 0.11111111 65.50 518.64
211 0.00000000 0.00 518.64
212 0.00000000 0.00 518.64
213 0.00000000 0.00 518.64
214 0.03703704 10.00 518.64
215 0.03703704 15.00 518.64
216 0.11111111 25.14 518.64
217 0.00000000 0.00 518.64
218 0.00000000 0.00 518.64
219 0.07407407 44.00 518.64
220 0.00000000 0.00 518.64
221 0.07407407 17.00 518.64
222 0.03703704 16.00 518.64
223 0.00000000 0.00 518.64
224 0.03703704 54.00 518.64
p_ij_obs_trip_expen
1 0.000000000
2 0.000000000
3 0.000000000
4 0.019017574
5 0.048103277
6 0.005593404
7 0.000000000
8 0.000000000
9 0.000000000
10 0.000000000
11 0.000000000
12 0.249130226
13 0.015661532
14 0.000000000
15 0.000000000
16 0.000000000
17 0.000000000
18 0.071595574
19 0.000000000
20 0.000000000
21 0.000000000
22 0.061527447
23 0.000000000
24 0.221498809
25 0.000000000
26 0.050340638
27 0.077188979
28 0.000000000
29 0.146782115
30 0.033560426
31 0.000000000
32 0.000000000
33 0.106298166
34 0.000000000
35 0.000000000
36 0.000000000
37 0.054882205
38 0.000000000
39 0.000000000
40 0.000000000
41 0.054304498
42 0.000000000
43 0.000000000
44 0.041594935
45 0.033507031
46 0.000000000
47 0.000000000
48 0.000000000
49 0.000000000
50 0.017331223
51 0.011554149
52 0.067580215
53 0.000000000
54 0.025419127
55 0.190643451
56 0.043905764
57 0.000000000
58 0.169268276
59 0.023108297
60 0.000000000
61 0.135183538
62 0.025419127
63 0.000000000
64 0.000000000
65 0.000000000
66 0.000000000
67 0.000000000
68 0.000000000
69 0.000000000
70 0.049867850
71 0.066490467
72 0.000000000
73 0.000000000
74 0.000000000
75 0.000000000
76 0.009973570
77 0.000000000
78 0.000000000
79 0.005136389
80 0.000000000
81 0.000000000
82 0.000000000
83 0.000000000
84 0.000000000
85 0.000000000
86 0.224405326
87 0.000000000
88 0.000000000
89 0.000000000
90 0.000000000
91 0.000000000
92 0.000000000
93 0.531092605
94 0.113033794
95 0.000000000
96 0.000000000
97 0.000000000
98 0.000000000
99 0.000000000
100 0.000000000
101 0.086580087
102 0.000000000
103 0.000000000
104 0.086580087
105 0.000000000
106 0.000000000
107 0.125541126
108 0.086580087
109 0.000000000
110 0.000000000
111 0.000000000
112 0.108225108
113 0.000000000
114 0.000000000
115 0.000000000
116 0.000000000
117 0.000000000
118 0.043290043
119 0.160173160
120 0.000000000
121 0.021645022
122 0.000000000
123 0.000000000
124 0.000000000
125 0.000000000
126 0.281385281
127 0.000000000
128 0.000000000
129 0.000000000
130 0.000000000
131 0.036158192
132 0.000000000
133 0.000000000
134 0.000000000
135 0.000000000
136 0.000000000
137 0.000000000
138 0.000000000
139 0.081355932
140 0.067796610
141 0.000000000
142 0.112994350
143 0.000000000
144 0.000000000
145 0.000000000
146 0.203389831
147 0.000000000
148 0.000000000
149 0.000000000
150 0.000000000
151 0.000000000
152 0.158192090
153 0.000000000
154 0.000000000
155 0.000000000
156 0.135593220
157 0.046327684
158 0.000000000
159 0.158192090
160 0.000000000
161 0.000000000
162 0.008143175
163 0.000000000
164 0.000000000
165 0.000000000
166 0.000000000
167 0.000000000
168 0.000000000
169 0.000000000
170 0.028953512
171 0.235247281
172 0.223810644
173 0.045239862
174 0.000000000
175 0.000000000
176 0.000000000
177 0.000000000
178 0.019905539
179 0.000000000
180 0.000000000
181 0.038001484
182 0.000000000
183 0.032572700
184 0.045239862
185 0.000000000
186 0.000000000
187 0.282170066
188 0.000000000
189 0.040715876
190 0.000000000
191 0.000000000
192 0.000000000
193 0.000000000
194 0.000000000
195 0.000000000
196 0.000000000
197 0.067484189
198 0.000000000
199 0.000000000
200 0.000000000
201 0.040490514
202 0.000000000
203 0.086765386
204 0.215949406
205 0.057843591
206 0.000000000
207 0.000000000
208 0.000000000
209 0.055915471
210 0.126291840
211 0.000000000
212 0.000000000
213 0.000000000
214 0.019281197
215 0.028921795
216 0.048472929
217 0.000000000
218 0.000000000
219 0.084837267
220 0.000000000
221 0.032778035
222 0.030849915
223 0.000000000
224 0.104118464
[1] 0.5586409 -1.4456805 0.8119981 1.4633403 -1.4456805 -1.4456805
[7] -0.4042878 0.1671033 0.7611454 0.8119981 0.1671033 -0.4297476
[13] 0.6116451 -0.4297476 0.8924717 -0.4297476 -0.4297476 -0.4297476
[19] -0.4297476 0.8924717 0.6116451 -0.4297476 -0.2148738 -0.2148738
[25] -0.2148738 0.8265189 -0.2148738 -0.2148738 -0.2148738 -0.2148738
[31] 1.1073455 -0.2148738 -0.2148738 -0.2148738 -0.2148738 -0.2148738
[37] 1.1073455 -0.2148738 -0.2148738 -0.2148738 -0.2148738 0.8265189
[43] -0.2148738 -0.2148738 0.1391845 0.1391845 0.4200111 0.8053619
[49] 0.7105756 -0.9022082 0.5891535 -0.9022082 0.8053619 -0.9022082
[55] -0.9022082 -0.1893441 -0.1893441 -0.1893441 0.8520486 -0.1893441
[61] -0.1893441 -0.1893441 -0.1893441 0.8520486 -0.1893441 -0.1893441
[67] -0.2768831 -0.2768831 -0.2768831 0.7645096 -0.2768831 -0.2768831
[73] -0.2768831 -0.2768831 1.7274383 -0.2768831 -0.2768831 -0.1202018
[79] -0.1202018 -0.1202018 -0.1202018 -0.1202018 -0.1202018 -0.1202018
[85] -0.1202018 1.2020175 -0.1202018 -0.1202018 -0.3768671 -0.3768671
[91] 0.6645256 1.2359167 -0.3768671 -0.3768671 -0.3768671 -0.3768671
[97] 1.1144946 -0.3768671 -0.3768671 -0.3359608 0.7054318 -0.3359608
[103] -0.3359608 -0.3359608 0.7054318 -0.3359608 -0.3359608 1.2768230
[109] -0.3359608 -0.3359608 -0.2668185 -0.2668185 -0.2668185 -0.2668185
[115] -0.2668185 1.0554008 -0.2668185 -0.2668185 1.3459654 -0.2668185
[121] -0.2668185
Call:
lm(formula = mci_formula, data = mciworkfile)
Residuals:
Min 1Q Median 3Q Max
-1.27457 -0.28725 -0.02391 0.32163 1.29351
Coefficients:
Estimate Std. Error t value Pr(>|t|)
d_time_t -1.2443 0.2319 -5.367 4.02e-07 ***
salesarea_qm_t 0.9413 0.1158 8.132 4.59e-13 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 0.4458 on 119 degrees of freedom
Multiple R-squared: 0.4603, Adjusted R-squared: 0.4512
F-statistic: 50.74 on 2 and 119 DF, p-value: < 2.2e-16
MCI documentation built on May 2, 2019, 6:02 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value Author(s) References See Also Examples
Description
Creation of an interaction matrix with market shares (p_{ij}) of every supplier (j) in every submarket (i) based on the frequencies in the raw data (e.g. household or POS survey).
Usage
1 2 3 | ijmatrix.create(rawdataset, submarkets, suppliers, ..., remNA = TRUE,
remSing = FALSE, remSing.val = 1, remSingSupp.val = 1,
correctVar = FALSE, correctVar.val = 1)
|
Arguments
rawdataset |
a |
submarkets |
the column in the dataset containing the submarkets (e.g. ZIP codes) |
suppliers |
the column in the dataset containing the suppliers (e.g. store codes) |
... |
other numeric variables in the raw data which were observed and shall be used to calculate market shares (e.g. expenditures) |
remNA |
logical argument that indicates if |
remSing |
logical argument that indicates if singular instances of the submarkets and suppliers are removed or not (default: |
remSing.val |
if |
remSingSupp.val |
if |
correctVar |
logical argument that indicates if the calculated market shares shall be corrected when they do not match the MCI standards (p_{ij} = 0) (default: |
correctVar.val |
if |
Details
This function creates an interaction matrix for all i submarkets (e.g. geographical regions) and all j suppliers (e.g. store locations). The function calculates p_{ij} based on the frequencies and, optionally, further market shares calculated from other observed variables in the given raw dataset (e.g. expenditures from submarket i at supplier j).
Single observations with missing submarket or supplier (NA) are removed from the data automatically (unless remNA = FALSE). Optionally, singular instances (e.g. some submarkets or suppliers are only represented once or twice in the whole dataset) can also be removed (remSing = TRUE), where the limit values for extraction can be set by remSing.val and remSingSupp.val (e.g. remSing.val = 2 and remSingSupp.val = 1 removes every submarket from the interaction matrix which was observed ≤ 2 and every supplier observed ≤ 1).
Value
An interaction matrix which is a data.frame containing the i x j combinations ('interaction'), the submarkets (column is named as in raw data), the suppliers (column is named as in raw data), the observed absolute frequencies of every j in every i ('freq_ij_abs'), the observed absolute frequencies in every i ('freq_i_total') and the observed market shares of every j in every i ('p_ij_obs'). If additional variables are stated (e.g. expenditures) which shall be turned into (local) market shares, the output interaction matrix contains absolute values for every interaction, total values for every i submarket and market shares (p_{ij}) for these variables, too, which are automatically named based on the given variable name (e.g. the market shares based on a raw data variable called expen is named p_ij_obs_expen). The first three variables of the output matrix are factors, the calculated values are numeric.
Author(s)
Thomas Wieland
References
Cooper, L. G./Nakanishi, M. (2010): “Market-Share Analysis: Evaluating competitive marketing effectiveness”. Boston, Dordrecht, London : Kluwer (first published 1988). E-book version from 2010: http://www.anderson.ucla.edu/faculty/lee.cooper/MCI_Book/BOOKI2010.pdf
Huff, D. L./McCallum, D. (2008): “Calibrating the Huff Model Using ArcGIS Business Analyst”. ESRI White Paper, September 2008. https://www.esri.com/library/whitepapers/pdfs/calibrating-huff-model.pdf
Wieland, T. (2015): “Raeumliches Einkaufsverhalten und Standortpolitik im Einzelhandel unter Beruecksichtigung von Agglomerationseffekten. Theoretische Erklaerungsansaetze, modellanalytische Zugaenge und eine empirisch-oekonometrische Marktgebietsanalyse anhand eines Fallbeispiels aus dem laendlichen Raum Ostwestfalens/Suedniedersachsens”. Geographische Handelsforschung, 23. 289 pages. Mannheim : MetaGIS.
See Also
ijmatrix.shares, ijmatrix.crosstab
Examples
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 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 | # Creating an interaction matrix based on the POS survey in grocery1 #
data(grocery1)
# Loads the data
ijmatrix.create (grocery1, "plz_submarket", "store_code")
# Creates an interaction matrix with local market shares based on frequencies
mynewmcidata <- ijmatrix.create (grocery1, "plz_submarket", "store_code")
# Save results directly in a new dataset
ijmatrix.create (grocery1, "plz_submarket", "store_code", "trip_expen")
# Creates an interaction matrix with local market shares based on frequencies
# and expenditures (Variable "trip_expen")
# MCI analysis for the grocery store market areas based on the POS survey in shopping1 #
data(shopping1)
# Loading the survey dataset
data(shopping2)
# Loading the distance/travel time dataset
data(shopping3)
# Loading the dataset containing information about the city districts
data(shopping4)
# Loading the grocery store data
shopping1_KAeast <- shopping1[shopping1$resid_code %in%
shopping3$resid_code[shopping3$KA_east == 1],]
# Extracting only inhabitants of the eastern districts of Karlsruhe
ijmatrix_gro_adj <- ijmatrix.create(shopping1_KAeast, "resid_code",
"gro_purchase_code", "gro_purchase_expen", remSing = TRUE, remSing.val = 1,
remSingSupp.val = 2, correctVar = TRUE, correctVar.val = 0.1)
# Removing singular instances/outliers (remSing = TRUE) incorporating
# only suppliers which are at least obtained three times (remSingSupp.val = 2)
# Correcting the values (correctVar = TRUE)
# by adding 0.1 to the absolute values (correctVar.val = 0.1)
ijmatrix_gro_adj <- ijmatrix_gro_adj[(ijmatrix_gro_adj$gro_purchase_code !=
"REFORMHAUSBOESER") & (ijmatrix_gro_adj$gro_purchase_code != "WMARKT_DURLACH")
& (ijmatrix_gro_adj$gro_purchase_code != "X_INCOMPLETE_STORE"),]
# Remove non-regarded observations
ijmatrix_gro_adj_dist <- merge (ijmatrix_gro_adj, shopping2, by.x="interaction",
by.y="route")
# Include the distances and travel times (shopping2)
ijmatrix_gro_adj_dist_stores <- merge (ijmatrix_gro_adj_dist, shopping4,
by.x = "gro_purchase_code", by.y = "location_code")
# Adding the store information (shopping4)
mci.transvar(ijmatrix_gro_adj_dist_stores, "resid_code", "gro_purchase_code",
"p_ij_obs")
# Log-centering transformation of one variable (p_ij_obs)
ijmatrix_gro_transf <- mci.transmat(ijmatrix_gro_adj_dist_stores, "resid_code",
"gro_purchase_code", "p_ij_obs", "d_time", "salesarea_qm")
# Log-centering transformation of the interaction matrix
mcimodel_gro_trips <- mci.fit(ijmatrix_gro_adj_dist_stores, "resid_code",
"gro_purchase_code", "p_ij_obs", "d_time", "salesarea_qm")
# MCI model for the grocery store market areas
# shares: "p_ij_obs", explanatory variables: "d_time", "salesarea_qm"
summary(mcimodel_gro_trips)
# Use like lm
|
Example output
interaction plz_submarket store_code freq_ij_abs freq_i_total
1 PLZ_37073-ALDI1 PLZ_37073 ALDI1 0 45
2 PLZ_37073-ALDI3 PLZ_37073 ALDI3 0 45
3 PLZ_37073-ALDI6 PLZ_37073 ALDI6 0 45
4 PLZ_37073-ALDI7 PLZ_37073 ALDI7 1 45
5 PLZ_37073-ALNATURA PLZ_37073 ALNATURA 2 45
6 PLZ_37073-EDEKA1 PLZ_37073 EDEKA1 1 45
7 PLZ_37073-EDEKA2 PLZ_37073 EDEKA2 0 45
8 PLZ_37073-EDEKA3 PLZ_37073 EDEKA3 0 45
9 PLZ_37073-EDEKA4 PLZ_37073 EDEKA4 0 45
10 PLZ_37073-EDEKA5 PLZ_37073 EDEKA5 0 45
11 PLZ_37073-KAUFLAND1 PLZ_37073 KAUFLAND1 0 45
12 PLZ_37073-KAUFLAND2 PLZ_37073 KAUFLAND2 11 45
13 PLZ_37073-LIDL1 PLZ_37073 LIDL1 1 45
14 PLZ_37073-LIDL2 PLZ_37073 LIDL2 0 45
15 PLZ_37073-NAHKAUF1 PLZ_37073 NAHKAUF1 0 45
16 PLZ_37073-NAHKAUF4 PLZ_37073 NAHKAUF4 0 45
17 PLZ_37073-NAHKAUF5 PLZ_37073 NAHKAUF5 0 45
18 PLZ_37073-NETTO1 PLZ_37073 NETTO1 5 45
19 PLZ_37073-NETTO6 PLZ_37073 NETTO6 0 45
20 PLZ_37073-PENNY1 PLZ_37073 PENNY1 0 45
21 PLZ_37073-PENNY2 PLZ_37073 PENNY2 0 45
22 PLZ_37073-REAL1 PLZ_37073 REAL1 1 45
23 PLZ_37073-REAL2 PLZ_37073 REAL2 0 45
24 PLZ_37073-REWE1 PLZ_37073 REWE1 8 45
25 PLZ_37073-REWE2 PLZ_37073 REWE2 0 45
26 PLZ_37073-REWE3 PLZ_37073 REWE3 3 45
27 PLZ_37073-REWE4 PLZ_37073 REWE4 2 45
28 PLZ_37073-REWE6 PLZ_37073 REWE6 0 45
29 PLZ_37073-TEGUT1 PLZ_37073 TEGUT1 9 45
30 PLZ_37073-TEGUT2 PLZ_37073 TEGUT2 1 45
31 PLZ_37073-TEGUT3 PLZ_37073 TEGUT3 0 45
32 PLZ_37073-TEGUT4 PLZ_37073 TEGUT4 0 45
33 PLZ_37075-ALDI1 PLZ_37075 ALDI1 3 42
34 PLZ_37075-ALDI3 PLZ_37075 ALDI3 0 42
35 PLZ_37075-ALDI6 PLZ_37075 ALDI6 0 42
36 PLZ_37075-ALDI7 PLZ_37075 ALDI7 0 42
37 PLZ_37075-ALNATURA PLZ_37075 ALNATURA 3 42
38 PLZ_37075-EDEKA1 PLZ_37075 EDEKA1 0 42
39 PLZ_37075-EDEKA2 PLZ_37075 EDEKA2 0 42
40 PLZ_37075-EDEKA3 PLZ_37075 EDEKA3 0 42
41 PLZ_37075-EDEKA4 PLZ_37075 EDEKA4 2 42
42 PLZ_37075-EDEKA5 PLZ_37075 EDEKA5 0 42
43 PLZ_37075-KAUFLAND1 PLZ_37075 KAUFLAND1 0 42
44 PLZ_37075-KAUFLAND2 PLZ_37075 KAUFLAND2 4 42
45 PLZ_37075-LIDL1 PLZ_37075 LIDL1 2 42
46 PLZ_37075-LIDL2 PLZ_37075 LIDL2 0 42
47 PLZ_37075-NAHKAUF1 PLZ_37075 NAHKAUF1 0 42
48 PLZ_37075-NAHKAUF4 PLZ_37075 NAHKAUF4 0 42
49 PLZ_37075-NAHKAUF5 PLZ_37075 NAHKAUF5 0 42
50 PLZ_37075-NETTO1 PLZ_37075 NETTO1 1 42
51 PLZ_37075-NETTO6 PLZ_37075 NETTO6 1 42
52 PLZ_37075-PENNY1 PLZ_37075 PENNY1 3 42
53 PLZ_37075-PENNY2 PLZ_37075 PENNY2 0 42
54 PLZ_37075-REAL1 PLZ_37075 REAL1 1 42
55 PLZ_37075-REAL2 PLZ_37075 REAL2 2 42
56 PLZ_37075-REWE1 PLZ_37075 REWE1 2 42
57 PLZ_37075-REWE2 PLZ_37075 REWE2 0 42
58 PLZ_37075-REWE3 PLZ_37075 REWE3 10 42
59 PLZ_37075-REWE4 PLZ_37075 REWE4 1 42
60 PLZ_37075-REWE6 PLZ_37075 REWE6 0 42
61 PLZ_37075-TEGUT1 PLZ_37075 TEGUT1 6 42
62 PLZ_37075-TEGUT2 PLZ_37075 TEGUT2 1 42
63 PLZ_37075-TEGUT3 PLZ_37075 TEGUT3 0 42
64 PLZ_37075-TEGUT4 PLZ_37075 TEGUT4 0 42
65 PLZ_37077-ALDI1 PLZ_37077 ALDI1 0 15
66 PLZ_37077-ALDI3 PLZ_37077 ALDI3 0 15
67 PLZ_37077-ALDI6 PLZ_37077 ALDI6 0 15
68 PLZ_37077-ALDI7 PLZ_37077 ALDI7 0 15
69 PLZ_37077-ALNATURA PLZ_37077 ALNATURA 0 15
70 PLZ_37077-EDEKA1 PLZ_37077 EDEKA1 1 15
71 PLZ_37077-EDEKA2 PLZ_37077 EDEKA2 1 15
72 PLZ_37077-EDEKA3 PLZ_37077 EDEKA3 0 15
73 PLZ_37077-EDEKA4 PLZ_37077 EDEKA4 0 15
74 PLZ_37077-EDEKA5 PLZ_37077 EDEKA5 0 15
75 PLZ_37077-KAUFLAND1 PLZ_37077 KAUFLAND1 0 15
76 PLZ_37077-KAUFLAND2 PLZ_37077 KAUFLAND2 1 15
77 PLZ_37077-LIDL1 PLZ_37077 LIDL1 0 15
78 PLZ_37077-LIDL2 PLZ_37077 LIDL2 0 15
79 PLZ_37077-NAHKAUF1 PLZ_37077 NAHKAUF1 2 15
80 PLZ_37077-NAHKAUF4 PLZ_37077 NAHKAUF4 0 15
81 PLZ_37077-NAHKAUF5 PLZ_37077 NAHKAUF5 0 15
82 PLZ_37077-NETTO1 PLZ_37077 NETTO1 0 15
83 PLZ_37077-NETTO6 PLZ_37077 NETTO6 0 15
84 PLZ_37077-PENNY1 PLZ_37077 PENNY1 0 15
85 PLZ_37077-PENNY2 PLZ_37077 PENNY2 0 15
86 PLZ_37077-REAL1 PLZ_37077 REAL1 4 15
87 PLZ_37077-REAL2 PLZ_37077 REAL2 0 15
88 PLZ_37077-REWE1 PLZ_37077 REWE1 0 15
89 PLZ_37077-REWE2 PLZ_37077 REWE2 0 15
90 PLZ_37077-REWE3 PLZ_37077 REWE3 0 15
91 PLZ_37077-REWE4 PLZ_37077 REWE4 0 15
92 PLZ_37077-REWE6 PLZ_37077 REWE6 0 15
93 PLZ_37077-TEGUT1 PLZ_37077 TEGUT1 4 15
94 PLZ_37077-TEGUT2 PLZ_37077 TEGUT2 2 15
95 PLZ_37077-TEGUT3 PLZ_37077 TEGUT3 0 15
96 PLZ_37077-TEGUT4 PLZ_37077 TEGUT4 0 15
97 PLZ_37079-ALDI1 PLZ_37079 ALDI1 0 12
98 PLZ_37079-ALDI3 PLZ_37079 ALDI3 0 12
99 PLZ_37079-ALDI6 PLZ_37079 ALDI6 0 12
100 PLZ_37079-ALDI7 PLZ_37079 ALDI7 0 12
101 PLZ_37079-ALNATURA PLZ_37079 ALNATURA 1 12
102 PLZ_37079-EDEKA1 PLZ_37079 EDEKA1 0 12
103 PLZ_37079-EDEKA2 PLZ_37079 EDEKA2 0 12
104 PLZ_37079-EDEKA3 PLZ_37079 EDEKA3 2 12
105 PLZ_37079-EDEKA4 PLZ_37079 EDEKA4 0 12
106 PLZ_37079-EDEKA5 PLZ_37079 EDEKA5 0 12
107 PLZ_37079-KAUFLAND1 PLZ_37079 KAUFLAND1 1 12
108 PLZ_37079-KAUFLAND2 PLZ_37079 KAUFLAND2 1 12
109 PLZ_37079-LIDL1 PLZ_37079 LIDL1 0 12
110 PLZ_37079-LIDL2 PLZ_37079 LIDL2 0 12
111 PLZ_37079-NAHKAUF1 PLZ_37079 NAHKAUF1 0 12
112 PLZ_37079-NAHKAUF4 PLZ_37079 NAHKAUF4 1 12
113 PLZ_37079-NAHKAUF5 PLZ_37079 NAHKAUF5 0 12
114 PLZ_37079-NETTO1 PLZ_37079 NETTO1 0 12
115 PLZ_37079-NETTO6 PLZ_37079 NETTO6 0 12
116 PLZ_37079-PENNY1 PLZ_37079 PENNY1 0 12
117 PLZ_37079-PENNY2 PLZ_37079 PENNY2 0 12
118 PLZ_37079-REAL1 PLZ_37079 REAL1 1 12
119 PLZ_37079-REAL2 PLZ_37079 REAL2 3 12
120 PLZ_37079-REWE1 PLZ_37079 REWE1 0 12
121 PLZ_37079-REWE2 PLZ_37079 REWE2 1 12
122 PLZ_37079-REWE3 PLZ_37079 REWE3 0 12
123 PLZ_37079-REWE4 PLZ_37079 REWE4 0 12
124 PLZ_37079-REWE6 PLZ_37079 REWE6 0 12
125 PLZ_37079-TEGUT1 PLZ_37079 TEGUT1 0 12
126 PLZ_37079-TEGUT2 PLZ_37079 TEGUT2 1 12
127 PLZ_37079-TEGUT3 PLZ_37079 TEGUT3 0 12
128 PLZ_37079-TEGUT4 PLZ_37079 TEGUT4 0 12
129 PLZ_37081-ALDI1 PLZ_37081 ALDI1 0 13
130 PLZ_37081-ALDI3 PLZ_37081 ALDI3 0 13
131 PLZ_37081-ALDI6 PLZ_37081 ALDI6 1 13
132 PLZ_37081-ALDI7 PLZ_37081 ALDI7 0 13
133 PLZ_37081-ALNATURA PLZ_37081 ALNATURA 0 13
134 PLZ_37081-EDEKA1 PLZ_37081 EDEKA1 0 13
135 PLZ_37081-EDEKA2 PLZ_37081 EDEKA2 0 13
136 PLZ_37081-EDEKA3 PLZ_37081 EDEKA3 0 13
137 PLZ_37081-EDEKA4 PLZ_37081 EDEKA4 0 13
138 PLZ_37081-EDEKA5 PLZ_37081 EDEKA5 0 13
139 PLZ_37081-KAUFLAND1 PLZ_37081 KAUFLAND1 1 13
140 PLZ_37081-KAUFLAND2 PLZ_37081 KAUFLAND2 1 13
141 PLZ_37081-LIDL1 PLZ_37081 LIDL1 0 13
142 PLZ_37081-LIDL2 PLZ_37081 LIDL2 1 13
143 PLZ_37081-NAHKAUF1 PLZ_37081 NAHKAUF1 0 13
144 PLZ_37081-NAHKAUF4 PLZ_37081 NAHKAUF4 0 13
145 PLZ_37081-NAHKAUF5 PLZ_37081 NAHKAUF5 0 13
146 PLZ_37081-NETTO1 PLZ_37081 NETTO1 2 13
147 PLZ_37081-NETTO6 PLZ_37081 NETTO6 0 13
148 PLZ_37081-PENNY1 PLZ_37081 PENNY1 0 13
149 PLZ_37081-PENNY2 PLZ_37081 PENNY2 0 13
150 PLZ_37081-REAL1 PLZ_37081 REAL1 0 13
151 PLZ_37081-REAL2 PLZ_37081 REAL2 0 13
152 PLZ_37081-REWE1 PLZ_37081 REWE1 2 13
153 PLZ_37081-REWE2 PLZ_37081 REWE2 0 13
154 PLZ_37081-REWE3 PLZ_37081 REWE3 0 13
155 PLZ_37081-REWE4 PLZ_37081 REWE4 0 13
156 PLZ_37081-REWE6 PLZ_37081 REWE6 2 13
157 PLZ_37081-TEGUT1 PLZ_37081 TEGUT1 2 13
158 PLZ_37081-TEGUT2 PLZ_37081 TEGUT2 0 13
159 PLZ_37081-TEGUT3 PLZ_37081 TEGUT3 1 13
160 PLZ_37081-TEGUT4 PLZ_37081 TEGUT4 0 13
161 PLZ_37083-ALDI1 PLZ_37083 ALDI1 0 25
162 PLZ_37083-ALDI3 PLZ_37083 ALDI3 1 25
163 PLZ_37083-ALDI6 PLZ_37083 ALDI6 0 25
164 PLZ_37083-ALDI7 PLZ_37083 ALDI7 0 25
165 PLZ_37083-ALNATURA PLZ_37083 ALNATURA 0 25
166 PLZ_37083-EDEKA1 PLZ_37083 EDEKA1 0 25
167 PLZ_37083-EDEKA2 PLZ_37083 EDEKA2 0 25
168 PLZ_37083-EDEKA3 PLZ_37083 EDEKA3 0 25
169 PLZ_37083-EDEKA4 PLZ_37083 EDEKA4 0 25
170 PLZ_37083-EDEKA5 PLZ_37083 EDEKA5 2 25
171 PLZ_37083-KAUFLAND1 PLZ_37083 KAUFLAND1 3 25
172 PLZ_37083-KAUFLAND2 PLZ_37083 KAUFLAND2 5 25
173 PLZ_37083-LIDL1 PLZ_37083 LIDL1 1 25
174 PLZ_37083-LIDL2 PLZ_37083 LIDL2 0 25
175 PLZ_37083-NAHKAUF1 PLZ_37083 NAHKAUF1 0 25
176 PLZ_37083-NAHKAUF4 PLZ_37083 NAHKAUF4 0 25
177 PLZ_37083-NAHKAUF5 PLZ_37083 NAHKAUF5 0 25
178 PLZ_37083-NETTO1 PLZ_37083 NETTO1 1 25
179 PLZ_37083-NETTO6 PLZ_37083 NETTO6 0 25
180 PLZ_37083-PENNY1 PLZ_37083 PENNY1 0 25
181 PLZ_37083-PENNY2 PLZ_37083 PENNY2 2 25
182 PLZ_37083-REAL1 PLZ_37083 REAL1 0 25
183 PLZ_37083-REAL2 PLZ_37083 REAL2 1 25
184 PLZ_37083-REWE1 PLZ_37083 REWE1 1 25
185 PLZ_37083-REWE2 PLZ_37083 REWE2 0 25
186 PLZ_37083-REWE3 PLZ_37083 REWE3 0 25
187 PLZ_37083-REWE4 PLZ_37083 REWE4 6 25
188 PLZ_37083-REWE6 PLZ_37083 REWE6 0 25
189 PLZ_37083-TEGUT1 PLZ_37083 TEGUT1 2 25
190 PLZ_37083-TEGUT2 PLZ_37083 TEGUT2 0 25
191 PLZ_37083-TEGUT3 PLZ_37083 TEGUT3 0 25
192 PLZ_37083-TEGUT4 PLZ_37083 TEGUT4 0 25
193 PLZ_37085-ALDI1 PLZ_37085 ALDI1 0 27
194 PLZ_37085-ALDI3 PLZ_37085 ALDI3 0 27
195 PLZ_37085-ALDI6 PLZ_37085 ALDI6 0 27
196 PLZ_37085-ALDI7 PLZ_37085 ALDI7 0 27
197 PLZ_37085-ALNATURA PLZ_37085 ALNATURA 1 27
198 PLZ_37085-EDEKA1 PLZ_37085 EDEKA1 0 27
199 PLZ_37085-EDEKA2 PLZ_37085 EDEKA2 0 27
200 PLZ_37085-EDEKA3 PLZ_37085 EDEKA3 0 27
201 PLZ_37085-EDEKA4 PLZ_37085 EDEKA4 2 27
202 PLZ_37085-EDEKA5 PLZ_37085 EDEKA5 0 27
203 PLZ_37085-KAUFLAND1 PLZ_37085 KAUFLAND1 2 27
204 PLZ_37085-KAUFLAND2 PLZ_37085 KAUFLAND2 4 27
205 PLZ_37085-LIDL1 PLZ_37085 LIDL1 1 27
206 PLZ_37085-LIDL2 PLZ_37085 LIDL2 0 27
207 PLZ_37085-NAHKAUF1 PLZ_37085 NAHKAUF1 0 27
208 PLZ_37085-NAHKAUF4 PLZ_37085 NAHKAUF4 0 27
209 PLZ_37085-NAHKAUF5 PLZ_37085 NAHKAUF5 3 27
210 PLZ_37085-NETTO1 PLZ_37085 NETTO1 3 27
211 PLZ_37085-NETTO6 PLZ_37085 NETTO6 0 27
212 PLZ_37085-PENNY1 PLZ_37085 PENNY1 0 27
213 PLZ_37085-PENNY2 PLZ_37085 PENNY2 0 27
214 PLZ_37085-REAL1 PLZ_37085 REAL1 1 27
215 PLZ_37085-REAL2 PLZ_37085 REAL2 1 27
216 PLZ_37085-REWE1 PLZ_37085 REWE1 3 27
217 PLZ_37085-REWE2 PLZ_37085 REWE2 0 27
218 PLZ_37085-REWE3 PLZ_37085 REWE3 0 27
219 PLZ_37085-REWE4 PLZ_37085 REWE4 2 27
220 PLZ_37085-REWE6 PLZ_37085 REWE6 0 27
221 PLZ_37085-TEGUT1 PLZ_37085 TEGUT1 2 27
222 PLZ_37085-TEGUT2 PLZ_37085 TEGUT2 1 27
223 PLZ_37085-TEGUT3 PLZ_37085 TEGUT3 0 27
224 PLZ_37085-TEGUT4 PLZ_37085 TEGUT4 1 27
p_ij_obs
1 0.00000000
2 0.00000000
3 0.00000000
4 0.02222222
5 0.04444444
6 0.02222222
7 0.00000000
8 0.00000000
9 0.00000000
10 0.00000000
11 0.00000000
12 0.24444444
13 0.02222222
14 0.00000000
15 0.00000000
16 0.00000000
17 0.00000000
18 0.11111111
19 0.00000000
20 0.00000000
21 0.00000000
22 0.02222222
23 0.00000000
24 0.17777778
25 0.00000000
26 0.06666667
27 0.04444444
28 0.00000000
29 0.20000000
30 0.02222222
31 0.00000000
32 0.00000000
33 0.07142857
34 0.00000000
35 0.00000000
36 0.00000000
37 0.07142857
38 0.00000000
39 0.00000000
40 0.00000000
41 0.04761905
42 0.00000000
43 0.00000000
44 0.09523810
45 0.04761905
46 0.00000000
47 0.00000000
48 0.00000000
49 0.00000000
50 0.02380952
51 0.02380952
52 0.07142857
53 0.00000000
54 0.02380952
55 0.04761905
56 0.04761905
57 0.00000000
58 0.23809524
59 0.02380952
60 0.00000000
61 0.14285714
62 0.02380952
63 0.00000000
64 0.00000000
65 0.00000000
66 0.00000000
67 0.00000000
68 0.00000000
69 0.00000000
70 0.06666667
71 0.06666667
72 0.00000000
73 0.00000000
74 0.00000000
75 0.00000000
76 0.06666667
77 0.00000000
78 0.00000000
79 0.13333333
80 0.00000000
81 0.00000000
82 0.00000000
83 0.00000000
84 0.00000000
85 0.00000000
86 0.26666667
87 0.00000000
88 0.00000000
89 0.00000000
90 0.00000000
91 0.00000000
92 0.00000000
93 0.26666667
94 0.13333333
95 0.00000000
96 0.00000000
97 0.00000000
98 0.00000000
99 0.00000000
100 0.00000000
101 0.08333333
102 0.00000000
103 0.00000000
104 0.16666667
105 0.00000000
106 0.00000000
107 0.08333333
108 0.08333333
109 0.00000000
110 0.00000000
111 0.00000000
112 0.08333333
113 0.00000000
114 0.00000000
115 0.00000000
116 0.00000000
117 0.00000000
118 0.08333333
119 0.25000000
120 0.00000000
121 0.08333333
122 0.00000000
123 0.00000000
124 0.00000000
125 0.00000000
126 0.08333333
127 0.00000000
128 0.00000000
129 0.00000000
130 0.00000000
131 0.07692308
132 0.00000000
133 0.00000000
134 0.00000000
135 0.00000000
136 0.00000000
137 0.00000000
138 0.00000000
139 0.07692308
140 0.07692308
141 0.00000000
142 0.07692308
143 0.00000000
144 0.00000000
145 0.00000000
146 0.15384615
147 0.00000000
148 0.00000000
149 0.00000000
150 0.00000000
151 0.00000000
152 0.15384615
153 0.00000000
154 0.00000000
155 0.00000000
156 0.15384615
157 0.15384615
158 0.00000000
159 0.07692308
160 0.00000000
161 0.00000000
162 0.04000000
163 0.00000000
164 0.00000000
165 0.00000000
166 0.00000000
167 0.00000000
168 0.00000000
169 0.00000000
170 0.08000000
171 0.12000000
172 0.20000000
173 0.04000000
174 0.00000000
175 0.00000000
176 0.00000000
177 0.00000000
178 0.04000000
179 0.00000000
180 0.00000000
181 0.08000000
182 0.00000000
183 0.04000000
184 0.04000000
185 0.00000000
186 0.00000000
187 0.24000000
188 0.00000000
189 0.08000000
190 0.00000000
191 0.00000000
192 0.00000000
193 0.00000000
194 0.00000000
195 0.00000000
196 0.00000000
197 0.03703704
198 0.00000000
199 0.00000000
200 0.00000000
201 0.07407407
202 0.00000000
203 0.07407407
204 0.14814815
205 0.03703704
206 0.00000000
207 0.00000000
208 0.00000000
209 0.11111111
210 0.11111111
211 0.00000000
212 0.00000000
213 0.00000000
214 0.03703704
215 0.03703704
216 0.11111111
217 0.00000000
218 0.00000000
219 0.07407407
220 0.00000000
221 0.07407407
222 0.03703704
223 0.00000000
224 0.03703704
interaction plz_submarket store_code freq_ij_abs freq_i_total
1 PLZ_37073-ALDI1 PLZ_37073 ALDI1 0 45
2 PLZ_37073-ALDI3 PLZ_37073 ALDI3 0 45
3 PLZ_37073-ALDI6 PLZ_37073 ALDI6 0 45
4 PLZ_37073-ALDI7 PLZ_37073 ALDI7 1 45
5 PLZ_37073-ALNATURA PLZ_37073 ALNATURA 2 45
6 PLZ_37073-EDEKA1 PLZ_37073 EDEKA1 1 45
7 PLZ_37073-EDEKA2 PLZ_37073 EDEKA2 0 45
8 PLZ_37073-EDEKA3 PLZ_37073 EDEKA3 0 45
9 PLZ_37073-EDEKA4 PLZ_37073 EDEKA4 0 45
10 PLZ_37073-EDEKA5 PLZ_37073 EDEKA5 0 45
11 PLZ_37073-KAUFLAND1 PLZ_37073 KAUFLAND1 0 45
12 PLZ_37073-KAUFLAND2 PLZ_37073 KAUFLAND2 11 45
13 PLZ_37073-LIDL1 PLZ_37073 LIDL1 1 45
14 PLZ_37073-LIDL2 PLZ_37073 LIDL2 0 45
15 PLZ_37073-NAHKAUF1 PLZ_37073 NAHKAUF1 0 45
16 PLZ_37073-NAHKAUF4 PLZ_37073 NAHKAUF4 0 45
17 PLZ_37073-NAHKAUF5 PLZ_37073 NAHKAUF5 0 45
18 PLZ_37073-NETTO1 PLZ_37073 NETTO1 5 45
19 PLZ_37073-NETTO6 PLZ_37073 NETTO6 0 45
20 PLZ_37073-PENNY1 PLZ_37073 PENNY1 0 45
21 PLZ_37073-PENNY2 PLZ_37073 PENNY2 0 45
22 PLZ_37073-REAL1 PLZ_37073 REAL1 1 45
23 PLZ_37073-REAL2 PLZ_37073 REAL2 0 45
24 PLZ_37073-REWE1 PLZ_37073 REWE1 8 45
25 PLZ_37073-REWE2 PLZ_37073 REWE2 0 45
26 PLZ_37073-REWE3 PLZ_37073 REWE3 3 45
27 PLZ_37073-REWE4 PLZ_37073 REWE4 2 45
28 PLZ_37073-REWE6 PLZ_37073 REWE6 0 45
29 PLZ_37073-TEGUT1 PLZ_37073 TEGUT1 9 45
30 PLZ_37073-TEGUT2 PLZ_37073 TEGUT2 1 45
31 PLZ_37073-TEGUT3 PLZ_37073 TEGUT3 0 45
32 PLZ_37073-TEGUT4 PLZ_37073 TEGUT4 0 45
33 PLZ_37075-ALDI1 PLZ_37075 ALDI1 3 42
34 PLZ_37075-ALDI3 PLZ_37075 ALDI3 0 42
35 PLZ_37075-ALDI6 PLZ_37075 ALDI6 0 42
36 PLZ_37075-ALDI7 PLZ_37075 ALDI7 0 42
37 PLZ_37075-ALNATURA PLZ_37075 ALNATURA 3 42
38 PLZ_37075-EDEKA1 PLZ_37075 EDEKA1 0 42
39 PLZ_37075-EDEKA2 PLZ_37075 EDEKA2 0 42
40 PLZ_37075-EDEKA3 PLZ_37075 EDEKA3 0 42
41 PLZ_37075-EDEKA4 PLZ_37075 EDEKA4 2 42
42 PLZ_37075-EDEKA5 PLZ_37075 EDEKA5 0 42
43 PLZ_37075-KAUFLAND1 PLZ_37075 KAUFLAND1 0 42
44 PLZ_37075-KAUFLAND2 PLZ_37075 KAUFLAND2 4 42
45 PLZ_37075-LIDL1 PLZ_37075 LIDL1 2 42
46 PLZ_37075-LIDL2 PLZ_37075 LIDL2 0 42
47 PLZ_37075-NAHKAUF1 PLZ_37075 NAHKAUF1 0 42
48 PLZ_37075-NAHKAUF4 PLZ_37075 NAHKAUF4 0 42
49 PLZ_37075-NAHKAUF5 PLZ_37075 NAHKAUF5 0 42
50 PLZ_37075-NETTO1 PLZ_37075 NETTO1 1 42
51 PLZ_37075-NETTO6 PLZ_37075 NETTO6 1 42
52 PLZ_37075-PENNY1 PLZ_37075 PENNY1 3 42
53 PLZ_37075-PENNY2 PLZ_37075 PENNY2 0 42
54 PLZ_37075-REAL1 PLZ_37075 REAL1 1 42
55 PLZ_37075-REAL2 PLZ_37075 REAL2 2 42
56 PLZ_37075-REWE1 PLZ_37075 REWE1 2 42
57 PLZ_37075-REWE2 PLZ_37075 REWE2 0 42
58 PLZ_37075-REWE3 PLZ_37075 REWE3 10 42
59 PLZ_37075-REWE4 PLZ_37075 REWE4 1 42
60 PLZ_37075-REWE6 PLZ_37075 REWE6 0 42
61 PLZ_37075-TEGUT1 PLZ_37075 TEGUT1 6 42
62 PLZ_37075-TEGUT2 PLZ_37075 TEGUT2 1 42
63 PLZ_37075-TEGUT3 PLZ_37075 TEGUT3 0 42
64 PLZ_37075-TEGUT4 PLZ_37075 TEGUT4 0 42
65 PLZ_37077-ALDI1 PLZ_37077 ALDI1 0 15
66 PLZ_37077-ALDI3 PLZ_37077 ALDI3 0 15
67 PLZ_37077-ALDI6 PLZ_37077 ALDI6 0 15
68 PLZ_37077-ALDI7 PLZ_37077 ALDI7 0 15
69 PLZ_37077-ALNATURA PLZ_37077 ALNATURA 0 15
70 PLZ_37077-EDEKA1 PLZ_37077 EDEKA1 1 15
71 PLZ_37077-EDEKA2 PLZ_37077 EDEKA2 1 15
72 PLZ_37077-EDEKA3 PLZ_37077 EDEKA3 0 15
73 PLZ_37077-EDEKA4 PLZ_37077 EDEKA4 0 15
74 PLZ_37077-EDEKA5 PLZ_37077 EDEKA5 0 15
75 PLZ_37077-KAUFLAND1 PLZ_37077 KAUFLAND1 0 15
76 PLZ_37077-KAUFLAND2 PLZ_37077 KAUFLAND2 1 15
77 PLZ_37077-LIDL1 PLZ_37077 LIDL1 0 15
78 PLZ_37077-LIDL2 PLZ_37077 LIDL2 0 15
79 PLZ_37077-NAHKAUF1 PLZ_37077 NAHKAUF1 2 15
80 PLZ_37077-NAHKAUF4 PLZ_37077 NAHKAUF4 0 15
81 PLZ_37077-NAHKAUF5 PLZ_37077 NAHKAUF5 0 15
82 PLZ_37077-NETTO1 PLZ_37077 NETTO1 0 15
83 PLZ_37077-NETTO6 PLZ_37077 NETTO6 0 15
84 PLZ_37077-PENNY1 PLZ_37077 PENNY1 0 15
85 PLZ_37077-PENNY2 PLZ_37077 PENNY2 0 15
86 PLZ_37077-REAL1 PLZ_37077 REAL1 4 15
87 PLZ_37077-REAL2 PLZ_37077 REAL2 0 15
88 PLZ_37077-REWE1 PLZ_37077 REWE1 0 15
89 PLZ_37077-REWE2 PLZ_37077 REWE2 0 15
90 PLZ_37077-REWE3 PLZ_37077 REWE3 0 15
91 PLZ_37077-REWE4 PLZ_37077 REWE4 0 15
92 PLZ_37077-REWE6 PLZ_37077 REWE6 0 15
93 PLZ_37077-TEGUT1 PLZ_37077 TEGUT1 4 15
94 PLZ_37077-TEGUT2 PLZ_37077 TEGUT2 2 15
95 PLZ_37077-TEGUT3 PLZ_37077 TEGUT3 0 15
96 PLZ_37077-TEGUT4 PLZ_37077 TEGUT4 0 15
97 PLZ_37079-ALDI1 PLZ_37079 ALDI1 0 12
98 PLZ_37079-ALDI3 PLZ_37079 ALDI3 0 12
99 PLZ_37079-ALDI6 PLZ_37079 ALDI6 0 12
100 PLZ_37079-ALDI7 PLZ_37079 ALDI7 0 12
101 PLZ_37079-ALNATURA PLZ_37079 ALNATURA 1 12
102 PLZ_37079-EDEKA1 PLZ_37079 EDEKA1 0 12
103 PLZ_37079-EDEKA2 PLZ_37079 EDEKA2 0 12
104 PLZ_37079-EDEKA3 PLZ_37079 EDEKA3 2 12
105 PLZ_37079-EDEKA4 PLZ_37079 EDEKA4 0 12
106 PLZ_37079-EDEKA5 PLZ_37079 EDEKA5 0 12
107 PLZ_37079-KAUFLAND1 PLZ_37079 KAUFLAND1 1 12
108 PLZ_37079-KAUFLAND2 PLZ_37079 KAUFLAND2 1 12
109 PLZ_37079-LIDL1 PLZ_37079 LIDL1 0 12
110 PLZ_37079-LIDL2 PLZ_37079 LIDL2 0 12
111 PLZ_37079-NAHKAUF1 PLZ_37079 NAHKAUF1 0 12
112 PLZ_37079-NAHKAUF4 PLZ_37079 NAHKAUF4 1 12
113 PLZ_37079-NAHKAUF5 PLZ_37079 NAHKAUF5 0 12
114 PLZ_37079-NETTO1 PLZ_37079 NETTO1 0 12
115 PLZ_37079-NETTO6 PLZ_37079 NETTO6 0 12
116 PLZ_37079-PENNY1 PLZ_37079 PENNY1 0 12
117 PLZ_37079-PENNY2 PLZ_37079 PENNY2 0 12
118 PLZ_37079-REAL1 PLZ_37079 REAL1 1 12
119 PLZ_37079-REAL2 PLZ_37079 REAL2 3 12
120 PLZ_37079-REWE1 PLZ_37079 REWE1 0 12
121 PLZ_37079-REWE2 PLZ_37079 REWE2 1 12
122 PLZ_37079-REWE3 PLZ_37079 REWE3 0 12
123 PLZ_37079-REWE4 PLZ_37079 REWE4 0 12
124 PLZ_37079-REWE6 PLZ_37079 REWE6 0 12
125 PLZ_37079-TEGUT1 PLZ_37079 TEGUT1 0 12
126 PLZ_37079-TEGUT2 PLZ_37079 TEGUT2 1 12
127 PLZ_37079-TEGUT3 PLZ_37079 TEGUT3 0 12
128 PLZ_37079-TEGUT4 PLZ_37079 TEGUT4 0 12
129 PLZ_37081-ALDI1 PLZ_37081 ALDI1 0 13
130 PLZ_37081-ALDI3 PLZ_37081 ALDI3 0 13
131 PLZ_37081-ALDI6 PLZ_37081 ALDI6 1 13
132 PLZ_37081-ALDI7 PLZ_37081 ALDI7 0 13
133 PLZ_37081-ALNATURA PLZ_37081 ALNATURA 0 13
134 PLZ_37081-EDEKA1 PLZ_37081 EDEKA1 0 13
135 PLZ_37081-EDEKA2 PLZ_37081 EDEKA2 0 13
136 PLZ_37081-EDEKA3 PLZ_37081 EDEKA3 0 13
137 PLZ_37081-EDEKA4 PLZ_37081 EDEKA4 0 13
138 PLZ_37081-EDEKA5 PLZ_37081 EDEKA5 0 13
139 PLZ_37081-KAUFLAND1 PLZ_37081 KAUFLAND1 1 13
140 PLZ_37081-KAUFLAND2 PLZ_37081 KAUFLAND2 1 13
141 PLZ_37081-LIDL1 PLZ_37081 LIDL1 0 13
142 PLZ_37081-LIDL2 PLZ_37081 LIDL2 1 13
143 PLZ_37081-NAHKAUF1 PLZ_37081 NAHKAUF1 0 13
144 PLZ_37081-NAHKAUF4 PLZ_37081 NAHKAUF4 0 13
145 PLZ_37081-NAHKAUF5 PLZ_37081 NAHKAUF5 0 13
146 PLZ_37081-NETTO1 PLZ_37081 NETTO1 2 13
147 PLZ_37081-NETTO6 PLZ_37081 NETTO6 0 13
148 PLZ_37081-PENNY1 PLZ_37081 PENNY1 0 13
149 PLZ_37081-PENNY2 PLZ_37081 PENNY2 0 13
150 PLZ_37081-REAL1 PLZ_37081 REAL1 0 13
151 PLZ_37081-REAL2 PLZ_37081 REAL2 0 13
152 PLZ_37081-REWE1 PLZ_37081 REWE1 2 13
153 PLZ_37081-REWE2 PLZ_37081 REWE2 0 13
154 PLZ_37081-REWE3 PLZ_37081 REWE3 0 13
155 PLZ_37081-REWE4 PLZ_37081 REWE4 0 13
156 PLZ_37081-REWE6 PLZ_37081 REWE6 2 13
157 PLZ_37081-TEGUT1 PLZ_37081 TEGUT1 2 13
158 PLZ_37081-TEGUT2 PLZ_37081 TEGUT2 0 13
159 PLZ_37081-TEGUT3 PLZ_37081 TEGUT3 1 13
160 PLZ_37081-TEGUT4 PLZ_37081 TEGUT4 0 13
161 PLZ_37083-ALDI1 PLZ_37083 ALDI1 0 25
162 PLZ_37083-ALDI3 PLZ_37083 ALDI3 1 25
163 PLZ_37083-ALDI6 PLZ_37083 ALDI6 0 25
164 PLZ_37083-ALDI7 PLZ_37083 ALDI7 0 25
165 PLZ_37083-ALNATURA PLZ_37083 ALNATURA 0 25
166 PLZ_37083-EDEKA1 PLZ_37083 EDEKA1 0 25
167 PLZ_37083-EDEKA2 PLZ_37083 EDEKA2 0 25
168 PLZ_37083-EDEKA3 PLZ_37083 EDEKA3 0 25
169 PLZ_37083-EDEKA4 PLZ_37083 EDEKA4 0 25
170 PLZ_37083-EDEKA5 PLZ_37083 EDEKA5 2 25
171 PLZ_37083-KAUFLAND1 PLZ_37083 KAUFLAND1 3 25
172 PLZ_37083-KAUFLAND2 PLZ_37083 KAUFLAND2 5 25
173 PLZ_37083-LIDL1 PLZ_37083 LIDL1 1 25
174 PLZ_37083-LIDL2 PLZ_37083 LIDL2 0 25
175 PLZ_37083-NAHKAUF1 PLZ_37083 NAHKAUF1 0 25
176 PLZ_37083-NAHKAUF4 PLZ_37083 NAHKAUF4 0 25
177 PLZ_37083-NAHKAUF5 PLZ_37083 NAHKAUF5 0 25
178 PLZ_37083-NETTO1 PLZ_37083 NETTO1 1 25
179 PLZ_37083-NETTO6 PLZ_37083 NETTO6 0 25
180 PLZ_37083-PENNY1 PLZ_37083 PENNY1 0 25
181 PLZ_37083-PENNY2 PLZ_37083 PENNY2 2 25
182 PLZ_37083-REAL1 PLZ_37083 REAL1 0 25
183 PLZ_37083-REAL2 PLZ_37083 REAL2 1 25
184 PLZ_37083-REWE1 PLZ_37083 REWE1 1 25
185 PLZ_37083-REWE2 PLZ_37083 REWE2 0 25
186 PLZ_37083-REWE3 PLZ_37083 REWE3 0 25
187 PLZ_37083-REWE4 PLZ_37083 REWE4 6 25
188 PLZ_37083-REWE6 PLZ_37083 REWE6 0 25
189 PLZ_37083-TEGUT1 PLZ_37083 TEGUT1 2 25
190 PLZ_37083-TEGUT2 PLZ_37083 TEGUT2 0 25
191 PLZ_37083-TEGUT3 PLZ_37083 TEGUT3 0 25
192 PLZ_37083-TEGUT4 PLZ_37083 TEGUT4 0 25
193 PLZ_37085-ALDI1 PLZ_37085 ALDI1 0 27
194 PLZ_37085-ALDI3 PLZ_37085 ALDI3 0 27
195 PLZ_37085-ALDI6 PLZ_37085 ALDI6 0 27
196 PLZ_37085-ALDI7 PLZ_37085 ALDI7 0 27
197 PLZ_37085-ALNATURA PLZ_37085 ALNATURA 1 27
198 PLZ_37085-EDEKA1 PLZ_37085 EDEKA1 0 27
199 PLZ_37085-EDEKA2 PLZ_37085 EDEKA2 0 27
200 PLZ_37085-EDEKA3 PLZ_37085 EDEKA3 0 27
201 PLZ_37085-EDEKA4 PLZ_37085 EDEKA4 2 27
202 PLZ_37085-EDEKA5 PLZ_37085 EDEKA5 0 27
203 PLZ_37085-KAUFLAND1 PLZ_37085 KAUFLAND1 2 27
204 PLZ_37085-KAUFLAND2 PLZ_37085 KAUFLAND2 4 27
205 PLZ_37085-LIDL1 PLZ_37085 LIDL1 1 27
206 PLZ_37085-LIDL2 PLZ_37085 LIDL2 0 27
207 PLZ_37085-NAHKAUF1 PLZ_37085 NAHKAUF1 0 27
208 PLZ_37085-NAHKAUF4 PLZ_37085 NAHKAUF4 0 27
209 PLZ_37085-NAHKAUF5 PLZ_37085 NAHKAUF5 3 27
210 PLZ_37085-NETTO1 PLZ_37085 NETTO1 3 27
211 PLZ_37085-NETTO6 PLZ_37085 NETTO6 0 27
212 PLZ_37085-PENNY1 PLZ_37085 PENNY1 0 27
213 PLZ_37085-PENNY2 PLZ_37085 PENNY2 0 27
214 PLZ_37085-REAL1 PLZ_37085 REAL1 1 27
215 PLZ_37085-REAL2 PLZ_37085 REAL2 1 27
216 PLZ_37085-REWE1 PLZ_37085 REWE1 3 27
217 PLZ_37085-REWE2 PLZ_37085 REWE2 0 27
218 PLZ_37085-REWE3 PLZ_37085 REWE3 0 27
219 PLZ_37085-REWE4 PLZ_37085 REWE4 2 27
220 PLZ_37085-REWE6 PLZ_37085 REWE6 0 27
221 PLZ_37085-TEGUT1 PLZ_37085 TEGUT1 2 27
222 PLZ_37085-TEGUT2 PLZ_37085 TEGUT2 1 27
223 PLZ_37085-TEGUT3 PLZ_37085 TEGUT3 0 27
224 PLZ_37085-TEGUT4 PLZ_37085 TEGUT4 1 27
p_ij_obs freq_ij_abs_trip_expen freq_i_total_trip_expen
1 0.00000000 0.00 893.91
2 0.00000000 0.00 893.91
3 0.00000000 0.00 893.91
4 0.02222222 17.00 893.91
5 0.04444444 43.00 893.91
6 0.02222222 5.00 893.91
7 0.00000000 0.00 893.91
8 0.00000000 0.00 893.91
9 0.00000000 0.00 893.91
10 0.00000000 0.00 893.91
11 0.00000000 0.00 893.91
12 0.24444444 222.70 893.91
13 0.02222222 14.00 893.91
14 0.00000000 0.00 893.91
15 0.00000000 0.00 893.91
16 0.00000000 0.00 893.91
17 0.00000000 0.00 893.91
18 0.11111111 64.00 893.91
19 0.00000000 0.00 893.91
20 0.00000000 0.00 893.91
21 0.00000000 0.00 893.91
22 0.02222222 55.00 893.91
23 0.00000000 0.00 893.91
24 0.17777778 198.00 893.91
25 0.00000000 0.00 893.91
26 0.06666667 45.00 893.91
27 0.04444444 69.00 893.91
28 0.00000000 0.00 893.91
29 0.20000000 131.21 893.91
30 0.02222222 30.00 893.91
31 0.00000000 0.00 893.91
32 0.00000000 0.00 893.91
33 0.07142857 92.00 865.49
34 0.00000000 0.00 865.49
35 0.00000000 0.00 865.49
36 0.00000000 0.00 865.49
37 0.07142857 47.50 865.49
38 0.00000000 0.00 865.49
39 0.00000000 0.00 865.49
40 0.00000000 0.00 865.49
41 0.04761905 47.00 865.49
42 0.00000000 0.00 865.49
43 0.00000000 0.00 865.49
44 0.09523810 36.00 865.49
45 0.04761905 29.00 865.49
46 0.00000000 0.00 865.49
47 0.00000000 0.00 865.49
48 0.00000000 0.00 865.49
49 0.00000000 0.00 865.49
50 0.02380952 15.00 865.49
51 0.02380952 10.00 865.49
52 0.07142857 58.49 865.49
53 0.00000000 0.00 865.49
54 0.02380952 22.00 865.49
55 0.04761905 165.00 865.49
56 0.04761905 38.00 865.49
57 0.00000000 0.00 865.49
58 0.23809524 146.50 865.49
59 0.02380952 20.00 865.49
60 0.00000000 0.00 865.49
61 0.14285714 117.00 865.49
62 0.02380952 22.00 865.49
63 0.00000000 0.00 865.49
64 0.00000000 0.00 865.49
65 0.00000000 0.00 601.59
66 0.00000000 0.00 601.59
67 0.00000000 0.00 601.59
68 0.00000000 0.00 601.59
69 0.00000000 0.00 601.59
70 0.06666667 30.00 601.59
71 0.06666667 40.00 601.59
72 0.00000000 0.00 601.59
73 0.00000000 0.00 601.59
74 0.00000000 0.00 601.59
75 0.00000000 0.00 601.59
76 0.06666667 6.00 601.59
77 0.00000000 0.00 601.59
78 0.00000000 0.00 601.59
79 0.13333333 3.09 601.59
80 0.00000000 0.00 601.59
81 0.00000000 0.00 601.59
82 0.00000000 0.00 601.59
83 0.00000000 0.00 601.59
84 0.00000000 0.00 601.59
85 0.00000000 0.00 601.59
86 0.26666667 135.00 601.59
87 0.00000000 0.00 601.59
88 0.00000000 0.00 601.59
89 0.00000000 0.00 601.59
90 0.00000000 0.00 601.59
91 0.00000000 0.00 601.59
92 0.00000000 0.00 601.59
93 0.26666667 319.50 601.59
94 0.13333333 68.00 601.59
95 0.00000000 0.00 601.59
96 0.00000000 0.00 601.59
97 0.00000000 0.00 231.00
98 0.00000000 0.00 231.00
99 0.00000000 0.00 231.00
100 0.00000000 0.00 231.00
101 0.08333333 20.00 231.00
102 0.00000000 0.00 231.00
103 0.00000000 0.00 231.00
104 0.16666667 20.00 231.00
105 0.00000000 0.00 231.00
106 0.00000000 0.00 231.00
107 0.08333333 29.00 231.00
108 0.08333333 20.00 231.00
109 0.00000000 0.00 231.00
110 0.00000000 0.00 231.00
111 0.00000000 0.00 231.00
112 0.08333333 25.00 231.00
113 0.00000000 0.00 231.00
114 0.00000000 0.00 231.00
115 0.00000000 0.00 231.00
116 0.00000000 0.00 231.00
117 0.00000000 0.00 231.00
118 0.08333333 10.00 231.00
119 0.25000000 37.00 231.00
120 0.00000000 0.00 231.00
121 0.08333333 5.00 231.00
122 0.00000000 0.00 231.00
123 0.00000000 0.00 231.00
124 0.00000000 0.00 231.00
125 0.00000000 0.00 231.00
126 0.08333333 65.00 231.00
127 0.00000000 0.00 231.00
128 0.00000000 0.00 231.00
129 0.00000000 0.00 221.25
130 0.00000000 0.00 221.25
131 0.07692308 8.00 221.25
132 0.00000000 0.00 221.25
133 0.00000000 0.00 221.25
134 0.00000000 0.00 221.25
135 0.00000000 0.00 221.25
136 0.00000000 0.00 221.25
137 0.00000000 0.00 221.25
138 0.00000000 0.00 221.25
139 0.07692308 18.00 221.25
140 0.07692308 15.00 221.25
141 0.00000000 0.00 221.25
142 0.07692308 25.00 221.25
143 0.00000000 0.00 221.25
144 0.00000000 0.00 221.25
145 0.00000000 0.00 221.25
146 0.15384615 45.00 221.25
147 0.00000000 0.00 221.25
148 0.00000000 0.00 221.25
149 0.00000000 0.00 221.25
150 0.00000000 0.00 221.25
151 0.00000000 0.00 221.25
152 0.15384615 35.00 221.25
153 0.00000000 0.00 221.25
154 0.00000000 0.00 221.25
155 0.00000000 0.00 221.25
156 0.15384615 30.00 221.25
157 0.15384615 10.25 221.25
158 0.00000000 0.00 221.25
159 0.07692308 35.00 221.25
160 0.00000000 0.00 221.25
161 0.00000000 0.00 552.61
162 0.04000000 4.50 552.61
163 0.00000000 0.00 552.61
164 0.00000000 0.00 552.61
165 0.00000000 0.00 552.61
166 0.00000000 0.00 552.61
167 0.00000000 0.00 552.61
168 0.00000000 0.00 552.61
169 0.00000000 0.00 552.61
170 0.08000000 16.00 552.61
171 0.12000000 130.00 552.61
172 0.20000000 123.68 552.61
173 0.04000000 25.00 552.61
174 0.00000000 0.00 552.61
175 0.00000000 0.00 552.61
176 0.00000000 0.00 552.61
177 0.00000000 0.00 552.61
178 0.04000000 11.00 552.61
179 0.00000000 0.00 552.61
180 0.00000000 0.00 552.61
181 0.08000000 21.00 552.61
182 0.00000000 0.00 552.61
183 0.04000000 18.00 552.61
184 0.04000000 25.00 552.61
185 0.00000000 0.00 552.61
186 0.00000000 0.00 552.61
187 0.24000000 155.93 552.61
188 0.00000000 0.00 552.61
189 0.08000000 22.50 552.61
190 0.00000000 0.00 552.61
191 0.00000000 0.00 552.61
192 0.00000000 0.00 552.61
193 0.00000000 0.00 518.64
194 0.00000000 0.00 518.64
195 0.00000000 0.00 518.64
196 0.00000000 0.00 518.64
197 0.03703704 35.00 518.64
198 0.00000000 0.00 518.64
199 0.00000000 0.00 518.64
200 0.00000000 0.00 518.64
201 0.07407407 21.00 518.64
202 0.00000000 0.00 518.64
203 0.07407407 45.00 518.64
204 0.14814815 112.00 518.64
205 0.03703704 30.00 518.64
206 0.00000000 0.00 518.64
207 0.00000000 0.00 518.64
208 0.00000000 0.00 518.64
209 0.11111111 29.00 518.64
210 0.11111111 65.50 518.64
211 0.00000000 0.00 518.64
212 0.00000000 0.00 518.64
213 0.00000000 0.00 518.64
214 0.03703704 10.00 518.64
215 0.03703704 15.00 518.64
216 0.11111111 25.14 518.64
217 0.00000000 0.00 518.64
218 0.00000000 0.00 518.64
219 0.07407407 44.00 518.64
220 0.00000000 0.00 518.64
221 0.07407407 17.00 518.64
222 0.03703704 16.00 518.64
223 0.00000000 0.00 518.64
224 0.03703704 54.00 518.64
p_ij_obs_trip_expen
1 0.000000000
2 0.000000000
3 0.000000000
4 0.019017574
5 0.048103277
6 0.005593404
7 0.000000000
8 0.000000000
9 0.000000000
10 0.000000000
11 0.000000000
12 0.249130226
13 0.015661532
14 0.000000000
15 0.000000000
16 0.000000000
17 0.000000000
18 0.071595574
19 0.000000000
20 0.000000000
21 0.000000000
22 0.061527447
23 0.000000000
24 0.221498809
25 0.000000000
26 0.050340638
27 0.077188979
28 0.000000000
29 0.146782115
30 0.033560426
31 0.000000000
32 0.000000000
33 0.106298166
34 0.000000000
35 0.000000000
36 0.000000000
37 0.054882205
38 0.000000000
39 0.000000000
40 0.000000000
41 0.054304498
42 0.000000000
43 0.000000000
44 0.041594935
45 0.033507031
46 0.000000000
47 0.000000000
48 0.000000000
49 0.000000000
50 0.017331223
51 0.011554149
52 0.067580215
53 0.000000000
54 0.025419127
55 0.190643451
56 0.043905764
57 0.000000000
58 0.169268276
59 0.023108297
60 0.000000000
61 0.135183538
62 0.025419127
63 0.000000000
64 0.000000000
65 0.000000000
66 0.000000000
67 0.000000000
68 0.000000000
69 0.000000000
70 0.049867850
71 0.066490467
72 0.000000000
73 0.000000000
74 0.000000000
75 0.000000000
76 0.009973570
77 0.000000000
78 0.000000000
79 0.005136389
80 0.000000000
81 0.000000000
82 0.000000000
83 0.000000000
84 0.000000000
85 0.000000000
86 0.224405326
87 0.000000000
88 0.000000000
89 0.000000000
90 0.000000000
91 0.000000000
92 0.000000000
93 0.531092605
94 0.113033794
95 0.000000000
96 0.000000000
97 0.000000000
98 0.000000000
99 0.000000000
100 0.000000000
101 0.086580087
102 0.000000000
103 0.000000000
104 0.086580087
105 0.000000000
106 0.000000000
107 0.125541126
108 0.086580087
109 0.000000000
110 0.000000000
111 0.000000000
112 0.108225108
113 0.000000000
114 0.000000000
115 0.000000000
116 0.000000000
117 0.000000000
118 0.043290043
119 0.160173160
120 0.000000000
121 0.021645022
122 0.000000000
123 0.000000000
124 0.000000000
125 0.000000000
126 0.281385281
127 0.000000000
128 0.000000000
129 0.000000000
130 0.000000000
131 0.036158192
132 0.000000000
133 0.000000000
134 0.000000000
135 0.000000000
136 0.000000000
137 0.000000000
138 0.000000000
139 0.081355932
140 0.067796610
141 0.000000000
142 0.112994350
143 0.000000000
144 0.000000000
145 0.000000000
146 0.203389831
147 0.000000000
148 0.000000000
149 0.000000000
150 0.000000000
151 0.000000000
152 0.158192090
153 0.000000000
154 0.000000000
155 0.000000000
156 0.135593220
157 0.046327684
158 0.000000000
159 0.158192090
160 0.000000000
161 0.000000000
162 0.008143175
163 0.000000000
164 0.000000000
165 0.000000000
166 0.000000000
167 0.000000000
168 0.000000000
169 0.000000000
170 0.028953512
171 0.235247281
172 0.223810644
173 0.045239862
174 0.000000000
175 0.000000000
176 0.000000000
177 0.000000000
178 0.019905539
179 0.000000000
180 0.000000000
181 0.038001484
182 0.000000000
183 0.032572700
184 0.045239862
185 0.000000000
186 0.000000000
187 0.282170066
188 0.000000000
189 0.040715876
190 0.000000000
191 0.000000000
192 0.000000000
193 0.000000000
194 0.000000000
195 0.000000000
196 0.000000000
197 0.067484189
198 0.000000000
199 0.000000000
200 0.000000000
201 0.040490514
202 0.000000000
203 0.086765386
204 0.215949406
205 0.057843591
206 0.000000000
207 0.000000000
208 0.000000000
209 0.055915471
210 0.126291840
211 0.000000000
212 0.000000000
213 0.000000000
214 0.019281197
215 0.028921795
216 0.048472929
217 0.000000000
218 0.000000000
219 0.084837267
220 0.000000000
221 0.032778035
222 0.030849915
223 0.000000000
224 0.104118464
[1] 0.5586409 -1.4456805 0.8119981 1.4633403 -1.4456805 -1.4456805
[7] -0.4042878 0.1671033 0.7611454 0.8119981 0.1671033 -0.4297476
[13] 0.6116451 -0.4297476 0.8924717 -0.4297476 -0.4297476 -0.4297476
[19] -0.4297476 0.8924717 0.6116451 -0.4297476 -0.2148738 -0.2148738
[25] -0.2148738 0.8265189 -0.2148738 -0.2148738 -0.2148738 -0.2148738
[31] 1.1073455 -0.2148738 -0.2148738 -0.2148738 -0.2148738 -0.2148738
[37] 1.1073455 -0.2148738 -0.2148738 -0.2148738 -0.2148738 0.8265189
[43] -0.2148738 -0.2148738 0.1391845 0.1391845 0.4200111 0.8053619
[49] 0.7105756 -0.9022082 0.5891535 -0.9022082 0.8053619 -0.9022082
[55] -0.9022082 -0.1893441 -0.1893441 -0.1893441 0.8520486 -0.1893441
[61] -0.1893441 -0.1893441 -0.1893441 0.8520486 -0.1893441 -0.1893441
[67] -0.2768831 -0.2768831 -0.2768831 0.7645096 -0.2768831 -0.2768831
[73] -0.2768831 -0.2768831 1.7274383 -0.2768831 -0.2768831 -0.1202018
[79] -0.1202018 -0.1202018 -0.1202018 -0.1202018 -0.1202018 -0.1202018
[85] -0.1202018 1.2020175 -0.1202018 -0.1202018 -0.3768671 -0.3768671
[91] 0.6645256 1.2359167 -0.3768671 -0.3768671 -0.3768671 -0.3768671
[97] 1.1144946 -0.3768671 -0.3768671 -0.3359608 0.7054318 -0.3359608
[103] -0.3359608 -0.3359608 0.7054318 -0.3359608 -0.3359608 1.2768230
[109] -0.3359608 -0.3359608 -0.2668185 -0.2668185 -0.2668185 -0.2668185
[115] -0.2668185 1.0554008 -0.2668185 -0.2668185 1.3459654 -0.2668185
[121] -0.2668185
Call:
lm(formula = mci_formula, data = mciworkfile)
Residuals:
Min 1Q Median 3Q Max
-1.27457 -0.28725 -0.02391 0.32163 1.29351
Coefficients:
Estimate Std. Error t value Pr(>|t|)
d_time_t -1.2443 0.2319 -5.367 4.02e-07 ***
salesarea_qm_t 0.9413 0.1158 8.132 4.59e-13 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 0.4458 on 119 degrees of freedom
Multiple R-squared: 0.4603, Adjusted R-squared: 0.4512
F-statistic: 50.74 on 2 and 119 DF, p-value: < 2.2e-16
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.