Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started