R and determine if it is signicantly different from zero

Question

Lane Chap. 14
2. The formula for a regression equation is Y' = 2X + 9.
a. What would be the predicted score for a person scoring 6 on X?  The predicted score for that person would be,

6. For the X,Y data below, compute:

a. r and determine if it is signi?cantly different from zero. The obtained output from Minitab is given below, From the above output we can see that the correlation coefficient between X and Y is 0.849 with corresponding P value 0.032. As the P value is smaller than the significance level of 0.05 so we can conclude that the correlation coefficient is significantly different from zero.

b. the slope of the regression line and test if it differs signi?cantly from zero.  Using the data analysis tool pack of Excel the obtained output is given below,

SUMMARY OUTPUT

R
Standard Error 3.5028
Observations 6

ANOVA
df SS MS F Significance F
Regression 1 126.9207 126.9207 10.3441 0.0324
Residual 4 49.0793 12.2698
T
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept

Answer 1

For the above regression equation problem, provide me the best work done by the experts; I will be grateful to you for all your support and will always take assistance from your site.