Stats

Challenge #1

Step 1:  Locate your store’s weekly data and the group you are in below based on your last name.

Group 1 – A –H or Group 2 – I – M or Group 3 – N - Z

 Step 2:  Locate the following Data Columns from your store’s weekly report.

  A)  Sales

  B)  Transactions

  C)  Traffic

  D)  UPT

  E)  OppVol

 

Step 3:  There will be 5 functions you will have to compute with the data columns from Step 2. When you look at the chart below in Step 4, the numbers correspond to the statistical procedure you must compute below. So for example, if you are in group A-H, you will compute the mean for your transactions data.

  1)  Compute the Five-number summary (Min., Q1, Q2, Q3, Max)

  2)  Compute Mean

  3)  Find Variance

  4)  Compute the Standard Deviation

  5)  Find the 95% Standard Deviations

 

Step 4:  Please find the chart below which identifies the data set and the 5 functions you must compute.  As you can see, you will be using six data sets and computing a few different functions for each test.

Group (By Last Name)	Data Columns
	A	B	C	D	E
(1) A – H	1	2	4	3	5
(2) I – M	1	5	2	4	3
(3) N – Z	1	4	3	5	2

So for Group #2 you will need to compute:

Data Colum A (sales) – Compute the Five-number summary (Min., Q1, Q2, Q3, Max)

Data Colum B (Transactions) - Find the 95% Standard Deviations

Data Colum C (Traffic) - Compute Mean

Data Colum D (UPT) - Compute the Standard Deviation

Data Colum E (OppVol) - Find Variance

		A	B	C	D	E
Name	Gender	Sales	Transactions	Traffic	UPT	OppVol
S. Totalier	f	1533	60	113	5.56	456
V. Teagle	m	6356	31	113	5.56	834
L. Wheeler	m	6113	36	130	5.64	36
M. Scott	m	6395	109	616	5.64	1316
T. Brown	f	6144	66	103	5.64	31
M. Mayo	f	6533	86	186	5.69	30
C. Endsoy	f	6113	88	166	5.8	133
I. McClean	m	1566	50	130	5.86	618
L. Thompson	f	6539	33	616	6.06	951
S. Leaderis	m	1301	55	111	6.06	384
T. Dixon	f	6441	96	186	6.03	1050
M. Terrell	f	1386	51	100	6.66	65
P. Worlda	f	1353	63	130	6.66	159
M. Davis	f	6311	81	93	6.68	56
S. Miller	m	1966	30	616	6.68	143
D. Arias	m	6611	101	186	6.33	653
J. Merrell	f	1653	53	103	6.33	106
L. McKinnon	m	6556	86	166	6.43	861
M. Clarke	f	1095	104	186	6.51	659
E. Brown	f	1699	55	93	6.56	34
A. Reda	m	1656	95	111	6.66	658
J. Hags	f	1103	69	186	6.31	353
R. Haug	f	1356	36	186	6.81	136
B. Wilson	m	6655	55	91	3.03	64
J. Santiago	m	1683	105	166	3.03	895
UPT - Units per transaction
OppVol - Missed Sales based on volume