How many forclosure transactions are in this data set?

$162$

$1$ points

QUESTION $2$

What is the average Price of all transactions? Please put the answer in cell K$1.($Round of the nearest integer.$)$

$383329\mathrm{.}1101$

$1$ points

QUESTION $3$

What is the average Price for all transaction with price above $600$k$?$

$2$ points

QUESTION $4$

What is the Location of the transaction with the highest Price?

Paso Robles

Arroyo Grande

Oceano

Santa Maria$-$Orcutt

$2$ points

QUESTION $5$

Create a new variable in column H$.$ Calculate price per square foot for each transaction in column H$.$ What is the average price per square foot of all tranactions? $($Round of the nearest integer.$)$

$2$ points

QUESTION $6$

In cell K$1,$ calculate the average price of all transactions. Create a new vavarialbe using IF formula in column I. For the transaction that with price above average, write text ABOVE in column I. Otherwise, assing BELOW in column I.

Which of the following Excel formula can be applied in cell I$2$ such that we can obtain the correct answer and can autofil the formula for the rest of transactions?

$=$IF$($C$2>$K$1,$ ABOVE, BELOW$)$

$=$IF$($C$2>$K$1,$ "ABOVE", "BELOW"$)$

$=$IF$($C$2>$$K$$1,$ "ABOVE", "BELOW"$)$

None of the above.