Use the Data Given Below to Answer the Following Questions)

question 33

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 generates a scatter chart in Excel with the values predicted by the regression model included?

• A) Trendline
• B) Residual Plots
• C) R Square
• D) Line Fit Plots

---

Definitions:

Lawn Debris

Waste materials, such as leaves and grass clippings, that are collected from maintaining a lawn or garden area.

Click-on Agreement

A legal agreement entered into by clicking on a button or link, typically online, to accept terms and conditions.

Binding

Describes an agreement, contract, or legal decision that is enforceable by law.

Enforceable Contract

An agreement between parties that is legally binding and may be upheld and compelled by law.