case study questions

profilesherryjiang
CSFall19_Convenience_shopping.xlsx
Home>Business & Finance homework help>Accounting homework help>case study questions

Sheet 1

Sales.(Dollars) Volume.(Gallons) Washes Price.(cents) DayWeek
2273 3111 261 144.2 no
2080 2588 280 136.3 no
2074 3464 280 140.8 no
2641 3749 76 138.1 yes
1765 2811 268 137.3 no
2017 2808 420 140.7 no
2041 3477 153 152.5 no
1791 2280 259 147.4 no
2479 3493 167 137.3 yes
2509 3638 192 158.2 yes
2129 3009 201 136.4 no
2423 2330 35 140.8 no
2454 3472 296 155.4 yes
2210 3472 278 142.7 yes
2855 3948 542 137.4 yes
2407 3587 217 163.1 yes
2189 2416 135 136.7 no
3022 3382 666 137.2 yes
2677 2925 337 138.5 yes
2066 3862 113 154.3 yes
1995 2560 256 140.2 no
2093 3196 193 136.9 no
2215 2793 167 136.8 no
2460 3610 311 144.6 yes
2247 3730 206 154.9 yes
2301 2925 215 137.3 no
2442 3801 193 136.4 yes
2668 3851 249 138.1 yes
1998 3757 20 139.6 no
2499 3577 367 142.7 yes
2422 3670 348 137.6 yes
2004 3572 213 156.7 yes
2434 3003 206 138.1 no
2051 2744 171 137.6 no
1973 1882 265 143 no
2383 2615 220 137 no
1615 1912 132 137.4 no
2688 4008 335 138.7 yes
3076 3858 369 136.9 yes
2725 3449 167 138.1 yes
2579 3628 432 153.3 yes
2412 3116 339 136.3 no
2761 4008 229 158.5 yes
2619 3656 186 140 yes
2274 2441 3 148.2 no
2404 3980 286 149.2 yes
2851 3932 361 139.8 yes
1934 2728 353 136.7 no
2034 2620 145 141.8 no
2269 3189 239 140.7 no
2125 1801 281 136.4 no
2685 4007 478 138.2 yes
2487 3558 235 142.2 yes
2376 3170 87 136.9 no
2981 4234 282 145.3 yes
2238 2460 323 136.5 no
2959 4284 202 146.1 yes
2192 2205 239 141.3 no
1966 2264 116 138.9 no
2536 3653 125 137.6 yes
2405 3607 320 146.2 yes
2690 3121 248 136.5 yes
2390 3176 130 139.1 no
2378 3241 263 137.4 no
2325 2907 591 139.6 no
2773 3499 238 136.7 yes
2282 3659 123 143.9 yes
2032 1969 212 137 no
2165 3219 234 144.2 no
2899 4051 506 154.8 yes
1811 2678 388 136.6 no
3316 3958 350 155.5 yes
2665 3916 180 136.4 yes
2304 3347 95 141.1 no
2216 3390 377 154.5 yes
2258 2481 408 139.2 no
2011 2845 165 136.8 no
2599 2998 179 158.2 yes
1994 3187 235 136.5 no
2173 3876 94 146.4 yes
2411 3642 66 136.5 yes
2635 3176 176 136.5 yes
2536 2894 323 136.4 no
1889 2667 360 139.9 no
2172 3459 112 154.2 yes
1878 2176 160 136.9 no
1781 1999 119 136.9 no
2161 2754 115 138.4 no
1943 2407 119 136.3 no
2546 2481 393 137.8 no
3026 3736 220 144.2 yes
2589 4052 187 153.9 yes
2016 1960 65 158.3 no
2417 3866 132 159.6 yes
2863 4001 170 142.8 yes
2205 2545 511 137.8 no
2126 3162 110 144.5 no
2006 2380 76 136.9 no
2352 3258 277 136.8 no
1906 2101 179 147.8 no
2047 3174 439 151.8 no
2915 3920 239 139.2 yes
2076 3343 128 150.1 no
2384 4129 511 138.1 yes
2247 1992 205 136.5 no
2222 3398 155 137.3 no
2281 3409 322 139.7 yes
2829 3485 380 143.6 yes
2097 3602 369 137.9 no
2231 3316 127 143.8 no
2001 2317 326 137.6 no
2447 3575 185 151.7 yes
1986 3144 187 138.6 no
1976 3415 134 150.7 no
2271 4189 276 138.1 yes
2750 3487 221 155.9 yes
2136 3107 237 138.5 no
2745 3797 116 137.5 yes
1908 3127 178 162.4 no
2005 3016 147 136.7 no
2457 3656 259 146.7 yes
2330 2727 339 136.6 no
3673 4241 147 139.5 yes
3235 4085 467 142.5 yes
2826 3278 347 137.7 yes
3109 3481 226 142 yes
2892 2804 184 136.9 yes
2221 3174 170 137.6 no
2073 2329 250 137.8 no
2384 3588 219 145.6 yes
2621 3861 497 142.7 yes
2080 3981 196 136.8 yes
2426 3561 289 141.4 yes
2406 3625 216 136.8 yes
2576 3550 309 137 yes
2496 3633 136 146 yes
1987 2603 263 157.1 no
2816 4141 228 158.3 yes
1950 2525 90 136.4 no
2813 3761 139 143.9 yes
2522 3675 381 150.2 yes
2617 3967 600 142.7 yes
2814 3515 222 145 yes
2227 3415 206 140.3 no
1878 2154 139 138.1 no
2902 3372 116 144.7 yes
2844 3922 154 151.3 yes
2472 2911 667 138.6 yes
2144 3823 191 140.4 yes
1658 2422 203 145.7 no
1981 3058 139 138.2 no
1688 2517 372 140.8 no
1872 2170 299 136.3 no
2413 3560 90 142.9 yes
2783 3897 449 157 yes
1871 2232 184 139.4 no
2038 3379 249 150.4 no
1969 1769 639 136.7 no
2092 3670 122 136.3 no
2287 3194 204 136.4 no
2468 2910 173 136.8 no
2417 3904 102 156.2 yes
2396 2462 267 144.6 no
2377 3507 370 137.1 yes
2016 3148 141 142.6 no
2987 2548 436 136.7 yes
2528 3215 335 138 yes
2409 3367 169 146.1 yes
2188 3394 274 148.7 yes
2966 3835 125 138.5 yes
2210 3808 128 143 yes
2133 3318 144 139.5 no
2316 2089 276 136.5 no
2446 3885 206 148.3 yes
2578 3860 320 146.8 yes
2432 3634 127 142.2 yes
2627 2887 135 139.9 no
2358 3480 186 146.4 yes
2193 3229 335 136.2 no
2765 2909 218 137.1 yes
2560 3797 129 143.6 yes
2343 3027 387 136.4 no
2209 3749 144 137.2 yes
2522 4013 89 139.7 yes
2208 3176 397 136.3 no
2711 4208 273 142.8 yes
2311 3361 232 139.4 no
2961 3851 241 149.1 yes
2560 3178 228 140.7 yes
2874 4035 541 140.1 yes
2599 4242 394 147.1 yes
2722 4035 178 142.3 yes
1938 3684 90 136.9 no
2214 2699 229 164.9 no
2718 3891 187 154.6 yes
2486 3477 372 141.2 yes
2292 3197 233 136.6 no
3205 4264 349 139 yes
2758 3434 79 139.3 yes
2396 3564 409 136.7 yes
2272 3619 247 147.4 yes
2724 3272 245 137.3 yes
2003 3144 198 137.5 no
2533 2535 514 136.7 no
2499 3365 85 138 yes
2890 3974 298 144.7 yes
2516 2687 154 147.8 no
2208 2949 165 137.5 no
2645 3558 9 138.3 yes
1717 2398 52 139 no
2125 2581 142 140.4 no
2385 3351 156 146.1 yes
2221 2203 233 136.6 no
2078 2758 224 136.6 no
2275 3533 376 156 yes
2533 3142 210 140 yes
2480 3883 329 144.2 yes
2485 3475 318 142.2 yes
2416 3591 322 137.7 yes
2794 3632 231 163.6 yes
2360 3990 218 159.7 yes
1940 2585 111 142.8 no
2326 3653 113 137.8 yes
2275 2330 201 159.1 no
2219 3633 139 143.6 yes
1917 3201 114 142.3 no
2728 3389 272 139.5 yes
2504 3589 222 140.9 yes
2235 3125 346 141.6 no
2392 3207 291 144.3 yes
2149 2463 299 140.6 no
3427 4062 211 137.1 yes
2645 2426 270 136.7 no
1843 2032 251 136.5 no
2620 3781 175 142.6 yes
2674 3844 150 143.1 yes
2665 3671 488 145.4 yes
2312 3353 458 136.6 yes
2145 3135 164 150.2 no
2477 3916 125 162.6 yes
2585 2785 340 137.1 no
2388 3738 318 145.3 yes
2837 3826 101 142.9 yes
1880 3671 2 150.1 no
2417 3618 125 137.1 yes
2215 2345 240 137.2 no
1923 2216 230 143.2 no
2648 3800 330 139.8 yes
2392 3749 317 138.2 yes
2785 3419 217 139.9 yes
2210 3281 345 138.4 no
2134 3543 221 138.1 no
2256 3367 171 149.7 yes
2231 3317 260 142.5 no
2973 3877 163 137.9 yes
2366 4141 358 163.4 yes
2138 3105 207 153.2 no
2113 2416 146 141.2 no
2116 3787 164 151.2 yes
2577 3431 245 150.6 yes
2754 3730 146 138.9 yes
2592 3594 288 142.9 yes
2096 3629 237 137.2 no
2239 2925 137 136.4 no
3087 4260 408 137.4 yes
2200 3667 229 137.9 yes
2455 3233 197 148.9 yes
2232 2651 145 138 no
2618 3311 215 144.4 yes
1929 3313 206 142.4 no
2356 3151 73 141 no
2443 3349 251 136.7 yes
2267 3127 368 163.8 yes
2334 3179 276 137.9 no