Could i please get help solving this

1. Davis Construction is going to install cable lines to a housing development. The goal is to minimize the total length of cable used. The development is shown to the right, with each house as a numbered blue circle, and the distances between houses given in hundreds of feet. How should the houses be connected? Show work below using Table 9.4 in the chapter as an example. *Start from Node 13* Connected Nodes Step 1 Unconnected Nodes 13 Closest Unconnected Node Arc Selected Arc Length Total Distance 2. The number of cars arriving per hour at Lundberg's Car Wash during the past 200 hours of operation is observed and recorded in the orange table below. A. Calculate the probabilities in column C, and calculate the cumulative probabilities in column E. Fill in the lower bound for the probability ranges in column D, so that Excel can use =VLOOKUP on D3:F7. Hint: Programs 13.2, 13.5, and 13.6 all show how to create the ranges to use VLOOKUP. B. Using the random numbers given in B12:B26, simulate 15 hours of car arrivals and compute the average number of arrivals per hour. C. Have Excel generate random numbers between 0 and 1 in cells H12:H26, and repeat the simulation. Number of Cars Arriving Frequency Probability 4 20 5 30 6 50 7 60 8 40 TOTAL 200 Simulation # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Probability Range (Lower) Cumulative Probability Number of Cars Arriving 4 5 6 7 8 Number of Random # Cars Arriving 0.7583 0.0456 0.7772 0.9292 0.0794 0.2468 0.6933 0.5687 0.3252 0.5671 0.6139 0.1399 0.2260 0.9060 0.4237 Simulation # Random # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15