MBA 646
Professor Carter
Assignment 3 solutions
Ch. 3: 40, Problems 3-7
1
1. Problem 3.40
(a)
(b)
In the pivot chart below, the colors don’t show up when printed. The traffic has decreased in waves from
its peak in about 2001. California’s and Texas’ crossings have increased the most since 2011. New
Mexico has a relatively small number throughout the period, while Texas had the highest number
throughout.
Month/Yr State Crossings Month
Jan-95 Arizona 794454 Jan
Feb-95 Arizona 709410 Feb
Mar-95 Arizona 716456 Mar
Apr-95 Arizona 699579 Apr
May-95 Arizona 700291 May
Jun–95 Arizona 725734 Jun
Jul–95 Arizona 736267 Jul
Aug-95 Arizona 669943 Aug
Sep-95 Arizona 693019 Sep
Average of Crossings State
Month/Yr Arizona California New Mexico Texas Grand Total
1995 719718 1076029 29054 3571350 1349038
1996 727956 991122 40764 3723739 1370895
1997 780028 2317961 36185 3863193 1749342
1998 787757 2510642 34554 4005744 1834674
1999 853809 2645225 40662 4303328 1960756
2000 888567 2694280 41964 4465513 2022581
2001 870954 2612625 50724 4309048 1960838
2002 896122 2764899 66573 4154520 1970529
2003 853310 2823351 57058 3985075 1929698
2004 877644 2984795 51161 4078616 1998054
2005 844959 3034745 55154 4105859 2010179
2006 761156 2963841 61517 3989996 1944127
2007 716254 2682060 73237 3773107 1811165
2008 677231 2468831 61866 3791173 1749775
2009 645479 2306064 72002 3211844 1558847
2010 586336 2204635 72927 2886646 1437636
2011 589954 2157334 65603 2708524 1380354
2012 655095 2196503 62884 2753738 1417055
2013 713755 2273491 71019 2937797 1499015
2014 742653 2406863 77053 3044435 1567751
2015 780480 2623330 81018 3076721 1640387
Grand Total 759950 2411071 56706 3668371 1724025
MBA 646
Professor Carter
Assignment 3 solutions
Ch. 3: 40, Problems 3-7
500000
1000000
1500000
2000000
2500000
3000000
3500000
4000000
4500000
5000000
Arizona
California
New Mexico
Texas