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:

Perfect Price Discrimination

A pricing strategy where a seller charges the maximum possible price to each customer based on their willingness to pay, capturing all consumer surplus as profit.

Consumer Surplus

The discrepancy between what consumers are prepared and able to spend on a product or service and the actual amount they end up paying.

Producer Surplus

The difference between what producers are willing to sell a good for and the actual price they receive, serving as an indicator of producer welfare.

Direct Price Discrimination

A pricing strategy where a business charges different prices to different customers for the same product or service, based on willingness to pay.