Please asnwer all parts of question 2 Fiscal Year Company code Sales (millions) Number of Customers...

Please asnwer all parts of question 2

Fiscal Year	Company code	Sales (millions)	Number of Customers
2002	K	203.00	1103.00
2000	K	470.00	6024.00
2003	I	478.00	9226.00
2001	K	523.00	2644.00
2008	E	581.00	3252.00
2004	H	902.00	9240.00
2000	N	970.00	9896.00
2004	N	1078.00	863.00
2006	O	1346.00	7265.00
2002	H	1354.00	9824.00
2007	I	1366.00	3728.00
2002	O	1372.00	230.00
2006	E	1431.00	7018.00
2000	L	1480.00	8804.00
2008	K	1500.00	7011.00
2007	O	1520.00	4079.00
2009	B	1523.00	5215.00
2001	D	1526.00	9694.00
2003	L	1538.00	7319.00
2000	P	1546.00	4547.00
2009	I	1560.00	4889.00
2008	C	1579.00	958.00
2003	D	1582.00	8827.00
2003	M	1861.00	3924.00
2005	B	1985.00	9416.00
2001	H	2128.00	6303.00
2005	G	2151.00	8743.00
2002	A	2217.00	1083.00
2001	B	2297.00	8865.00
2001	E	2298.00	6285.00
2004	A	2302.00	3106.00
2000	I	2359.00	6726.00
2004	C	2362.00	5379.00
2004	O	2367.00	8230.00
2001	I	2530.00	2474.00
2009	H	2530.00	320.00
2007	B	2554.00	300.00
2007	M	2570.00	1015.00
2005	O	2659.00	8243.00
2006	G	2687.00	6088.00
2007	C	2877.00	830.00
2005	I	2887.00	6675.00
2006	L	2898.00	4667.00
2009	K	3037.00	9862.00
2003	B	3074.00	2605.00
2009	A	3136.00	7330.00
2003	E	3140.00	8093.00
2003	A	3157.00	3296.00
2004	G	3335.00	5684.00
2000	E	3375.00	7578.00
2003	P	3378.00	2139.00
2004	D	3393.00	2868.00
2002	D	3526.00	500.00
2005	H	3620.00	8803.00
2006	A	3620.00	627.00
2007	P	3620.00	5203.00
2001	N	3635.00	2641.00
2000	A	3698.00	5941.00
2008	I	3754.00	3812.00
2004	E	3853.00	1467.00
2008	B	3972.00	1289.00
2007	D	4112.00	9247.00
2007	N	4146.00	2962.00
2008	O	4192.00	3199.00
2000	H	4197.00	2272.00
2005	P	4224.00	2151.00
2002	G	4280.00	9513.00
2009	L	4300.00	7610.00
2002	C	4640.00	7953.00
2002	N	4784.00	327.00
2007	E	4838.00	6613.00
2001	P	4876.00	9627.00
2009	D	4944.00	8902.00
2005	M	5055.00	5559.00
2005	N	5221.00	5446.00
2009	G	5230.00	3026.00
2006	C	5463.00	7089.00
2000	D	5570.00	6787.00
2006	H	5690.00	8200.00
2009	E	5726.00	8354.00
2000	G	5801.00	2664.00
2006	B	5924.00	8727.00
2005	K	5952.00	9790.00
2005	A	5995.00	1910.00
2004	M	6101.00	8082.00
2007	K	6101.00	954.00
2008	H	6229.00	7640.00
2001	L	6230.00	1330.00
2003	N	6268.00	7765.00
2001	M	6349.00	4803.00
2001	A	6398.00	3494.00
2008	M	6580.00	1020.00
2008	D	6585.00	8559.00
2008	G	6594.00	7162.00
2002	E	6595.00	2644.00
2000	M	6646.00	9390.00
2008	P	6696.00	8070.00
2003	C	6725.00	9058.00
2004	P	6745.00	6060.00
2002	B	6960.00	5446.00
2005	C	7015.00	8798.00
2006	P	7019.00	8702.00
2005	D	7067.00	1232.00
2004	B	7133.00	9529.00
2002	P	7135.00	7005.00
2008	L	7145.00	8213.00
2009	C	7147.00	9260.00
2003	O	7166.00	8344.00
2007	H	7184.00	8591.00
2001	C	7264.00	2561.00
2009	N	7398.00	8520.00
2003	K	7545.00	277.00
2006	M	7576.00	8802.00
2009	M	7604.00	9689.00
2006	D	7734.00	4564.00
2007	A	7759.00	7131.00
2005	L	7780.00	8629.00
2001	O	7798.00	3380.00
2002	M	7956.00	2699.00
2003	G	8201.00	7433.00
2006	N	8205.00	4906.00
2008	A	8249.00	6330.00
2004	I	8306.00	3813.00
2008	N	8358.00	6190.00
2002	I	8435.00	4017.00
2004	L	8441.00	8741.00
2006	K	8527.00	313.00
2004	K	8564.00	6500.00
2007	G	8898.00	2634.00
2007	L	8972.00	2953.00
2000	C	8988.00	2330.00
2001	G	9002.00	437.00
2009	P	9062.00	4748.00
2000	B	9088.00	6072.00
2000	O	9474.00	4339.00
2005	E	9515.00	5160.00
2003	H	9584.00	5417.00
2006	I	9614.00	9526.00
2009	O	9616.00	6763.00
2002	L	9825.00	3453.00

Question 2: Use Data2 Sheet

2a. Conduct a 2-level sort: on Fiscal Year (Largest to Smallest) and then on Company code (Z to A).

Report company code and year of 5^th record (do not count the header of the table).

In Answer Sheet, put Company code and year continuously like: K2002

2b. For each company, calculate the annual sales growth. Report the company code and year of the 8^th Highest growth number.

Annual sales growth = Sale year (i)/Sale year (i-1) -1

In Answer Sheet, put Company code and year continuously like: K2002

2c. For each year, if you want to find a firm with the smallest Sales, how will you sort the data so that you can systematically identify these records? (this sort answers a question such as: in 2002, which firm has the lowest sales number?)

Sort first by:

Then by:

In Answer Sheet, we use column A, B, C, D instead of typing Fiscal year (column A), Company code (column B), Sales (column C) …

So if you think you should sort on Fiscal Year (column A), then on Company Code (column B), then on Sales (column C), simply type ABC

Expert Solution

Q2a	Fifth record
	Company code	L
	Year	2009
	L2009

Q2b	2009C

Q2c	Sort first by	Fiscal year	Smallest to largest
	Then By	Sales	Smallest to largest
	Then By	Company code	A to Z

Fiscal Year	Company code	Sales (millions)	Number of Customers
2000	K	470	6024
2000	N	970	9896
2000	L	1480	8804
2000	P	1546	4547
2000	I	2359	6726
2000	E	3375	7578
2000	A	3698	5941
2000	H	4197	2272
2000	D	5570	6787
2000	G	5801	2664
2000	M	6646	9390
2000	C	8988	2330
2000	B	9088	6072
2000	O	9474	4339
2001	K	523	2644
2001	D	1526	9694
2001	H	2128	6303
2001	B	2297	8865
2001	E	2298	6285
2001	I	2530	2474
2001	N	3635	2641
2001	P	4876	9627
2001	L	6230	1330
2001	M	6349	4803
2001	A	6398	3494
2001	C	7264	2561
2001	O	7798	3380
2001	G	9002	437
2002	K	203	1103
2002	H	1354	9824
2002	O	1372	230
2002	A	2217	1083
2002	D	3526	500
2002	G	4280	9513
2002	C	4640	7953
2002	N	4784	327
2002	E	6595	2644
2002	B	6960	5446
2002	P	7135	7005
2002	M	7956	2699
2002	I	8435	4017
2002	L	9825	3453
2003	I	478	9226
2003	L	1538	7319
2003	D	1582	8827
2003	M	1861	3924
2003	B	3074	2605
2003	E	3140	8093
2003	A	3157	3296
2003	P	3378	2139
2003	N	6268	7765
2003	C	6725	9058
2003	O	7166	8344
2003	K	7545	277
2003	G	8201	7433
2003	H	9584	5417
2004	H	902	9240
2004	N	1078	863
2004	A	2302	3106
2004	C	2362	5379
2004	O	2367	8230
2004	G	3335	5684
2004	D	3393	2868
2004	E	3853	1467
2004	M	6101	8082
2004	P	6745	6060
2004	B	7133	9529
2004	I	8306	3813
2004	L	8441	8741
2004	K	8564	6500
2005	B	1985	9416
2005	G	2151	8743
2005	O	2659	8243
2005	I	2887	6675
2005	H	3620	8803
2005	P	4224	2151
2005	M	5055	5559
2005	N	5221	5446
2005	K	5952	9790
2005	A	5995	1910
2005	C	7015	8798
2005	D	7067	1232
2005	L	7780	8629
2005	E	9515	5160
2006	O	1346	7265
2006	E	1431	7018
2006	G	2687	6088
2006	L	2898	4667
2006	A	3620	627
2006	C	5463	7089
2006	H	5690	8200
2006	B	5924	8727
2006	P	7019	8702
2006	M	7576	8802
2006	D	7734	4564
2006	N	8205	4906
2006	K	8527	313
2006	I	9614	9526
2007	I	1366	3728
2007	O	1520	4079
2007	B	2554	300
2007	M	2570	1015
2007	C	2877	830
2007	P	3620	5203
2007	D	4112	9247
2007	N	4146	2962
2007	E	4838	6613
2007	K	6101	954
2007	H	7184	8591
2007	A	7759	7131
2007	G	8898	2634
2007	L	8972	2953
2008	E	581	3252
2008	K	1500	7011
2008	C	1579	958
2008	I	3754	3812
2008	B	3972	1289
2008	O	4192	3199
2008	H	6229	7640
2008	M	6580	1020
2008	D	6585	8559
2008	G	6594	7162
2008	P	6696	8070
2008	L	7145	8213
2008	A	8249	6330
2008	N	8358	6190
2009	B	1523	5215
2009	I	1560	4889
2009	H	2530	320
2009	K	3037	9862
2009	A	3136	7330
2009	L	4300	7610
2009	D	4944	8902
2009	G	5230	3026
2009	E	5726	8354
2009	C	7147	9260
2009	N	7398	8520
2009	M	7604	9689
2009	P	9062	4748
2009	O	9616	6763

