Solution
we will solve it by using excel and the steps are
Enter the Data into excel
Click on Data tab
Click on Data Analysis
Select Regression
Select input Y Range as Range of dependent variable.
Select Input X Range as Range of independent variable
click on labels if your selecting data with labels
click on ok.
So this is the output of Regression in Excel.
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.77 | |||||||
R Square | 0.60 | |||||||
Adjusted R Square | 0.57 | |||||||
Standard Error | 35.16 | |||||||
Observations | 18.00 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1.00 | 29166.90 | 29166.90 | 23.59 | 0.00 | |||
Residual | 16.00 | 19783.10 | 1236.44 | |||||
Total | 17.00 | 48950.00 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 712.69 | 14.70 | 48.47 | 0.00 | 681.52 | 743.85 | 681.52 | 743.85 |
Head Circumference | 39.17 | 8.07 | 4.86 | 0.00 | 22.08 | 56.27 | 22.08 | 56.27 |
a) correlation r = 0.77
b) y=712.69+39.17*Head Circumference
c)
Head Circumference = 1.8
y=712.69+39.17*Head Circumference
y=712.69+39.17*1.8
y = 783.10
The accompanying data on x = head circumference z score (a comparison score with peers of...
The accompanying data on x = head circumference z score (a comparison score with peers of the same age - a positive score suggests a larger size than for peers) at age 6 to 14 months and y = volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article. Cerebral Grey Matter (ml) 2-5 yr Head Circumfer- ence z Scores at 6-14 Months 680 -0.72 690 1.6 700 -0.27...
The accompanying data on x = head circumference z score (a comparison score with peers of the same age - a positive score suggests a larger size than for peers) at age 6 to 14 months and y = volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article. Head Circumfer- Cerebral Grey ence z Scores at Matter (ml) 2-5 yr 6-14 Months 680 -0.73 690 1.6 700 -0.28...
The accompanying data on - head circumference z score (a comparison score with peers of the same age a positive score suggests a larger size than for peers) at age 6 to 14 months and y volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article Head Circumfere Cerebral Grey ence Scores at Matter (ml) 2-5 yr 6-14 Months 680 -0.75 1.2 700 -0.30 720 0.25 740 D.30 740...
The accompanying data on x = head circumference z score (a comparison score with peers of the same age - a positive score suggests a larger size than for peers) at age 6 to 14 months and y = volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article. Head Circumfer- Cerebral Grey Matter (ml) 2-5 yr encez Scores at 6-14 Months 680 -0.74 690 1.8 700 -0.29 720...
Help please
The accompanying data on x = head circumference score (a comparison score with peers of the same age a positive care suggests a larger size than for peers) tape 6 to 14 months and y volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article Head Circumfer Cerebral Grey Matter (ml) 2-5 yr ence Scores at SY 6-14 Months -0.71 690 1.7 700 720 740 1.5 750...
clearly state answers a,b and c please.
The accompanying data on x = head circumference z score (a comparison score with peers of the same age - a positive score suggests a larger size than for peers) at age 6 to 14 months and y- volume of cerebral grey matter (in ml) at age 2 to 5 years were read from a graph in an article Cerebral Grey Head Circumfer- Matter (ml) 2-5 yr 6-14 Months ence x Scores at...