2) In EXCEL display a descriptive statistic on Units Sold (using Store and Regional Sales Database) by using Data Analysis Add-in , then answer the following questions: a. What is the Kurtosis? How to interpret it?  b. What is the Skewness? How to interpret it?  c. What is the Range? How to interpret it? Store and Regional Sales Database                             ID Store No. Sales Region Item No. Item Description Unit Price Units Sold Week Ending   1 1 South 2005 24" Monitor $229.00 28 October   2 1 South 2005 24" Monitor $229.00 30 November   3 1 South 2005 24" Monitor $229.00 9 December   4 1 South 3006 Wireless Keyboard $19.95 30 October   5 1 South 3006 Wireless Keyboard $19.95 35 November   6 1 South 3006 Wireless Keyboard $19.95 39 December   7 1 South 6050 PC Mouse $8.95 28 October   8 1 South 6050 PC Mouse $8.95 3 November   9 1 South 6050 PC Mouse $8.95 38 December   10 1 South 8500 Laptop $849.95 25 October   11 1 South 8500 Laptop $849.95 27 November   12 1 South 8500 Laptop $849.95 33 December   13 2 South 2005 24" Monitor $229.00 8 October   14 2 South 2005 24" Monitor $229.00 8 November   15 2 South 2005 24" Monitor $229.00 10 December   16 2 South 3006 Wireless Keyboard $19.95 8 October   17 2 South 3006 Wireless Keyboard $19.95 8 November   18 2 South 3006 Wireless Keyboard $19.95 8 December   19 2 South 6050 PC Mouse $8.95 9 October   20 2 South 6050 PC Mouse $8.95 9 November   21 2 South 6050 PC Mouse $8.95 8 December   22 2 South 8500 Laptop $849.95 18 October   23 2 South 8500 Laptop $849.95 18 November   24 2 South 8500 Laptop $849.95 20 December   25 3 South 2005 24" Monitor $229.00 38 October   26 3 South 2005 24" Monitor $229.00 30 November   27 3 South 2005 24" Monitor $229.00 3 December   28 3 South 3006 Wireless Keyboard $19.95 30 October   29 3 South 3006 Wireless Keyboard $19.95 32 November   30 3 South 3006 Wireless Keyboard $19.95 33 December   31 3 South 6050 PC Mouse $8.95 25 October   32 3 South 6050 PC Mouse $8.95 5 November   33 3 South 6050 PC Mouse $8.95 26 December   34 3 South 8500 Laptop $849.95 28 October   35 3 South 8500 Laptop $849.95 27 November   36 3 South 8500 Laptop $849.95 29 December   37 4 North 2005 24" Monitor $229.00 18 October   38 4 North 2005 24" Monitor $229.00 20 November   39 4 North 2005 24" Monitor $229.00 4 December   40 4 North 3006 Wireless Keyboard $19.95 12 October   41 4 North 3006 Wireless Keyboard $19.95 24 November   42 4 North 3006 Wireless Keyboard $19.95 36 December   43 4 North 6050 PC Mouse $8.95 29 October   44 4 North 6050 PC Mouse $8.95 11 November   45 4 North 6050 PC Mouse $8.95 38 December   46 4 North 8500 Laptop $849.95 21 October   47 4 North 8500 Laptop $849.95 24 November   48 4 North 8500 Laptop $849.95 30 December   49 5 North 2005 24" Monitor $229.00 27 October   50 5 North 2005 24" Monitor $229.00 25 November   51 5 North 2005 24" Monitor $229.00 23 December   52 5 North 3006 Wireless Keyboard $19.95 80 October   53 5 North 3006 Wireless Keyboard $19.95 82 November   54 5 North 3006 Wireless Keyboard $19.95 75 December   55 5 North 6050 PC Mouse $8.95 65 October   56 5 North 6050 PC Mouse $8.95 24 November   57 5 North 6050 PC Mouse $8.95 55 December   58 5 North 8500 Laptop $849.95 55 October   59 5 North 8500 Laptop $849.95 57 November   60 5 North 8500 Laptop $849.95 47 December   61 6 East 2005 24" Monitor $229.00 24 October   62 6 East 2005 24" Monitor $229.00 85 November   63 6 East 2005 24" Monitor $229.00 56 December   64 6 East 3006 Wireless Keyboard $19.95 52 October   65 6 East 3006 Wireless Keyboard $19.95 58 November   66 6 East 3006 Wireless Keyboard $19.95 69 December   67 6 East 6050 PC Mouse $8.95 35 October   68 6 East 6050 PC Mouse $8.95 39 November   69 6 East 6050 PC Mouse $8.95 44 December   70 6 East 8500 Laptop $849.95 78 October   71 6 East 8500 Laptop $849.95 88 November   72 6 East 8500 Laptop $849.95 99 December   73 7 East 2005 24" Monitor $229.00 34 October   74 7 East 2005 24" Monitor $229.00 36 November   75 7 East 2005 24" Monitor $229.00 35 December   76 7 East 3006 Wireless Keyboard $19.95 49 October   77 7 East 3006 Wireless Keyboard $19.95 47 November   78 7 East 3006 Wireless Keyboard $19.95 48 December   79 7 East 6050 PC Mouse $8.95 45 October   80 7 East 6050 PC Mouse $8.95 42 November   81 7 East 6050 PC Mouse $8.95 45 December   82 7 East 8500 Laptop $849.95 55 October   83 7 East 8500 Laptop $849.95 57 November   84 7 East 8500 Laptop $849.95 55 December   85 8 East 2005 24" Monitor $229.00 18 October   86 8 East 2005 24" Monitor $229.00 17 November   87 8 East 2005 24" Monitor $229.00 23 December   88 8 East 3006 Wireless Keyboard $19.95 22 October   89 8 East 3006 Wireless Keyboard $19.95 18 November   90 8 East 3006 Wireless Keyboard $19.95 22 December   91 8 East 6050 PC Mouse $8.95 14 October   92 8 East 6050 PC Mouse $8.95 16 November   93 8 East 6050 PC Mouse $8.95 17 December   94 8 East 8500 Laptop $849.95 32 October   95 8 East 8500 Laptop $849.95 28 November   96 8 East 8500 Laptop $849.95 30 December

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

