600,000 students in 79 countries take a PISA test every three years to evaluate their learning in reading, math, and science. Students in the Beijing-Shanghai-Jiangsu-Zhejiang regions in China scored the highest average scores in all three subjects in 2018. Canada ranked around 12th overall but has had steadily declining scores in math and science. We have data on average math scores and characteristics of 500 school districts across Canada. This problem asks you to build up a regression model to look for factors that affect average math test scores in various school districts in Canada.
I run a basic regression equation that explains math scores
(SCORE) as a function of:
1. STR = the student teacher ratio. (number of
students per teacher)
2. SPEND = government spending per student in the
school district in dollars per student.
3. HIESL= a dummy variable=1 if the percentage of
students learning English as a new language is above 20% and =0 if
it is below 20%.
The regression also includes the usual constant term.
There is a categorical variable called PROVINCE for the province of the school district. This variable =1 for Ontario, =2 for Quebec, =3 for Alberta, and =4 for British Columbia.
There is also a categorical variable called INCOME which is the average per capita income of households in the school district. INCOME = 1 if the district has average per capital income below $40000, =2 if the district has per capita income between $40000 and $60000, =3 if the district has per capita income >= $60000.
How do I add PROVINCE and INCOME into my regression model? Which
specification is correct?
SCORE = b1 + b2STR + b3SPEND + b4HIESL + b5ON + b6QC + b7BC + b8AB + b9INC1 + b10INC2 + b11INC3
where
ON = 1 if the district is in Ontario and 0 otherwise
QC = 1 if the district is in Quebec and 0 otherwise
BC = 1 if the district is in BC and 0 otherwise
AB = 1 if the district is in Alberta and 0 otherwise
INC1 = 1 if the district is the low income range and 0
otherwise
INC2 = 1 if the district is the middle income range and 0
otherwise
INC3 = 1 if the district is the high income range and 0
otherwise
SCORE = b1 +b2STR + b3SPEND + b4HIESL + b5ON + b5QC + b6BC + b7INC2 + b8INC3
where
ON = 1 if the district is in Ontario and 0 otherwise
QC = 1 if the district is in Quebec and 0 otherwise
BC = 1 if the district is in BC and 0 otherwise
INC2 = 1 if the district is the middle income range and 0
otherwise
INC3 = 1 if the district is the high income range and 0
otherwise
SCORE = b2STR + b3SPEND + b4HIESL + b5ON + b6QC + b7BC + b8AB + b9INC1 + b10INC2 + b11INC3
where
ON = 1 if the district is in Ontario and 0 otherwise
QC = 1 if the district is in Quebec and 0 otherwise
BC = 1 if the district is in BC and 0 otherwise
AB = 1 if the district is in Alberta and 0 otherwise
INC1 = 1 if the district is the low income range and 0
otherwise
INC2 = 1 if the district is the middle income range and 0
otherwise
INC3 = 1 if the district is the high income range and 0
otherwise
SCORE = b1 +b2STR + b3SPEND + b4HIESL + b5ON + b6QC + b7BC + b8AB + b7INC2 + b8INC3
where
ON = 1 if the district is in Ontario and 0 otherwise
QC = 1 if the district is in Quebec and 0 otherwise
BC = 1 if the district is in BC and 0 otherwise
AB = 1 if the district is in Alberta and 0 otherwise
INC2 = 1 if the district is the middle income range and 0
otherwise
INC3 = 1 if the district is the high income range and 0
otherwise
SCORE = b1 +b2STR + b3SPEND + b4HIESL + b5PROVINCE + b6INCOME
where PROVINCE takes values 1 to 4
and INCOME takes values 1 to 3.
From the given information,
The required correct answer is,
E.
SCORE = b1 +b2STR + b3SPEND + b4HIESL + b5PROVINCE + b6INCOME
where PROVINCE takes values 1 to 4
and INCOME takes values 1 to 3.
Thank you
600,000 students in 79 countries take a PISA test every three years to evaluate their learning...
Refer to the table of estimated regressions below, computed using data for 1999 from all 420 K-6 and K-8 districts in California, to answer the following question. The variable of interest, test scores, is the average of the reading and math scores on the Stanford 9 Achievement Test, a standardized test administered to fifth-grade students. School characteristics (average across the district) include enrollment, number of teachers (measured as "full-time equivalents"), number of computers per classroom, and expenditure per student. Results...
The ACT is a standardized test that many high school students in the U.S. take in order to apply for college (the other major admissions test is the SAT). Scores on the ACT range from 1 to 36 in one point increments. The dean of a college of business is interested in examining the relationship between ACT scores and GPAs of students in the college. After taking a random sample of 141 students, he performs a regression analysis using Excel...
TEST 1: ANSWERS INTS EACH). This section takes around 5 minutes. Name Spring 2019 8) A researcher wants to determine whether female teachers give higher or lower grades, on average, then male teachers. She picks a random sample by picking a random sample of schools, in the schools picked, picking a random sample of departments, and in the departments picked, picking a random sample of teachers. What kind of sampling was performed? d) voluntary response e) cluster b) stratified Random...