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

374518 764271Discover how to deal along with your domain get in touch with details and registration. Comprehend domain namelocking and Exclusive domain name Registration. 581515

674844 423214Id always want to be update on new content material on this web site , saved to fav! . 192715