In Excel, to Construct a Residual Plot, Input of a Y

Multiple Choice

In Excel, to construct a residual plot, input of a y range and an x range is needed. Aimee is examining the relationship between age and square foot range (sqft) of living space. In the scenario provided, what would be the y and what would be the x range data?

A) In selecting a regression, residual plot is the first selection before range input.
B) Input y range would be age and Input x range would be sqft.
C) Input y range would be blank to produce a concise x range.
D) Input y range would be sqft and Input x range would be age.