What is the AirBNB price distribution of private room

Assignment Help Other Subject

Reference no: EM132418491

BUS708 Statistics and Data Analysis - Excel Report Assignment, King's Own Institute, Australia

OVERVIEW OF THE ASSIGNMENT - This assignment will test your skill to collect, summarise and present data using Microsoft Excel and/or other approved tools. It will also test your understanding to interpret the output produced by the software to solve business problems.

You will need to use the dataset provided as well as collecting your own dataset and produce a numerical and graphical summary.

Your tasks are to provide a description for each dataset in Section 1, and to answer the following research questions given in Section 2 to Section 6 using dataset 1 or dataset 2 as indicated in each section.

1. Section 1: Description about Data

a. Dataset 1: Give a short but clear description about this dataset. Is this primary or secondary data? What are the cases? How many variables are there in the dataset?

b. Dataset 2: Explain how you collect the data and discuss its limitation (e.g. whether your sample is biased). Is this primary or secondary data? What are the variables and their types?

2. Section 2: What are the proportions of different room types of AirBNB in Sydney?

Using Dataset 1, describe the proportion of the different room types available for rent in Sydney AirBNB. You need to provide the frequency and the proportion (either as a decimal or a percentage) as well as graphical display that easily shows the proportion of the room types.

3. Section 3: What is the AirBNB price distribution of private room after an iteration of outlier removal?

Using Dataset 1, perform one iteration of outlier detection on the price of private rooms using the method described in the lecture notes. After removing those outliers, describe the price distribution of private rooms using both numerical and graphical summary which shows the remaining outliers, if any.

4. Section 4: Is there a difference in the number of available days in the next 365 days among different room types?

Using Dataset 1, describe the distribution of availability for 365 days in the future, for each room type. You need to provide both numerical summary as well as graphical display which shows the outliers, if any.

5. Section 5: Is there any relationship between Longitude and Price?

Using Dataset 1, describe the relationship between the longitude of an AirBNB property location and its price. You need to provide both numerical summary as well as graphical display.

6. Section 6: Is there any relationship between gender and room type accommodation?

Using Dataset 2, describe the relationship between the gender of an international student and their current room type accommodation, e.g. whether the student currently shares a room, lives in a private room (but shares an apartment or a house) or lives in an apartment or a house by him/herself. You need to provide both numerical summary and graphical display.

Attachment:- Assignment & Data Files.rar

Reference no: EM132418491

Questions Cloud

What is the unit product cost for the month : What is the unit product cost for the month under variable costing? What is the unit product cost for the month under absorption costing?

Investigation into Cancers : Describe to the audience the characteristics of a cancer cell. What mechanisms does our body have in place to protect us and avoid the development of cancer?

During ejaculation : During ejaculation, millions of sperm are deposited into the female's vagina.

Ethics in health care : Using Levitt-Rosenthal's 2013 article, Ethics, Values, and Decision Making from your readings. Relate ideas expressed in the article to your own experiences.

What is the AirBNB price distribution of private room : What is the AirBNB price distribution of private room after an iteration of outlier removal? Describe proportion of different room types available for rent

What is its weighted average cost of capital : Assume that a not-for-profit company has $17 million of long-term tax-exempt debt with an interest rate of 3.5%. The organization

Act as a judge and offer a decision on the case : Act as a judge and offer a decision on the case, given the facts and the constitutional precedent - Guinninvs Superintendent of Mockingbird High

What are the excess capacity costs : If so, what are the excess capacity costs? How can Dr. Meara reduce the costs of excess capacity? More generally, should Dr. Meara try to reduce the costs of ex

Compare the annual population growth rate of both countries : Compare the annual population growth rate of both countries. What factors do you think are contributing to the differences observed between the two countries?

User Account

All Pages