Answers
1.
The pop-up box that appears when you select custom sort
After you sort on the basis of United States Region,this is the way the data appears:-
2. 
3. Select the table we created in 2nd part --> Go to insert tab --> Select pie chart option from Charts
Sort CEO Total Industry Company City Of Bir State Of B United Ste Age of CEO 2 490001 Financial Rochester Passaic NJ 3 498500 Financial Trustmark Aberdeen MS 4 500000 Financial GP 5 523040 Financial First 6 523560 Financial SFFed Neosho MO 7 535817 Financial Michigan Brooklyn NY 8 536930 Financial United Columbus NC 9 548341 Financial Synovus Augusta GA 10 574745 Financial Cullen/Fro San Antor TX 11 575211 Financial CSF 12 608262 Financial Magna Belleville IL 13 611963 Financial First 14 615841 Financial BBT 15 617054 Financial California NY 16 627048 Financial Premier LeavenwCKS 17| 650443 Financial First 18 652115 Financial St 19 663111 Financial Franklin Montclair NJ 20 668831 Financial First 21 674514 Financial Anchor Philadelpl PA 22 687147 Financial US 57 Add Level XDelete Levelopy LevelO Options..MMy data has headers Column Sort On Order Racine WI 53 Smithfiel NC Sort by United States Regior Cell Values A to Z 52 57 Miami FL 52 Cancel NY Charlotte NC 45 57 Island NY 59 53 61 49 Detroit MI Clarksville IN Grandviev WA
1 1 CEO Total Industry Company City Of Bi State Of B United Sta Age of CE 2 490001 Financial Rochester Passaic NJ 3 535817 Financial Michigan Brooklyn NY 4 611963 Financial First NY 5617054 Financial CaliforniaNY 6 650443 Financial First Island NY 7 663111 Financial Franklin MontclaiiNJ 8 674514 Financial Anchor Philadelp PA 9 691994 Financial Summit Watertow NY 10 770034 Financial Dauphin Philadelp PA 11 780932 Financial Charter BaltimorE MD E 12 793214 Financial Hibernia Branch NJ 13 798255 Financial FirstFed Philadelp PA 14 875180 Financial Bank Washingt DC 15 987400 Financial Mercantil Baltimore MD E 16 1075140 Financial Dime Brooklyn NY 17 1173000 Financial MBIA Canaan CT 18 500000 Financial GP 19 608262 Financial Magna Belleville IL 20 627048 Financial Premier Leavenwa KS 21 652115 Financial St 22 668831 Financial First Clarksvill IN 23 697279 Financial MGIC Chicago IL 24 741192 Financial Fourth CentervilLSD 25 869452 Financial TC 26 884470 Financial Standard Detroit M 27 935235 Finanrial Comercia DetroitM 57 54 NY NY 57 59 61 62 53 65 48 46 61 52 62 46 52 53 64 E Racine WI Detroit MI 53 49 49 56 50 63 Detroit MI
28 951545 Financial AmSouth Evanston IL 29 960565 Financial Integra Youngsto OH N 30 962075 Financial MidlanticFairmont MN N 31 979092 Financial Marshall Milw auk WIN 32 1020460 Financial Provident DaytonOH N 33 1030600 Financial GATX Chicago IL 34 1086720 Financial National Davenpor IA 35 498500 Financial Trustmarl Aberdeen MS 36 523040 Financial First Smithfiel NC S 37 523560 Financial SFFed Neosho MO S 38 536930 Financial United Columbus NC S 39 548341 Financial Synovus Augusta GAS 40 574745 Financial Cullen/Fr San Antor TXs 41 575211 Financial CSF Miami FL S 42 615841 Financial BBT Charlotte NC S 43 716365 Financial United Kansas Ci M0 S 44 780250 Financial Ambac City MOS 45 800265 Financial FirstFed Gainesvil FL S 461842121 Financial Compass Birminghỉ AL S 47 921921 Financial Wachovia Lovettsvil VA S 48 953206 Financial Southern Charlotte NC S 49 1047910 Financial SouthTrus Dothan AL S 50 1121950 Financial Cenral Lincolnto NC S 51 687147 Financial US 52 728010 Financial CoastNogales AZ 53 768648 Financial First Ogen UT 54 912994 Finanrial Star 62 54 57 52 59 62 56 52 57 52 52 45 67 50 48 51 52 54 57 59 Grandvie WA 58 9 59 Los Anpel CA NW
K2 fr COUNTIF(F2F54,"E") 1 CEO Total Industry Company City Of Bi State Of B United StaAge of CEO 2 490001 Financial Rochester Passaic NJ 3 535817 Financial Michigan Brooklyn NY 4 611963 Financial First 5 617054 Financial California NY 6 650443 Financial First 7 663111 Financial Franklin Montclail NJ 8 674514 Financial Anchor Philadelp PA 9 691994 Financial Summit Watertow NY 10 770034 Financial Dauphin Philadelp PA 11 78093? Financial Charter Raltimore MD Region East West North #CEO's 16 57 54 60 57 59 17 16 53 Island NY Total 62 65
No. Of CEO in US Regions 30% 80% 896 32% EastWest North South
.
Similar Solved Questions
1 answer
1. What is the magnetic field at y = -3.6cm. ______mT k? 6. What is the...
1. What is the magnetic field at y = -3.6cm. ______mT k? 6. What is the magnetic field at y = 0. ______mT k? 9. What is the magnetic field at y =+3.8. ______mT k? 12. What is the magnetic field at y = +9.5 cm. _____mT k? The current in the wire at y =-6.0 cm is in the-X direction and the current in...
1 answer
Find the vertical, horizontal, oblique asymptotes, if any, for the given rational function
find the vertical, horizontal, oblique asymptotes, if any, for the given rational function. R(x)=10x^2+19x-15 -------------- 2x+5 please show how you arrived with the answer! thank you...
1 answer
A function f : A - B is said to be injective (or one-to-one) provided Va,...
A function f : A - B is said to be injective (or one-to-one) provided Va, a2 € A, f(a) = f(az) ► a1 = . A function g: A + B is said to be surjective (or onto) provided W6 € B, 3 some a € A such that g(a) = b. A function h: A → B is said to be bijective (or a bijection or a ...
1 answer
Your firm currently has 1,543,589 shares of stock outstanding that sell for 18.35. Additionally, you've issued...
Your firm currently has 1,543,589 shares of stock outstanding that sell for 18.35. Additionally, you've issued 23,052 bonds, with a par value of S1,000. They currently sell for 94.1% of par. What is the firm's equity weight? (Enter your answer as a percentage to 1 decimal place. ex: 12.3)...
1 answer
2.4 kN/m Problem No. 1 (25%): 2 kN/m y = kx 3.0 KN 300 For the...
2.4 kN/m Problem No. 1 (25%): 2 kN/m y = kx 3.0 KN 300 For the beam and loading shown, determine (a) the magnitude and location of the resultant of the distributed load (b) the reactions at the beam supports (Fig. 1). B A 0.6 m 1.2 m - 0.8 m 2.4 m —- - 10 ml Fig. 1...
1 answer
Say Questions: Differentiate the role of AGPCNP from the role of physician in a way that...
say Questions: Differentiate the role of AGPCNP from the role of physician in a way that defends the NP role as both distinct and valuable, using at least one argument based on scholarly research and at least one argument based on nursing theory. Make an argument aimed at legislators (so think about...
1 answer
Please solve the following (simple steps): Q1) i ii iii and Q2) i ii For the circuit shown: XSC1 XFG1 P 1 2 3 4 2 100mH 20% 10k Key A 100nF 0 1) Find equations (step response) for both vc and i f...
please solve the following (simple steps): Q1) i ii iii and Q2) i ii For the circuit shown: XSC1 XFG1 P 1 2 3 4 2 100mH 20% 10k Key A 100nF 0 1) Find equations (step response) for both vc and i for the following cases: i. ii, iii. R= 12%, R 20%, and R:-29%. 2) Using a square wave with a frequency ...
1 answer
Problem 9-18 Comprehensive Variance Analysis Miller Toy Company manufactures a plastic swimming pool at its Westwood...
Problem 9-18 Comprehensive Variance Analysis Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Flexible Budget Actual Sales (4,000 pools) ...
1 answer
In the figure above, if the government provides level Q2 of the public good: Group of...
In the figure above, if the government provides level Q2 of the public good: Group of answer choices a. it leads to a welfare gain because it creates jobs in the public sector. b. it is the optimal level. c. it is less than the optimal level Q3. d. it leads to a welfare loss because the MC is less t...
1 answer
(-70.1 Points) DETAILS TANAPMATHS 4.3.020. MY NOTES PRACTICE ANOTHER What monthly payment is required to amortize...
(-70.1 Points) DETAILS TANAPMATHS 4.3.020. MY NOTES PRACTICE ANOTHER What monthly payment is required to amortize a loan of $50,000 over 14 yr if interest at the rate of 13%/year is charged on the unpaid balance and interest calculations are made at the end of each month? (Round your answer to the n...
1 answer
Do Understaffed hospitals have an impact on patient care outcomes?
Do Understaffed hospitals have an impact on patient care outcomes?...
1 answer
Find the magnitude and orientation of the principle moment of inertia of the given shape, 60...
find the magnitude and orientation of the principle moment of inertia of the given shape, 60 mm 40 mm 40 mm...
1 answer
Telomeres are long stretches of non-coding DNA at the ends of linear (eukaryotic chromosomes. A beneficial...
Telomeres are long stretches of non-coding DNA at the ends of linear (eukaryotic chromosomes. A beneficial effect of having telomeres is that they -7 speed up the rate of cell proliferation. B)prevent shortening of the leading strand of the DNA during replication prevent shortening of the lagging st...