Reference no: EM132970296 , Length: word count:1600

BUS708 Statistics and Data Analysis - Excel Report

Topic: Rental Properties

TASK DESCRIPTION

There are two datasets involved in this assignment: Dataset 1 and Dataset 2, detailed below.

Dataset 1: This dataset will be sent to your KOI email address by the end of Week 3. Please email the lecturer if you have not received the dataset. This dataset is a subset of Rental bond lodgement data - June 2021, provided by NSW Fair Trading. Note that you will need to use the dataset sent to your email, not the original dataset.

Dataset 2: You will need to collect a dataset to answer your own research question. The details are given in Section 6 below. You will need to collect data from at least 30 international students. The data should have 2 categorical variables that will answer your research question (see Section 6).

Both datasets should be saved in an Excel file (see Submission Requirement on the next page). All data processing should be performed in Excel or other approved tools (this will be communicated during tutorials). Failure to use Excel or approved tools will results in mark deduction.

Your tasks are described below.
1. Section 1: Description about the Datasets
a. Dataset 1: Give a short but clear description (2-3 sentences) about this dataset (e.g. what the dataset is about, where it comes from, is this primary or secondary data).
b. Dataset 2:
i. State your research question.
ii. Give a short but clear description (2-3 sentences) about this dataset (e.g. what the dataset is about, how you collect the data, is this primary or secondary data, is it biased).

2. Section 2: Do you believe that the population proportion of house dwelling type could be 35%?
Using Dataset 1, provide the frequency and the proportion (either as a decimal or a percentage) for each category for the variable Dwelling Type. You also need to provide a graphical display that easily shows the proportion of each category. Finally, write a comment about your findings and answer the question.
3. Section 3: Is the Average Weekly Rent of House in NSW more than $575?
Using Dataset 1, first filter the dataset to include only House dwelling type. Then describe the Weekly Rent distribution of all houses. You need to provide numerical summary (sample size, mean, standard deviation and median) as well as graphical display which shows the outliers, if any. Finally, write a comment about your findings and answer the question.
4. Section 4: Is there a difference in Weekly Rent among four different postcodes in Greater Sydney?
Using Dataset 1, describe the distribution of Weekly Rent (of all types of dwellings) for each of the following postcodes: 2145, 2150, 2155, 2170. You need to provide both numerical summary as well as graphical display which shows any outliers.
Finally, write a comment about your findings (you need to list the suburbs for the corresponding postcode) and answer the question.
5. Section 5: Is there a correlation between the number of bedrooms and the weekly rent of all dwelling types in four postcodes in Greater Sydney?
First, filter Dataset 1 to include only the postcodes 2145, 2150, 2155, 2170. Then describe the relationship between the number of bedrooms and the weekly rent. You need to provide both numerical summary as well as graphical display. Finally, write a comment about your findings and answer the question.
6. Section 6: Exploration of Two Categorical Variables

Suggest a research question around the topic of accommodation, which involves only 2 categorical variables and involves international students. You need to design a survey that consist of only two questions, resulting in two categorical variables.

After collecting the data and store it in Dataset 2, describe the relationship between the two variables. You need to provide both numerical summary and graphical display. Finally, write a comment about your findings and answer your research question.

Report in a single Microsoft Excel document which consists of the original datasets, numerical summaries, graphical displays and comments/conclusion.

Attachment:- Statistics and Data Analysis.rar