Loading...

Messages

Proposals

Stuck in your homework and missing deadline?

Get Urgent Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework Writing

100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Discussion on Use the estimate, constructed in Question 1, for the population proportion of residential properties for sale which are units, to address your relative’s concern that their choice will be limited if they restrict their search to units.

Category: Education Paper Type: Online Exam | Quiz | Test Reference: APA Words: 1350

All the quantitative data is arranged in the form of the table under the relevant headings of "price", number of bedrooms, number of bathrooms, and type of residential option. According to the case scenario, relative is interested to purchase the property under the identified budget. Therefore, only selecting units from the available property options rather than including houses will limit the search options. In the available data, only 37 property options fall in the category of unit. While the rest of all relates to the category of the house. Somehow, to test this scenario two hypotheses are developed which will be used in the statistical testing process and population proportion analysis. Thus, the analysis and testing suggest that the hypothesis is true and the chances of error in testing are low. Conclusively, it can be said that by creating a restriction of units search will be limited for relative.  

Question 2

100 to 200 words and 0.5 to 1 page

Use your answer to Question 2:

In the location specified by your sample, is the mean two and three bedroom residential property price more than $330,000?

to answer your relative’s question. That is, is the location too expensive?

The mean price for all available options regarding the property such as units and houses is around $306,435 by including all options for houses and units. The average is calculated by adding up all prices and then dividing the answer by the total number of options.

Somehow, the mean price of units is around 285, 916 (or 278 thousand). However, the mean price for the houses is almost $340,995. See the following table (in appendix) for calculated mean values for available property types in the selected locality.

In the presented table (see appendix), the specific mean prices represent the average price demanded by the property owners offering 2 to 3 bedrooms in units or houses of the selected locality. Total available option regarding this specification is a total of 69 out of the 100 collected property options. Considering these values for testing expensiveness it can be said that average prices for houses are greater than units. Thus, calculation suggests that houses are expensive as compared to units. Projecting on results, the locality is really expensive.

Question 3

100 to 200 words and 0.5 to 1 page

Use your estimate for the mean difference in price between units and houses for sale in the location specified by your sample, constructed in Question 3, to answer your relative’s question. That is, how much they would save if they purchased a unit instead of a house.

The estimate and statistical analysis represent a huge difference in price between houses and units for sale in the specified location by the relative. Considering the calculation of mean prices for the 2 and 3 bedroom property option (including both houses and units) is greater than the maximum budget of the relative. According to the case scenario, the relative has a total budget of $330, 000 in which he is interested to purchase a house or unit with 2 to 3 bedrooms.  

The amount of $330,000 is greater than the mean prices for the property with required features (regarding a total number of rooms). Total 69 properties are having 2 and 3 bedrooms and the average prices for these property options is around $306,435. The total difference between the average price of these properties and budget is limited to $23,565. Although, the difference between the average price of units and the budget is $44,084. Somehow, the average price of houses is greater than the maximum budget as the difference in prices is around $10,995. Thus, if they purchase unit they would save $44,084.

Questions 4 and 5

100 to 300 words and 0.5 to 2 pages

Use the simple and multiple linear regression models developed in Questions 4 and 5 to provide, and justify, a linear model to predict price from several bedrooms and/or number of bathrooms and/or type (house or unit)

·         Include and justify the simple or multiple linear regression model which best fits the data.

·         Discuss and interpret the values of the regression coefficients and coefficient of determination of the best model.

·         Present the results without unnecessary statistical jargon.

Predict price from several bedrooms and/or the number of bathrooms and/or type (house or unit) varies from each other but have a similar trend therefore based on the historical information we can predict the future prices. The multiple linear regression calculated regression and variance in the values based on which further predictions are made. The p-value represents the significance value for hypothesis testing. Somehow, the statistical analysis recommends that an increase in the total number of rooms would also increase prices for the houses and units. See the following best fit line graph inclining towards maximum prices required to have more bedrooms in the property.

 

Appendices for Part B -

Appendix B.1 – Statistical answer for Question 1

 

Considering this now calculating that:

x

37

y

63

n

100

P^x

0.37

p^y

0.63

Confidence Intervals for Population Proportion

CI [1-a)-100%

Area in Tail

CV for (z a/2)

90%

0.05

1.645

95%

0.025

1.96

99%

0.005

2.575

Upper Bound and Lower Bound of Normal distribution.

90%

Upper Bound

0.079421309

Lower Bound

0.290578691

95%

Upper Bound

0.464629644

Lower Bound

0.275370356

99%

Upper Bound

0.494322109

Lower Bound

0.245677891


Appendix B.2 – Statistical answer for Question 2   

 

Indicators

Amount

Mean of Prices [Units]

$             278

Specific unit mean Price

$      285,916

Mean of Prices [Houses]

$             491

Specific houses mean price

$      340,995

Total Average

$             306 435

Cheaper option

Units

 

Appendix B.3 Statistical answer for Question 3

 

Maximum Amount for purchase

 $      330,000

2&3 bedroom residential options

 $               69

Difference Between Price of Unit

 $        44,084

Difference Between Price of House

 $      (10,995)

Difference between prices and budget

 $        23,565

 

Appendix B.4 Statistical answers for Questions 4 and 5

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.724124519

R Square

0.524356319

Adjusted R Square

0.519502812

Standard Error

135.6016128

Observations

100

ANOVA

 

df

SS

MS

F

Significance F

Regression

1

1986554.85

1986555

108.0366

1.69182E-17

Residual

98

1802004.144

18387.8

Total

99

3788558.994

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

77.25367972

34.96231093

2.209627

0.029459

7.872111538

146.6352

7.872112

146.6352

X Variable 1

97.08820878

9.340735258

10.39406

1.69E-17

78.55182366

115.6246

78.55182

115.6246

 

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.816396876

R Square

0.666503859

Adjusted R Square

0.656082104

Standard Error

114.7220284

Observations

100

ANOVA

 

df

SS

MS

F

Significance F

Regression

3

2525089.188

841696.4

63.95313

8.29672E-23

Residual

96

1263469.806

13161.14

Total

99

3788558.994

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

120.9457878

43.04285467

2.809892

0.006006

35.50639656

206.385179

35.50639656

206.385179

Number of Bedrooms

25.78817279

13.8612428

1.860452

0.065883

-1.7261767

53.30252229

-1.7261767

53.30252229

Number of Bathrooms

134.2159566

22.19347273

6.047542

2.82E-08

90.16226139

178.2696518

90.16226139

178.2696518

Type

-106.2046102

30.45083719

-3.48774

0.000737

-166.6490443

-45.76017609

-166.6490443

-45.76017609

 

Assumptions and Variables Defined

Question 4 Simple Linear Regression Model

The simple linear regression model only includes two variables: one independent and second dependent variable. Simple linear regression only represents a linear relationship or non-linear trend between quantitative data for research variables. In the linear regression model, regression coefficients are determined by considering the specification of research variables.

Question 5 Multiple Linear Regression Model

In this calculation, the independent variables are the total number of bedrooms, the total number of bathrooms, and house types. Somehow, dependent variables are prices for the units and houses in the selected area. The regression analysis is used to test a hypothesis about the impact of independent variables on the dependent variable (prices of units and houses). The greater values of coefficient indicate a strong relationship between prices and independent variables (total number of bedrooms, the total number of bathrooms, and house types). 

Our Top Online Essay Writers.

Discuss your homework for free! Start chat

Buy Coursework Help

ONLINE

Buy Coursework Help

1617 Orders Completed

Engineering Help

ONLINE

Engineering Help

1176 Orders Completed

Instant Homework Helper

ONLINE

Instant Homework Helper

6006 Orders Completed