Adila Group of Companies is a research firm established in Melbourne CBD. They mainly provide their service to real estate investors. Assume your group is the data analytics team on Adila Group of Companies. Based on that assumption, access any of the following websites and a report is to be made based on the requirements listed below. Websites https://www.realestate.com.au/ https://www.domain.com.au/ Requirements: 1. Access rental property details from one of the above online sources, select a specific state (NSW, QLD, SA, TAS. VIC or WA), and prepare a data table with a minimum of 50 observations Variable required a. Weekly rent b. Number of bedrooms (minimum of 10 property details in each for houses with 1, 2, 3 and 4 bedrooms) c. Number of car space d. Number of bathrooms e. Date Available f. Bond g. Hyperlink for the selected rental property Note: use the most recent data, share the details on data sources and are not allowed to use hypothetical data. 2. Perform descriptive statistical analysis and prepare a table with the following descriptive measures for the Weekly rent variable in data set. Mean, median, mode, variance, standard deviation, skewness, kurtosis, coefficient of variation. 3. Critically review the descriptive statistics in part (2) and explain the nature of the distribution of those variables. 4. Derive a suitable graph to represent the relationship between weekly rent and other variables in your data set. (Relationship between weekly rent and no of bedrooms, the relationship between weekly rent and no of car space, the relationship between weekly rent and no of bathrooms) 5. Based on the data set, perform a correlation analysis between Weekly rent, No of bedrooms, No of car space, and No of bathrooms. 6. Comment on the observed trends between variables based on the answer for Q4 and Q5. 7. Based on the data set, perform a simple regression analysis to assess whether no of bedrooms is a determinant of weekly rent and answer the questions below a. Derive the simple regression equation and Interpret the meaning of all the coefficients. b. Interpret the coefficient of determination.

Collection of the data set which meets the given guidelines (Q1) 5 marks Preparation of descriptive statistical table for the weekly rental variable (Q2) 4 marks A critical review of calculated descriptive statistics (Q3) 4 marks Derive Suitable graphs for an analysis of the relationship between variables(Q4) 3 marks Correlation analysis 3 marks Critical review of relationship between variables based on answers in Q4 and Q5. (Q6) 3 marks Deriving simple regression output using excel 3 marks Deriving simple regression equation based on the regression output and interpretation 5 marks of regression coefficients Interpretation of coefficient of determination. 4 marks