Wiley E. Coyote is planning to install movement sensors in different locations in an effort to...

Transcribed Image Text:

Wiley E. Coyote is planning to install movement sensors in different locations in an effort to capture his nemesis Road Runner. He selects locations Road Runner always visits. Each sensor is advertized to have an effective range of 150 yards and costs $75. The following table shows distance between locations. Poor Wiley has only $400 and hence wants to minimize the number of sensors to install and yet cover all of the locations. A B C H A 162 0 132 170 196 36 175 166 B 132 0 106 165 C 170 106 0 163 158 75 100 D 196 175 163 0 140 200 194 0 121 159 E 194 36 166 158 140 181 193 188 200 F 121 0 162 200 G 192 151 140 194 159 162 0 138 H 162 165 75 100 194 200 138 0 DE F G 181 192 193 151 188 140 How many sensors can Wiley buy? What is the total cost of these sensors? Give a complete model to the problem. Use use Excel to solve it and report the answer here. After a few failed attempts, Wiley used his knowledge of statistics to prove that the sensors actually have an effective range of only 125 yards. Assuming that he will use the sensors bought in the previous problem, how many additional sensors will he need now? Wiley E. Coyote is planning to install movement sensors in different locations in an effort to capture his nemesis Road Runner. He selects locations Road Runner always visits. Each sensor is advertized to have an effective range of 150 yards and costs $75. The following table shows distance between locations. Poor Wiley has only $400 and hence wants to minimize the number of sensors to install and yet cover all of the locations. A B C H A 162 0 132 170 196 36 175 166 B 132 0 106 165 C 170 106 0 163 158 75 100 D 196 175 163 0 140 200 194 0 121 159 E 194 36 166 158 140 181 193 188 200 F 121 0 162 200 G 192 151 140 194 159 162 0 138 H 162 165 75 100 194 200 138 0 DE F G 181 192 193 151 188 140 How many sensors can Wiley buy? What is the total cost of these sensors? Give a complete model to the problem. Use use Excel to solve it and report the answer here. After a few failed attempts, Wiley used his knowledge of statistics to prove that the sensors actually have an effective range of only 125 yards. Assuming that he will use the sensors bought in the previous problem, how many additional sensors will he need now?

Answer rating: 100% (QA)

Im sorry but as an AI Im not able to directly use software applications like Excel to solve problems However I can guide you through the approach you ... View the full answer