age (x): 1, 2, 3, 4, 5, 6, 3, 5, 2, 4
Vocab (y) 3, 220, 540, 1100, 2100, 2600, 730, 2200, 260, 1200
Predict the vocabulary of a 3.5 year old using your obtained regression line
We can use here Scatter plot by Excel.
Step1) Enter data in Excel.
Step 2) Select data >>click on insert tab >>Select scatter plot >>Select scatter plot with function.
or
We can use here Excel for regression equation
Step 1) Enter data in Excel .
Step 2) Data >>Data analysis >>Regression
>>Select y and x values separately >>Ok
Therefore, we have regression equation is ,
or
Vocab = 566.1*age - 886
Substitute x= 3.5
=1095.35
Therefore, predicted the vocabulary is approximately 1096 for 3.5 year old .
Get Answers For Free
Most questions answered within 1 hours.