HI EXPERT, please kindly help with a step by step solution on how to run he regression, please see below the data set and question:

DATA SET:

	The data below is number of students in various categores.
	White Male	Asian Male	Other Male	White Female	Asian Female	Other Female
Number Applied to STEM	25	19	19	15	10	17
Did not Apply to STEM	15	15	29	31	18	26
	This data is extracted from the STEM data. GPA and SAT data are for those students who have applied for a STEM program.
	White Male GPA	Asian Male GPA	Other Male GPA	White Female GPA	Asian Female GPA	Other Female GPA	White Male SAT	Asian Male SAT	SAT	White Female SAT	Asian Female SAT	Other Female SAT
	3.30	4.50	2.90	3.20	2.90	2.90	1560	1350	1450	1500	1450	1520
	2.50	3.70	3.80	3.40	3.80	4.00	1450	1490	1430	1450	1430	1530
	3.10	2.70	3.20	2.90	3.20	3.80	1360	1530	1480	1570	1480	1600
	2.90	3.80	4.40	3.80	4.40	4.30	1340	1380	1390	1460	1390	1590
	3.20	3.60	4.00	2.90	4.00	3.00	1380	1200	1340	1560	1340	1540
	3.80	4.40	2.60	3.30	2.60	2.70	1270	1400	1460	1550	1460	1350
	4.10	3.70	3.80	3.30	3.80	2.70	1190	1210	1400	1310	1400	1520
	2.80	3.20	4.50	3.90	4.50	4.40	1410	1470	1500	1450	1500	1470
	3.00	4.20	3.80	4.40	3.80	4.00	1240	1440	1520	1550	1520	1320
	2.60	3.60	2.70	2.70	2.70	3.00	1430	1450	1470	1560	1470	1470
	3.10	3.70	3.40	3.20		3.10	1430	1570	1560	1370		1600
	2.50	3.70	4.20	2.60		3.60	1380	1380	1550	1550		1510
	2.70	4.10	3.70	2.90		3.70	1540	1370	1350	1550		1460
	4.30	3.90	2.60	2.80		3.90	1480	1330	1370	1530		1390
	3.60	3.10	4.30	4.20		3.40	1200	1410	1420	1570		1390
	3.00	3.60	3.50			2.70	1450	1410	1570			1520
	3.80	3.20	3.90			3.40	1430	1590	1580			1580
	4.40	3.60	4.50				1450	1330	1430
	3.60	2.50	4.10				1490	1220	1390
	3.00						1520
	2.50						1520
	2.90						1490
	2.80						1590
	4.00						1230
	2.50						1330

Q5

Introduce the race variable (white and Asian) in the model

Put the regression model output here.

Write down the regression model

Assume some reasonable values for the independent variables and calculate confidence and prediction intervals