Question

In: Statistics and Probability

Q1. Using the data provided for your group assignment estimate the simple regression Y= Final_exam and...

Q1. Using the data provided for your group assignment estimate the simple regression

Y= Final_exam and X= assignment_grade. Each part of question is worth 2 marks.

  1. Prior to estimating the regression what are your a priori expectations about the sign of β1? Explain.
  2. Write down the regression results in traditional form, with t statistics below each of the estimated coefficients and anything else that should be included.
  3. Test the null hypothesis that β1=0 against the two sided alternative hypothesis at the 5% level of significance. Interpret your results.
  4. Now estimate the multiple regression model including assignment_grade (X1) and Tutorial_attend (X2). Write down the regression results in traditional form, with t statistics below each of the estimated coefficients and anything else that should be included.
  5. Within the multiple regression model- test the null hypothesis that β1=0 against the two sided alternative hypothesis at the 5% level of significance. Interpret your results.

Final_exam

assignment_grade

Tutorial_attend

100

90

5

100

75

5

90

75

5

85

85

5

85

100

5

80

95

5

70

80

5

60

95

5

60

80

5

55

95

5

55

25

4

50

80

5

45

90

5

40

65

5

40

65

4

35

0

3

30

70

4

30

55

4

25

85

5

25

90

4

15

5

3

15

80

5

15

50

5

15

45

3

5

75

3

5

70

4

100

100

5

95

75

5

90

100

5

85

85

5

80

95

5

70

45

5

70

100

5

65

90

5

60

100

5

55

65

4

55

90

5

55

80

4

50

50

5

45

50

4

45

75

3

40

75

5

40

70

5

35

90

4

30

95

5

30

55

5

25

75

4

25

20

3

25

65

2

15

60

4

15

60

4

15

80

5

10

55

4

10

80

2

0

0

2

Solutions

Expert Solution

Answer(i):

Here we have Final_exam score as dependent variable and assignment grade as independent variable. Our expectation will be of a positive relationship between the dependent and independent variable as generally the final _exam score will increase with the increase in assignment grade.

Hence our expectation of sign of β1 is Positive.

Answer(ii):

We used excel data analysis tool to fit a simple regression model and the output in the tradition from is given below:

Intercept

Assignment_grade

Coefficients

8.556

(10.349)

0.537

(0.138)

t statistic

0.827

3.896

*values in parentheses are standard errors

The fitted regression equation is

Answer(iii):

We have to test

H0: β1 = 0

H1: β1 ≠ 0

we have the t statistic for β1

­t=3.896

The critical value of t for two tailed alternative hypothesis at 0.05 level of significance with 53df is 2.005

The t statistic for β1 is 3.896 which is greater than tcritical = 2.005 and it suggest that we have enough evidence against H0 to reject it, so we reject the H0 at 5% level of significance and conclude that the β1 is highly significant.

Answer(iv):

We used excel data analysis tool to fit a multiple regression model and the output in the tradition from is given below:

Intercept

assignment_grade

Tutorial_attend

Coefficients

-35.753

(15.549)

0.218

(0.153)

15.338

(4.296)

t statistic

-2.300

1.421

3.570

*values in parentheses are standard errors

The fitted regression equation is

Answer(v):

We have to test

H0: β1 = 0

H1: β1 ≠ 0

we have the t statistic for β1

­t=1.421

The critical value of t for two tailed alternative hypothesis at 0.05 level of significance with 53df is 2.005

The t statistic for β1 is 3.896 which is less than tcritical = 2.005 and it suggest that we do not have enough evidence against H0 to reject it, so we fail to reject the H0 at 5% level of significance and conclude that the β1 is not significant.


Related Solutions

Use Excel to estimate a simple linear regression model for the following data (Y is a...
Use Excel to estimate a simple linear regression model for the following data (Y is a dependent variable and X is an independent variable): Y X 0 -2 0 -1 1 0 1 1 3 2 Fill in Multiple Blanks: What is the slope of the estimated line?  In your answer, show one (1) digit to the right of the decimal point, for example, 1.0, 1.2. Apply the appropriate rounding rule if necessary. What is the Y-intercept?
In a simple linear regression analysis, will the estimate of the regression line be the same...
In a simple linear regression analysis, will the estimate of the regression line be the same if you exchange X and Y? Why or why not?
estimate the following linear regression equation using the data below: y=B0+B1X In this exercise, you need...
estimate the following linear regression equation using the data below: y=B0+B1X In this exercise, you need to estimate ŷ values for given y and x values using Excel. What are the estimated values of B0 and B1 ? x = 2, 4, 6, 8, 10 y = 10, 12, 20, 25, 40 ŷ =
Using your calculator, run a regression analysis on the following bivariate set of data with y...
Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5 77.4 68.2 -5.9 41.1 -83 61.4 -2.5 87.1 39.4 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer...
The following data are provided. (Nonlinear regression using excel) x 1 2 3 4 5 y...
The following data are provided. (Nonlinear regression using excel) x 1 2 3 4 5 y 2.2 2.8 3.6 4.5 5.5 Fit the model y=a+bx+c/x, where a, b and c are constants for the model. Perform nonlinear regression in EXCEL using solver to get model constants. Plot y model (model and data) vs x to see the quality of fit.
Please answer this using Rstudio For the oyster data, calculate regression fits (simple regression) for the...
Please answer this using Rstudio For the oyster data, calculate regression fits (simple regression) for the 2D and 3D data a.1) Give null and alternative hypotheses a.2) Fit the regression model a.3) Summarize the fit and evaluation of the regression model (is the linear relationship significant). a.4 )Calculate residuals and make a qqplot. Is the normal assumption reasonable? Actual   2D   3D 13.04   47.907   5.136699 11.71   41.458   4.795151 17.42   60.891   6.453115 7.23   29.949   2.895239 10.03   41.616   3.672746 15.59   48.070   5.728880 9.94  ...
Using Excel generate a simple regression model with Y as the dependent variable and X1 and...
Using Excel generate a simple regression model with Y as the dependent variable and X1 and X2 as the independent variables in the attached spreadsheet. Write the following from the output: Intercept: Coefficients of Independent variable: R-square: Significance F: Based on the model generated, forecast profits for a firm with X1= Based on the model generated, forecast profits for a firm with x1=250 and X2=100. Evaluate the predictability of the model using explanatory language that someone who does not have...
For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment....
For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed. Select the appropriate discrete probability distribution. If using a binomial distribution, use the constant probability from the collected data and assume a fixed number of events of 20. If using a Poisson distribution, use the applicable mean from the collected data. Identify...
Use your discussion group to complete this assignment. Discuss with your group the following case using...
Use your discussion group to complete this assignment. Discuss with your group the following case using this discussion board. Once you have come to a group resolution clearly label that final post as "final answers". Matheson Electronics has just developed a new electronic device it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: New equipment would have to be acquired to produce the device. The equipment would cost $315,000...
true or fulse q1 In a regression model it is given that the estimate of intercept...
true or fulse q1 In a regression model it is given that the estimate of intercept is 5 and the estimate of slope is 4 , then the value of dependent variable y for x = 2 is 14. True False q2 When looking at the waiting line at SEU daam system, we can assume that calling population is limited. True False q3 A coffee machine can serve customers at the rate of 20 per hour . The customers arrive...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT