Question

In: Statistics and Probability

Multiple regression analysis was used to study the relationship between a dependent variable, y, and four...

Multiple regression analysis was used to study the relationship between a dependent variable, y, and four independent variables; x1, x2, x3, and x4. The following is a partial result of the regression analysis involving 31 observations.

Coefficients

Standard Error

Intercept

18.00

6.00

x1

12.00

8.00

x2

24.00

48.00

x3

-36.00

36.00

x4

16.00

2.00


ANOVA

df

SS

MS

F

Regression

125

Error

Total

760

a) Compute the multiple coefficient of determination.

b) Perform a t test and determine whether or not β1 is significantly different from zero (α = .05).

c) Perform a t test and determine whether or not β4 is significantly different from zero (α = .05).

d) At α = .05, perform an F test and determine whether or not the regression model is significant.

Solutions

Expert Solution

Solution: To find the answers to part a through d, we need to complete the given tables. The tables are filled as:

ANOVA:

The p values are found using the t distribution for

a) Compute the multiple coefficient of determination.

Answer: The multiple coefficient of determination is given below:

rounded to four decimal places

b) Perform a t test and determine whether or not β1 is significantly different from zero (α = .05).

Answer: The null and the alternative hypotheses are:

The test statistic from the above table is:

And the is:

Since the p-value is greater than the significance level 0.05, therefore we fail to reject the null hypothesis and conclude that β1 is not significantly different from zero

c) Perform a t test and determine whether or not β4 is significantly different from zero (α = .05).

Answer: The null and the alternative hypotheses are:

The test statistic from the above table is:

And the is:

Since the p-value is less than the significance level 0.05, therefore we reject the null hypothesis and conclude that β4 is significantly different from zero.

d) At α = .05, perform an F test and determine whether or not the regression model is significant.

Answer: The null and the alternative hypotheses are:

At least one coefficient is different from 0.

The test statistic from the above ANOVA table is:

And the using the F distribution for is:

Since the p-value is less than the significance level 0.05, therefore we reject the null hypothesis and conclude at least one coefficient is significantly different from zero.


Related Solutions

Multiple Regression Analysis was used to find out which X variable have relationship with my Y...
Multiple Regression Analysis was used to find out which X variable have relationship with my Y variable (reduce overspending on food and beverage), and how strong relationship is.FIT A FIRST ORDER AUTO AGGRESSIVE MODEL (AR(1) USING Y(T) AS THE RESPONSE VARIABLE Y (T-1) AS THE INPUT VARIABLE. RECORD THE REGRESSION EQUATION. CALCULATE THE EXPONENTIAL SMOOTHING MODELS AND CALCULATE A MOVING AVERAGE MODEL. 4-Mar $31.69 5-Mar $4.19 5-Mar $19.01 5-Mar $7.99 6-Mar $3.32 6-Mar $57.11 7-Mar $4.07 8-Mar $2.49 8-Mar $6.30...
Estimate a multiple linear regression relationship with the U.K. stock returns as the dependent variable, and...
Estimate a multiple linear regression relationship with the U.K. stock returns as the dependent variable, and U.K. Corporate Bond yield (Interest rate), U.S. Stock Returns, and Japan Stock Returns as the independent variables using the monthly data covering the sample period 1980-2017 (Finding the determinants of U.K. stock returns). Show the estimated regression relationship Conduct a t-test for statistical significance of the individual slope coefficients at the 1% level of significance. Provide the interpretation of the significant slope estimates. Conduct...
Multiple regression analysis was used to study how an individual's income (Y in thousands of dollars)...
Multiple regression analysis was used to study how an individual's income (Y in thousands of dollars) is influenced by age (X1 in years), level of education (X2 ranging from 1 to 5), and the person's gender (X3 where 0 =female and 1=male). The following is a partial result of a computer program that was used on a sample of 20 individuals. Coefficient    Standard Error              X1 0.6251 0.094              X2 0.9210 0.190              X3 -0.510 0.920 Analysis of Variance...
A student used multiple regression analysis to study how family spending (y) is influenced by income...
A student used multiple regression analysis to study how family spending (y) is influenced by income (x1), family size (x2), and additions to savings (x3). The variables y, x1, and x3 are measured in thousands of dollars. The following results were obtained. Anova df ss regression 3 45.9634 residual 11 2.6218 Total coefficient Standard error intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 Calculate the estimated regression equation for the relationship between the variables,coefficient of determination. What...
A student used multiple regression analysis to study how family spending (y) is influenced by income...
A student used multiple regression analysis to study how family spending (y) is influenced by income (x1), family size (x2), and additionsto savings(x3). The variables y, x1, and x3 are measured in thousands of dollars. The following results were obtained. ANOVA df SS Regression 3 45.9634 Residual 11 2.6218 Total Coefficients Standard Error Intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 a. Write out the estimated regression equation for the relationship between the variables. (1 mark) b....
What type of relationship between a dependent and independent variable is described by linear regression? A....
What type of relationship between a dependent and independent variable is described by linear regression? A. An exponential relationship B. A parabolic relationship C. A threshold effect D. A linear relationship
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? (2 Points) 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. (2...
Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables...
Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which...
Estimate a multiple linear regression relationship with the U.K. stock returns as the dependent variable (intercept), and RBUK, U.S.
SUMMARY OUTPUT Regression Statistics Multiple R 0.727076179 R Square 0.528639771 Adjusted R Square 0.525504337 Standard Error 3.573206748 Observations 455 ANOVA df SS MS F Significance F Regression 3 6458.025113 2152.67504 168.601791 2.7119E-73 Residual 451 5758.280717 12.7678065 Total 454 12216.30583 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 99.0% Upper 99.0% Intercept -0.250148858 0.359211364 -0.6963835 0.48654745 -0.9560846 0.45578693 -1.1793476 0.67904987 RBUK 0.025079378 0.023812698 1.05319345 0.29281626 -0.0217182 0.07187699 -0.0365187 0.08667745 RSUS 0.713727515 0.042328316 16.8617037 8.0578E-50 0.6305423 0.79691273 0.60423372 0.82322131...
A regression line describes the relationship between the dependent and independent variables and can be used...
A regression line describes the relationship between the dependent and independent variables and can be used to estimate specific points for x or y, provided an individual is supplied with the values of all the other variables but one. true or false
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT