AGEMOS Final Initial age.binarize score.difference 1 55 0 0 younger 0 2 82 6 8 o
ID: 3277577 • Letter: A
Question
AGEMOS Final Initial age.binarize score.difference
1 55 0 0 younger 0
2 82 6 8 older -2
3 81 3 6 older -3
4 71 0 3 younger -3
5 84 2 15 older -13
6 76 2 8 younger -6
7 72 1 2 younger -1
8 48 0 2 younger -2
9 52 0 2 younger -2
10 77 4 4 younger 0
11 61 0 3 younger -3
12 69 4 5 younger -1
13 79 3 6 older -3
14 61 1 0 younger 1
15 67 4 2 younger 2
16 73 1 0 younger 1
17 69 3 5 younger -2
18 86 2 5 older -3
19 94 5 18 older -13
20 62 1 7 younger -6
21 85 5 23 older -18
22 100 1 11 older -10
23 103 2 8 older -6
24 86 2 4 older -2
25 101 3 6 older -3
26 101 4 8 older -4
27 100 3 8 older -5
28 79 6 2 older 4
29 111 4 16 older -12
30 85 2 4 older -2
31 104 4 13 older -9
32 72 0 3 younger -3
33 77 2 0 younger 2
34 92 0 5 older -5
35 54 1 9 younger -8
36 54 0 1 younger -1
37 107 3 9 older -6
38 107 1 11 older -10
39 114 9 10 older -1
40 115 1 10 older -9
41 116 6 8 older -2
42 117 7 18 older -11
43 119 5 11 older -6
44 55 2 5 younger -3
45 86 1 8 older -7
46 100 4 8 older -4
47 114 1 10 older -9
48 114 5 8 older -3
49 84 8 8 older 0
50 119 5 9 older -4
51 116 7 11 older -4
1. Without using lm command, perform a regression with Final as the response variable and Initial and age.binarize as the predictor variables. under the model below, without using the lm command, compute the least square estimate for beta 1. (Assume that beta 2 is estimated to be 0.12)
2. Under this model,what does the estimated coefficient beta 1 say about the scores of the older children compared to the scores of the younger children?
Finali = A Ba x Initiali + A × 1(age.binarizei-"older" } +c;Explanation / Answer
Enter the data into Excel.
Go to data tab -> Click on Data Analysis toolpack -> Choose regression -> Click OK.
Input Y range : <select final column>
Input X range : <select initial and age.binarise columns>
Tick on labels -> Click OK.
The output is as follows :
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.