2) In EXCEL display a descriptive statistic on Units Sold (using Store and Regional Sales Database) by using Data Analysis Add-in , then answer the following questions:
a. What is the Kurtosis? How to interpret it? 
b. What is the Skewness? How to interpret it? 
c. What is the Range? How to interpret it?

Store and Regional Sales Database          
                 
ID Store No. Sales Region Item No. Item Description Unit Price Units Sold Week Ending  
1 1 South 2005 24" Monitor $229.00 28 October  
2 1 South 2005 24" Monitor $229.00 30 November  
3 1 South 2005 24" Monitor $229.00 9 December  
4 1 South 3006 Wireless Keyboard $19.95 30 October  
5 1 South 3006 Wireless Keyboard $19.95 35 November  
6 1 South 3006 Wireless Keyboard $19.95 39 December  
7 1 South 6050 PC Mouse $8.95 28 October  
8 1 South 6050 PC Mouse $8.95 3 November  
9 1 South 6050 PC Mouse $8.95 38 December  
10 1 South 8500 Laptop $849.95 25 October  
11 1 South 8500 Laptop $849.95 27 November  
12 1 South 8500 Laptop $849.95 33 December  
13 2 South 2005 24" Monitor $229.00 8 October  
14 2 South 2005 24" Monitor $229.00 8 November  
15 2 South 2005 24" Monitor $229.00 10 December  
16 2 South 3006 Wireless Keyboard $19.95 8 October  
17 2 South 3006 Wireless Keyboard $19.95 8 November  
18 2 South 3006 Wireless Keyboard $19.95 8 December  
19 2 South 6050 PC Mouse $8.95 9 October  
20 2 South 6050 PC Mouse $8.95 9 November  
21 2 South 6050 PC Mouse $8.95 8 December  
22 2 South 8500 Laptop $849.95 18 October  
23 2 South 8500 Laptop $849.95 18 November  
24 2 South 8500 Laptop $849.95 20 December  
25 3 South 2005 24" Monitor $229.00 38 October  
26 3 South 2005 24" Monitor $229.00 30 November  
27 3 South 2005 24" Monitor $229.00 3 December  
28 3 South 3006 Wireless Keyboard $19.95 30 October  
29 3 South 3006 Wireless Keyboard $19.95 32 November  
30 3 South 3006 Wireless Keyboard $19.95 33 December  
31 3 South 6050 PC Mouse $8.95 25 October  
32 3 South 6050 PC Mouse $8.95 5 November  
33 3 South 6050 PC Mouse $8.95 26 December  
34 3 South 8500 Laptop $849.95 28 October  
35 3 South 8500 Laptop $849.95 27 November  
36 3 South 8500 Laptop $849.95 29 December  
37 4 North 2005 24" Monitor $229.00 18 October  
38 4 North 2005 24" Monitor $229.00 20 November  
39 4 North 2005 24" Monitor $229.00 4 December  
40 4 North 3006 Wireless Keyboard $19.95 12 October  
41 4 North 3006 Wireless Keyboard $19.95 24 November  
42 4 North 3006 Wireless Keyboard $19.95 36 December  
43 4 North 6050 PC Mouse $8.95 29 October  
44 4 North 6050 PC Mouse $8.95 11 November  
45 4 North 6050 PC Mouse $8.95 38 December  
46 4 North 8500 Laptop $849.95 21 October  
47 4 North 8500 Laptop $849.95 24 November  
48 4 North 8500 Laptop $849.95 30 December  
49 5 North 2005 24" Monitor $229.00 27 October  
50 5 North 2005 24" Monitor $229.00 25 November  
51 5 North 2005 24" Monitor $229.00 23 December  
52 5 North 3006 Wireless Keyboard $19.95 80 October  
53 5 North 3006 Wireless Keyboard $19.95 82 November  
54 5 North 3006 Wireless Keyboard $19.95 75 December  
55 5 North 6050 PC Mouse $8.95 65 October  
56 5 North 6050 PC Mouse $8.95 24 November  
57 5 North 6050 PC Mouse $8.95 55 December  
58 5 North 8500 Laptop $849.95 55 October  
59 5 North 8500 Laptop $849.95 57 November  
60 5 North 8500 Laptop $849.95 47 December  
61 6 East 2005 24" Monitor $229.00 24 October  
62 6 East 2005 24" Monitor $229.00 85 November  
63 6 East 2005 24" Monitor $229.00 56 December  
64 6 East 3006 Wireless Keyboard $19.95 52 October  
65 6 East 3006 Wireless Keyboard $19.95 58 November  
66 6 East 3006 Wireless Keyboard $19.95 69 December  
67 6 East 6050 PC Mouse $8.95 35 October  
68 6 East 6050 PC Mouse $8.95 39 November  
69 6 East 6050 PC Mouse $8.95 44 December  
70 6 East 8500 Laptop $849.95 78 October  
71 6 East 8500 Laptop $849.95 88 November  
72 6 East 8500 Laptop $849.95 99 December  
73 7 East 2005 24" Monitor $229.00 34 October  
74 7 East 2005 24" Monitor $229.00 36 November  
75 7 East 2005 24" Monitor $229.00 35 December  
76 7 East 3006 Wireless Keyboard $19.95 49 October  
77 7 East 3006 Wireless Keyboard $19.95 47 November  
78 7 East 3006 Wireless Keyboard $19.95 48 December  
79 7 East 6050 PC Mouse $8.95 45 October  
80 7 East 6050 PC Mouse $8.95 42 November  
81 7 East 6050 PC Mouse $8.95 45 December  
82 7 East 8500 Laptop $849.95 55 October  
83 7 East 8500 Laptop $849.95 57 November  
84 7 East 8500 Laptop $849.95 55 December  
85 8 East 2005 24" Monitor $229.00 18 October  
86 8 East 2005 24" Monitor $229.00 17 November  
87 8 East 2005 24" Monitor $229.00 23 December  
88 8 East 3006 Wireless Keyboard $19.95 22 October  
89 8 East 3006 Wireless Keyboard $19.95 18 November  
90 8 East 3006 Wireless Keyboard $19.95 22 December  
91 8 East 6050 PC Mouse $8.95 14 October  
92 8 East 6050 PC Mouse $8.95 16 November  
93 8 East 6050 PC Mouse $8.95 17 December  
94 8 East 8500 Laptop $849.95 32 October  
95 8 East 8500 Laptop $849.95 28 November  
96 8 East 8500 Laptop $849.95 30 December
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY