California State University Econometrics Worksheet

Description

Jamovi is a free program, it is required to read the data sets attached in order to answer question 1 and 3.i have attemepted to answer some of the question but please review and answer to your ability. Please show all work

5 attachmentsSlide 1 of 5attachment_1attachment_1attachment_2attachment_2attachment_3attachment_3attachment_4attachment_4attachment_5attachment_5.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

THE CALIFORNIA TEST SCORE DATA SET
The California Standardized Testing and Reporting (STAR) dataset contains data
on test performance, school characteristics and student demographic backgrounds. The
data used here are from all 420 K-6 and K-8 districts in California with data available for
1998 and 1999. Test scores are the average of the reading and math scores on the
Stanford 9 standardized test administered to 5th grade students. School characteristics
(averaged across the district) include enrollment, number of teachers (measured as “fulltime-equivalents”), number of computers per classroom, and expenditures per student.
The student-teacher ratio used here is the number of full-time equivalent teachers in the
district, divided by the number of students. Demographic variables for the students also
are averaged across the district. The demographic variables include the percentage of
students in the public assistance program CalWorks (formerly AFDC), the percentage of
students that qualify for a reduced price lunch, and the percentage of students that are
English Learners (that is, students for whom English is a second language). All of these
data were obtained from the California Department of Education (www.cde.ca.gov).
Series in Data Set:
DIST_CODE:
DISTRICT CODE;
READ_SCR:
AVG READING SCORE;
MATH_SCR:
AVG MATH SCORE;
COUNTY :
COUNTY;
DISTRICT:
DISTRICT;
GR_SPAN:
GRADE SPAN OF DISTRICT;
ENRL_TOT :
TOTAL ENROLLMENT;
TEACHERS:
NUMBER OF TEACHERS;
COMPUTER:
NUMBER OF COMPUTERS;
TESTSCR:
AVG TEST SCORE (= (READ_SCR+MATH_SCR)/2 );
COMP_STU:
COMPUTERS PER STUDENT ( = COMPUTER/ENRL_TOT);
EXPN_STU:
EXPENTITURES PER STUDENT ($’S);
STR:
STUDENT TEACHER RATIO (ENRL_TOT/TEACHERS);
EL_PCT:
PERCENT OF ENGLISH LEARNERS;
MEAL_PCT:
PERCENT QUALIFYING FOR REDUCED-PRICE LUNCH;
CALW_PCT:
PERCENT QUALIFYING FOR CALWORKS;
AVGINC:
DISTRICT AVERAGE INCOME (IN $1000’S);
1. Use the College Athletics data on Cougars Courses to answer the following questions.
a. What are the sample averages of the number of applicants for schools who did not play in a
bowl game the previous year and those who did play in a bowl game the previous year?
b. Is there a difference in the population in the average number of applicants for schools who
played in a bowl game versus those that did not? Show your Jamovi output.
c. Using a simple OLS regression, what is the effect of student-faculty ratio on the number of
applicants?
d. Interpret the effect of student-faculty ratio on applications that you found in part c.
e. Interpret the R2 from the regression you estimated in part c.
2. You use a random sample of 1,002 individuals and estimate the following OLS model
?????????? = 10.6 + 1.2 ? ?????????????????
Where wage is measured in dollars per hour and schooling is measured in the number of years
of education. You have also calculated TSS = 8,000 and SER = 2.00.
a. The sample average for years of schooling is 12. What is the sample average for wage?
?????????? = 10.6 + 1.2 ? ?????????????????
?????????? = ?????? ???????? = 10.6 + (1.2) ? 12 = 25
If schooling = 12, then
Sample avg for wage = 25
b. What is R2?
??????
???2
SER = ?
SSE = (SER)² (N-2)
= 2² * 1000
=4000
R² = 1 –
R² = 0.5
??????
??????
=1-
4000
8000
= 0.5
3. Use the CA School data on Cougars Courses. Provide the Jamovi output along with your
answers to the following questions.
a. You are asked by the Department of Education to determine the effect of reduced-price lunch
on test scores. What is the estimated effect from the sample of data?
Descriptives
654.157 + 44.705 =698.862
N
Mean
SD
meal_pct
420
44.705
27.123
testscr
420
654.157
19.053
698.862 / 2 = 349.431
b. Do you believe your results are useful for policy (can you use the results to suggest a
change that may improve test scores)? Why, or why not?
c. Interpret the R2 from your regression.
College Athletics Data
The data are school-level data for schools competing in NCAA Division 1 Athletics.
Obs:
1.
2.
3.
4.
5.
6.
7.
8.
9.
118
year
apps
top25
ver500
mth500
stufac
bowl
btitle
finfour
1992 or 1993
# applics for admission
perc frosh class in 25th high sch percen
perc frosh >= 500 on verbal SAT
perc frosh >= 500 on math SAT
student-faculty ratio
= 1 if bowl game in prev year
= 1 if men’s cnf chmps prev year
= 1 if men’s final 4 prev year

Purchase answer to see full
attachment

Explanation & Answer:
2 Questions

Tags:
economics

Econometrics

JAMOVI

User generated content is uploaded by users for the purposes of learning and should be used following FENTYESSAYS.COM ESSAY’s honor code & terms of service.