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

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

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.