Spreadsheet EB eBook Refer to the data file P08_66.xlsx. Comfy Company sells mediumpriced patio furniture through a mail-order catalog. It has operated primarily in the East but is now expanding to the Southwest. To get off to a good start, it plans to send potential customers a catalog with a discount coupon. However, Comfy is not sure how large a discount is needed to entice customers to buy. It experiments by sending catalogs to selected residents in six cities. Tucson and San Diego receive coupons for 5% off any furniture within the next two months, Phoenix and Santa Fe receive coupons for 10% off, and Riverside and Albuquerque receive coupons for 15% off. Comfy wonders whether there are differences across pairs of cities that receive the same discount. a. Calculate a 95% confidence interval for the difference between the mean amount spent for the following pairs of cities: (These means should include the "O purchases." Round your answers to one decimal place, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe Riverside minus Albuquerque Does city appear to make a difference? Select b. Calculate a 95% confidence interval for the difference between the proportion of customers who purchase something for the following pairs of cities: (Round your answers to three decimal places, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe 5 Riverside minus Albuquerque Does city appear to make a difference? Select 0 Icon Key F 0 2 8 5 5 A B 1 Customer City 2 1 Tucson 3 2 Tucson 4 3 Tucson 4 Tucson 6 5 Tucson 7 6 Tucson 8 7 Tucson 9 8 Tucson 10 9 Tucson 11 Tucson 12 11 Tucson 13 12 Tucson 14 13 Tucson LO 15 14 16 15 Tucson Tucson Tucson 17 16 18 17 Tucson E Discount Items Purchased Total Paid 5% 0 5% 1 409 5% 0 0 5% 1 395 5% 0 0 5% 0 0 5% 1 229 5% 1 340 5% 0 0 5% 1 294 5% 0 0 5% 0 0 5% 0 0 5% 1 325 5% 1 381 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 1 602 5% 1 516 5% 0 5% 1 591 5% 0 0 5% 0 0 5% 0 0 5% 1 643 5% 1 5% 0 5% 0 0 5% 1 468 5% 0 0 5% 0 0 19 18 20 19 Tucson Tucson Tucson 21 20 21 22 23 22 24 23 25 24 26 25 0 27 26 28 27 29 28 Tucson San Diego San Diego San Diego San Diego SanDiego San Diego SanDiego San Diego San Diego SanDiego San Diego SanDiego San Diego SanDiego SanDiego 30 29 30 31 32 31 523 33 32 0 34 33 35 34 36 35 36 37 A B E F G 38 37 0 0 39 38 0 0 40 39 0 0 41 40 1 595 42 41 0 0 43 42 0 0 44 43 0 0 44 0 0 45 46 47 45 0 0 46 1 562 48 47 1 365 350 49 48 1 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 50 49 0 0 51 50 0 0 52 0 0 51 52 53 0 0 54 53 0 0 55 54 1 SanDiego San Diego San Diego SanDiego San Diego San Diego San Diego San Diego San Diego San Diego Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix 333 338 56 55 1 57 56 2 568 58 57 0 0 59 58 1 369 60 59 0 0 61 1 360 62 60 61 62 10% 1 326 63 10% 2 523 64 63 10% 2 530 65 64 0 0 66 65 0 0 67 66 1 338 68 67 1 305 69 68 2 2 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 664 461 70 69 2 71 70 0 0 72 71 1 395 284 73 72 1 74 73 0 E 75 74 0 0 76 75 2 568 76 1 260 77 78 77 0 0 79 78 1 307 80 79 1 397 81 80 0 0 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 82 81 0 0 83 82 1 337 84 83 0 0 85 84 2 661 86 85 0 0 87 86 0 0 88 87 1 368 89 88 10% 1 408 90 89 10% 0 0 91 90 10% 1 392 92 91 2 814 93 92 Phoenix Phoenix Phoenix Phoenix Santa Fe Santa Fe SantaFe Santa Fe Santa Fe Santa Fe SantaFe SantaFe Santa Fe SantaFe Santa Fe SantaFe SantaFe SantaFe SantaFe SantaFe Santa Fe SantaFe SantaFe Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside 1 386 94 93 0 0 95 94 1 387 96 1 310 95 96 97 0 0 97 0 0 98 99 0 0 100 0 0 98 99 100 101 102 2 1024 10% 10% 10% 10% 10% 10% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 101 102 103 104 1 451 1 433 103 0 0 105 104 0 0 106 1 107 2 105 106 107 108 436 854 496 108 1 109 0 0 110 109 1 422 111 110 0 0 A1 X fx Customer A D E 0 112 113 111 112 113 114 114 0 1 1 1 1 1 2 398 409 551 115 116 117 115 116 117 118 458 520 788 373 118 1 119 120 119 0 0 121 120 0 0 122 121 1 367 123 122 2 412 124 123 1 253 125 124 0 0 126 125 1 200 B Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 127 126 0 0 128 0 0 129 2 648 130 131 132 133 127 128 129 130 131 132 133 134 135 136 137 138 2 1 1 1 2 2 0 1 315 264 234 260 632 587 0 134 135 136 137 1 138 139 210 298 244 1 140 139 1 284 239 141 140 1 142 141 1 201 Spreadsheet eBook Refer to the data file P08_66.xlsx. Comfy Company sells mediumpriced patio furniture through a mail-order catalog. It has operated primarily in the East but is now expanding to the Southwest. To get off to a good start, it plans to send potential customers a catalog with a discount coupon. However, Comfy is not sure how large a discount is needed to entice customers to buy. It experiments by sending catalogs to selected residents in six cities. Tucson and San Diego receive coupons for 5% off any furniture within the next two months, Phoenix and Santa Fe receive coupons for 10% off, and Riverside and Albuquerque receive coupons for 15% off. Comfy wonders whether there are differences across pairs of cities that receive the same discount. a. Calculate a 95% confidence interval for the difference between the mean amount spent for the following pairs of cities: (These means should include the "O purchases." Round your answers to one decimal place, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe Riverside minus Albuquerque Does city appear to make a difference? Select Select te a 95% confidence interval for the difference between the proportion of customers who purchase something for the following pairs of cities: (Round your answers to three decimal places, if necessary. If your answer is Jumber, enter "minus" sign.) Yes No Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe BE Riverside minus Albuquerque Does city appear to make a difference? Select Spreadsheet EB eBook Refer to the data file P08_66.xlsx. Comfy Company sells mediumpriced patio furniture through a mail-order catalog. It has operated primarily in the East but is now expanding to the Southwest. To get off to a good start, it plans to send potential customers a catalog with a discount coupon. However, Comfy is not sure how large a discount is needed to entice customers to buy. It experiments by sending catalogs to selected residents in six cities. Tucson and San Diego receive coupons for 5% off any furniture within the next two months, Phoenix and Santa Fe receive coupons for 10% off, and Riverside and Albuquerque receive coupons for 15% off. Comfy wonders whether there are differences across pairs of cities that receive the same discount. a. Calculate a 95% confidence interval for the difference between the mean amount spent for the following pairs of cities: (These means should include the "O purchases." Round your answers to one decimal place, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe Riverside minus Albuquerque Does city appear to make a difference? Select b. Calculate a 95% confidence interval for the difference between the proportion of customers who purchase something for the following pairs of cities: (Round your answers to three decimal places, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe 5 Riverside minus Albuquerque Does city appear to make a difference? Select 0 Icon Key F 0 2 8 5 5 A B 1 Customer City 2 1 Tucson 3 2 Tucson 4 3 Tucson 4 Tucson 6 5 Tucson 7 6 Tucson 8 7 Tucson 9 8 Tucson 10 9 Tucson 11 Tucson 12 11 Tucson 13 12 Tucson 14 13 Tucson LO 15 14 16 15 Tucson Tucson Tucson 17 16 18 17 Tucson E Discount Items Purchased Total Paid 5% 0 5% 1 409 5% 0 0 5% 1 395 5% 0 0 5% 0 0 5% 1 229 5% 1 340 5% 0 0 5% 1 294 5% 0 0 5% 0 0 5% 0 0 5% 1 325 5% 1 381 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 0 0 5% 1 602 5% 1 516 5% 0 5% 1 591 5% 0 0 5% 0 0 5% 0 0 5% 1 643 5% 1 5% 0 5% 0 0 5% 1 468 5% 0 0 5% 0 0 19 18 20 19 Tucson Tucson Tucson 21 20 21 22 23 22 24 23 25 24 26 25 0 27 26 28 27 29 28 Tucson San Diego San Diego San Diego San Diego SanDiego San Diego SanDiego San Diego San Diego SanDiego San Diego SanDiego San Diego SanDiego SanDiego 30 29 30 31 32 31 523 33 32 0 34 33 35 34 36 35 36 37 A B E F G 38 37 0 0 39 38 0 0 40 39 0 0 41 40 1 595 42 41 0 0 43 42 0 0 44 43 0 0 44 0 0 45 46 47 45 0 0 46 1 562 48 47 1 365 350 49 48 1 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 50 49 0 0 51 50 0 0 52 0 0 51 52 53 0 0 54 53 0 0 55 54 1 SanDiego San Diego San Diego SanDiego San Diego San Diego San Diego San Diego San Diego San Diego Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix Phoenix 333 338 56 55 1 57 56 2 568 58 57 0 0 59 58 1 369 60 59 0 0 61 1 360 62 60 61 62 10% 1 326 63 10% 2 523 64 63 10% 2 530 65 64 0 0 66 65 0 0 67 66 1 338 68 67 1 305 69 68 2 2 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 664 461 70 69 2 71 70 0 0 72 71 1 395 284 73 72 1 74 73 0 E 75 74 0 0 76 75 2 568 76 1 260 77 78 77 0 0 79 78 1 307 80 79 1 397 81 80 0 0 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 82 81 0 0 83 82 1 337 84 83 0 0 85 84 2 661 86 85 0 0 87 86 0 0 88 87 1 368 89 88 10% 1 408 90 89 10% 0 0 91 90 10% 1 392 92 91 2 814 93 92 Phoenix Phoenix Phoenix Phoenix Santa Fe Santa Fe SantaFe Santa Fe Santa Fe Santa Fe SantaFe SantaFe Santa Fe SantaFe Santa Fe SantaFe SantaFe SantaFe SantaFe SantaFe Santa Fe SantaFe SantaFe Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside 1 386 94 93 0 0 95 94 1 387 96 1 310 95 96 97 0 0 97 0 0 98 99 0 0 100 0 0 98 99 100 101 102 2 1024 10% 10% 10% 10% 10% 10% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 101 102 103 104 1 451 1 433 103 0 0 105 104 0 0 106 1 107 2 105 106 107 108 436 854 496 108 1 109 0 0 110 109 1 422 111 110 0 0 A1 X fx Customer A D E 0 112 113 111 112 113 114 114 0 1 1 1 1 1 2 398 409 551 115 116 117 115 116 117 118 458 520 788 373 118 1 119 120 119 0 0 121 120 0 0 122 121 1 367 123 122 2 412 124 123 1 253 125 124 0 0 126 125 1 200 B Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Riverside Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque Albuquerque 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 127 126 0 0 128 0 0 129 2 648 130 131 132 133 127 128 129 130 131 132 133 134 135 136 137 138 2 1 1 1 2 2 0 1 315 264 234 260 632 587 0 134 135 136 137 1 138 139 210 298 244 1 140 139 1 284 239 141 140 1 142 141 1 201 Spreadsheet eBook Refer to the data file P08_66.xlsx. Comfy Company sells mediumpriced patio furniture through a mail-order catalog. It has operated primarily in the East but is now expanding to the Southwest. To get off to a good start, it plans to send potential customers a catalog with a discount coupon. However, Comfy is not sure how large a discount is needed to entice customers to buy. It experiments by sending catalogs to selected residents in six cities. Tucson and San Diego receive coupons for 5% off any furniture within the next two months, Phoenix and Santa Fe receive coupons for 10% off, and Riverside and Albuquerque receive coupons for 15% off. Comfy wonders whether there are differences across pairs of cities that receive the same discount. a. Calculate a 95% confidence interval for the difference between the mean amount spent for the following pairs of cities: (These means should include the "O purchases." Round your answers to one decimal place, if necessary. If your answer is negative number, enter "minus" sign.) Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe Riverside minus Albuquerque Does city appear to make a difference? Select Select te a 95% confidence interval for the difference between the proportion of customers who purchase something for the following pairs of cities: (Round your answers to three decimal places, if necessary. If your answer is Jumber, enter "minus" sign.) Yes No Lower Limit Upper Limit Tucson minus San Diego Phoenix minus Santa Fe BE Riverside minus Albuquerque Does city appear to make a difference? Select