For Analytic Solver, partition data sets into 50% training, 30% validation, and 20% test and use 12345 as the default random seed. If the predictor variable values are in the character format, then treat the predictor variable as a categorical variable. Otherwise, treat the predictor variable as a numerical variable. Create a regression tree using the accompanying data set in Exercise_10.28_Data worksheet (predictor variables: x₁ to x₅; target: y). a-1. What is the minimum validation MSE in the prune log? (Round your answer to 4 decimal places.) a-2. How many decision nodes are associated with the minimum error? b. How many leaf nodes are in the best-pruned and minimum error trees? c. What are the predictor variable and split value for the first split (root node) of the best-pruned tree? (Round "Split value" answer to 2 decimal places.) d. What are the RMSE and MAD of the best-pruned tree on the test data? (Round your answers to 4 decimal places.) e. Score the new observations in the Exercise_10.28_Score worksheet using the best-pruned tree. What is the predicted value of y for the first observation? (Round your answers to 2 decimal places.) f. What are the minimum, maximum, and average values of predicted y? (Round your answers to 2 decimal places.)

x1	x2	x3	x4	x5	y
34.52346	154.96	0	93	13.55	18.9
163.2669	191.88	0	95.67	8.61	23
8.07538	52.26	0	93.33	8.39	24.5
32.96326	166.66	1	84.67	5.82	33.1
35.44344	63.96	0	64.33	10.58	39.8
60.95002	128.18	0	100	15.93	22
45.12206	333.58	0	132.67	12.74	20.3
2204.401	509.08	0	134.33	36.99	15.6
23.33306	146.64	0	81	13.2	20.5
66.33002	260.26	0	144	22.69	18.8
290.789	103.22	0	88	4.42	43.5
25.50658	310.18	0	91	11.03	11.9
7559.277	470.6	0	222	29.71	17.2
44.22898	152.36	0	110	4.94	29.6
422.7066	103.22	0	88	20.71	30.7
129.6741	191.88	0	95.67	17.91	22.2
249.0725	161.2	0	102.33	7.35	31.7
891.2508	509.08	0	134.33	19.74	21.5
35.85232	105.3	0	98.67	7.46	29.4
9.56564	38.22	0	134	6.23	32.9
24611.4	470.6	0	222	51.77	7
25.19992	88.66	0	90	12.33	22.6
33.09238	134.94	0	74.67	13.01	18.7
3659.029	470.6	0	222	20.58	20
337.5358	211.64	0	102.33	11.86	19.9
1237.615	509.08	0	134.33	15.54	23.8
51.17456	333.58	0	132.67	12.52	21.4
19.08824	94.64	0	105	12.95	20.9
113.8462	222.56	0	128	18.82	19.3
525.1795	569.14	0	145.67	24.23	15.6
123.0729	222.56	0	128	14.88	18.6
19.10438	126.36	0	93.67	10.51	22.9
2927.333	470.6	0	222	24.82	15.2
135.5706	275.34	0	92.33	25.28	22.5
94.1769	154.96	0	93	14.18	24.7
42.3675	89.44	0	132.67	9.35	32
5162.492	470.6	0	222	28.43	12.1
23.10172	391.04	0	90	14.83	20.6
4942.617	470.6	0	222	33.04	11.3
18.43726	134.94	0	74.67	13.72	19.5
72.92052	157.82	0	115	18.33	17.4
7187.572	470.6	0	222	22.89	12.7
2064.22	470.6	0	222	19.87	19.9
152.749	191.88	0	95.67	16.44	18.5
92.37998	133.38	0	94.67	20.22	16
219.348	161.2	1	102.33	30.04	21.7
16.0593	56.68	0	74	7.29	28.7
47.73674	146.64	0	81	18.83	19.7
361.4876	211.64	0	102.33	20.73	16.6
75.4814	152.36	0	110	8.26	24.4
68.87476	222.56	0	128	17.18	19.8
11145.32	470.6	0	222	32.68	11.9
329.0085	103.22	0	88	7.17	50
61.6548	180.96	0	74.33	10.82	24.4
30.36472	166.66	1	84.67	4.94	32.4
14.86494	76.7	0	84	6.05	30.8
68.56272	179.66	0	77.67	6.78	26.6
4411.912	470.6	0	222	23.72	13.5
5.89648	58.5	0	100	11.52	22
6481.932	470.6	0	222	19.74	20.8
81.16268	721.24	0	237	25.28	15.2
90.1688	191.88	0	95.67	10.08	23.8
6429.692	470.6	0	222	16.98	27.9
2292.585	470.6	0	222	17.74	22.6
1279.671	470.6	0	222	18.68	20.6
36.9068	75.14	0	92	8.67	33.2
44.35272	128.18	0	100	8.9	23.7
66.00722	179.66	0	77.67	13.37	21.2
83.0941	133.38	0	94.67	9.6	23.3
9952.032	470.6	0	222	53.16	13.8
27.34654	134.94	0	74.67	7.95	22.2
198.6296	257.4	0	101.33	12.99	23.8
105.1198	281.06	0	101.67	10.56	23.4
21.57918	39.52	0	109.67	5.71	33.3
116.8482	275.34	1	92.33	22.44	22.4
27.21742	116.74	0	82.33	13.47	23.9
54.25192	260.26	0	144	14.22	22.8
4334.015	470.6	0	222	25.4	13.8
75.59976	275.34	0	92.33	13.13	28.1
189.5535	569.14	0	145.67	20.43	17.1
173.5803	569.14	0	145.67	23.66	17.4
5361.999	470.6	0	222	26.39	15.4
9.19442	52.52	0	62.33	6.3	30.1
2339.649	470.6	0	222	22.81	19.9
113.1844	86.58	0	72	6.79	35.1
9729.515	470.6	0	222	40.67	7.2
10805.68	470.6	0	222	42.88	8.8
5052.159	470.6	0	222	32.03	12.8
760.6513	509.08	1	134.33	21.17	47.6
18.5341	52.78	0	116	10.4	43.7
2511.831	470.6	0	222	26.61	37.2
183.5064	191.88	0	95.67	8.57	47
1417.888	257.4	0	101.33	17.7	30.7
48.78584	89.44	0	132.67	7.14	19.2
4966.977	470.6	0	222	13.34	45.6
5505.354	470.6	0	222	25.24	20.5
63.19886	204.62	0	103.67	18.58	6.9
4730.161	470.6	0	222	24.02	11.7
47.50002	204.62	0	103.67	17.4	22.9
7.42978	11.96	0	85	4.16	50
2071.139	470.6	1	222	18.58	21.7
343.2225	211.64	0	102.33	14.36	18.2
67.67502	89.44	0	132.67	6.38	29.8
31.14482	157.82	0	115	11.34	22
208.3943	666.9	0	62.67	38.16	15.7
1986.893	470.6	0	222	20.51	17.7
1702.017	470.6	0	222	19.78	19.9
31.0964	63.96	0	64.33	7.06	37.2
90.93276	666.9	0	62.67	20.73	21.4
1901.835	509.08	1	134.33	21.03	15.6
16.40362	98.28	0	123.33	6.45	31.2
202.1696	275.34	1	92.33	33.57	19.3
8224.944	470.6	0	222	32.54	13.9
5118.333	470.6	0	222	26.19	14.9
3793.126	470.6	0	222	32.61	13.4
1159.417	509.08	0	134.33	23.31	15.6
35.73396	105.3	0	98.67	9.69	29.9
136.4153	257.4	0	101.33	16.1	16.2
115.1804	152.36	0	110	5.03	24.8
2030.939	470.6	0	222	24.01	19
5024.323	470.6	0	222	33.71	9.5
33.69494	310.18	0	91	13.54	22.4
131.9284	257.4	0	101.33	22.32	19.8
4170.7	470.6	0	222	22.72	14.9
3580.347	470.6	0	222	19.59	19.5
5976.158	470.6	0	222	48.68	13.8
19.24964	86.58	0	72	5.26	45.4
23.55902	87.62	0	112.33	14.34	19.4
156.5042	569.14	0	145.67	33.82	14
175.0813	569.14	0	145.67	21.55	18
3050.449	470.6	1	222	5.22	50
986.5683	509.08	1	134.33	2.69	50
19.4487	128.7	0	81.67	6.58	27.9
3778.153	470.6	0	222	21.98	14.2
24.35526	310.18	0	91	12.71	20.6
4437.472	470.6	0	222	23.44	17.8
25.10308	39.52	0	109.67	12.05	30.3
73.09806	275.34	1	92.33	20.52	24.4
61.50416	222.56	0	128	10.74	26.5
5965.021	470.6	0	222	21.03	16.7
59.32526	133.38	0	94.67	9.42	22.2
139.4227	569.14	0	145.67	24.07	16.2
68.95008	157.82	0	115	12.31	20.9
3133.317	470.6	0	222	15.04	23
93.24078	251.94	0	130.33	16.81	21.8
8.07538	31.46	1	66	4.42	50
390.4804	211.64	0	102.33	15.79	18.2
452.2105	211.64	0	102.33	23.11	13.9
160.4262	161.2	0	102.33	5.49	46.7
30.8543	116.74	0	82.33	9.14	26.6
44.04606	75.14	0	92	5	43.8
35.59946	84.24	0	143.33	13.96	19.3
101.3377	179.66	0	77.67	19.81	20
746.7386	211.64	0	102.33	38.79	13.2
20633.27	470.6	0	222	42.83	5
44.4657	361.92	0	96.33	12.01	23.9
275.3645	161.2	0	102.33	6.62	31.5
21.15416	88.66	0	90	11.48	22
14.69278	183.82	0	80.67	12.8	21.6
12722.73	470.6	0	222	33.17	13.1
9612.285	470.6	0	222	30.49	10.2
134.3924	569.14	0	145.67	29.85	13.3
169.6475	161.2	0	102.33	5.8	44.8
56.88812	721.24	0	237	25.3	13.6
37.18118	89.44	0	132.67	6.57	30.5
13.68134	98.28	0	123.33	10.05	23.9
6228.91	470.6	0	222	35.95	9.7
2451.058	470.6	0	222	9.97	27.5
309.506	161.2	0	102.33	3.46	41.7
80.33416	133.38	0	94.67	18.41	18.7
20262.1	470.6	0	222	20.33	10.9
24.5328	361.14	1	92	18.91	23.3
531.7753	211.64	0	102.33	27.83	14.5
37.1489	56.68	0	74	7.46	36.2
13343.31	470.6	0	222	27.68	8.3
46.84366	333.58	0	132.67	14.38	20.8
766.6608	509.08	0	134.33	10.35	23.3
514.2043	211.64	0	102.33	24.19	14.8
98.65306	721.24	0	237	33.56	7
265.2232	257.4	0	101.33	6.36	22.8
23.11786	138.32	0	97.67	13.31	24.8
37.77836	105.3	0	98.67	14.15	23.2
805.0202	509.08	0	134.33	18.59	19.6
338.8109	211.64	0	102.33	11.56	20.4
177.7821	161.2	0	102.33	15.23	24
50.02862	666.9	0	62.67	25.1	20.5
15.4675	391.04	0	90	8.69	25
36.17512	84.24	0	143.33	10.28	22.6
49.37764	105.3	0	98.67	12.66	23.6
30.4508	88.66	0	90	7.7	23.6
7711.531	470.6	0	222	18.35	21.4
1988.959	470.6	0	222	19.6	21.9
92.1056	222.56	0	128	26.12	19.5
1206.39	509.08	0	134.33	16.3	22.7
279.8353	103.22	0	88	8.27	48.8
19.68542	126.36	0	93.67	9.41	24.8
61.4665	361.14	1	92	14.7	23
27.02374	157.56	0	101.33	17.4	17.1
3071.001	470.6	0	222	10.84	23.7
649.592	509.08	0	134.33	20.2	17.4