Problem Description: You are consultants working with an online real estate appraiser, onthehouse.

Required:

Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the central tendency, variability and shape for housing price and two additional variables. (1 Mark)

Draw a graph that displays the relative share of bedrooms in the sample. (1 Mark)

Create a box-and-whisker plot for the distribution of the price of the homes and describe the shape. Is there evidence of outliers in the data? (1 Mark)

What is the likelihood that a house is both over $600,000 and more than 10 kilometres from the CBD? Is the price statistically independent of distance? Use a Contingency Table. (2 Marks)

Estimate the 90% confidence interval for the population mean housing price. (1 Mark)

Your supervisor recently stated that it is obvious that the mean housing price is greater than $610,000, which was the average price of housing sold last year. Test his claim at the 5% level of significance. (1 Mark)

Run a multiple linear regression using the data and show the output from Excel. (1 Mark)

Is the coefficient estimate for the number of bedrooms statistically different than zero at the 5% level of significance? Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach. Interpret the coefficient estimate of the slope. (2 Marks)

Interpret the remaining slope coefficient estimates. Comment on whether the signs are what you are expecting. (2 Marks)

Interpret the value of the Adjusted R2. Is the overall model statistically significant at the 1% level of significance? Use the p-value approach. (1 Mark)

Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of the Errors, and Homoscedasticity of Errors? Show using scatter diagrams, normal probability plots and/or histograms and Explain. (3 Marks)

Based on the results of the regressions, is it likely that other factors have influenced housing prices? If so, provide a couple possible examples and indicate whether these would likely influence the regression results if they were included. (1 Mark)

If a community housing organisation asked for information regarding the characteristics of housing targeting the households of Aboriginal and Torres Strait islanders, explain whether a simple random sampling technique would provide an accurate representation of these households. (Note: This question does not use the data) (1 Mark)