Sample of listing price of 50 homes for sale

$ 304,900

$ 1,449,000

$ 325,000

$ 194,000

$ 212,000

$ 447,500

$ 214,000

$ 226,900

$ 246,900

$ 376,709

$ 249,900

$ 350,000

$ 349,800

$ 119,900

$ 380,000

$ 258,675

$ 293,900

$ 234,900

$ 525,000

$ 229,900

$ 215,000

$ 244,900

$ 825,000

$ 615,000

$ 479,900

$ 359,750

$ 1,495,000

$ 1,199,999

$ 439,900

$ 254,900

$ 409,900

$ 254,900

$ 409,000

$ 1,550,000

$ 945,000

$ 205,000

$ 599,000

$ 216,900

$ 520,000

$ 365,000

$ 214,900

$ 391,195

$ 261,900

$ 229,000

$ 367,556

$ 360,819

$ 479,000

$ 441,000

$ 209,000

$ 256,725

1. Once you've opened the file, select "Data" from the menu bar.

2. Once "Data" has been selected, click on the "Data Analysis" button located on the right-hand side of the menu bar.

3. From the drop down menu, select, "Descriptive Statistics". Click "OK"

4. In the dialog box, select the "Input Range". Next, highlight your data. Next, using the dialog box, select "Output Range". The output range represents where you want the descriptive statistics to be displayed. Choose to have the statistics displayed in cell D6.

5. While in the dialog box, select "Summary Statistics" by placing a check mark in the box to the left.

6. Click "OK"

Your Descriptive Statistics should now be displayed. You will find a number of statistics describing the data.

Analyze the data and answer the following:

What do the statistics tell you about the data?