Question

In: Advanced Math

Question C [SD1: 5 Marks]             A multiple regression analysis between yearly income (Y in $1,000s),...

Question C [SD1: 5 Marks]

            A multiple regression analysis between yearly income (Y in $1,000s), college grade point average (X1), age of the individuals (X2), and the gender of the individual (X3; zero representing female and one representing male) was performed on a sample of 10 people, and the following results were obtained.

Coefficients

Standard Error

Intercept

  4.0928

1.4400

    X1

10.0230

1.6512

    X2

  0.1020

0.1225

    X3

-4.4811

1.4400

ANOVA

DF

SS

MS

F

Regression

360.59

Residual (Error)

Required:

  23.91

1-

Interpret the meaning of the coefficient of X3.

2-

Is the coefficient of X3 significant? Use a = 0.05.

3-

Perform an F test and determine whether or not the model is significant.

Solutions

Expert Solution

The regression equation will be

Here n=10, k=3

1. Interpret the meaning of the coefficient of

ans-

The male's income is lower then the female's income

that is, if the gender is male then the income reduces to

2. Is the coefficient of significant? use

ans-

Here total sample size n=10

For t-test degree of freedom will be n-k-1=10-3-1=6

so for 6 degree of freedom and 0.005 level of critical value of t=2.447

so reject null hypothesis if or

Null hypothesis

Alternative hypothesis

coefficient / standard error

Here the the critical value so reject

coefficient of is significant.

3. Perform an F test and determine whether or not the model is significant.

ans-

MS regression=SS regression / DF regression

=360.59/3

=120.1967

MS residual=SS residual / DF resudual

=23.91/6

=3.985

F=MS regression / MS residual

=120.1967/3.985

=15.08

For 0.05 level and 3,6 degree of freedom critical value F=4.757

so null hypothesis will be rejected if

ANOVA
DF SS MS F
regression k=3 360.59 120.1967 30.1622
residual n-k-1=6 23.91 3.985
9 384.5

Here 30.1622 is greater then the critical value.

Model is significant.


Related Solutions

A multiple regression analysis between yearly income (y in thousands of dollars), college grade point average...
A multiple regression analysis between yearly income (y in thousands of dollars), college grade point average (X1), age of the individuals (X2 in years), and the gender of the individual (X3: 0 representing female and 1 representing male) was performed on a sample of 10 people, and the following results were obtained. Coefficients Standard of Error Intercept 4.0928 1.4400 x1 10.0230 1.6512 x2 0.1020 0.1225 x3 -4.4811 1.4400 ANOVA Source of Variation DF Sum of Squares Mean Square F Regression...
Question 3 (10 marks) A student used multiple regression analysis to study how family spending (y)...
Question 3 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 Coefficients Standard Error Intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 Write out the estimated regression equation for the relationship between the variables....
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
QUESTION 3 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 3 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
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...
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...
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....
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals...
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals with their age (x1) and their gender (x2) (0 if male and 1 if female). Ŷ = 30 + .7x1 + 3x2 Also provided are SST = 1200 and SSE = 384. The test statistic for testing the significance of the model is
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals...
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals with their age (x1) and their gender (x2) (0 if male and 1 if female). Ŷ = 30 + .7x1 + 3x2 Also provided are SST = 1200 and SSE = 384. If we want to test for the significance of the model, the critical value of F at α = .05 is a. 3.33. b. 3.35. c. 3.34. d. 2.96.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT