The product manager at a subsidiary of Kraft Foods, Inc. is interested in learning how sensitive sales area to changes in the unit price of a frozen pizza in Halifax, Montreal, Toronto, and Calgary. The product manager has been provided data on both Prices and Sales volume every wzak over a period of nearly three years for the four cities. The data are in the file Assign4Data (Tab Q2. (No calculation is required). a) Using Minitab, examine the relationship between Prices and Sales for Toronto and Montreal only Be sure to discuss the nature and validity of this relationship. Is it linear? Is it negative? Is it significant? Are the conditions of regression met? Provide the following information: i. A scatterplot (volume vs price); ii. Residuals plots (histogram of residuals, normal probability plot of residuals, residuals vs fits (regular), and residuals vs order, and iii. A regression analysis report (Regression Equation, Coefficients, Model Summary, Analysis of Variance, Unusual Observations). b) Using Minitab, for Toronto and Montreal only, include 99% confidence intervals for the mean Sales if the Price is $2.75 and discuss how that interval changes if the price is $3.75. You need to provide the report with the prediction and the Fitted Line Plot graph. UN Week Halifax Volume 1 32982 2 31951 33782 37074 5 24765 3 6 27393 2 7 53354 20 8 20312 1 9 23786 12 10 27984 13 11 33796 24 12 26227 15 13 22761 16 14 20889 17 15 22334 18 16 26671 19 17 24707 20 18 28648 21 19 41379 22 20 27217 23 21 23664 24 22 17743 25 23 21909 26 24 21733 27 25 23692 28 26 28991 29 27 22117 30 28 19846 31 29 24190 32 30 25583 33 31 25689 34 32 21251 35 33 37376 36 34 59706 37 35 19564 38 36 27579 Halifax Price Montreal Volume 3.26 108224 3.48 97699 3.28 109578 3.12 111595 3.31 114889 3.52 96388 2.77 88557 3.49 92141 3.49 104003 3.41 92071 3.22 95460 3.38 99125 3.41 85426 3.51 93584 3.46 100153 3.29 96674 3.26 101860 3.29 92922 3.05 99805 3.29 105995 3.28 95672 3.61 94865 3.48 93586 3.31 98247 3.41 85731 3.23 103838 3.54 94073 3.64 87644 3.4 95730 3.32 88898 3.24 88311 3.58 114728 3.2 98657 2.86 90664 3.63 94247 3.23 95993 Montreal Price 2.85 3.04 2.69 2.79 2.51 3.05 3.07 2.94 2.82 2.98 2.84 2.8 3.17 2.97 2.9 2.98 2.77 2.96 2.84 2.74 2 84 2.91 2.92 2.91 3.13 2.81 2.99 3.1 2.91 3.04 3.06 2.8 3.02 3.01 2.92 2.88 Toronto Volume 303412 214862 154975 158763 276558 126891 144365 153761 738517 186677 162151 106506 134016 144463 237830 214288 202606 223315 139959 160632 114154 131729 227166 185714 101795 127816 88010 142369 126607 183628 180445 160488 189181 199865 253249 321406 Toronto Price 2.54 2.81 2.97 2.9 2.65 2.98 2.97 2.89 1.75 2.74 2.71 2.98 3.04 2.94 2.65 2.89 2.71 2.62 2.78 2.87 2.96 2.87 2.6 2.75 3.04 2.86 2.97 2.91 2.88 2.64 2.86 2.86 2.75 2.61 2.75 2.53 Calgary Volume 68171 69348 73137 71271 80480 63496 54649 49197 57402 53671 52161 53886 59775 53667 56386 45949 56205 55375 50401 54619 43016 47993 60936 53777 54389 56804 49972 88652 50711 53116 52049 54581 55254 54872 58318 52241 Calgary Price 3.05 3 3.01 2.89 2.82 3.08 3.1 3.47 3.16 3.25 3.2 3.11 3.07 3.18 3.15 3.37 3.26 3.24 3.26 3.14 3.33 3.18 3.14 3.17 3.07 3.08 3.32 2.82 3.32 3.11 3.15 3.23 3.16 3.06 2.95 3.07 A B D E F G H 37 38 39 40 3.14 2.98 3.19 3.32 3.49 3.19 3.1 3.43 3.36 42 43 45 46 47 3.5 op OO 48 49 USG 9 0 1 2 3 4 5 6 7 8 9 0 1 2 53 14 55 16 57 58 59 50 51 52 53 54 65 66 67 68 69 70 71 72 73 74 75 51 52 53 54 55 56 29542 28842 27596 26463 23823 25967 42353 26387 24363 22457 26197 51259 47864 23839 25240 31689 28489 22079 21584 45180 47682 35720 39891 27408 67815 28484 27635 24997 31133 37192 37209 27548 21950 25750 24465 28957 28780 3.83 2.96 2.65 3.41 3.38 2.9 3.2 3.32 3.19 2.86 889 OSOBA 106030 104484 95910 98751 110742 105176 105644 132453 87597 86597 86801 99407 104554 109472 103654 100692 109119 110422 96767 103102 103555 98546 91009 88298 98798 119101 100863 97750 96896 92549 102207 91088 98527 96503 91118 101606 112879 2.84 2.86 2.75 2.82 2.72 2.76 2.69 2.52 2.98 2.99 2.94 2.75 2.81 2.76 2.78 2.66 2.73 2.78 2.76 2.64 2.8 2.89 2.9 2.9 2.77 2.68 2.77 2.79 2.88 2.94 2.87 130731 144456 158841 206122 143034 154850 182300 237539 178471 225674 151830 199857 227443 162355 143319 321829 326624 154535 117758 309200 303337 158526 84385 313914 143329 174733 107224 122836 180030 200358 186875 115033 135174 268006 212068 218585 110198 2.85 2.88 2.78 2.73 2.92 2.75 2.81 2.59 2.73 2.6 2.77 2.7 2.76 2.82 2.84 2.42 2.48 2.78 3.05 2.62 2.65 2.94 3.16 2.25 2.96 2.73 2.93 2.92 2.74 2.85 2.83 2.78 2.85 2.55 2.81 2.62 2.98 51883 52960 55763 53667 47513 49935 60273 67389 51613 46747 46911 52906 52730 54588 53644 62192 87953 77361 63432 61412 71661 69469 50636 46315 54551 53717 49750 49916 43508 41411 44195 37853 47850 42495 37581 42941 45147 3.05 3.04 2.93 3.34 3.14 3.06 2.88 2.87 3.31 3.31 3.31 3.05 3.24 3.16 3.24 2.86 2.76 2.93 3.01 2.96 2.89 2.98 3.31 3.21 3.08 3.15 3.11 3.11 3.3 3.33 3.4 3.41 3.16 3.45 3.37 3.16 31 57 2.91 58 59 60 61 62 63 64 65 66 3.04 3.05 3.26 2.81 3.21 3.14 3.52 3.04 3.25 3.17 3.14 3.45 3.37 3.63 3.53 3 34 68 69 2.94 2.9 2.97 71 72 73 3.06 2.9 2.66 01 3.59 3.53 2294 3.14 92 PSE 9768 124761 119-485 101270 114983 3.46 08 3.1 SESES 29333 760 75 78 79 27 28 82 79 82 80 83 81 84 82 83 83 86 84 82 85 88 89 82 38 92 89 92 90 93 92 95 281 2.61 2.67 2.82 2.76 2.96 2.9 2.89 2.98 2.89 2.25 2.67 2.89 2 54225 57222 49263 41335 43203 51010 48282 43931 43182 50761 45774 3.27 3.65 3:48 3:47 3.13 3.24 3.13 3.14 3.34 3.65 3.5 3.62 ESTOS 20013 20014 21145 19676 34392 27984 20338 24338 24438 29555 35968 38198 38512 33853 25783 26904 26017 20479 31388 45563 47380 52111 53420 45428 30757 25673 27212 98 2.95 06 101743 101341 100886 95651 114074 114764 99457 100082 102310 95751 102378 108465 108358 100569 103330 9950 112340 98290 92684 2.93 3.05 2,82 2.89 2.89 2.92 2.81 2.89 2.59 2.72 2.93 3.07 2.45 2.67 2.73 2.9 2.66 2.73 2.89 3.14 3.19 2.99 2.88 2.9 2.85 2.51 2.98 2.98 2.66 3.04 249 2.74 2.39 2.54 2.28 283 2.61 44382 51786 57737 60482 57152 64574 57813 2.29 3.15 3.03 3.28 3.29 3.12 3.03 3.27 3.12 3.3 2.94 3.07 3.1 3.16 3.12 3.13 3.24 3,32 2.14 2.84 1.09 2.98 3.09 16 L'E 110225 128346 126610 103431 118018 179639 155250 136280 84293 251977 182514 159131 117997 226670 166563 167714 116223 89306 158325 153041 159735 131067 289476 106490 146423 197229 140722 227869 228231 159335 289547 511046 179120 200379 195116 337824 176468 2.61 16 3:26 3.29 3.27 SZSOS 96 16 95 3 2.95 97 98 99 200 32 98 47706 77444 81643 72914 62119 55451 3.65 TOT 66 1.64 00606 95830 20695 2016 202 100 103 101 204 102 205 103 206 104 3.62 3:55 1.06 OS996 SS 9 2.7 2.8 2.82 2.85 2.83 3.01 2.97 3.04 2.91 2.95 29 2.80 2.93 2,83 278 2.95 2,70 2.89 3.02 10199 37655 19245 50212 3.42 1.43 3.31 3:15 2.97 SOL 201 901 BOT Spoca EU S 103074 111169 96265 111204 135282 114041 126472 131700 117928 51163 18421 518019 48611 33913 82481 105414 30661 78051 60189 COLE 15 1.47 2.89 3151 2.54 200 107 110 108 111 100 212110 44421 78841 34126 2.77 2.16 2.8 SENE 2.17 2.91 TE IZ10 113 111 114 112 115 113 116 114 117 115 118 116 119 117 120 118 121 119 122 120 123 121 124 122 125 123 126 124 127 125 128 126 129 127 130 128 131 129 132 130 133 131 134 132 135 133 136 134 137 135 138 136 139 137 140 138 141 139 142 140 143 141 144 142 145 143 146 144 147 145 148 145 149 147 150 148 151 149 152 150 153 151 154 152 155 153 156 154 157 155 158 1.6 28635 25212 46754 40449 106915 68498 85449 62638 19943 19535 24549 23329 19643 19778 22032 29346 31293 19788 22802 20583 33163 45174 24225 25373 26958 38289 32810 25253 22745 24483 28475 60664 23494 25420 34007 32165 30863 27772 46516 28095 27130 24994 22140 21289 34660 25314 29637 3.54 3.71 2.9 3.05 2.82 2.57 2.55 2.59 3.78 3.81 3.61 3.54 3.85 3.79 3.71 3.4 3.1 3.59 3.71 3.79 3.39 3.14 3.58 3.48 3.54 3.36 3:35 3.76 3.78 3.72 3.56 2.99 3.57 3.61 3.14 3.15 3.23 3.43 3.09 3:47 3.58 3.57 3.9 3.9 3:22 3:58 3.43 117928 95153 95427 97658 106359 116694 101112 105915 97243 96638 99924 102264 98975 95549 96210 92410 100677 100109 117832 106376 87678 87749 100600 114599 99489 100214 100064 93033 103026 94268 99738 89375 106762 90729 98880 90362 94836 97474 116961 125783 114502 109518 108238 114473 122866 109073 95898 3.02 3.19 3.18 3.26 3.03 2.99 3.21 3.09 3.29 3.07 3.01 2.97 2.95 2.93 2.97 2.97 2.92 3.02 2.84 3.02 3.35 3.21 3.18 2.91 3.01 2.98 3.06 3.28 2.96 3.07 3.07 3.05 176468 96194 237849 140873 156240 187102 329105 102468 197641 149946 105152 159746 149295 136959 129117 147244 120395 210343 166569 145231 89881 64110 152566 130667 147294 180029 225040 175709 67891 98379 173308 89748 212264 166366 199485 92803 104395 149287 385409 154982 90170 114392 77371 143649 277841 158105 202685 2.91 3.15 2.29 2.98 2.9 2.76 2.14 2.95 2.88 2.89 3.05 2.78 2.97 3.03 2.87 2.71 2.88 2.77 2.91 2.92 3.16 3.23 2.82 2.98 3 2.91 2.74 2.89 3.12 3.13 2.92 3.15 2.6 2.81 28 3.17 3.06 2.78 2.45 2.8 3.18 3.07 3.15 2.93 2.6 2.96 2.75 60189 45790 41611 50050 58849 51238 51415 47141 45118 55263 52637 44681 42686 42357 55679 52892 57589 53200 46467 39369 44131 42983 49872 42834 41379 44242 43093 46984 41461 37328 41998 57002 48262 48727 62168 83904 70792 68893 95112 75747 58934 65223 51251 55021 68090 81835 69959 3:31 3.3 3.59 3.27 3.25 33 3.24 3.33 3.48 3.27 3.18 3.39 3.46 3.46 3.19 3.14 3.13 3.23 3.28 3.47 3.27 3.28 3.28 3.48 3.5 3.35 3.44 3.22 3.49 3.42 3:34 3.16 352 3.21 2.98 3.01 3.07 3.06 2.71 3.22 3.41 3 3.23 3.09 3.1 289 3.18 3.06 3.27 3.25 3.13 2.86 2.74 2.94 2.88 2.91 105 3.14 3.05 3.07 CT 291 2.95