please show all steps no excel. i do not understand how to do
the regression shit...
Questions 27-30: A prediction model for the selling price (in thousands) of a house is to be developed. It's believed that the selling price is influenced by the assessed values (X1. Assessed, in thousands) of the house, the amount of time it took house to sell (X2. Time, in months) and whether the house is a new house or an old house (K3, Ne house and New-1 an old house). Twenty-five houses are randomly selected and the Microsoft Excel output is provided with New-0 for a new w, below: Coefficients Standard Error t Stat P-value Intercept 30.946 2.7038446 1.19E-11 18.299 2.26E-16 Assessed 0.5173 0.0283 Time New 2.284 0.0308 1.592 0.1235 -0.1644 0.0720 1.0965 0.6888 27) Which of the following equations is the correct multiple regression equation for the data? B) -30.946 0.5173X1-0.1644X2i-1.0965 D) Y-30.946 0.5173X1i-0.1644x2i- 1.0965X3 A) Yi-30.946+0.5173X1 0.1644X2i 1.0965X3i C) Yi-30.946+0.5173X1-0.1644x2 1.0965x3