Question

11. (25 points) A multiple regression analysis is conducted to determine factors that relate to the success of sales associates. The regression is conducted between annual sales (Y in $1,000s), years of experience gion (X3; zero representing USA and 1 representing Canada) was performed on a sample of 29 people, and the following results were obtamed where SSR 84 60 amd SSE 57.5. Standard Coefficient Error Constant X1 X2 X3 40.28 1.36 12.03 1.65 0.121.22 6.481.54 Write the regression equation. Calculate the coefficient of determination and the adjusted coefficient of determination. What percentage variance in the data can be explained by the model? a. b. c. Perform a test to determine whether the model is significant. Report the test statistic and the criteria used in d. Test whether the coefficient of X2 is significant. Report the test statistic and the criteria used in reaching a e. Provide an interpretation for the meaning of the coefficient of X3 in the context of this problem. reaching a conclusion. Use alpha 0.01 conclusion. Use alpha 0.01

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
11. (25 points) A multiple regression analysis is conducted to determine factors that relate to the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A multiple regression analysis between yearly income (Y in $1,000s), college grade point average (X1), age...

    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. Coefficient                  Standard Error Constant                                              4.0928                         1.4400 X1                                                       10.0230                       1.6512 X2                                                       0.1020                         0.1225 X3                                                       -4.4811                        1.4400 Analysis of Variance Source                         DoF                 SoS                  MS                  F Regression ? 360.59...

  • 1. A multiple regression analysis between yearly income (Y in $1,000s), college grade point average (X1),...

    1. 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 ten students, and the following results were obtained:    Coefficients Standard Error p-value Intercept 4.0928 1.4400 X1 10.0230 1.6512 X2 0.1020 0.1225 X3 ‐4.4811 1.4400    ANOVA DF SS MS Regression 360.59 Residual error 23.91   a. Write the regression...

  • The following is a partial result of Multiple Regression analysis conducted in Excel. Predictor Coefficients Standard...

    The following is a partial result of Multiple Regression analysis conducted in Excel. Predictor Coefficients Standard Error t Statistic p-value Intercept -139.61 2548.99 -0.05 0.157154 x1 4.25 22.25 1.08 0.005682 x2 3.10 17.45 1.87 0.03869 x3 15.18 11.88 1.03 0.00002 Specify the following: Regression Equation: Which independent/predictor variables are statistically significant at α = 0.01 and Why?

  • 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 follow...

    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 var...

    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...

  • 8. Use the following information from a multiple regression analysis. n = 15 b1 = 5...

    8. Use the following information from a multiple regression analysis. n = 15 b1 = 5 b2 = 6 Sb1 = 1.4 Sb2 = 0.8 a. Which variable has the largest​ slope, in units of a t​ statistic? The variable _____ has the largest​ slope, with tSTAT = _____ b. Construct a 90​% confidence interval estimate of the population​ slope, β1. c. Begin by determining whether X1 makes a significant contribution to the regression model. Determine the null and alternative...

  • In a regression analysis involving 30 observations, the following estimated regression equation w...

    In a regression analysis involving 30 observations, the following estimated regression equation was obtained. y=17.6+3.8x1-2.3x2+7.6x3+2.7x4 For this estimated regression equation SST= 1805 and SSR=1756. a. At a= 0.05  , test the significance of the relationship among the variables. SSE=_________________ (to 1 decimal, if necessary) MSR=________________ (to 1 decimal, if necessary) MSE=+_______________ (to 2 decimals, if necessary) What is the value of the F test statistic (to 1 decimal)? _______________ What is the p-value? - Select your answer -less than .01,between...

  • 43. A multiple regression analysis is conducted with 5 independent variables and an intercept on a...

    43. A multiple regression analysis is conducted with 5 independent variables and an intercept on a sample of 100 observations. Suppose you want to conduct a hypothesis to test whether the coefficient of the first variable is statistically significant. What will be the degrees of freedom for this test? A.98 B. 99

  • You may need to use the appropriate technology to answer this question. In a regression analysis ...

    You may need to use the appropriate technology to answer this question. In a regression analysis involving 27 observations, the following estimated regression equation was developed. ŷ = 25.2 + 5.5x1 For this estimated regression equation SST = 1,550 and SSE = 550. (a) At α = 0.05, test whether x1 is significant. State the null and alternative hypotheses. H0: β1 = 0 Ha: β1 ≠ 0H0: β0 = 0 Ha: β0 ≠ 0     H0: β1 ≠ 0 Ha: β1...

  • 13)-19) A company analyst is interested in the relationship between number of cars sold per month...

    13)-19) A company analyst is interested in the relationship between number of cars sold per month (in 1,000s) and three independent variables: price per gallon of gasoline (X1=Gas, in $), the prevailing interest rate for car loans (x2=Interest, in %), and the car model (x3=model, with X3=1, the car is standard; and X3=0, if the car is luxury). He took a sample of 50 observations and obtained the following output: Coefficients Standard Errort Stat P-value Intercept 96.0744 10.0080 5.60 0.0001...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT