# Thirty data points on Y and X are employed to estimate the parameters in the linear relation Y = a + bX.

Answer is needed in Excell format pleaseHomework ExercisesQ1. Thirty data points on Y and X are employed to estimate the parameters in the linearrelation Y = a + bX. The computer output from the regression analysis isDEPENDENT VARIABLE: Y R-SQUARE F-RATIO P-VALUE ON FOBSERVATIONS: 30 0.3301 13.79 0.0009VARIABLEPARAMETERESTIMATESTANDARDERRORT-RATIOP-VALUEINTERCEPT 93.54 46.210 2.02 0.0526X –3.25 0.875 –3.71 0.0009a. The equation of the sample regression line is Yˆ = _________________.b. There are ______ degrees of freedom for the t-test. At the 1% level of significance,the critical t-value for the test is ______________.c. At the 1% level of significance, aˆ __________ (is, is not) significant, and bˆ________ (is, is not) significant.d. At the 2% level of significance, the critical t-value for a t-test is___________. At the 2% level of significance, ˆ a ____________ (is, is not)significant, and bˆ ____________ (is, is not) significant.e. The p-value for bˆ indicates that the exact level of significance is ______percent, which is the probability of ______________________________________________________________________________________________.f. At the 1% level of significance, the critical value of the F-statistic is__________. The model as a whole ______________(is, is not) significant atthe 1% level.g. If X equals 500, the fitted (or predicted) value of Y is __________________.h. The percentage of the total variation in Y not explained by the regression is______________ percent.i. Explain why it is necessary to assess the statistical significance of theparameter estimates.Q2. Suppose Y is related to R and S in the following nonlinear way:Y = aRbSca. In order to estimate the parameters a, b, and c, the equation must be transformedinto the form: ___________________________________.Twenty-six observations are used to obtain the following regression results:DEPENDENT VARIABLE: LNY R-SQUARE F-RATIO P-VALUE ON FOBSERVATIONS: 26 0.3647 4.21 0.0170VARIABLEPARAMETERESTIMATESTANDARDERRORT-RATIOP-VALUEINTERCEPT 2.9957 0.3545 8.45 0.0001LNR 2.34 0.87 2.69 0.0134LNS –0.687 0.334 –2.06 0.0517b. There are __________ degrees of freedom for the t-test. At the 1% level ofsignificance, the critical t-value for the test is ________________.c. At the 1% level of significance, aˆ ____________ (is, is not) significant, bˆ__________ (is, is not) significant, and ˆ c ___________ (is, is not) significant.d. The estimated value of a is __________________.e. The p-value for bˆ indicates that the exact level of significance is _______percent, which is the probability of ______________________________________________________________________________________________.f. At the 1% level of significance, the critical value of the F-statistic is_________. The model as a whole ___________ (is, is not) significant at the1% level.g. If R = 12 and S = 30, the fitted (or predicted) value of Y is _____________.h. The percentage of the total variation in the dependent variable not explainedby the regression is _______________ percent.i. If R increases by 14%, Y will increase by ________ percent.j. A 6.87% increase in Y will occur if S ________________ (increases, decreases)by _______ percent.

parametr estimateINTERCEPTXdependent YvarR2F ratioP value Se93.54-3.25 t value46.210.875 2.02-3.71 Pvalue0.05260.0009 0.330113.790.0009 Yˆ =93.54-3.25Xa.b.28c.is not, isd….