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:

Proprietorship

A business owned by a single individual who is responsible for its assets and liabilities.

Personal Assets

Items of value owned by an individual, including cash, real estate, investments, and personal property.

Accounting Records

Documentation and books involved in preparing financial statements, including ledgers, journals, and other evidence of transactions.

Allowance For Doubtful Accounts

A contra asset account on a company's balance sheet that represents the estimated portion of accounts receivable that may not be collectible.