/* 

Education Expenditure Data, from Chatterjee and Price (1977);
50 subjects, 7 variables:

1. Index
2. State
3. Region (1=Northeastern, 2=North central, 3=Southern, 4=Western);
4. Number of residents per thousand residing in urban areas in 1970 (x[1]);
5. Per capita personal income in 1973 (x[2]);
6. Number of residents per thousand under 18 years of age in 1974(x[3]);
7. Per capita expenditure on public education in a state, projected for 1975 (y);

*/


CREATE TABLE EDUCATION_SPENDING (
  ID NUMBER PRIMARY KEY,
  STATE CHAR(2),
  REGION NUMBER(1),
  RESIDENTS NUMBER,
  INCOME NUMBER,
  UNDER18 NUMBER,
  EXPENDITURE NUMBER );



INSERT INTO EDUCATION_SPENDING VALUES (1,'ME',1,508,3944,325,235);
INSERT INTO EDUCATION_SPENDING VALUES (2,'NH',1,564,4578,323,231);
INSERT INTO EDUCATION_SPENDING VALUES (3,'VT',1,322,4011,328,270);
INSERT INTO EDUCATION_SPENDING VALUES (4,'MA',1,846,5233,305,261);
INSERT INTO EDUCATION_SPENDING VALUES (5,'RI',1,871,4780,303,300);
INSERT INTO EDUCATION_SPENDING VALUES (6,'CT',1,774,5889,307,317);
INSERT INTO EDUCATION_SPENDING VALUES (7,'NY',1,856,5663,301,387);
INSERT INTO EDUCATION_SPENDING VALUES (8,'NJ',1,889,5759,310,285);
INSERT INTO EDUCATION_SPENDING VALUES (9,'PA',1,715,4894,300,300);
INSERT INTO EDUCATION_SPENDING VALUES (10,'OH',2,753,5012,324,221);
INSERT INTO EDUCATION_SPENDING VALUES (11,'IN',2,649,4908,329,264);
INSERT INTO EDUCATION_SPENDING VALUES (12,'IL',2,830,5753,320,308);
INSERT INTO EDUCATION_SPENDING VALUES (13,'MI',2,738,5439,337,379);
INSERT INTO EDUCATION_SPENDING VALUES (14,'WI',2,659,4634,328,342);
INSERT INTO EDUCATION_SPENDING VALUES (15,'MN',2,664,4921,330,378);
INSERT INTO EDUCATION_SPENDING VALUES (16,'IA',2,572,4869,318,232);
INSERT INTO EDUCATION_SPENDING VALUES (17,'MO',2,701,4672,309,231);
INSERT INTO EDUCATION_SPENDING VALUES (18,'ND',2,443,4782,333,246);
INSERT INTO EDUCATION_SPENDING VALUES (19,'SD',2,446,4296,330,230);
INSERT INTO EDUCATION_SPENDING VALUES (20,'NB',2,615,4827,318,268);
INSERT INTO EDUCATION_SPENDING VALUES (21,'KS',2,661,5057,304,337);
INSERT INTO EDUCATION_SPENDING VALUES (22,'DE',3,722,5540,328,344);
INSERT INTO EDUCATION_SPENDING VALUES (23,'MD',3,766,5331,323,330);
INSERT INTO EDUCATION_SPENDING VALUES (24,'VA',3,631,4715,317,261);
INSERT INTO EDUCATION_SPENDING VALUES (25,'WV',3,390,3828,310,214);
INSERT INTO EDUCATION_SPENDING VALUES (26,'NC',3,450,4120,321,245);
INSERT INTO EDUCATION_SPENDING VALUES (27,'SC',3,476,3817,342,233);
INSERT INTO EDUCATION_SPENDING VALUES (28,'GA',3,603,4243,339,250);
INSERT INTO EDUCATION_SPENDING VALUES (29,'FL',3,805,4647,287,243);
INSERT INTO EDUCATION_SPENDING VALUES (30,'DY',3,523,3967,325,216);
INSERT INTO EDUCATION_SPENDING VALUES (31,'TN',3,588,3946,315,212);
INSERT INTO EDUCATION_SPENDING VALUES (32,'AL',3,584,3724,332,208);
INSERT INTO EDUCATION_SPENDING VALUES (33,'MS',3,445,3448,358,215);
INSERT INTO EDUCATION_SPENDING VALUES (34,'AR',3,500,3680,320,221);
INSERT INTO EDUCATION_SPENDING VALUES (35,'LA',3,661,3825,355,244);
INSERT INTO EDUCATION_SPENDING VALUES (36,'OK',3,680,4189,306,234);
INSERT INTO EDUCATION_SPENDING VALUES (37,'TX',3,797,4336,335,269);
INSERT INTO EDUCATION_SPENDING VALUES (38,'MT',4,534,4418,335,302);
INSERT INTO EDUCATION_SPENDING VALUES (39,'ID',4,541,4323,344,268);
INSERT INTO EDUCATION_SPENDING VALUES (40,'WY',4,605,4813,331,323);
INSERT INTO EDUCATION_SPENDING VALUES (41,'CO',4,785,5046,324,304);
INSERT INTO EDUCATION_SPENDING VALUES (42,'NM',4,698,3764,366,317);
INSERT INTO EDUCATION_SPENDING VALUES (43,'AZ',4,796,4504,340,332);
INSERT INTO EDUCATION_SPENDING VALUES (44,'UT',4,804,4005,378,315);
INSERT INTO EDUCATION_SPENDING VALUES (45,'NV',4,809,5560,330,291);
INSERT INTO EDUCATION_SPENDING VALUES (46,'WA',4,726,4989,313,312);
INSERT INTO EDUCATION_SPENDING VALUES (47,'OR',4,671,4697,305,316);
INSERT INTO EDUCATION_SPENDING VALUES (48,'CA',4,909,5438,307,332);
INSERT INTO EDUCATION_SPENDING VALUES (49,'AK',4,831,5309,333,311);
INSERT INTO EDUCATION_SPENDING VALUES (50,'HI',4,484,5613,386,546);

COMMIT;

