Descriptive Statistics and Interval Estimation for Sold Price and Brick Veneer Properties

Statistics
Student Name:
Instructor Name:
Course Number:

Task 1
Task 1 has been done in excel. The excel file is attached together with this word document.
Task 2 (10 marks)
Use Excel to produce a Frequency Column Chart (4 marks) and a Relative Frequency Pie-
Chart (3 marks) for your sample to show the number and proportion, respectively, of each
building type.
Use these graphical summaries to answer the following questions:

(a) How many properties in your sample consist of brick buildings? (1 mark)
Answer
32 properties consist of brick buildings
(b) Which building type occurs most frequently in your sample? (1 mark)
Answer
Brick veneer occurs most frequently
(c) What proportion of properties in your sample consists of weatherboard buildings? (1
mark)
Answer
38% of the properties consists of weatherboard buildings
Task 3 (10 marks)
(a) Use Excel to sort your sample “Sold Price” data and paste into your MS Word
assignment document. (1 mark)
Answer
Sorted out sold price
Sold Price
112 387.5 590 805
132 400 615 831
245 410 621 845
265 424 627.5 865
300 440 670 880
305 441 675 882
319 445 711 900
348 501 718 1424
350 505 736 1800
351 552 745 2650
361 555 755
363 570 800
(b) Use the percentile location formula;
100
P
)1+n(=LP , and the three associated rules (Slide 11 of Week 2 Seminar,
Session 1) (1 mark) to determine:
(i) The 70th percentile. (1 mark)
Answer Remember to show all working!