Question

In: Advanced Math

Import the text into Excel. The column delimiter is the minus sign, ‘-‘. Make a table...

Import the text into Excel. The column delimiter is the minus sign, ‘-‘. Make a table of the total population of each city in each state in excel and post all steps used.

State Code-County Code-City Code-Population
2-117-13-49174
4-134-21-72247
3-137-27-91811
8-140-13-13913
4-133-16-11028
1-119-12-37710
10-101-31-76485
8-138-16-82956
6-125-26-67320
2-108-19-27973
6-119-22-25359
8-122-17-16881
4-140-18-63178
2-111-13-53192
2-112-30-31156
1-127-19-37547
9-135-23-48125
3-108-19-61645
6-113-26-16166
5-112-31-17847
7-135-23-48441
5-124-15-20688
6-106-15-95046
3-105-16-35144
6-120-29-97858
9-117-26-19441
6-120-18-71854
2-114-24-80466
3-138-15-73195
3-104-28-62538
1-133-24-74205
2-126-11-56200
3-129-15-41400
8-121-21-13075
10-138-19-57237
8-112-21-99683
2-114-13-70453
4-113-28-33874
9-112-23-23172
6-105-18-74177
7-140-21-11851
1-115-28-28103
5-134-20-48211
6-114-20-51120
3-111-24-55273
7-119-28-19041
8-122-29-19288
3-134-11-94750
9-119-26-62117
6-138-21-66254
4-117-29-21650
2-135-28-31025
5-135-24-30519
10-118-27-22788
9-102-19-92033
1-138-22-49667
2-101-24-81847
3-122-20-13381
3-124-18-34141
6-140-17-52557
6-131-28-23671
2-126-12-15206
7-124-23-28605
10-101-23-85366
10-106-19-57824
4-132-21-53104
3-119-29-51525
4-107-30-53327
5-108-17-97390
5-128-26-24022
3-117-19-37134
7-135-17-64097
3-140-31-93398
10-129-19-30970
2-112-12-85156
6-136-29-52765
5-121-21-73339
4-113-27-54497
8-113-22-94934
8-138-12-51563

Solutions

Expert Solution

first of all copy and paste the data in your excell row wise like  

2-117-13-49174

4-134-21-72247

...

...

8-138-12-51563

then use delimiter of "-" as to seperate them as the columns

Split the content from one cell into two or more cells

  1. Select the cell or cells whose contents you want to split. ...
  2. On the Data tab, in the Data Tools group, click Text to Columns. ...
  3. Choose Delimited if it is not already selected, and then click Next.

then click on next

here i have took first country code then i have kept state code

by just copy paste after the seperating them into columns

now after that sorting them in ascending order

select the column you want to sort then

To sort a range:

  1. Select the cell range you want to sort. ...
  2. Select the Data tab on the Ribbon, then click the Sort command.
  3. The Sort dialog box will appear. ...
  4. Decide the sorting order (either ascending or descending). ...
  5. Once you're satisfied with your selection, click OK.
  6. The cell range will be sorted by the selected column.   

finally it looks like this

please give good rating


Related Solutions

In Excel, create a 2x30 data table with the left column representing a population of prey...
In Excel, create a 2x30 data table with the left column representing a population of prey and the right column representing a population of predators. Use the population model presented below. Let the starting values of the model parameters be: r = 1.3, k = 1, s = .5, v = 1.6, and u = .7 Let the starting population of P = 1.1 and Q = .4 Difference equations: P[t + 1] = P[t](1 + r(1 – P[t]/K)) -...
Assume that a minus sign in the input indicates pop the stack and write the return...
Assume that a minus sign in the input indicates pop the stack and write the return value to standard output, and any other string indicates push the string onto the stack. Further, suppose that the following input is processed: it was - the best - of times - - it was - the - - 1/ What is written to the standard output? 2/What are the contents (top to bottom) left on the stack?
make a table with three column, and write the similarities and differences for the three forces,...
make a table with three column, and write the similarities and differences for the three forces, 1. Gravitational Force 2. Colomb Force 3. Magnetic Force Make pictures to explain the differences.
Complete a horizontal analysis for Brown Company. (Negative answers should be indicated by a minus sign....
Complete a horizontal analysis for Brown Company. (Negative answers should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round the "percent" answers to the nearest hundredth percent.) BROWN COMPANY Comparative Balance Sheet December 31, 2014 and 2015 INCREASE (DECREASE)     2015     2014     Amount      Percent Assets   Current assets:      Cash $ 15,750 $ 10,500 $              Accounts receivable 18,000 13,500              Merchandise inventory 18,750 22,500              Prepaid advertising 54,000 45,000...
4) Make the following binomial table, where column x =0,1,2,3,4,5. And p(x) is the probability of...
4) Make the following binomial table, where column x =0,1,2,3,4,5. And p(x) is the probability of each event X P(X) x*p(x) Ex2 * p(x) 0 .395 0 0 1 .093 .093 .093 2 .023 .046 .092 3 .023 .069 .207 4 .070 .28 1.12 5 .140 .7 3.5 6 .070 .42 2.52 7 .093 .651 4.557 8 .093 .744 5.952 Total .999 3.003 18.041 5) Complete a probability histogram of the date above using the x and p(x) column. 6)...
make it clear using table or excel Consider the following information that relates to five different...
make it clear using table or excel Consider the following information that relates to five different items of plant and equipment at the reporting date: Asset Carrying amount $ Fair value $ Costs of disposal $ Value in use $ A 100 000 105 000 3 000 110 000 B   50 000   45 000 1 000   48 000 C   80 000   85 000 2 000   82 000 D 200 000 190 000 5 000 220 000 E 120 000 120...
Excel sorting In excel how do you sort a column of months in ascending order and...
Excel sorting In excel how do you sort a column of months in ascending order and not alphabetical when the month is in word format?
Create a 15 row and 4 column table with each column of the data so that...
Create a 15 row and 4 column table with each column of the data so that it goes 1A 1B 1C 1D across using this code as a base void PrintSeatingChart(seat seats[15][4], int numRows, int numColumns) {    int i;    int j;    for (i = 0; i < numRows; i++) {        cout << i + 1 << " ";        for (j = 0; j < numColumns; j++) {            cout << seats[i][j].seatLetter...
Consider the following contingency table that is based on a sample survey. Column 1 Column 2...
Consider the following contingency table that is based on a sample survey. Column 1 Column 2 Column 3 Row 1 136 90 83 Row 2 96 54 88 Row 3 125 75 110 a. Write the null and alternative hypotheses for a test of independence for this table. H 0 : Rows and columns are ; H 1 : Row and columns are . b. Calculate the expected frequencies for all cells assuming that the null hypothesis is true. Round...
Consider the following contingency table that is based on a sample survey. column 1 column 2...
Consider the following contingency table that is based on a sample survey. column 1 column 2 column 3 row 1 137 86 77 row 2 93 51 86 row 3 126 76 112 a. Write the null and alternative hypotheses for a test of independence for this table. H0: Rows and columns are: Independent or dependent H1: Rows and columns are: Independent or dependent b. Calculate the expected frequencies for all cells assuming that the null hypothesis is true. Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT