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 - J - M or Group 3 - N - Z Step 2: Locate the following Data Columns from your store's weekly report. A) B) C) D) E) Sales Transactions Traffic UPT 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 Variance for your Transactions data, 95% Standard Deviations for Traffic Data, etc. Use all 25 employee data points. 1) 2) 3) 4) 5) Compute the Five-number summary (Min., Q1, Q2, Q3, Max) Compute Mean Find Variance Compute the Standard Deviation Find the 95% Standard Deviations Step 4: Please find the chart below which identifies the data set and the 5 functions you must compute based on your group. As you can see, you will be using five data sets and computing a few different functions for each test. Group (By Your Last Name) (1) A - H Data Columns 1 3 5 2 4 (2) I - M 1 5 4 3 2 (3) N - Z 1 2 3 4 5 A B C D E Please ask any questions for this conference after you have carefully read the directions and mastered the powerpoint for this chapter. I will try and work with everyone. When you submit, please label your work clearly and show all work at the end. Bold all final answers. I will not hunt for answers. If they are not clearly identified by bolding and I cannot locate, the answer is incorrect. Name A. Leaderis S. Reda V. Totalier S. Teagle I. McClean J. Santiago L. Endsoy C. McMillion J. Dixon T. Hags M. Clarke D. Arias M. Scott S. Miller L. Thompson R. Haug M. Mayo P. Worlda L. Wheeler M. Merrill J. Brown Z. Terrell M. Davis E. Browning B. Wilson Gender m m m f m m m f f f f m m f m f f f m f f f f f m Sales 1701 1652 2352 1573 1526 1283 2552 2113 2441 1107 1095 2211 2795 2579 1966 1756 2533 1357 2113 1657 2144 1382 2311 1699 2255 UPT - Units per transaction OppVol - Missed Sales based on volume Transactions Traffic 55 95 71 60 50 105 86 88 96 69 104 101 109 77 70 72 82 67 76 57 62 51 81 55 55 UPT 111 111 117 117 130 162 162 162 182 182 182 186 216 216 216 186 186 130 130 103 103 100 93 93 91 OppVol 6.02 6.62 5.56 5.56 5.82 7.03 6.43 5.8 6.03 6.71 6.51 6.33 5.64 6.02 6.28 6.81 5.69 6.22 5.64 6.33 5.64 6.22 6.28 6.52 7.03 784 258 874 456 618 895 861 173 1050 357 259 257 1316 951 147 132 30 159 32 102 31 25 52 34 64