Question

In: Statistics and Probability

The following table contains results from the regression of sales price (y) on lot size (x1),...

The following table contains results from the regression of sales price (y) on lot size (x1), number of bedrooms (x2), number of bathrooms(x3) and number of storeys (x4). Sales price is the dependent variable and x1,x2,x3,x4 are independent variables.

R2 = 0.54

F= stat = 48.3235

p value and F - stat of 1.18E - 88

n > 30.

a. Write down the least square prediction equation

b.use R2 to check the validity of the model.

c use " t-stat" to check the validity of the coefficient at 5 % sig. level

d.use P value to check the validity of the coefficient at 1% sig level

e verbally explain each coefficient

f. check the validity of the model at 5% sig level ( use F stat and its P value )

Solutions

Expert Solution

a. The least square prediction equation for y using the 4 predictors can be expressed as:

b. The coefficient of determination R2 = 0.54.It implies that the 4 predictors together explains about 54% variation in y. It suggests a moderately efficient fit to the data.

c. The t-statistic for testing the significance of the slope corresponding to each of the 4 each of the 4 predictors tests the hypothesis:

Vs

If the test statistic t exceeds the critical value, ( |t| > t), we may reject H0 at % level of significance.We may then conclude that 'i' is significant in predicting the response 'y'.

d. If the p-value of the slope coefficient for the predictor is less than the significance level, we may reject H0 at % level of significance.

e. The coefficient of determination is a measure to validate the model and test its goodness of fit to the data.It gives the amount of variation in y that is explained by the predictors of the model.It ranges from 0 to 1.The higher the R2, the better the model)

The t test statistic and the p- value are the measures using which conclusions are drawn as to whether the coefficient or the test is significant or not.

f. Comparing the F statistic with the critical value, obtained from F table, and looking at the p value 0.000<0.05, we may conclude that the model is significant at 5% level.

It may be inferred that the predictors contribute significantly towards explaining the response variable through this linear model.


Related Solutions

Lot Price Data Lot Price is lot price in $1000s Lot Size is lot size in...
Lot Price Data Lot Price is lot price in $1000s Lot Size is lot size in 1000s of square feet Mature Trees is the number of mature trees on the property Distance from Water is the distance from the edge of property to the water in feet Distance from Road is the distance from the main road to the center of the property in miles Lot Price Lot Size Mature Trees Distance from Water Distance from Road 105.4 41.2 24...
A regression model between sales (y in $1000), unit price (x1 in dollars), and television advertisement...
A regression model between sales (y in $1000), unit price (x1 in dollars), and television advertisement (x2 in dollars) resulted in the following function: ​ = 7 - 3x1 + 5x2​ ​ For this model, SSR = 3500, SSE = 1500, and the sample size is 18. At the 5% level, options: there is no evidence that the model is significant. the conclusion is that the slope of x1 is significant. it can be concluded that the model is significant....
The following is part of the results of a regression analysis involving sales (Y in millions...
The following is part of the results of a regression analysis involving sales (Y in millions of dollars), advertising expenditures (X1 in thousands of dollars), and number of salespeople (X2) for a corporation. The regression was performed on a sample of 10 observations.                                     Coefficient         Standard Error        t value             p value             Constant            -11.340                   20.412                  X1                      0.798                     0.332                2.404               0.0345                  X2                      0.141                     0.278                0.507               0.2305 a.   Write the regression equation.             b.   Interpret the coefficients of the...
The following is part of regression output produced by Excel ( for Y vs X1 and...
The following is part of regression output produced by Excel ( for Y vs X1 and X2): Y 12.9 6.1 1.1 39.7 3.4 5.9 8.9 15 7.3 X1 0.9 0.8 1.0 0.3 0.4 0.7 0.71 0.5 0.9 X2 4.2 3.1 1.2 15.7 2.5 0.7 5.0 6.4 3.0 A) write out the estimated regression equation showing that depends on X1 and X2. b)if. X1=0.58 and X2=7.0, what is the value predicted for y c)write the number which is the standard error...
Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7...
Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7 y-intercept =3.2 n=10 SE=4.3 The equation of the regression line is …… and 95% confidence interval for the slope is…. (A)Y=3.2+12.7X, and (3.675,12.768) (B)Y=12.7+3.2X, and (2.784,12.745) (C)Y=3.2+12.7X, and (2.784,22.616)
Regression Project: Data The table below contains the price, demand, and total cost data for the...
Regression Project: Data The table below contains the price, demand, and total cost data for the production of x widgets. Here p is the price (in dollars) of a widget for an annual demand of x widgets, and C is the annual total cost (in dollars) of producing x widgets per year. Demand x (widgets) Price p ($/widget) Total Cost C ($) 10 141 609 20 133 1103 30 126 1618 40 128 2109 50 113 2603 60 97 3111...
) Consider the following regression results based on 30 observations. y = 238.33 – 0.95x1 +...
) Consider the following regression results based on 30 observations. y = 238.33 – 0.95x1 + 7.13x2 + 4.76x3; SSE = 3,439 y = 209.56 – 1.03x1 + 5.24(x2 + x3); SSE = 3,559 a. Formulate the hypotheses to determine whether the influences of x2 and x3 differ in explaining y. b. Calculate the value of the test statistic. c. At the 5% significance level, find the critical value(s). d. What is your conclusion to the test?
For the table below, if Y is the dependent variable and X1 and X2 are the...
For the table below, if Y is the dependent variable and X1 and X2 are the independent variables. Using the linear regression equation Y=-0.45X1-1.34X2+15.67, which observation has the largest absolute residual? Observation number Actual Y x1 X2 1 4.5 6.8 6.1 2 3.7 8.5 5.1 3 5 9 5 4 5.1 6.9 5.4 5 7 8 4 6 5.7 8.4 5.4 The first observation The third observation The fifth observation The second observation
For the table below, if Y is the dependent variable and X1 and X2 are the...
For the table below, if Y is the dependent variable and X1 and X2 are the independent variables. Using the linear regression equation Y=-0.45X1-1.34X2+15.67, find the Sum of Squared Residuals? (choose the best answer) Observation number Actual Y x1 X2 1 4.5 6.8 6.1 2 3.7 8.5 5.1 3 5 9 5 4 5.1 6.9 5.4 5 7 8 4 6 5.7 8.4 5.4 2.57 2.97 3.2 3.5
Y^ = b0 + b1X1 The following table shows the calculations for regression line: The following...
Y^ = b0 + b1X1 The following table shows the calculations for regression line: The following table shows the calculations for regression line: Customers (in 1000s), X Line Maintenance Expense (in $1000s), Y X^2 Y^2 XY 25.3 484.6 640.09 234837.16 12260.38 36.4 672.3 1324.96 451987.29 24471.72 37.9 839.4 1436.41 704592.36 31813.26 45.9 694.9 2106.81 482886.01 31895.91 53.4 836.4 2851.56 699564.96 44663.76 66.8 681.9 4462.24 464987.61 45550.92 78.4 1037 6146.56 1075369 81300.8 82.6 1095.6 6822.76 1200339.36 90496.56 93.8 1563.1 8798.44 2443281.61...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT