$1$a$.$ Put Purchasing Dept Cost on the Y axis for clarity.$1$b$.$ Consider the visualizations. Do you notice any outliers and can you explain them with case data? Should you do anything about them $($i$.$e$.$ retain, adjust, or exclude$)?$  Do any potential drivers appear more promising?$1$c$.$  Run the possible regression combinations $($i$.$e$.$ all potential drivers at once and then each of the possible pairs$).$  Focus on the coefficients and consider what they are telling you. Which is best?$2$a$.$  What would you tell Joe about cost behaviors at the stores?$2$b$.$  What recommendations would make?

 

Transcribed Image Text:

Purchasing Merchandise # of Purchase # of Store Locaton Dept. Cost ($) Purchased ($) Orders 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 Albuquerque 2,216,000 96,162,000 2584 73 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 Purchasing Merchandise # of Purchase # of Store Locaton Dept. Cost ($) Purchased ($) Orders 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 Albuquerque 2,216,000 96,162,000 2584 73 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