ijmatrix.create: Interaction matrix with market shares

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.