Question

A simple linear regression equation, LNQ = a + bLNH + cLNS is estimated by a...

  1. A simple linear regression equation, LNQ = a + bLNH + cLNS is estimated by a computer regression routine which produces the following output – see the information below. LNQ is the percentage change in the number of cars sold in a day; LNH is the percentage change in the number hours the dealership is open; and LNS is the percentage change in the number of sales persons working that day. The parameter estimates can be interpreted as the percentage change in sales due a percentage change in the independent variable.
    1. How many degrees of freedom does this regression analysis have?
    2. What is the critical value of t at the 5 percent level of significance?
      1. Test to see if the estimates of a, b and c are statistically significant.
    3. How much of the total variation in LNQ is explained by this regression equation? How much of the total variation in LNQ is unexplained by this regression equation?
    4. What is the critical value of the F-statistic at a 5 percent level of significance?
      1. Is the overall regression equation statistically significant?
    5. If the number of sales people (LNS) is increased by 10% by how much should sales rise
      Dependent Variable:         LNQ       R-Square               F-Ratio                  p-Value of F

        Observations        53                           0.5452                   29.97                      .0001

Variable                 Parameter              Standard                T- Ratio                 p-value

                                        Estimate                Error

        Intercept                0.9162                   .2413                      3.80                        .0004

        LNH                       0.3517                   .1021                      3.44                        .0012

        LNS                        0.2550                   .0785                      3.25                        .0021

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

  1. A simple linear regression equation, LNQ = a + bLNH + cLNS is estimated by a computer regression routine which produces the following output – see the information below. LNQ is the percentage change in the number of cars sold in a day; LNH is the percentage change in the number hours the dealership is open; and LNS is the percentage change in the number of sales persons working that day. The parameter estimates can be interpreted as the percentage change in sales due a percentage change in the independent variable.
    1. How many degrees of freedom does this regression analysis have?

Total Df= n-1=52

Regression Df= 2

Error Df= 50

  1. What is the critical value of t at the 5 percent level of significance?

Critical t=2.009

Test to see if the estimates of a, b and c are statistically significant.

To test for a, calculated t=3.80   > 2.009 the critical value, a is significant.

To test for b, calculated t=3.44   > 2.009 the critical value, b is significant.

To test for c, calculated t=3.25   > 2.009 the critical value, c is significant.

  1. How much of the total variation in LNQ is explained by this regression equation? How much of the total variation in LNQ is unexplained by this regression equation?

R square =0.5452. 54.52% of variation in LNQ is explained by this regression equation.

45.48% of variation in LNQ is unexplained by this regression equation

  1. What is the critical value of the F-statistic at a 5 percent level of significance?

Is the overall regression equation statistically significant?

Critical F( 2,50) = 3.183

calculated F=29.97   > 3.183 the critical F value, regression equation is significant.

  1. If the number of sales people (LNS) is increased by 10% by how much should sales rise

Regression coefficient for LNS= 0.2550

For a 10% increase in LNS, there is a 2.55% in sales increase.


  1. Dependent Variable:         LNQ       R-Square               F-Ratio                  p-Value of F

        Observations        53                           0.5452                   29.97                      .0001

Variable                 Parameter              Standard                T- Ratio                 p-value

                                        Estimate                Error

        Intercept                0.9162                   .2413                      3.80                        .0004

        LNH                       0.3517                   .1021                      3.44                        .0012

        LNS                        0.2550                   .0785                      3.25                        .0021

