2) In EXCEL display a descriptive statistic on Units Sold 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

The Answer is in the image, click to view ...

Question: 2) In EXCEL display a descriptive statistic on Units Sold by using Data Analysis Add-in , then answer the following questions: a. What is the

2) In EXCEL display a descriptive statistic on Units Sold 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Redfern Audio produces audio equipment including headphones. At the Campus Facility, it produces two wireless models, Standard and Enhanced, which differ both in the materials and components used and...

EFB106 COST AND BENEFIT ANALYSIS FOR PROJECT APPRAISAL Assessment Item 1: Sensitivity Analysis Online resource: http://www.cbabuilder.co.uk/ CBA Builder Excel Tool:...

2) In EXCEL using Data Analysis add-in, run a Regression model between Selling Price and Lot Cost. Display the Summary Output and answer the following questions: a. What is the null and alternative...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel. Access these tutorials at Atomic Learning using your SNHU login...

I do not know how to solve the problem about scatterplots. If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel....

Equipment acquired on January 3, 2005, at a cost of $360,000, has an estimated useful life of 12 years, has an estimated residual value of $30,000, and is depreciated by the straight-line method. a....

M/S XYZ Company Manufactures Sports bikes and supplies them to the local market. A local sub-contracting manufacturer supplies the wheels to the M/S XYZ Company through a purchase contract. The...

Verify that the given two - parameter family o f functions y = c 1 e 2 x + c 2 x e 2 x + x 2 e 2 x + x - 2 i s the general solutions o f the differential equation y ' ' - 4 y ' + 4 y = 2 e 2 x + 4 x...

A box office analyst seeks to predict opening weekend box office gross for movies. Toward this goal, the analyst plans to use online trailer views as a predictor. For each of the 6666 movies, the...

(a)A pro forma income statement for the project. (b)Calculation of Operating Cash Flows. (c) Calculation of Net Capital Spending. (d) Calculation of the annual change in Net Working Capital. (e)...

The asset schedule extract of Bilby Ltd shows the following details for its machinery as at 30 June 2019. The machinery has been accounted for using the revaluation model. Machine A (Alvino) Machine...

Kanga is a 10% partner in Roo, Ltd. His basis in the interest is $60,000 before loss allocations, including his $30,000 share of the partnership's nonrecourse debt (it is not qualified nonrecourse...

A pointer holds a memory address.

Do not get married, wait until I come, etc.

Do not come to the conclusion too quickly

Engage everyone in the dialogue