Please show me all the steps in excel!!

The following data contains sales data on business shirts in a sample of department stores. The variables collected are described below. Sales Unit sales (in thousands) at the store Average price charged by local competitor for one business CompPrice shirt (dollars) Income Community income level (in thousands of dollars) Advertising Local advertising budget for store (in thousands of dollars) Population Population size in geographic region of store (in thousands) Price Average price charged by store for one business shirt (dollars) Urban Yes or No depending on whether store is an urban or rural location a. a. b. Estimate the 95% confidence interval for the population average price charged by store for one business shirt (Price) and interpret your result. (8 Marks) How large a sample should be taken to reduce the confidence interval in part (a)? to one quarter of its current size with the same confidence level? (6 Marks) Estimate a 90% confidence interval for the population proportion of urban stores. You must verify any assumptions and present your final answer in a sentence. (8 Marks) c. Sales CompPrice Income Advertising Population Price Urban Store 1 9.5 120 73 11 276 120 Yes Store 2 11.22 98 48 16 260 83 Yes Store 3 108 35 10 269 10.06 7.4 112 100 4 466 80 Yes 97 Yes 128 Yes 72 No 4.15 136 64 3 340 10.81 119 113 13 408 6.63 110 105 0 45 108 Yes 120 Yes 11.85 131) 81 15 425 127 110 0 108 124 No 6.54 4.69 9.01 0 127 116 113 78 9 124 No 110 No 94 Yes 136 Yes 112 94 131 155 503 393 29 4 117 35 2 28 11 Store 4 Store 5 Store 6 Store 7 Store 8 Store 9 Store 10 Store 11 Store 12 Store 13 Store 14 Store 15 Store 16 Store 17 Store 18 Store 19 Store 20 Store 21 Store 22 Store 23 Store 24 Store 25 Store 26 Store 27 11.96 3.98 10.96 11.17 8.71 7.58 110 102 144 11 5 117 95 32 74 110 148 400 284 251 86 Yes 118 Yes 144 No 110 Yes 131 Yes 68 No 0 113 142 105 12.29 13.91 13 0 408 124 76 16 58 121 No 8.73 6.41 1201 90 2 367 129 29 12 239 12.13 5.08 123 46 6 497 131 Yes 109 No 138 Yes 109 Yes 113 Yes 82 No 5.87 116 31 0 292 10.14 140 119 16 294 14.9 134 32 0 176 8.33 102 115 11 496 131 No The following data contains sales data on business shirts in a sample of department stores. The variables collected are described below. Sales Unit sales (in thousands) at the store Average price charged by local competitor for one business CompPrice shirt (dollars) Income Community income level (in thousands of dollars) Advertising Local advertising budget for store (in thousands of dollars) Population Population size in geographic region of store (in thousands) Price Average price charged by store for one business shirt (dollars) Urban Yes or No depending on whether store is an urban or rural location a. a. b. Estimate the 95% confidence interval for the population average price charged by store for one business shirt (Price) and interpret your result. (8 Marks) How large a sample should be taken to reduce the confidence interval in part (a)? to one quarter of its current size with the same confidence level? (6 Marks) Estimate a 90% confidence interval for the population proportion of urban stores. You must verify any assumptions and present your final answer in a sentence. (8 Marks) c. Sales CompPrice Income Advertising Population Price Urban Store 1 9.5 120 73 11 276 120 Yes Store 2 11.22 98 48 16 260 83 Yes Store 3 108 35 10 269 10.06 7.4 112 100 4 466 80 Yes 97 Yes 128 Yes 72 No 4.15 136 64 3 340 10.81 119 113 13 408 6.63 110 105 0 45 108 Yes 120 Yes 11.85 131) 81 15 425 127 110 0 108 124 No 6.54 4.69 9.01 0 127 116 113 78 9 124 No 110 No 94 Yes 136 Yes 112 94 131 155 503 393 29 4 117 35 2 28 11 Store 4 Store 5 Store 6 Store 7 Store 8 Store 9 Store 10 Store 11 Store 12 Store 13 Store 14 Store 15 Store 16 Store 17 Store 18 Store 19 Store 20 Store 21 Store 22 Store 23 Store 24 Store 25 Store 26 Store 27 11.96 3.98 10.96 11.17 8.71 7.58 110 102 144 11 5 117 95 32 74 110 148 400 284 251 86 Yes 118 Yes 144 No 110 Yes 131 Yes 68 No 0 113 142 105 12.29 13.91 13 0 408 124 76 16 58 121 No 8.73 6.41 1201 90 2 367 129 29 12 239 12.13 5.08 123 46 6 497 131 Yes 109 No 138 Yes 109 Yes 113 Yes 82 No 5.87 116 31 0 292 10.14 140 119 16 294 14.9 134 32 0 176 8.33 102 115 11 496 131 No