Part B Here is data that is in a spreadsheet for activity 10 and click on the tab drill depth: Use this data to answer questions 3-11 35 Depth at Which Drilling Begins, X (in feet) Time to Drill 5 Feet, y (in minutes) 50 75 95 120 130 145 155 160 175 185 190 5.88 5.99 6.74 6.10 7.47 6.93 6.42 7.97 7.92 7.62 6.89 7.90 3. Download Activity 10 spreadsheet and open it. Click on the Drill Depth tab at the bottom of the spreadsheet 4. Highlight cells A1 - B14 and select Insert Scatterplot. Click on the green plus to add a trendline. 5. Click on cell B16 and type =correl(A3:A14,B3:B14) 6. Copy the correlation coefficient here (round to 4 decimal places) .7728 7. Is the correlation positive or negative? Is the correlation strong or weak? positive 8. Find the line of best fit (like we did in class) and record the equation here r= Y=D.Dillex +5.5273 9. How long will it take to drill 5 feet if we start at 1,00 feet? Round to two decimal places 6.69 minutes Y.DI (100)+5.5273 No if you are not not drilling any depths it s