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
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...
Related questions
Question
2) In EXCEL display a descriptive statistic on Units Sold (using Store and Regional Sales
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY