Question

1. Following is an extract from the Cost per Order Database of Grogtes LLC.
   

   Item Category	Item ID	Item Cost	Units	Cost per Order
   Nuts	N101	$ 2.44	94	$ 229.36
   Screws	S101	$ 20.44	49	$ 1,001.56
   Nuts	N102	$ 5.44	35	$ 190.40
   Screwdriver	SD101	$ 20.44	26	$ 531.44
   Nuts	N102	$ 3.44	55	$ 189.20
   Screws	S102	$ 5.44	59	$ 320.96
   Nuts	N101	$ 2.44	74	$ 180.56
   Nuts	N102	$ 5.44	89	$ 484.16
   Nuts	N101	$ 2.44	31	$ 75.64
   Screws	S103	$ 9.44	59	$ 556.96
   Nuts	N102	$ 5.44	89	$ 484.16
   Screws	S101	$ 2.44	28	$ 68.32
   Screws	S101	$ 20.44	80	$ 1,635.20
   Nuts	N102	$ 5.44	34	$ 184.96
   Nails	NG101	$ 125.45	1	$ 125.45
   Bolts	B101	$ 16.44	15	$ 246.60
   Screws	S103	$ 9.44	27	$ 254.88
   Screwdriver	SD102	$ 9.44	63	$ 594.72
   Screwdriver	SD101	$ 20.44	14	$ 286.16
   Bolts	B102	$ 5.44	95	$ 516.80
   Nuts	N103	$ 1.74	66	$ 114.84
   Bolts	B101	$ 16.44	73	$ 1,200.12
   Screws	S103	$ 9.44	45	$ 424.80
   Screws	S104	$ 15.45	86	$ 1,328.70
   Screws	S102	$ 5.44	3	$ 16.32
   Screws	S101	$ 20.44	6	$ 122.64
   Bolts	B102	$ 5.44	49	$ 266.56
   Nuts	N101	$ 2.44	65	$ 158.60
   Screwdriver	SD103	$ 5.44	95	$ 516.80
   Nuts	N103	$ 1.74	52	$ 90.48
   Screws	S103	$ 9.44	79	$ 745.76
   Nailgun pack	NG101	$ 125.45	4	$ 501.80
   Bolts	B102	$ 5.44	61	$ 331.84
   Bolts	B103	$ 12.94	54	$ 698.76
   Bolts	B104	$ 24.40	41	$ 1,000.40
   Nails	NG102	$ 275.45	2	$ 550.90
   Nuts	N103	$ 1.74	6	$ 10.44
   Screwdriver	SD104	$ 2.44	75	$ 183.00
   Screws	S101	$ 20.44	56	$ 1,144.64
   Nuts	N103	$ 1.74	13	$ 22.62
   Screws	S102	$ 5.44	10	$ 54.40
   Screws	S101	$ 20.44	93	$ 1,900.92
   Screws	S102	$ 5.44	27	$ 146.88

   
   Which of the following does the 38th percentile of the costs per order indicate?

   		62% of the costs per order are more than or equal to $190.40.
   		38% of the costs per order are more than or equal to $501.80.
   		38% of the costs per order are less than or equal to $189.20.
   		62% of the costs per order are less than or equal to $484.16.

QUESTION 2

1. Use the spreadsheet below to answer the following question(s).
   
   Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period. The rate of shoes sold per day (X) and the price of the shoes (Y).
   

   Shoes sold in % (X)	Price (Y)
   15	$48
   27	$55
   10	$40
   13	$88
   25	$53
   9	$47
   18	$40

   
   Use Excel to calculate the mean for X.

   		16.71
   		7.04
   		2.67
   		0.02

Answer 1

Ans 1) we have

data
229.36
1001.56
190.40
531.44
189.20
320.96
180.56
484.16
75.64
556.96
484.16
68.32
1635.20
184.96
125.45
246.60
254.88
594.72
286.16
516.80
114.84
1200.12
424.80
1328.70
16.32
122.64
266.56
158.60
516.80
90.48
745.76
501.80
331.84
698.76
1000.40
550.90
10.44
183.00
1144.64
22.62
54.40
1900.92
146.88

using excel we have =PERCENTILE.INC(M13:M55,0.38 ) = 190.40

62% of the costs per order are more than or equal to $190.40

ANs 2)using excel we have mean

16.71429