# Question

The file S02_11.xlsx contains data on 148 houses that were recently sold in a (fictional) suburban community.

The data set includes the selling price of each house, along with its appraised value, square footage, number of bedrooms, and number of bathrooms.

a. Which of these variables are continuous? Which are discrete?

b. Create histograms for the appraised values and selling prices of the houses. How are these two distributions similar? How are they different?

c. Find the maximum and minimum sizes (measured in square footage) of all sample houses.

d. Find the house(s) at the 80th percentile of all sample houses with respect to appraised value. Find the house(s) at the 80th percentile of all sample houses with respect to selling price.

e. What are the typical number of bedrooms and the typical number of bathrooms in this set of houses? How do you interpret the word “typical?”

The data set includes the selling price of each house, along with its appraised value, square footage, number of bedrooms, and number of bathrooms.

a. Which of these variables are continuous? Which are discrete?

b. Create histograms for the appraised values and selling prices of the houses. How are these two distributions similar? How are they different?

c. Find the maximum and minimum sizes (measured in square footage) of all sample houses.

d. Find the house(s) at the 80th percentile of all sample houses with respect to appraised value. Find the house(s) at the 80th percentile of all sample houses with respect to selling price.

e. What are the typical number of bedrooms and the typical number of bathrooms in this set of houses? How do you interpret the word “typical?”

## Answer to relevant Questions

The file S02_13.xlsx contains the thickness (in centimeters) of 252 mica pieces. A piece meets specifications if its thickness is between 7 and 15centimeters.a. What fraction of mica pieces meets specifications?b. Are the ...The Consumer Confidence Index (CCI) attempts to measure people’s feelings about general business conditions, employment opportunities, and their own income prospects. Monthly average values of the CCI are listed in the ...The file S02_27.xlsx contains monthly data for total U.S. retail sales of building materials. There are really two series, one of actual values and one of seasonally adjusted values. The latter adjusts for any possible ...The file S02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households. Use Excel filters to answer the following questions. a. Identify households that own their home and have a monthly home ...Recall that the file Baseball Salaries 2009.xlsx contains data on 818 MLB players as of May 2009. Using this data set, answer the following questions:a. Find the mean and median of the salaries of all shortstops. Are any of ...Post your question

0