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:

Carrying Cost

The total expense associated with holding inventory, including storage costs, insurance, and loss due to depreciation or obsolescence.

Total Cost

The aggregate of all costs, whether fixed or variable, incurred in producing goods or services.

Carrying Cost

The total expenses associated with maintaining inventory, encompassing storage costs, insurance fees, and taxes.

Fixed Cost

Costs that do not fluctuate in relation to the level of production or sales, such as rent or salaries.