In: Finance
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 5th 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 8th 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:
Then 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
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 |