Use the Data Given Below to Answer the Following Questions)

question 48

Multiple Choice

Use the data given below to answer the following questions) .
Following is an extract from the database of a construction company. The table shows the height of walls in feet and the cost of raising them. The estimated simple linear regression equation is given as Ŷ = b0 + b1X. Hint: Use Excel functions) . $$\begin{array} { | r | r | } \hline \text { Height ft) } & \text { Cost \$) } \\\hline 4 & 670 \\\hline 3 & 430 \\\hline 7 & 810 \\\hline 9 & 1100 \\\hline 6 & 790 \\\hline 8 & 880 \\\hline 5 & 760 \\\hline 11 & 1200 \\\hline\end{array}$$
-Which of the following statements is true when using the Excel Regression tool?

• A) The range for the independent variable values must be specified in the box for the Input Y Range.
• B) Checking the option Constant is Zero forces the intercept to zero.
• C) The Regression tool can be found in the Tools tab under Insert group.
• D) Adding an intercept term reduces the analysis' fit to the data.

---

Definitions:

Conformist Lifestyle

A way of living that closely follows the norms, values, and expectations of society, often at the expense of individuality.

Self-Efficacy

The belief in one's capabilities to organize and execute the courses of action required to manage prospective situations.

Locus of Control

Pertains to a person's convictions about the origins of their experiences and the elements they credit for their successes or failures.

Anti-Social Risk Takers

Individuals who engage in behaviors that disregard others’ well-being, often involving thrill-seeking or criminal activities.