Can you help me understand this Statistics question?

A.

Create the Descriptive Statistics for “Price” and “SQFT” – Include a 95% Confidence Test on the Population Mean

B.

Produce a Scatterplot for Price (Dependent) and SQFT (Independent) (PLACE BELOW)

C.

Conduct a 95% Hypothesis Test (i.e., α = .05) to determine if the Mean Price of Houses is greater than $242,512. Use a

Population Standard Deviation of $172,000 for your Z-test (i.e., we are determing if the mean has increased from the previous year).