since t ratio =Coefficient/standard error
from excel : p value =tdist(t-ratio,23,2)
from given data:
Y^ = | 32.778+ | 2.035X1 - | 3.385 X2+ | 3.120 X3 | |
2.421 | 0.945 | 1.874 | 2.025 | standard error | |
13.539 | 2.153 | -1.806 | 1.541 | t-ratios | |
0.042004 | 0.083976 | 0.1370 | p value |
Complete the missing information for this regression model. Note: N = 27. Y = 32.778 +...
A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X4 = 2005 high school graduation percentage. (a) Fill in the values in the table given here for a two-tailed test at a = 0.01 with 33 d.f. (Negative values should be indicated by a minus...
A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X4 = 2005 high school graduation percentage. (a) Fill in the values in the table given here for a two-tailed test at α = 0.01 with 31 d.f. (Negative values should be indicated by a minus...
Assume that you are building a regression model of the form y = beta0 + beta1 x1 + beta2 x2 + beta3 x3 + E where E is the random error term which is assumed to be normally distributed with mean 0 and constant variance. Data from 16 subjects are collected for the purpose of this study. The R-Square value from the model is 0.60 and the total sums of squares variation is 1000. What is the p-value of the...
Consider a multiple regression model of the dependent variable y on independent variables x1, X2, X3, and x4: Using data with n 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: y0.35 0.58x1 + 0.45x2-0.25x3 - 0.10x4 He would like to conduct significance tests for a multiple regression relationship. He uses the F test to determine whether a significant relationship exists between the dependent variable and He uses the t...
4. Testing for significance Aa Aa Consider a multiple regression model of the dependent variable y on independent variables x1, x2, X3, and x4: Using data with n = 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: 0.04 + 0.28X1 + 0.84X2-0.06x3 + 0.14x4 y She would like to conduct significance tests for a multiple regression relationship. She uses the F test to determine whether a significant relationship exists...
Using 17 observations on each variable, a computer program generated the following multiple regression model: ŷ = 88.2 +7.03x, + 1.69x2 - 9.84x, If the standard errors of the coefficients of the independent variables are, respectively, 4.78, 0.92, and 3.38 can you conclude that the independent variable X, is needed in the regression model? Let B. By, and B, denote the coefficients of the 3 variables in this model, and use a two-sided hypothesis test and significance level of 0.05...
Section 12.3 Multiple Linear Regression: Number ONE: Statistical software was used to fit the model E(y)Pox1 2x2 to n 20 data points. Complete parts a through h EEB Click the icon to see the software output. Data Table The regression equation is Y-1738.93 - 384.54x1 517.39x2 Predictor Constant X1 X2 Coef 1738.93 - 384.54 -517.39 SE Coef 369.06 101.65 - 3.78 0.002 353.04 - 1.47 0.162 4.71 0.000 s-172.003 R-sq-55.0% R-sq(adj):49.0% Analysis of Variance MS Source Regression Residual Error 17...
ek-tin Based on the following regression output, what proportion the total variation in Y is explained by X? Regression Statistics Multiple R 0.917214 R Square 0.841282 Adjusted R Square 0.821442 Standard Error 9.385572 Observations 10 ANOVA di SS MS Significance F 1 Regression 3735.3060 3735.30600 42.40379 0.000186 Residual 8 704.7117 88.08896 9 Total 4440.0170 Coefficients Standard Error t Stat P-value Lower 95% Intercept 31.623780 10.442970 3.028236 0.016353 7.542233 X Variable 1.131661 0.173786 6.511819 0.000186 0.730910 o a. 0.917214 o b.9.385572...
7 Consider the following regression output involving the variables y and, rı, r2. (note log is the natural logarithm as usual) 4.12 0.88 r Model A: Model B: log(y)0.34 0.14 + 0.001 2 Model C: logly)2011.4 log()0.02 r2 0.06 Model D: Model E: y = 5.4 + 0.82i --3.4 55.1 log(0.020 2 + 1.2r2 0.2 (1x2) Ceteris Paribus: (a) In Model A: If x1 increases 6 to 8 by 2 units, then the predicted change in y is Δy =...
*ANSWERS IN BOX ARE INCORRECT* Consider the following ANOVA table for a multiple regression model. Complete parts a through e below. Source Regression 3 3,600 1200 20 Residual 35 2,100 60 Total df SSMSF 38 5,700 a. What is the size of this sample? n41 b. How many independent variables are in this model? c. Calculate the multiple coefficient of determination. R0.5882 Round to four decimal places as needed.) d. Test the significance of the overall regression model using α=0.05...