Call Back

World's Leading Assignment Library



MIS770A – Foundation Skills in Data Analysis

Question Preview

Questions1. RelationshipsTo answer part (a), construct contingency tables (also called cross tabulations) for HousePrice versus the independent variable Suburb.(a) Is there any relationship between HousePrice and Suburb?To answer parts (b) and (c), construct 3 scatter diagrams (that show Trendlines and R2) for HousePrice versus each of the following independent variables (LandSizeSqm, HouseAreaSqm, WeeklyRent).(b) Do the independent variables have any linear or non-linear relationships with HousePrice?(c) Which independent variable has the strongest relationship with HousePrice?2. Regression AnalysisTo answer part (a), create a regression model with HousePrice as the dependent variable and HouseAreaSqm as the independent variable(a) Estimate the HousePrice where HouseAreaSqm was 500 square

Answer Preview

 Question 1a

To determine relationship between House Price and Suburb, the contingency tables (also called cross tabulation is constructed. For the given dataset including house price and suburb, the contingency table is constructed (See: Excel). From the contingency table, it can be depicted that there is no significant relationship between house price and suburb (Weiers, 2010). It is because there is no increasing or decreasing pattern in the house prices along with the suburbs. Houses with different prices are present in different suburbs.  

Question 1b

To determine linear or non-linear relationships of the independent variables with House Price, scatter diagrams showing trendline and R2 are constructed. The scatter diagram shows that there is a positive relationship between house price and land size (See: Excel). The data points in plot appear to be randomly distributed as they are not close to the line (Groebner et al., 2011). Apart from this, in the scatter diagram between house price and house area, it can be determined that shows that there is a positive relationship between both variables as R square is 0.317 but it is not a strong relationship (See: Excel). It is because the data points in plot appear to be randomly distributed as they are not close to the line. In addition, the scatter diagram also shows that house price and weekly rent show a positive and weak relationship (See: Exce

question Get solution

$ 15.00

Orginal Price : $ 20.00

Pay Now to get Assignments