This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: id textbook score nonpoor 1 0 32.34748 2 1 60.6767 1 3 36.8199 4 1 59.97848 5 1 94.84734 1 6 1 67.58567 1 7 1 89.47661 1 8 0 27.36664 9 0 26.91632 10 1 60.6944 11 0 34.57623 12 1 72.79 1 13 1 72.19371 1 14 0 16.21021 15 0 3.566154 16 20.01606 17 1 75.53525 1 18 1 68.07047 1 It is not that hard to see the difference between the test scores from the students with and without 19 0 24.23458 textbook. The average of test score of students without textbook (indicator: 0) are high much lower 20 0 39.00613 than the ones who have textbook(indicator: 1). 21 1 80.59294 1 22 1 80.25801 1 23 1 86.35025 1 2 67.60610984is the average score among students who have textbooks. 24 1 73.95139 1 25 36.00045 30.75545592is the average score among students who do not have textbooks. 26 0 49.77136 27 1 77.16637 1 The difference average score between students who have and not have textbook is 28 1 75.59013 1 36.850653913 29 0 40.46128 Based solely on these two numbers of the average scores from students with and without textbooks, 30 1 64.3642 1 we can conclude that the students with textbook have an average higher test score. Thus, textbooks 31 1 54.13269 1 have positive relation with test scores. 32 1 75.81052 1 33 1 83.76164 1 3 36.850653913 30.7554559 #N/A #N/A #N/A #N/A 34 0 11.90193 3.4377542502 2.6849719 #N/A #N/A #N/A #N/A 35 0 35.86093 0.5397018438 16.7676442 #N/A #N/A #N/A #N/A 36 1 65.15588 1 37 0 28.57663 y=a+b*text 38 1 10.0087 The esimate of the impact of textbooks on score is 36.85065391 39 1 107.5995 1 Excel outpus: intercept: 30.75546; standard error for it is: 2.684972; 40 0 32.04168 estimate is 36.85065391; standard error for it is 3.43775425 41 1 90.80514 1 42 1 84.13176 1 How does this coefficient estimate compare to your answer to Question 2 43 1 29.6261 With textbook, y=a+b=36.85+30.75546 67.606109836 which is the same with the 44 1 62.4787 1 number for average score of students with textbook in Q2 45 0 34.04641 Without textbook, y=a+b*0=a=30.75546, which is the same in Q2 for students without textbooks 46 0 21.85519 47 0 16.64392 48 1 48.64747 49 1 54.37235 1 Tstatistics is coeffient/standard error = 36.85/3.438 10.719397 50 1 67.6465 1 51 1 49.77844 1 It means, textbooks are strongly related to test scores....
View
Full
Document
This note was uploaded on 11/24/2011 for the course ECON 345 taught by Professor Jakiela during the Fall '11 term at Maryland.
 Fall '11
 jakiela

Click to edit the document details