STA1004 Fundamental Statistics for Accountants Assessment 2

Assessment Item Task Sheet Course Code and Name STA1004 Fundamental Statistics for Accountants Assessment Item Number and Name Assessment item 2: Problem Solving (including Problem Solving assignment and three Module Reviews) Assessment Item Type Problem Solving and Analyses, Online Quizzes Dataset: for Question 2, Question 3, and Question 4 you will need to use Excel to answer the questions. The dataset RealEstate.xlsx (Excel) can be found under the Assessment tab on the StudyDesk. Dataset Information Real Estate Dataset The real estate file (RealEstate.xlsx) looks at 513 dwellings sold in Melbourne, Australia (it is a random set of dwellings sold in 2020 in Melbourne). The following variables are included in this dataset (including their units and an explanation of what they are): Suburb the suburb that the dwelling is located at Rooms The number of rooms (bedrooms and study areas) in the dwelling Type the type of dwelling (1 = House, 2 = Apartment, 3 = Townhouse) Price the selling price ($) of the dwelling Distance the distance the suburb is from the City Centre (Melbourne) in km Bedroom the number of specific bedrooms in the house Bathroom the number of bathrooms in the house (1 = 1 bathroom, 2 = 2 bathrooms, 3 = 3 or more bathrooms) Car the number of car spaces at the dwelling (0 = no car spaces, 1 = 1 car space, 2 = 2 car spaces, 3 = 3 or more car spaces) Landsize size of the land the dwelling is situated on in square metres BuildingArea The size of the building (dwelling) in square metres Year the year the dwelling was built (1 = Built prior to 1920, 2 = built between 1920 and 1970, 3 = Built after 1970) Question 1 (5 marks) (Module 1) Google bad graph. From any of