Posted: September 13th, 2017
Paper, Order, or Assignment Requirements
Please check the instructions. this assignment is based on Part 1 and 2. please check them with the uploads.
Introduction
The Assignment Data (PopulationPropertyData2014.xls) file, which you can access from the Assessment Information page on the unit website contains, in the range A1:I401, real estate sales data for a population of 400 properties around Melbourne in a particular week. In Part I of the assignment you have selected a random sample of 50 properties each containing observations, where appropriate, of the eight variables V1 to V8. In Part II of the assignment you have performed some statistical analyses on a number of these variables using your sample data file, SamplePropertyData.xls. The variables in the data set are as follows:
V1 = Region around Melbourne where property is located (1 = North, 2 = West, 3 = East, 4 = Central)
V2 = Property type (0 = Unit, 1 = House)
V3 = Sale result (1 = Sold at auction, 2 = Passed-in, 3 = Private sale, 4 = Sold before auction). Note that a blank cell for this variable simply indicates that the property did not sell.
V4 = Building type (1 = Brick, 2 = Brick veneer, 3 = Weatherboard, 4 = Vacant land)
V5 = Number of rooms
V6 = Land size (Square metres)
V7 = Sold Price ($000s)
V8 = Advertised Price ($000s)
Column A (PN), contains the property identification numbers for the 400 properties.
You should continue the required work on Part III of the assignment using the Excel worksheet, SampleProperty Data.xls, that you were working on at the completion of Part II of the assignment.
Assignment Tasks (Part III)
Answers to the assignment tasks must be based on the sample data file that you created in Part I of the assignment. As for Part II, most tasks in Part III of the assignment require you to obtain an Excel output prior to performing some analysis. Copy and paste these outputs to your assignment MS Word document immediately preceding any subsequent analysis. Explanations must be precise and to the point. Charts and tables must have appropriate titles and numerical values must be rounded to an appropriate number of decimal places and accompanied by the correct units of measure.
There are four tasks in Part III of the assignment. You must meet all task requirements to receive full marks. No marks will be awarded to a task that requires an Excel output, if a print copy of the output has not been included with your answer. No marks will be awarded if only the Excel outputs are submitted without comments, explanations or the analysis required in the task.
The total mark available for the entire assignment is 60. The total mark you receive for your assignment will be converted to a mark out of 20 before being aggregated with your test and examination marks to produce your final result for the unit
Task 6 (7 marks)
A reminder, in this task, to make sure that you show any necessary working.
Failure to do so will result in the loss of marks.
Task 7 (7 marks)
(i) A point estimate of the mean “Sold Price” of the population of properties.
(ii) A 90% confidence interval estimate of the mean “Sold Price” of the population of properties.
(b) Make a brief verbal statement explaining the meaning of the confidence interval estimate obtained in (a) in the context of the variable in this task.
(c) If the population mean “Sold Price” is actually 650 ($000s), would you consider the interval estimate obtained in (a), to be satisfactory? Explain why or why not.
Task 8 (6 marks)
(sample statistic) ± (critical z or t) ´ (standard error of the sample statistic)
Task 9 (7 marks)
(a) Use Excel to produce a Descriptive Statistics table for the brick veneer properties in your sample suitable for constructing an interval estimate of the population proportion of brick veneer properties. Hence determine:
(i) A point estimate of the proportion of brick veneer properties in the population.
(ii) A 99% confidence interval estimate of the proportion of brick veneer properties in the population.
(b) Make a brief verbal statement explaining the meaning of the confidence interval estimate obtained in (a) in the context of the variable in this task.
(c) If the population proportion of brick veneer properties is actually 42%, would you consider the interval estimate obtained in (a), to be satisfactory? Explain why or why not.
Place an order in 3 easy steps. Takes less than 5 mins.