Posted: February 17th, 2022

statistics

use information (hooked up) to resolve the next questions utilizing Excel 

(1) Get rid of duplexes and properties with costs over $850,000 from the info. Get rid of non- numeric variables and redundant variables from the info.

(2) Which variable correlates most strongly with value? 

(three) Discover the regression line Y = β0 + β1x with the variable chosen within the earlier drawback. [The lm function in R or the Analysis ToolPak add-in for Excel will do ]

For the remaining issues, contemplate the next variables related to every property.
x1 = variety of bedrooms x2 = variety of bogs x3 = variety of tales
x4 = sq. footage
x5 = home has pool?

(four) Assemble the multivariable least squares mannequin with predictors x1, x2, x3, x4, x5. [First, con- vert x5 to binary.]

(5) Use a speculation take a look at to find out if the mannequin is beneficial for predicting house values at a stage α. State the p-value and interpret.

(6) Are any variables not helpful predictors of house value at significance stage α = zero.05? State the p-values of any rejected variables. What does this imply virtually?

Order | Check Discount