jeff jeffy answered 1 year ago

Please answer all the parts of this question Please answer all the parts of this question...

Please answer all the parts of this question Please answer all the parts of this question Question: a) Where is the flow accelerating in the control volume? b) Will the pressure be greater or less than hydrostatic in a region of accelerating flow? c) Is the hydrostatic estimate of force on the gate; larger, smaller, or the same, as that obtained from the Momentum Equation? Explain. d) Where does the change in flow momentum go in this control volume? Explain.

Can you please explain the asnwer for #1 (parts A - D) 1) A company manufactures...

Can you please explain the asnwer for #1 (parts A - D) 1) A company manufactures hair dryers. It buys some of the components, but it makes the heating element, which it can produce at the rate of 800 per day. Hair dryers are assembled daily, 250 days a year, at a rate of 300 per day. Because of the disparity between the production and usage rates, the heating elements are periodically produced in batches of 2,000 units. A) Approximately...

please asnwer all parts of question 5 Date Yearmonth SP500 WMT MSFT MGM CERN XOM 12/3/2012...

please asnwer all parts of question 5 Date Yearmonth SP500 WMT MSFT MGM CERN XOM 12/3/2012 201212 1426.19 65.33 25.39 11.64 38.76 82.52 11/1/2012 201211 1416.18 68.58 25.31 10.15 38.61 84.03 10/1/2012 201210 1412.16 71.43 26.91 10.31 38.1 86.38 9/4/2012 201209 1440.67 70.27 28.06 10.75 38.69 86.65 8/1/2012 201208 1406.58 69.13 29.06 9.86 36.57 82.72 7/2/2012 201207 1379.32 70.49 27.61 9.52 36.96 81.76 6/1/2012 201206 1362.16 66.03 28.66 11.16 41.33 80.55 5/1/2012 201205 1310.33 62.34 27.34 10.83 38.98 74.02 4/2/2012...

answer all parts please Brunell Products has projected the following sales for the coming year: ...

answer all parts please Brunell Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $360 $450 $600 $540 Sales in the year following this one are projected to be 10 percent greater in each quarter. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately. a. What is the payables...

Please answer all parts of this question for both parts!! Prompt: In our study of the...

Please answer all parts of this question for both parts!! Prompt: In our study of the skeletal system this week it should be readily apparent to you how important synovial joints are in the normal function of the human body. This week you will pick two synovial joints to discuss. Pick one from each category below. For each selected joint you should provide the following information: the movements that are possible at that joint (use appropriate anatomical terminology), identification of...

Please solve all parts of the following question. Please show all work and all steps. 1a.)...

Please solve all parts of the following question. Please show all work and all steps. 1a.) Solve x' = x + 3y + 2t y' = x - y + t^2 1b.) Solve x' + ty = -1 y' + x' = 2 1c.) Solve x' + y = 3t y' - tx' = 0

Please answer all parts of the question. Please show all work and all steps. 1a.) Show...

Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0

HELLO, PLEASE ANSWER THE FOLLOWING QUESTION. IT WAS ASSIGNED WITH 2 PARTS. THANKS 42A) A company...

HELLO, PLEASE ANSWER THE FOLLOWING QUESTION. IT WAS ASSIGNED WITH 2 PARTS. THANKS 42A) A company uses the periodic inventory system and had the following activity during the current monthly period. November 1: Beginning inventory 112 Units @ $20 November 5: Purchased 112 Units @ $22 November 8: Purchased 62 Units @ $23 November 16: Sold 174 Units @ $105 November 19: Purchased 75 Units @ $25 Using the weighted-average inventory method, the company's ending inventory would be 42B. A...

Please make sure to complete all parts of the question and to show all work used...

Please make sure to complete all parts of the question and to show all work used to compute the answer so I can see how the answer was found. A five-year annuity of 10 $5,230 semiannual payments will begin nine years from now, with the first payment coming nine and a half years from now. If the discount rate is 10 percent compounded monthly, what is the value of this annuity five years from now? What is the value three...

Java Problem: Please answer both parts of the question fully: (a). Write Java code for a...

Java Problem: Please answer both parts of the question fully: (a). Write Java code for a method to test if a LinkedList<Long> has Long values that form a Fibonacci sequence from the beginning to the end and return true if it is and false otherwise. A sequence of values is Fibonnaci if every third value is equal to sum of the previous two. Eg., 3,4,7,11,18,29 is a Fibonacci sequence whereas 1,2,3,4 is not, because 2+3 is not equal to 4....

Question