Question

Intercity distances data represents the distances between some of the major cities in the U.S. Your task is to use the matrix of intercity od distance between the cities in the green cells. Please write your formulas in the yellow cells Model SEAOAK CAL TEX KC MIN CHI MIL DET CLE TOR BAL NY BOS 0 678 954 1670 1489 1399 1720 1694 1932 2023 2124 2334 2421 2469 678 0 337 1467 1498 1589 1846 1845 2079 2161 2286 2457 2586 2704 954 337 0 1246 1363 1536 1745 1756 1979 2053 2175 2329 2475 2611 TEX 1670 1467 1246 0 460 853 798 843 982 1015 1186 1209 1383 1555 KC 1489 1498 1363 460 0 394 403 483 630 694 822 961 1113 1254 MIN 1399 1589 1536 853 394 0 334 297 528 622 780936 1028 1124 CHI 1720 1846 1745 798 403 334 0 74 235 307 430 621 740 867 0 237 328 434 641 746 860 DET 1932 2079 1979 982 630 528 235 237 0 95 206 409 509 632 CLE 2023 2161 2053 1015 694 622 307 328 95 0 193 314 425 563 TOR 2124 2286 2175 1186 822 780 430 434 206 193 0 384 366 463 BAL 2334 2457 2329 1209 961 936 621 641 409 314 384 0 184 370 NY 2421 2586 2475 1383 1113 1028 740 746 509 425 366 184 0 187 BOS 2469 2704 2611 1555 1254 1124 867 860 632 563 463 370 1870 From To OAK CAL TEX KC ances Distance MIL 1694 1845 1756 843 483 297 74 CLE TOR TOR BAL BAL NY 0

Show work on excel

Answer 1

STEPS

1) Enter all value in excel.

2) Now for the distance between see the table and accordingly enter formulas.

3) Formulas in respective order

FROM	TO	Distance
SEA	OAK	=B3
oak	CAL	=C4
cal	tex	=D5
tex	kc	=E6
kc	min	=F7
min	chi	=G8
chi	mil	=H9
mil	det	=I10
det	cle	=J11
cle	tor	=K12
tor	bal	=L13
bal	ny	=M14
ny	bos	=N14
bos	sea	=B15