Crusty Dough Pizza Company Possible values for each variable Store store ID Store Size s = small M = medium L = Large VL = Very Large Store 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Store Size S S VL M L VL L VL VL L L M VL M VL VL L M VL M M M L S VL L VL L VL VL VL M L VL M L S M M L VL VL VL S VL S S VL VL M VL M VL M VL VL VL VL VL L Liquor Student Seating License Population Y = yes Y = yes Number N = No N = No Seating N N Y N Y Y Y Y Y Y Y N Y N Y Y Y N Y N N N Y N Y Y Y Y Y Y Y N Y Y N Y N N N Y Y Y Y N Y N N Y Y N Y N Y N Y Y Y Y Y Y Liquor License No Yes Yes No Yes No No Yes No No No Yes No No No No Yes No No Yes No No No No No No Yes No No No Yes Yes Yes Yes Yes No No No Yes Yes No No No No Yes Yes Yes No Yes Yes No No Yes Yes Yes No No No Yes Yes Student Population 4480 3438 20568 9896 14943 16821 12128 15127 19991 13582 13612 6179 17222 6731 21844 22006 10151 9526 20685 7045 7979 9570 12937 3695 19306 13572 15153 11343 18793 20862 16294 9193 11307 16666 6593 13640 3698 6446 8792 13470 16785 17227 20233 4955 21005 3590 3547 19437 20848 9616 21769 8493 19518 6301 17102 20663 18434 16325 18116 14787 Competitors within 2 Miles Number Competitors Competitors within 5 within 15 Monthly Miles Miles Profit Number Number Dollars Competitors within 2 Miles 2 0 5 2 3 5 4 4 3 4 4 0 5 3 4 5 2 4 4 2 3 2 2 0 5 3 3 3 5 3 3 3 3 5 0 2 2 1 3 3 4 3 4 2 5 1 0 4 3 3 5 3 5 3 4 4 3 5 5 3 Competitors Competitors within 5 within 15 Miles Miles 4 11 0 5 9 22 6 10 4 14 5 16 8 19 8 20 4 12 8 13 6 15 4 4 6 12 4 12 8 13 9 14 6 12 7 11 8 17 2 10 4 10 3 5 3 11 4 12 5 15 5 15 7 14 4 15 9 20 7 11 6 9 4 8 5 11 7 18 3 9 2 6 6 13 3 11 4 9 4 15 5 13 6 10 8 18 6 11 6 15 1 8 3 9 5 15 7 18 3 11 7 17 5 15 5 18 4 9 6 10 7 12 3 6 6 18 9 17 6 11 Population Pizza within 20 Do they Varieties miles Delivery Order Options Number Number Y = yes T = Twitter N= No W = Website F=Fax T&W = Twitter and Website All = all three Population Monthly Pizza within 20 Do they Profit Varieties miles Delivery $869 28 516493 Yes $16,591 50 483096 Yes $21,206 19 460144 Yes $12,914 41 500471 Yes $22,235 42 276287 Yes $9,668 25 494311 No $3,151 26 201281 Yes $12,008 16 120795 Yes $30,455 19 457563 Yes $11,329 21 297939 Yes $1,320 37 449499 No $23,827 43 258270 Yes $15,454 45 216550 Yes -$1,064 28 199898 Yes $25,920 49 467547 No $11,723 44 319471 Yes $21,341 21 186915 Yes -$6,003 36 524060 Yes $19,148 40 162670 Yes $6,365 25 291312 No -$2,121 41 479711 No $7,258 49 314322 No $16,523 43 182619 Yes $13,702 38 376275 Yes $6,176 33 336583 Yes $18,260 16 311405 Yes $15,129 27 530117 No $8,662 49 278669 Yes $15,855 18 158631 Yes $32,163 16 271143 Yes $24,109 36 200571 Yes $7,829 23 436653 Yes $14,677 46 339433 Yes $17,587 40 190028 Yes $23,380 32 358930 Yes $23,837 48 88612 Yes $2,054 48 177548 Yes $13,825 36 338690 Yes $5,076 28 121215 Yes $16,598 43 427071 Yes $12,032 25 450159 Yes $25,522 42 537361 Yes $16,215 39 538145 Yes $3,228 15 234339 Yes $16,218 26 349972 No $6,004 50 342913 No $14,023 22 226785 No $20,078 33 321771 No $26,370 24 456127 No $12,631 16 275191 Yes $22,270 30 461562 Yes $3,630 28 269046 Yes $13,141 39 428198 Yes $3,099 15 428887 Yes $18,002 36 425600 No $21,376 24 480018 Yes $21,850 34 213670 Yes $1,646 23 452660 Yes $12,677 36 459743 Yes $19,486 24 427128 No Order Options T&W T&W All W W All W F T&W T&W F W T T&W T T&W T&W F T&W T&W F F F All W T&W T&W T&W F T T&W F All All W W W All All T T T T&W T W T&W T&W F T T&W F All T T F T W T F W Review in Monthly Offer Pizza local Advertising by the Parking newspaper expenditure Slice Spots Positive Dollars Y = Yes Number Negative N = No Review in local newspaper Positive Positive Positive Positive Positive Positive Positive Positive Negative Negative Positive Positive Positive Positive Positive Negative Negative Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Positive Positive Positive Negative Positive Negative Positive Positive Positive Negative Positive Negative Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Negative Positive Positive Positive Positive Negative Positive Positive Monthly Offer Pizza Advertising by the Parking expenditure Slice Spots 1311 Yes 38 2272 Yes 42 2168 Yes 153 2173 No 55 2043 Yes 83 1233 No 184 1233 Yes 52 1882 Yes 181 2701 Yes 185 2385 Yes 80 1216 Yes 49 1754 No 51 1755 Yes 53 1245 No 33 3405 No 129 2078 Yes 105 2032 Yes 79 1033 Yes 17 1714 Yes 151 971 No 35 1216 Yes 56 928 Yes 48 2138 Yes 78 2391 Yes 39 1312 No 52 1846 Yes 52 1684 No 147 947 Yes 90 2139 Yes 76 3448 Yes 112 1994 Yes 130 1052 No 21 2077 Yes 89 1837 No 118 2273 Yes 23 2398 Yes 41 1262 Yes 28 2311 Yes 49 937 No 59 2345 Yes 67 2263 Yes 125 2150 Yes 62 1964 Yes 148 1006 Yes 21 2009 Yes 169 1263 Yes 19 1740 No 19 2172 Yes 197 2130 No 54 2343 No 13 2037 No 77 818 Yes 14 2400 Yes 116 979 Yes 13 1731 No 196 1792 Yes 66 1813 No 65 1063 Yes 104 1737 Yes 51 1945 Yes 78 Buffet on Weekends Yes No Buffet on Weekends No No Yes No Yes Yes Yes No No No No No Yes No No No Yes No Yes No No No Yes No No Yes Yes Yes Yes No No No Yes Yes No Yes No No No No No No Yes No Yes No No Yes Yes No No No No No No No Yes Yes No No Bins S M L VL 7 14 12 27 60 Crusty Dough Pizza Company Possible values for each variable Store store ID Store A B C D E F G H I J K L M N O P Q R S T Store Size s = small M = medium L = Large VL = Very Large Store Size VL VL S VL M L VL VL L S M VL S M L VL VL M L VL Liquor Student Seating License Population Y = yes Y = yes Number N = No N = No Seating Y Y N Y N Y Y Y Y N N Y N N Y Y Y N Y Y Liquor License No No Yes Yes No Yes Yes No No Yes No No No No Yes Yes Yes Yes Yes No Student Population 19963 21522 3659 19192 7852 12746 21432 19440 13410 4164 7629 16334 3427 9391 12761 17600 20678 6986 14866 21303 Competitors within 2 Miles Number Competitors Competitors within 5 within 15 Monthly Miles Miles Profit Number Number Dollars Competitors within 2 Miles 4 4 3 5 3 3 3 5 2 3 2 4 2 2 3 5 5 3 3 4 Competitors Competitors within 5 within 15 Miles Miles 5 17 5 9 7 10 8 16 5 13 7 17 7 11 8 14 4 8 3 14 5 7 6 11 2 4 2 8 3 7 8 21 6 12 3 6 3 11 7 19 Monthly Profit ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Population Pizza within 20 Do they Varieties miles Delivery Order Options Number Number Y = yes T = Twitter N= No W = Website F=Fax T&W = Twitter and Website All = all three Pizza Varieties 21 42 45 28 30 25 34 30 23 31 26 15 43 16 35 43 29 18 50 36 Population within 20 Do they miles Delivery 472379 No 534016 Yes 385494 Yes 383308 Yes 306180 No 98713 Yes 121146 Yes 141764 Yes 204447 Yes 442330 Yes 86223 Yes 372905 Yes 335489 No 262498 Yes 195002 Yes 466450 Yes 218576 No 337140 Yes 166007 Yes 530611 Yes Order Options T T T&W All T&W F T W T All All T T&W T All F T All All T&W Review in Monthly Offer Pizza local Advertising by the Parking newspaper expenditure Slice Spots Positive Dollars Y = Yes Number Negative N = No Review in local newspaper Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Positive Negative Positive Positive Negative Negative Positive Negative Monthly Offer Pizza Advertising by the Parking expenditure Slice Spots $2,151.00 Yes 98 $2,917.00 Yes 195 $823.00 Yes 46 $2,371.00 No 71 $1,234.00 Yes 49 $2,061.00 Yes 75 $1,893.00 Yes 189 $2,238.00 Yes 94 $2,220.00 No 71 $1,136.00 No 50 $2,070.00 Yes 10 $1,306.00 Yes 109 $968.00 Yes 38 $2,094.00 Yes 14 $2,017.00 Yes 87 $1,788.00 No 174 $1,971.00 Yes 172 $980.00 No 11 $2,021.00 Yes 82 $1,719.00 Yes 74 Buffet on Weekends Yes No Buffet on Weekends Yes No No No No No Yes Yes No No No No No No Yes No No No No No Crusty Dough Pizza Company Monthly Sales Data for ten stores Store A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 Jan $22,910.28 $1,604.99 $23,317.20 $12,339.01 $12,771.04 $19,694.54 $19,258.64 $18,483.54 $23,471.33 $15,572.27 Feb $20,827.53 $1,547.67 $16,142.68 $13,585.38 $12,771.04 $16,145.98 $18,391.14 $21,344.08 $21,430.35 $18,041.04 Mar $27,336.13 $1,929.81 $15,943.38 $14,457.83 $11,223.03 $17,565.40 $14,227.11 $19,143.66 $28,063.55 $22,788.68 Apr $22,389.59 $1,853.38 $20,128.52 $13,585.38 $15,093.05 $15,791.12 $20,299.65 $20,243.87 $22,195.72 $22,029.06 May $29,418.88 $2,139.98 $18,135.60 $13,086.83 $10,707.03 $19,517.11 $17,003.13 $24,864.76 $29,339.17 $19,750.19 Jun $29,418.88 $2,159.09 $19,530.65 $12,588.29 $11,997.04 $20,226.83 $15,268.11 $23,984.59 $30,614.78 $22,788.68 Jul $26,815.44 $2,216.41 $17,537.72 $10,469.47 $15,351.05 $18,629.97 $15,268.11 $23,324.46 $23,981.58 $17,851.14 Aug $25,774.07 $1,968.02 $21,922.15 $9,970.92 $12,900.04 $14,549.12 $15,441.62 $20,023.83 $24,236.70 $19,750.19 Sep $21,868.90 $1,585.88 $17,737.01 $11,092.65 $10,320.03 $21,291.40 $13,880.10 $19,363.70 $30,104.54 $18,800.66 Oct $24,732.69 $1,776.95 $23,117.91 $13,336.11 $11,610.04 $16,855.69 $15,441.62 $25,304.84 $30,614.78 $22,218.97 Nov $30,980.95 $2,235.52 $20,726.40 $14,083.92 $14,190.04 $16,855.69 $18,391.14 $23,984.59 $27,298.18 $17,471.32 Dec ? ? ? ? ? ? ? ? ?