Identify the number of data values for the house age data.

The number of data values is

(Type a whole number.)

Part 2

Compute the mean of the house age data.

The population mean of the house age data is

(Round to two decimal places as needed.)

Part 3

Compute the deviation from the mean for the first house's age of years

The deviation from the mean is

(Round to two decimal places as needed.)

Part 4

Compute the variance of the house age data.

The population variance of the house age data is

(Round to two decimal places as needed.)

Part 5

Compute the standard deviation of the house age data.

The population standard deviation of the house age data is

(Round to two decimal places as needed.)

Part 6

Compute the mean of the square feet data.

The population mean of the square feet data is

(Round to two decimal places as needed.)

Part 7

Compute the deviation from the mean for the first house's square footage of

square feet.

The deviation from the mean is

(Round to two decimal places as needed.)

Part 8

Compute the variance of the square feet data.

The population variance of the square feet data is

(Round to two decimal places as needed.)

Part 9

Compute the standard deviation of the square feet data.

The population standard deviation of the square feet data is

(Round to two decimal places as needed.)

Part 10

Compute the mean of the market value data.

The population mean of the market value data is

(Round to two decimal places as needed.)

Part 11

Compute the deviation from the mean for the first house's market value of $114,000.

The deviation from the mean is

(Round to two decimal places as needed.)

Part 12

Compute the variance of the market value data.

The population variance of the market value data is

(Round to two decimal places as needed.)

Part 13

Compute the standard deviation of the market value data.

The population standard deviation of the market value data is

(Round to two decimal places as needed.)

and these formulas. Verify your calculations using the appropriate Excel function. Click here to view the data. Click here to view the formulas. Home Market Value Data Formulas If a population consists of N observations x1,x2,,xN, the population mean is calculated as =Ni=1Nxi. The formula for the variance of a population is 2=Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean. For a population, the standard deviation is computed as =Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean. and these formulas. Verify your calculations using the appropriate Excel function. Click here to view the data. Click here to view the formulas. Home Market Value Data Formulas If a population consists of N observations x1,x2,,xN, the population mean is calculated as =Ni=1Nxi. The formula for the variance of a population is 2=Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean. For a population, the standard deviation is computed as =Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean