Questions: The following table presents prices, in thousands of dollars, of single-family homes in various metro areas of the United States for last year and this year. Metro Area, Last year, This year, Metro Area, Last year, This year Atlanta, GA, 87.8, 115.1, Philadelphia, PA, 193.5, 197.7 Baltimore, MD, 218.1, 226.5, Phoenix, AZ, 129.9, 169.0 Boston, MA, 311.5, 332.2, Portland, OR, 208.6, 246.5 Chicago, IL, 157.2, 159.4, Riverside, CA, 174.3, 216.7 Cincinnati, OH, 112.5, 121.0, St. Louis, MO, 103.7, 111.0 Cleveland, OH, 84.9, 101.0, San Diego, CA, 359.5, 412.3 Dallas, TX, 148.2, 160.4, San Francisco, CA, 448.0, 593.9 Denver, CO, 226.4, 261.2, Seattle, WA, 265.4, 312.6 Houston, TX, 152.1, 163.7, Tampa, FL, 131.9, 141.8 Los Angeles, CA, 122.1, 155.1, Washington, DC, 311.6, 348.7

The following table presents prices, in thousands of dollars, of single-family homes in various metro areas of the United States for last year and this year.

Metro Area, Last year, This year, Metro Area, Last year, This year
Atlanta, GA, 87.8, 115.1, Philadelphia, PA, 193.5, 197.7
Baltimore, MD, 218.1, 226.5, Phoenix, AZ, 129.9, 169.0
Boston, MA, 311.5, 332.2, Portland, OR, 208.6, 246.5
Chicago, IL, 157.2, 159.4, Riverside, CA, 174.3, 216.7
Cincinnati, OH, 112.5, 121.0, St. Louis, MO, 103.7, 111.0
Cleveland, OH, 84.9, 101.0, San Diego, CA, 359.5, 412.3
Dallas, TX, 148.2, 160.4, San Francisco, CA, 448.0, 593.9
Denver, CO, 226.4, 261.2, Seattle, WA, 265.4, 312.6
Houston, TX, 152.1, 163.7, Tampa, FL, 131.9, 141.8
Los Angeles, CA, 122.1, 155.1, Washington, DC, 311.6, 348.7
Transcript text: The following table presents prices, in thousands of dollars, of single-family homes in various metro areas of the United States for last year and this year. \begin{tabular}{lcclcc} \hline Metro Area & Last year & This year & Metro Area & Last year & This year \\ \hline Atlanta, GA & 87.8 & 115.1 & Philadelphia, PA & 193.5 & 197.7 \\ Baltimore, MD & 218.1 & 226.5 & Phoenix, AZ & 129.9 & 169.0 \\ Boston, MA & 311.5 & 332.2 & Portland, OR & 208.6 & 246.5 \\ Chicago, IL & 157.2 & 159.4 & Riverside, CA & 174.3 & 216.7 \\ Cincinnati, OH & 112.5 & 121.0 & St. Louis, MO & 103.7 & 111.0 \\ Cleveland, OH & 84.9 & 101.0 & San Diego, CA & 359.5 & 412.3 \\ Dallas, TX & 148.2 & 160.4 & San Francisco, CA & 448.0 & 593.9 \\ Denver, CO & 226.4 & 261.2 & Seattle, WA & 265.4 & 312.6 \\ Houston, TX & 152.1 & 163.7 & Tampa, FL & 131.9 & 141.8 \\ Los Angeles, CA & 122.1 & 155.1 & Washington, DC & 311.6 & 348.7 \\ \hline \end{tabular}
failed

Solution

failed
failed

Solution Steps

Step 1: Calculate the Mean of Last Year Prices

The mean (\(\mu\)) of last year prices is calculated using the formula: \[ \mu = \frac{\sum_{i=1}^N x_i}{N} \] Substituting the given values: \[ \mu = \frac{3947.2}{20} = 197.36 \]

Step 2: Calculate the Mean of This Year Prices

The mean (\(\mu\)) of this year prices is calculated using the same formula: \[ \mu = \frac{\sum_{i=1}^N x_i}{N} \] Substituting the given values: \[ \mu = \frac{4545.8}{20} = 227.29 \]

Step 3: Calculate the Variance and Standard Deviation of Last Year Prices

The variance (\(\sigma^2\)) is calculated using: \[ \sigma^2 = \frac{\sum (x_i - \mu)^2}{n-1} \] Substituting the given values: \[ \sigma^2 = 9629.81 \] The standard deviation (\(\sigma\)) is: \[ \sigma = \sqrt{9629.81} = 98.13 \]

Step 4: Calculate the Variance and Standard Deviation of This Year Prices

The variance (\(\sigma^2\)) is calculated using the same formula: \[ \sigma^2 = \frac{\sum (x_i - \mu)^2}{n-1} \] Substituting the given values: \[ \sigma^2 = 15082.34 \] The standard deviation (\(\sigma\)) is: \[ \sigma = \sqrt{15082.34} = 122.81 \]

Step 5: Calculate the Covariance and Correlation Coefficient

The covariance (\(\text{Cov}(X,Y)\)) is given as: \[ \text{Cov}(X,Y) = 11859.79 \] The correlation coefficient (\(r\)) is calculated using: \[ r = \frac{\text{Cov}(X,Y)}{\sigma_X \sigma_Y} \] Substituting the given values: \[ r = \frac{11859.79}{98.13 \times 122.81} = 0.98 \]

Final Answer

  • Mean of last year prices: \(\boxed{197.36}\)
  • Mean of this year prices: \(\boxed{227.29}\)
  • Variance of last year prices: \(\boxed{9629.81}\)
  • Standard deviation of last year prices: \(\boxed{98.13}\)
  • Variance of this year prices: \(\boxed{15082.34}\)
  • Standard deviation of this year prices: \(\boxed{122.81}\)
  • Covariance between last year and this year prices: \(\boxed{11859.79}\)
  • Correlation coefficient between last year and this year prices: \(\boxed{0.98}\)
Was this solution helpful?
failed
Unhelpful
failed
Helpful