Home /
Answered Questions /
Business data analytics /
business-data-analytics-jmp-tableau-excel-create-pricing-formula-for-renting-airbnb-in-chicago-q-374
(Solved): Business data analytics|jmp|tableau|excel|Create Pricing Formula for renting Airbnb in Chicago...
Task: Create Pricing Formula for renting Airbnb in Chicago.
create a new column in the data where you do a formula that would calculate all the fees together and create a "cost per day" or something that could be used to determine the spectrum of cost for each rental from least to most expensive.
Hypothesis: All areas have the same average cost?
USE DATA: Fees: (cleaning, minimum nights required, security deposit, cancellation fee)
- Use JMP Pro Excel, and Tableau
- Must perform some data cleaning (outlier analysis)
- Test correlations between data variables
- Perform appropriate statistical test (t-test, ANOVA, Regression, Cluster analysis)
Questions
Q1: Is the hypothesis true explain why in a few sentences.
Q2: Use tableau and show the areas with rentals from least to most expensive. Explain in your own words why they are expensive and why they are cheap.
Q3: If hypothesis is not true, explain why its not true in a few sentences.
We have an Answer from Expert
View Expert Answer
Expert Answer
We have an Answer from Expert
Buy This Answer $30
Buy This Answer $30
-- OR --
Subscribe To View Unlimited Answers
Subscribe $20 / Month
Subscribe $20 / Month