Add a comment
Know the answer?
Add Answer to:
A simple linear regression equation, LNQ = a + bLNH + cLNS is estimated by a...
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
  • Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y annual...

    Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y annual income in $1000s) is related to the independent variables education (x1 level of education attained in number of years), age (x2 in years), and gender x3 dummy variable, 1= female, 0 = male. Develop the dummy variable for the gender variable first. Use the t test to test whether each of the coefficients obtained in part (a) are significant at .05 level of significance....

  • Answer both questions please true or false 16. The slope of the simple linear regression equation...

    Answer both questions please true or false 16. The slope of the simple linear regression equation represents the average change in the value of the dependent variable per unit change in the independent variable (X). True/False 19. When using simple regression analysis, if there is a strong correlation between the independent and dependent variable, then we can conclude that an increase in the value of the independent variable causes an increase in the value of the dependent variable.

  • In a simple linear regression model, the intercept of the regression line measures

    QUESTION 1In a simple linear regression model, the intercept of the regression line measuresa.the change in Y per unit change in X.b.the change in X per unit change in Y.c.the expected change in Y per unit change in X.d.the expected change in X per unit change in Y.e.the value of Y when X equals 0.f.the value of X when Y equals 0.g.the average value of Y when X equals 0.h.the average value of X when Y equals 0.QUESTION 2In a...

  • 1. The director of marketing at Vanguard Corporationbelieves that sales of the company’s Bright S...

    1. The director of marketing at Vanguard Corporationbelieves that sales of the company’s Bright Side laundry detergent (S)are related to Vanguard’s own advertising expenditure (A),as well as the combined advertising expenditures of its three biggest rival detergents (R). The marketing director collects 36 weeklyobservations on S, A, and R to estimate the following multiple regression equation: S = a + bA + cR where S, A, and R are measured in dollars per week. Vanguard’s marketing director is comfortable using...

  • Use the following linear regression equation to answer the questions. x1 = 1.4 + 3.7x2 –...

    Use the following linear regression equation to answer the questions. x1 = 1.4 + 3.7x2 – 8.3x3 + 1.8x4 (c) If x2 = 2, x3 = 6, and x4 = 10, what is the predicted value for x1? (Use 1 decimal place.) Suppose x3 and x4 were held at fixed but arbitrary values and x2 increased by 1 unit. What would be the corresponding change in x1? Suppose x2 increased by 2 units. What would be the expected change in...

  • Use the following linear regression equation to answer the questions. x3 = −16.5 + 4.5x1 +...

    Use the following linear regression equation to answer the questions. x3 = −16.5 + 4.5x1 + 8.4x4 − 1.5x7 (a) Which variable is the response variable? x4x3    x7x1 Which variables are the explanatory variables? (Select all that apply.) x4x7x3x1 (b) Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant x1 coefficient      x4 coefficient x7 coefficient (c) If x1 = 3, x4 = -10, and x7 = 8, what is the predicted value for x3? (Round...

  • Thomas Bruggink and David Rose' estimated a regression for the annual team revenue for Major League...

    Thomas Bruggink and David Rose' estimated a regression for the annual team revenue for Major League Baseball franchises (standard errors in parenthesis): Ri= –1522.5 +53.1P: + 1469.4M + 1322.75 — 7376.31 (9.1) (233.6) (1363.6) (2255.7) R2= .682 N = 78 where: R = team revenue from attendance, broadcasting, and concessions (in $000's) P. = the ith team's winning rate (times 1,000) M = the population of the ith team's metropolitan area (in millions) S = a dummy equal to 1...

  • Use the following linear regression equation to answer the questions. x1 = 1.4 + 3.1x2 –...

    Use the following linear regression equation to answer the questions. x1 = 1.4 + 3.1x2 – 8.2x3 + 2.1x4 Suppose x3 and x4 were held at fixed but arbitrary values and x2 increased by 1 unit. What would be the corresponding change in x1? Suppose x2 increased by 2 units. What would be the expected change in x1? Suppose x2 decreased by 4 units. What would be the expected change in x1? (e) Suppose that n = 13 data points...

  • Question 3: Evaluate this model with the global test at the significance level a 0.05. (6...

    Question 3: Evaluate this model with the global test at the significance level a 0.05. (6 points) Step 1: State the hypotheses H1: Step 2: Compute the global F-statistic for the model. (Round to the nearest 100) Step 3: Find F-value for the critical value. (Round to the nearest 100) Step 4: State decision rule Step 5: State a conclusion and interpret the conclusion. Table 2 presents the parameter estimates of the regression model. Conduct a test of Question 4:...

  • a) The simple linear regression equation that shows the best relationship between the number of patients...

    a) The simple linear regression equation that shows the best relationship between the number of patients and year is (round your responses to three decimal places). y= _ + _x b) Using linear regression the number of patients Dr. Fok will see in year 11 = _____ patients (round your response to two decimal places). c) Using linear regression, the number of patients Dr. Fok will see in year 12 = _____ patients. (round your response to two decimal places)....

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