use data (attached) to solve the following questions using Excel?
use data (attached) to solve the following questions using Excel (1) Eliminate duplexes and properties with prices over $850,000 from the data. Eliminate non- numeric variables and redundant variables from the data.(2) Which variable correlates most strongly with price? (3) Find the regression line Y = β0 + β1x with the variable chosen in the previous problem. [The lm function in R or the Analysis ToolPak add-in for Excel will do ]For the remaining problems, consider the following variables associated with each property.x1 = number of bedrooms x2 = number of bathrooms x3 = number of storiesx4 = square footagex5 = house has pool?(4) Construct the multivariable least squares model with predictors x1, x2, x3, x4, x5. [First, con- vert x5 to binary.](5) Use a hypothesis test to determine if the model is useful for predicting home values at a level α. State the p-value and interpret.(6) Are any variables not useful predictors of home price at significance level α = 0.05? State the p-values of any rejected variables. What does this mean practically?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.