a. frequency and percentage frequency for sold houses:
Vacant houses are not yet sold and therefore the required houses are either owner occupied or occupied by tenants, the first step is to determine those houses that are owner occupied,
The first step is to identify the houses that are owner occupied, using the EXACT function in excel the results are set to test whether the occupied variable matches owner occupied and returns the value TRUE if true and FALSE if false
The next step is to identify the houses that are occupied by tenants, using the EXACT function in excel, the results are set to test whether the occupied variable matches homes occupied by tenants and returns the value TRUE if true and FALSE if false.
To identify which houses are occupied meaning that they are sold then the OR function is used, this returns the value TRUE if either of the above EXACT results are true.
Number of bedrooms:
To identify the number of bedrooms for the houses that are sold the IF function is used, if the value of the OR results is true then the value of the IF results is 1, and if the OR function results is false then the value of the IF results is 0. The number of bedrooms from the original data is multiplied with the results of the IF sign to get a new variable named sold and number of bedrooms.
To come up with the frequency table the COUNTIF function is used, it is set to count the number of value from the new variable sold and number of bedrooms, setting the value 1, 2, 3, 4, 5, 6 and 7 for each class 1 to 7 respectively. The table below summarizes the frequencies and percentage frequencies:
Where percentage frequency of the class 1 = 3/ 548 * 100 = 0.5128%
b. polygon and histogram:
The chart below is the histogram,
The chart below is the percentage frequency polygon
c. cumulative frequency polygon
a. Compute the
b. Compute the
Coefficient of variation
Z scores for the price variable
Z scores for the price variable
The skewness value is 6.3, this means that data is positively skewed meaning that a large numeric of price values are relatively high compared to low prices.
the mean house price 154863.177 and prices deviate 122912.8072 units from the mean price, the mean is greater than the median meaning that data is positively skewed, the range value indicates the difference between the lowest and largest value and in this case the range is1558000, finally there are more prices that have relatively high prices and this is evident from the skewness value.
e. proportion of house prices that are
(+/- 1 standard deviations of the mean)
(+/- 2 standard deviations of the mean)
(+/- 3 standard deviations of the mean)
F: Compare with the empirical rule:
The empirical rule states that 68% of data is contained within (+/- 1 standard deviations of the mean), 95% within (+/- 2 standard deviations of the mean) and 99.7% within (+/- 3 standard deviations of the mean) this means that the above distribution does not assume a normal distribution given that 92% compared to 68% of the data compared with the empirical rule are contained within (+/- 1 standard deviations of the mean)
a. covariance between price and size:
Covariance = 94168317.66
b. correlation between price and size:
(c) Scatter plot between price and size
(d) Relationship between price and size
From the correlation coefficient there is a strong positive relationship between price and size, this relationship is depicted by the scatter diagram which shows that as size increase prices also increase.
(e) Conclusions about the relationship between price and size
The size of a house will influence the price, the larger the house the higher the price and the smaller the size the cheaper is the house.
- Academic Writing
- Case Study
- Critical Thinking
- Education Questions
- Essay Tips
- Essay Writing
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Human Resources
- Problem Solving
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles