STATISTICAL ANALYSIS with SOFTWARE APPLICATION

Which concrete is best sold where? The marketing team of an engineering firm noticed that some of their concrete products are having trouble being sold at some of their distribution points. So they decided to investigate the sales for three concrete types: high-strength concrete, stamped concrete, and high-performance concrete. After consulting with the sales managers at three of their distribution points (A, B and C), they suspected two possibilities as potential reasons for the sales problem. The first is simply that some concrete types just sells better than others. The second is that in general, concrete sells in some places better than in others. So, they thought that if the first reason was true, they would have to just cut down on the production of the concrete types which don't sell well. But if the second reason was true, then they would just limit normal distribution of concrete to places where it sells well. To clear these issues out they conducted a study. For each one of the three types of concrete they recorded the quantities sold at each of the three distribution points on a random sample of 45 days. The data is given in Table 1 with the following format.

Check whether the data supports the first reasons suspected by the marketing team, and state your conclusion.

Check whether the data supports the second reason suspected by the marketing team, and state your conclusion.

Based on the results of (a) and (b), propose and discuss a concrete distribution policy for this engineering firm.

Table 1

	Distribution	Distribution	Distribution
	Point A	Point B	Point C
High-strength concrete	223	117	201
	234	99	102
	259	66	130
	187	55	153
	160	108	183
	199	79	170
	216	95	169
	252	113	169
	197	63	160
	237	105	162
	219	139	143
	212	144	209
	257	98	181
	194	118	210
	220	150	192
	210	140	156
	177	113	172
	202	149	166
	254	58	181
	209	110	148
	209	60	169
	195	100	144
	193	104	173
	201	120	190
	187	94	177
	204	112	158
	206	135	155
	231	136	169
	195	142	190
	224	152	133
	159	147	139
	205	116	137
	179	122	155
	201	119	121
	230	111	169
	244	69	166
	200	102	162
	208	85	109
	215	82	184
	268	82	180
	243	109	164
	235	109	147
	186	96	102
	226	83	138
	208	106	111
Stamped concrete	227	148	162
	228	117	150
	214	95	199
	152	155	281
	93	199	201
	151	170	217
	133	145	228
	150	231	240
	98	170	212
	75	94	110
	150	174	237
	211	98	190
	191	134	173
	202	62	163
	163	151	205
	127	138	198
	108	118	191
	86	104	233
	168	126	200
	129	118	250
	166	170	223
	124	157	216
	119	101	193
	119	178	208
	190	124	275
	188	173	205
	148	185	185
	171	132	159
	149	145	225
	69	162	245
	109	145	193
	178	186	201
	132	141	214
	139	115	210
	180	169	136
	179	144	203
	161	202	210
	174	127	211
	210	200	169
	134	134	188
	149	134	202
	90	212	238
	134	170	202
	121	96	183
	151	89	219
High-performance concrete	161	215	157
	109	267	177
	148	206	121
	116	325	236
	145	200	118
	146	212	59
	210	217	140
	95	220	93
	142	201	83
	146	170	121
	178	155	93
	156	230	174
	119	219	163
	204	174	168
	179	243	97
	153	151	181
	178	208	166
	193	239	111
	134	264	127
	163	165	119
	139	163	110
	126	159	191
	201	113	74
	159	197	169
	114	210	176
	146	202	145
	154	123	52
	209	148	175
	134	214	68
	132	172	161
	129	188	166
	141	214	88
	194	194	170
	161	304	180
	151	213	94
	102	107	134
	200	180	140
	203	196	100
	100	218	134
	177	149	142
	141	185	203
	45	190	96
	67	249	98
	181	233	104
	145	216	107