I need a function/correlationfactor of the three variables/dimension which show the change of the Median (price) while the three dimensions (pers_capacity, amount of bedrooms, amount of bathrooms) grow. e.g. Y(#pers_capacity,bedroom,bathroom) = ..
- in the screenshot are not all the data available (just a part of it)
- median => price per night
e.g. For 7 persons, 3 bedrooms and 2 bathroom is the median price 249$ per night
Do you have some ideas how I can calculate the correlation/equation (f(..)=...) in order to get a reliable factor? How is it doable on tableau? => I have 3 x-variable (person_cap, bathroom, bedroom) and 1 y-variable (median price).
As per my understanding it is possible in Tableau through calculated fields. You just need to add the formula for calculating the median price.