Using Excel, prepare the statistical analysis described under Requirement 1a-e in the case. what is the best model and why you chose it)

Store Locaton	Purchasing Dept. Cost ($)	Merchandise Purchased ($)	# of Purchase Orders	# of Suppliers
Sheridan, WY	575,000	47,239,000	1708	61
Denver	1,226,000	102,364,000	2519	95
Salt Lake City	1,710,000	100,162,000	206	139
Kansas City	881,000	95,760,000	1719	91
Omaha	1,544,000	51,466,000	2883	155
Milwaukee	794,000	50,631,000	647	75
Minneapolis	1,341,000	84,753,000	2978	103
Phoenix	794,000	103,464,000	3761	117
Las Vegas	2,216,000	96,162,000	2584	73
Albuquerque	2,030,000	62,364,000	5497	176
Tucson	1,338,000	65,635,000	4347	130
Houston	856,000	88,524,000	2878	62
Oklahoma City	1,122,000	72,645,000	819	129
Tulsa	863,000	61,638,000	1247	145
Dallas	1,085,000	105,666,000	2162	141
San Antonio	952,000	59,437,000	2822	105
Austin	1,134,000	38,542,000	5115	51
El Paso	1,042,000	33,020,000	382	131
Nashville	1,634,000	36,322,000	5293	172
Memphis	699,000	34,121,000	967	34
Indianapolis	875,000	31,920,000	2425	48