Can you check my answer and my work in excel And answer point e , f , g 8.5.4: T

Question

Can you check my answer and my work in excel And answer point e , f , g 8.5.4: The famous "Leaning Tower of Pisa" began to lean even while in the Excel spreadsheet for Lab 11 shows the measured lean for the years 1975 through 1987: the distance in meters between where a particular point on the tower would be if the tower were straight and where it actually was. a. Insert a scatter XY chart to display this data. it was under construction in the 1170s. The table b. Construct the regression line for this data and estimate (visually) what the lean was in the year 2000. to format the trendline and forecast forward to increase the graph to 2000.) (You will have c. Display the equation of the trendline on the chart d. What is the slope of the regression line? What are its units? What does it mean? Slope O.00 how vmrch Y - S3 e. Check your estimate from part a using the equation of the regression line. Can you use the formula as it appears in the chart, or do you need more decimal places? y o. 00200)i233 223 0.0001319 (2000) + 1-1233-414z! f. Explain why the actual numbers in the data table for the Tower of Pisa depend on the height of the "particular point" at which measurements were taken. What would the numbers be if the point were twice as high? g. What has happened to the Tower of Pisa since 1987?

Explanation / Answer

Hi team

As per Calculation I can see the answers as well.. And it Slope will be 0.0009319

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.