Business Statistics and Data Analysis

Do you want a similar paper? Click here to get it from our professional writers!

Business Statistics and Data Analysis

Assignment – Brief 

You have been accepted as an intern in a real estate company based in the heart of Sydney CBD. Your first job is to conduct an analysis of the current state of the Sydney rental market in various suburbs, particularly those with a significant number of international students like Sydney CBD, Ashfield, Strathfield, Parramatta, Epping, Eastwood, Hurstville, Bankstown, Chatswood, and so forth.

  1. Choose 5 different suburbs. For each suburb, collect data of ten 2-bedroom units / apartments for rent from a real estate website (realestate.com.au or domain.com.au). You are to record the following information about each of the 10 units for rent in each suburb:
  2. Number of bedrooms
  3. Number of bathrooms
  4. Dishwasher (yes / no)
  5. Walking distance to nearest train station (in minutes)
  6. Minimum total travel time to Sydney Opera House by public transport (in minutes – according to weekday normal timetables)
  7. Rent per week ($)
  8. Determine and provide explanations for measurement levels of data specified above from (a) to (f).
  9. List and present the data collected in a table by suburb. Also list the source where you obtained the data.
  10. Compute the 5-number summary for the weekly rent for each suburb.
  11. Briefly compare the weekly rent across different suburbs in terms of both central tendency and variability.

Combine data from the 5 chosen suburb in an Excel spreadsheet and use this combined sample to answer the following questions. 

  1. A recent industry report indicates that units with premium weekly rent (more than $500 per week) are more likely to include dishwasher in the property than lower-priced units. Analyse your sample and examine whether it is indeed the case for Sydney. Show the steps in your analysis (including justification for choice of techniques used and all calculations) and report your findings clearly.
  2. It is a common perception that tenants are willing to pay more for properties with easy access to major means of transport like train stations. Explore the relationship between walking distances to train stations and rent per week for two-bedroom units/apartments. Use an appropriate graph and technique (including justification of choice of graph) and report your findings (including all output from Excel and interpretation of results).
  3. Construct a 95% confidence interval for the average weekly rent in Sydney.
  4. Another team based on Melbourne recently conducted a similar analysis for the market in Melbourne and are kind enough to share the data with you. Latest data from the team indicates that the average rent for 2-bedroom units in Melbourne is from $340 to $380 per week with a confidence level of 95%.

How does the confidence interval compare for the two markets (Sydney and Melbourne)? What inference can you draw from this comparison?

  1. A recent study has claimed that the minimum weekly rent for a two-bedroom apartment in Sydney is $650. Use your sample data to test this claim. Report your findings with clear conclusions and all supporting calculations.

Business Statistics and Data Analysis

Assignment – Brief 

You have been accepted as an intern in a real estate company based in the heart of Sydney CBD. Your first job is to conduct an analysis of the current state of the Sydney rental market in various suburbs, particularly those with a significant number of international students like Sydney CBD, Ashfield, Strathfield, Parramatta, Epping, Eastwood, Hurstville, Bankstown, Chatswood, and so forth.

  1. Choose 5 different suburbs. For each suburb, collect data of ten 2-bedroom units / apartments for rent from a real estate website (realestate.com.au or domain.com.au). You are to record the following information about each of the 10 units for rent in each suburb:
  2. Number of bedrooms
  3. Number of bathrooms
  4. Dishwasher (yes / no)
  5. Walking distance to nearest train station (in minutes)
  6. Minimum total travel time to Sydney Opera House by public transport (in minutes – according to weekday normal timetables)
  7. Rent per week ($)
  8. Determine and provide explanations for measurement levels of data specified above from (a) to (f).
  9. List and present the data collected in a table by suburb. Also list the source where you obtained the data.
  10. Compute the 5-number summary for the weekly rent for each suburb.
  11. Briefly compare the weekly rent across different suburbs in terms of both central tendency and variability.

Combine data from the 5 chosen suburb in an Excel spreadsheet and use this combined sample to answer the following questions. 

  1. A recent industry report indicates that units with premium weekly rent (more than $500 per week) are more likely to include dishwasher in the property than lower-priced units. Analyse your sample and examine whether it is indeed the case for Sydney. Show the steps in your analysis (including justification for choice of techniques used and all calculations) and report your findings clearly.
  2. It is a common perception that tenants are willing to pay more for properties with easy access to major means of transport like train stations. Explore the relationship between walking distances to train stations and rent per week for two-bedroom units/apartments. Use an appropriate graph and technique (including justification of choice of graph) and report your findings (including all output from Excel and interpretation of results).
  3. Construct a 95% confidence interval for the average weekly rent in Sydney.
  4. Another team based on Melbourne recently conducted a similar analysis for the market in Melbourne and are kind enough to share the data with you. Latest data from the team indicates that the average rent for 2-bedroom units in Melbourne is from $340 to $380 per week with a confidence level of 95%.

How does the confidence interval compare for the two markets (Sydney and Melbourne)? What inference can you draw from this comparison?

  1. A recent study has claimed that the minimum weekly rent for a two-bedroom apartment in Sydney is $650. Use your sample data to test this claim. Report your findings with clear conclusions and all supporting calculations.

 

Do you want a similar paper? Click here to get it from our professional writers!

Leave a Reply

Your email address will not be published. Required fields are marked *