Question

We continue with the Concrete dataset. Concrete is a central product for most modern constructions and is used in homes, roads, and commercial structures and there are many other building applications. Frequently, there is an issue of strength (compressive strength) which is measured in megapascals (MPa). Several attributes contribute to the strength of concrete.

**Download the data file https://docs.google.com/spreadsheets/d/1jVV26-UbjWhGEOi9Aww81JmSj3kM3JY6lQY662VK-pg/edit?usp=sharing

1.) The model of the data is described by  ŷ = __ + __*x1 + __*x₂ + __*x₃ + __*x₄ + __*x₅ + __*x₆+ __*x₇+ __*x₈

Round each entry to three decimals. Use leading zeros and negative signs when necessary.

Note: the variables must remain in the original data file order such that x₁=Cement and x₈=Age.

Answer 1

Performing the whole regression analysis in excel, go to data analysis tab --> Regression --> input y variable range --> input x variable range --> if headers are selected click on labels --> Click ok

(Note: if there is no data analysis tab then go to file --> excel options --> add ins --> select excel add ins --> click go --> Check the analysis tool pack and click ok)

The model is therefore,

Please up vote if you find the solution helpful. Thank you!