The data sheet.. Name Gender Sales Transactions Traffic UPT S. Leaderis m 1701 5

Question

The data sheet..

Name Gender Sales Transactions Traffic UPT S. Leaderis m 1701 55 111 6.02 A. Reda m 1652 95 111 6.62 V. Teagle m 2352 71 117 5.56 S. Totalier f 1573 60 117 5.56 I. McClean m 1526 50 130 5.82 J. Santiago m 1283 105 162 7.03 L. McKinnon m 2552 86 162 6.43 C. Endsoy f 2113 88 162 5.8 T. Dixon f 2441 96 182 6.03 J. Hags f 1107 69 182 6.71 M. Clarke f 1095 104 182 6.51 D. Arias m 2211 101 186 6.33 M. Scott m 2795 109 216 5.64 L. Thompson f 2579 77 216 6.02 S. Miller m 1966 70 216 6.28 R. Haug f 1756 72 186 6.81 M. Mayo f 2533 82 186 5.69 P. Worlda f 1357 67 130 6.22 L. Wheeler m 2113 76 130 5.64 J. Merrell f 1657 57 103 6.33 T. Brown f 2144 62 103 5.64 M. Terrell f 1382 51 100 6.22 M. Davis f 2311 81 93 6.28 E. Brown f 1699 55 93 6.52 B. Wilson m 2255 55 91 7.03 UPT - Units per transaction OppVol - Missed Sales based on volume Illustrations Step 1: Locate your store's weekly data and the group you are in below based on your last name 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 variance 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 Data Columns (By Last Name) A (3) N-Z 3

Explanation / Answer

You can use either MS-EXCEL or R whatever you like to solve this problem.I will use MS-EXCEL here.

   To find quartiles use the function QUARTILE.

I have attached the excel sheet on the link below in case you wana check it yourself.

https://drive.google.com/file/d/0ByUkX0Zrq3LBQ1lwU0ZRSHFTTm8/view?usp=sharing

Sales Transactions Traffic UPT Min 1095 50 91 5.56 Q1 1573 60 111 5.8 Q2 1966 72 130 6.22 Q3 2311 88 182 6.51 Max 2795 109 216 7.03

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---