Multiple Regression & Variety of Characteristics Worksheet

Price ($1000)	Type	Mileage	Volume (litres)	Cylinders	Cruise Control	Sedan	Coupe	Convertible	Compact
70.76	Convertible	583	4.6	8	1	0	0	1	0
68.57	Convertible	6420	4.6	8	1	0	0	1	0
69.13	Convertible	7892	4.6	8	1	0	0	1	0
66.37	Convertible	12021	4.6	8	1	0	0	1	0
65.28	Convertible	15600	4.6	8	1	0	0	1	0
63.91	Convertible	18200	4.6	8	1	0	0	1	0
60.57	Convertible	23193	4.6	8	1	0	0	1	0
57.15	Convertible	29260	4.6	8	1	0	0	1	0
55.64	Convertible	31805	4.6	8	1	0	0	1	0
52.00	Convertible	42691	4.6	8	1	0	0	1	0
46.73	Convertible	3625	6	8	1	0	0	1	0
47.07	Convertible	5239	6	8	1	0	0	1	0
44.75	Convertible	12115	6	8	1	0	0	1	0
42.77	Convertible	14546	6	8	1	0	0	1	0
41.37	Convertible	20000	6	8	1	0	0	1	0
39.55	Convertible	23826	6	8	1	0	0	1	0
39.69	Convertible	25169	6	8	1	0	0	1	0
38.82	Convertible	25960	6	8	1	0	0	1	0
36.97	Convertible	30502	6	8	1	0	0	1	0
37.29	Convertible	32039	6	8	1	0	0	1	0
35.62	Convertible	10340	2	4	1	0	0	1	0
34.82	Convertible	12251	2	4	1	0	0	1	0
34.36	Convertible	17711	2	4	1	0	0	1	0
32.74	Convertible	19112	2	4	1	0	0	1	0
33.54	Convertible	20925	2	4	1	0	0	1	0
31.97	Convertible	21208	2	4	1	0	0	1	0
33.29	Convertible	21661	2	4	1	0	0	1	0
32.08	Convertible	23553	2	4	1	0	0	1	0
31.97	Convertible	24559	2	4	1	0	0	1	0
27.67	Convertible	35157	2	4	1	0	0	1	0
37.09	Convertible	3828	2	4	1	0	0	1	0
33.38	Convertible	17381	2	4	1	0	0	1	0
33.36	Convertible	17590	2	4	1	0	0	1	0
33.59	Convertible	18930	2	4	1	0	0	1	0
30.73	Convertible	22479	2	4	1	0	0	1	0
30.32	Convertible	23635	2	4	1	0	0	1	0
30.17	Convertible	25049	2	4	1	0	0	1	0
30.25	Convertible	27558	2	4	1	0	0	1	0
29.14	Convertible	31655	2	4	1	0	0	1	0
29.61	Convertible	32477	2	4	1	0	0	1	0
38.32	Convertible	12090	2	4	1	0	0	1	0
38.17	Convertible	13162	2	4	1	0	0	1	0
37.38	Convertible	16088	2	4	1	0	0	1	0
36.34	Convertible	18195	2	4	1	0	0	1	0
35.58	Convertible	21167	2	4	1	0	0	1	0
35.30	Convertible	21293	2	4	1	0	0	1	0
34.39	Convertible	24031	2	4	1	0	0	1	0
33.98	Convertible	25420	2	4	1	0	0	1	0
33.25	Convertible	27051	2	4	1	0	0	1	0
28.78	Convertible	48991	2	4	1	0	0	1	0
13.01	Coupe	7372	2.2	4	1	0	1	0	0
13.04	Coupe	13607	2.2	4	0	0	1	0	0
12.05	Coupe	19136	2.2	4	0	0	1	0	0
12.47	Coupe	19712	2.2	4	0	0	1	0	0
11.54	Coupe	22405	2.2	4	0	0	1	0	0
11.73	Coupe	23103	2.2	4	0	0	1	0	0
12.21	Coupe	23512	2.2	4	1	0	1	0	0
11.20	Coupe	27364	2.2	4	1	0	1	0	0
10.79	Coupe	31436	2.2	4	1	0	1	0	0
11.15	Coupe	34447	2.2	4	1	0	1	0	0
14.58	Coupe	1160	2.2	4	1	0	1	0	0
13.68	Coupe	10210	2.2	4	1	0	1	0	0
13.45	Coupe	17741	2.2	4	0	0	1	0	0
12.33	Coupe	19347	2.2	4	0	0	1	0	0
12.27	Coupe	19612	2.2	4	1	0	1	0	0
12.63	Coupe	22571	2.2	4	1	0	1	0	0
12.43	Coupe	22771	2.2	4	0	0	1	0	0
12.32	Coupe	24568	2.2	4	1	0	1	0	0
12.55	Coupe	25816	2.2	4	0	0	1	0	0
12.23	Coupe	30297	2.2	4	1	0	1	0	0
15.05	Coupe	4652	2.2	4	1	0	1	0	0
14.40	Coupe	5189	2.2	4	0	0	1	0	0
14.64	Coupe	6224	2.2	4	0	0	1	0	0
13.46	Coupe	14231	2.2	4	1	0	1	0	0
13.68	Coupe	17971	2.2	4	1	0	1	0	0
12.51	Coupe	19715	2.2	4	1	0	1	0	0
13.14	Coupe	19898	2.2	4	1	0	1	0	0
13.59	Coupe	20682	2.2	4	1	0	1	0	0
12.73	Coupe	21386	2.2	4	1	0	1	0	0
12.23	Coupe	28408	2.2	4	0	0	1	0	0
14.02	Coupe	13776	2.2	4	0	0	1	0	0
12.81	Coupe	19461	2.2	4	1	0	1	0	0
13.14	Coupe	21796	2.2	4	1	0	1	0	0
13.11	Coupe	21910	2.2	4	0	0	1	0	0
12.85	Coupe	22382	2.2	4	1	0	1	0	0
12.57	Coupe	22479	2.2	4	0	0	1	0	0
12.90	Coupe	23200	2.2	4	1	0	1	0	0
11.96	Coupe	27394	2.2	4	1	0	1	0	0
12.71	Coupe	27521	2.2	4	1	0	1	0	0
12.49	Coupe	28492	2.2	4	0	0	1	0	0
15.64	Coupe	1169	2.2	4	0	0	1	0	0
15.75	Coupe	6048	2.2	4	0	0	1	0	0
14.62	Coupe	15768	2.2	4	1	0	1	0	0
14.19	Coupe	20374	2.2	4	0	0	1	0	0
13.70	Coupe	25845	2.2	4	1	0	1	0	0
13.31	Coupe	26143	2.2	4	1	0	1	0	0
13.53	Coupe	27249	2.2	4	1	0	1	0	0
13.02	Coupe	27942	2.2	4	1	0	1	0	0
12.68	Coupe	29891	2.2	4	1	0	1	0	0
12.55	Coupe	32844	2.2	4	1	0	1	0	0
39.88	Coupe	7054	6	8	1	0	1	0	0
39.71	Coupe	8967	6	8	1	0	1	0	0
38.99	Coupe	9410	6	8	1	0	1	0	0
39.09	Coupe	10717	6	8	1	0	1	0	0
39.37	Coupe	11619	6	8	1	0	1	0	0
35.26	Coupe	21350	6	8	1	0	1	0	0
35.58	Coupe	22740	6	8	1	0	1	0	0
34.30	Coupe	24259	6	8	1	0	1	0	0
34.74	Coupe	25747	6	8	1	0	1	0	0
31.19	Coupe	34191	6	8	1	0	1	0	0
18.80	Coupe	5827	3.8	6	1	0	1	0	0
18.91	Coupe	8345	3.8	6	1	0	1	0	0
19.18	Coupe	10414	3.8	6	1	0	1	0	0
18.04	Coupe	11647	3.8	6	1	0	1	0	0
17.69	Coupe	15898	3.8	6	1	0	1	0	0
17.52	Coupe	18602	3.8	6	1	0	1	0	0
16.36	Coupe	23491	3.8	6	1	0	1	0	0
16.35	Coupe	25931	3.8	6	1	0	1	0	0
15.80	Coupe	26700	3.8	6	1	0	1	0	0
15.50	Coupe	33345	3.8	6	1	0	1	0	0
21.75	Coupe	7065	3.8	6	1	0	1	0	0
21.73	Coupe	13457	3.8	6	1	0	1	0	0
22.38	Coupe	14788	3.8	6	1	0	1	0	0
20.54	Coupe	16950	3.8	6	1	0	1	0	0
21.23	Coupe	17337	3.8	6	1	0	1	0	0
20.68	Coupe	18021	3.8	6	1	0	1	0	0
20.84	Coupe	22152	3.8	6	1	0	1	0	0
20.02	Coupe	22729	3.8	6	1	0	1	0	0
18.88	Coupe	27218	3.8	6	1	0	1	0	0
17.59	Coupe	39049	3.8	6	1	0	1	0	0
23.57	Coupe	12466	3.8	6	1	0	1	0	0
23.53	Coupe	14948	3.8	6	1	0	1	0	0
22.11	Coupe	21992	3.8	6	1	0	1	0	0
22.47	Coupe	22626	3.8	6	1	0	1	0	0
20.62	Coupe	24067	3.8	6	1	0	1	0	0
20.05	Coupe	24665	3.8	6	1	0	1	0	0
21.53	Coupe	25020	3.8	6	1	0	1	0	0
20.38	Coupe	25240	3.8	6	1	0	1	0	0
21.02	Coupe	25550	3.8	6	1	0	1	0	0
20.22	Coupe	26223	3.8	6	1	0	1	0	0
17.36	Coupe	881	3.4	6	0	0	1	0	0
17.68	Coupe	5131	3.4	6	0	0	1	0	0
17.14	Coupe	6761	3.4	6	1	0	1	0	0
17.20	Coupe	9380	3.4	6	0	0	1	0	0
16.79	Coupe	12071	3.4	6	1	0	1	0	0
15.60	Coupe	18315	3.4	6	0	0	1	0	0
15.25	Coupe	20917	3.4	6	1	0	1	0	0
15.59	Coupe	22414	3.4	6	0	0	1	0	0
15.06	Coupe	22641	3.4	6	1	0	1	0	0
14.70	Coupe	23335	3.4	6	0	0	1	0	0
32.42	Coupe	9185	5.7	8	1	0	1	0	0
32.22	Coupe	10915	5.7	8	1	0	1	0	0
31.02	Coupe	13678	5.7	8	1	0	1	0	0
29.60	Coupe	16193	5.7	8	1	0	1	0	0
29.66	Coupe	21418	5.7	8	1	0	1	0	0
27.43	Coupe	23886	5.7	8	1	0	1	0	0
27.37	Coupe	24960	5.7	8	1	0	1	0	0
27.55	Coupe	26126	5.7	8	1	0	1	0	0
28.50	Coupe	27199	5.7	8	1	0	1	0	0
25.53	Coupe	36480	5.7	8	1	0	1	0	0
13.16	Coupe	13145	2.2	4	0	0	1	0	0
12.83	Coupe	17830	2.2	4	1	0	1	0	0
12.83	Coupe	19081	2.2	4	1	0	1	0	0
12.88	Coupe	19225	2.2	4	1	0	1	0	0
12.83	Coupe	20618	2.2	4	1	0	1	0	0
12.46	Coupe	21891	2.2	4	1	0	1	0	0
12.47	Coupe	23931	2.2	4	0	0	1	0	0
12.26	Coupe	24318	2.2	4	1	0	1	0	0
11.90	Coupe	25285	2.2	4	0	0	1	0	0
12.21	Coupe	26097	2.2	4	0	0	1	0	0
16.92	Coupe	2879	2.2	4	1	0	1	0	0
15.64	Coupe	8507	2.2	4	1	0	1	0	0
16.26	Coupe	10555	2.2	4	0	0	1	0	0
15.40	Coupe	12920	2.2	4	1	0	1	0	0
14.88	Coupe	14376	2.2	4	0	0	1	0	0
15.28	Coupe	16951	2.2	4	0	0	1	0	0
14.70	Coupe	17656	2.2	4	1	0	1	0	0
15.03	Coupe	19455	2.2	4	0	0	1	0	0
13.99	Coupe	21020	2.2	4	0	0	1	0	0
14.77	Coupe	22255	2.2	4	1	0	1	0	0
13.72	Coupe	23645	2.2	4	0	0	1	0	0
13.87	Coupe	24349	2.2	4	1	0	1	0	0
13.52	Coupe	25981	2.2	4	1	0	1	0	0
13.83	Coupe	26034	2.2	4	0	0	1	0	0
13.81	Coupe	26236	2.2	4	0	0	1	0	0
14.08	Coupe	26788	2.2	4	0	0	1	0	0
14.41	Coupe	26986	2.2	4	1	0	1	0	0
13.60	Coupe	27231	2.2	4	0	0	1	0	0
13.03	Coupe	30108	2.2	4	1	0	1	0	0
11.54	Coupe	38958	2.2	4	0	0	1	0	0
12.15	Compact	10011	1.6	4	0	0	0	0	1
12.16	Compact	12101	1.6	4	0	0	0	0	1
11.47	Compact	19699	1.6	4	0	0	0	0	1
11.02	Compact	20100	1.6	4	0	0	0	0	1
11.10	Compact	20334	1.6	4	1	0	0	0	1
10.39	Compact	22225	1.6	4	0	0	0	0	1
11.14	Compact	22484	1.6	4	0	0	0	0	1
11.05	Compact	24568	1.6	4	1	0	0	0	1
10.78	Compact	27906	1.6	4	0	0	0	0	1
9.93	Compact	29680	1.6	4	0	0	0	0	1
11.03	Compact	20156	1.6	4	0	0	0	0	1
11.34	Compact	20186	1.6	4	1	0	0	0	1
11.39	Compact	21421	1.6	4	0	0	0	0	1
11.25	Compact	21427	1.6	4	1	0	0	0	1
10.92	Compact	23119	1.6	4	0	0	0	0	1
11.18	Compact	23121	1.6	4	0	0	0	0	1
11.39	Compact	25107	1.6	4	0	0	0	0	1
11.07	Compact	25476	1.6	4	0	0	0	0	1
11.01	Compact	25746	1.6	4	1	0	0	0	1
11.12	Compact	30056	1.6	4	1	0	0	0	1
10.81	Compact	266	1.6	4	1	0	0	0	1
11.17	Compact	4716	1.6	4	1	0	0	0	1
10.90	Compact	6699	1.6	4	0	0	0	0	1
10.11	Compact	14200	1.6	4	1	0	0	0	1
10.35	Compact	14521	1.6	4	0	0	0	0	1
10.29	Compact	16521	1.6	4	1	0	0	0	1
9.72	Compact	20836	1.6	4	1	0	0	0	1
9.51	Compact	22169	1.6	4	0	0	0	0	1
9.79	Compact	22986	1.6	4	0	0	0	0	1
9.22	Compact	29992	1.6	4	1	0	0	0	1
18.96	Compact	5936	3.5	6	0	0	0	0	1
18.95	Compact	8687	3.5	6	0	0	0	0	1
17.89	Compact	17020	3.5	6	0	0	0	0	1
17.80	Compact	19386	3.5	6	1	0	0	0	1
16.72	Compact	19740	3.5	6	1	0	0	0	1
16.74	Compact	21829	3.5	6	0	0	0	0	1
16.83	Compact	23460	3.5	6	0	0	0	0	1
16.54	Compact	24583	3.5	6	0	0	0	0	1
16.14	Compact	26532	3.5	6	1	0	0	0	1
14.91	Compact	33906	3.5	6	0	0	0	0	1
19.47	Compact	6608	3.5	6	1	0	0	0	1
18.01	Compact	15190	3.5	6	0	0	0	0	1
18.27	Compact	16335	3.5	6	0	0	0	0	1
18.31	Compact	17441	3.5	6	0	0	0	0	1
17.55	Compact	18451	3.5	6	0	0	0	0	1
18.00	Compact	18771	3.5	6	0	0	0	0	1
17.66	Compact	19490	3.5	6	1	0	0	0	1
17.12	Compact	24461	3.5	6	0	0	0	0	1
16.99	Compact	24905	3.5	6	1	0	0	0	1
16.80	Compact	25874	3.5	6	1	0	0	0	1
18.97	Compact	5632	3.5	6	0	0	0	0	1
18.32	Compact	7397	3.5	6	1	0	0	0	1
19.58	Compact	7645	3.5	6	0	0	0	0	1
18.17	Compact	14754	3.5	6	0	0	0	0	1
17.99	Compact	17488	3.5	6	0	0	0	0	1
17.17	Compact	18721	3.5	6	0	0	0	0	1
16.46	Compact	20200	3.5	6	0	0	0	0	1
16.27	Compact	21452	3.5	6	0	0	0	0	1
16.86	Compact	22841	3.5	6	1	0	0	0	1
16.03	Compact	22889	3.5	6	0	0	0	0	1
17.31	Sedan	8221	3.1	6	1	1	0	0	0
17.54	Sedan	9135	3.1	6	1	1	0	0	0
16.22	Sedan	13196	3.1	6	1	1	0	0	0
16.34	Sedan	16342	3.1	6	1	1	0	0	0
16.34	Sedan	19832	3.1	6	1	1	0	0	0
15.71	Sedan	22236	3.1	6	1	1	0	0	0
15.23	Sedan	22576	3.1	6	1	1	0	0	0
15.05	Sedan	22964	3.1	6	1	1	0	0	0
14.86	Sedan	24021	3.1	6	1	1	0	0	0
15.30	Sedan	27325	3.1	6	1	1	0	0	0
21.34	Sedan	10237	3.6	6	1	1	0	0	0
20.54	Sedan	15066	3.6	6	1	1	0	0	0
20.51	Sedan	16633	3.6	6	1	1	0	0	0
19.92	Sedan	19800	3.6	6	1	1	0	0	0
19.77	Sedan	23359	3.6	6	1	1	0	0	0
19.34	Sedan	23765	3.6	6	1	1	0	0	0
19.11	Sedan	24008	3.6	6	1	1	0	0	0
18.54	Sedan	26034	3.6	6	1	1	0	0	0
17.81	Sedan	32896	3.6	6	1	1	0	0	0
17.97	Sedan	34665	3.6	6	1	1	0	0	0
22.36	Sedan	8970	3.6	6	1	1	0	0	0
23.79	Sedan	10577	3.6	6	1	1	0	0	0
22.93	Sedan	14363	3.6	6	1	1	0	0	0
21.90	Sedan	16508	3.6	6	1	1	0	0	0
21.27	Sedan	18908	3.6	6	1	1	0	0	0
21.46	Sedan	19467	3.6	6	1	1	0	0	0
21.18	Sedan	21394	3.6	6	1	1	0	0	0
20.41	Sedan	22596	3.6	6	1	1	0	0	0
21.06	Sedan	24469	3.6	6	1	1	0	0	0
19.56	Sedan	25245	3.6	6	1	1	0	0	0
23.45	Sedan	15755	3.8	6	1	1	0	0	0
23.55	Sedan	16235	3.8	6	1	1	0	0	0
23.02	Sedan	18147	3.8	6	1	1	0	0	0
22.23	Sedan	22102	3.8	6	1	1	0	0	0
22.63	Sedan	23612	3.8	6	1	1	0	0	0
21.80	Sedan	24439	3.8	6	1	1	0	0	0
21.34	Sedan	25212	3.8	6	1	1	0	0	0
21.68	Sedan	26779	3.8	6	1	1	0	0	0
20.99	Sedan	27096	3.8	6	1	1	0	0	0
20.90	Sedan	29649	3.8	6	1	1	0	0	0
20.70	Sedan	2992	3.8	6	1	1	0	0	0
20.10	Sedan	10036	3.8	6	1	1	0	0	0
18.15	Sedan	18339	3.8	6	1	1	0	0	0
17.94	Sedan	19592	3.8	6	1	1	0	0	0
19.03	Sedan	21797	3.8	6	1	1	0	0	0
18.35	Sedan	23852	3.8	6	1	1	0	0	0
17.75	Sedan	25040	3.8	6	1	1	0	0	0
17.77	Sedan	25052	3.8	6	1	1	0	0	0
17.39	Sedan	25464	3.8	6	1	1	0	0	0
17.65	Sedan	27830	3.8	6	1	1	0	0	0
21.91	Sedan	17353	3.8	6	1	1	0	0	0
21.96	Sedan	17787	3.8	6	1	1	0	0	0
21.65	Sedan	19562	3.8	6	1	1	0	0	0
21.58	Sedan	20137	3.8	6	1	1	0	0	0
20.95	Sedan	20158	3.8	6	1	1	0	0	0
21.56	Sedan	23767	3.8	6	1	1	0	0	0
19.98	Sedan	24323	3.8	6	1	1	0	0	0
19.43	Sedan	27839	3.8	6	1	1	0	0	0
19.19	Sedan	29187	3.8	6	1	1	0	0	0
19.64	Sedan	31324	3.8	6	1	1	0	0	0
25.59	Sedan	2308	3.8	6	1	1	0	0	0
25.10	Sedan	10014	3.8	6	1	1	0	0	0
23.42	Sedan	18910	3.8	6	1	1	0	0	0
22.66	Sedan	20105	3.8	6	1	1	0	0	0
23.49	Sedan	20453	3.8	6	1	1	0	0	0
22.44	Sedan	22287	3.8	6	1	1	0	0	0
21.88	Sedan	23237	3.8	6	1	1	0	0	0
23.08	Sedan	23798	3.8	6	1	1	0	0	0
21.70	Sedan	25489	3.8	6	1	1	0	0	0
21.83	Sedan	25564	3.8	6	1	1	0	0	0
26.83	Sedan	4695	3.8	6	1	1	0	0	0
26.06	Sedan	9795	3.8	6	1	1	0	0	0
26.78	Sedan	12052	3.8	6	1	1	0	0	0
26.30	Sedan	13050	3.8	6	1	1	0	0	0
26.19	Sedan	17335	3.8	6	1	1	0	0	0
25.51	Sedan	17480	3.8	6	1	1	0	0	0
23.35	Sedan	24027	3.8	6	1	1	0	0	0
23.41	Sedan	25387	3.8	6	1	1	0	0	0
23.16	Sedan	25869	3.8	6	1	1	0	0	0
21.54	Sedan	37128	3.8	6	1	1	0	0	0
51.15	Sedan	2202	5.7	8	1	1	0	0	0
49.25	Sedan	6685	5.7	8	1	1	0	0	0
46.75	Sedan	15343	5.7	8	1	1	0	0	0
44.13	Sedan	21341	5.7	8	1	1	0	0	0
44.08	Sedan	21367	5.7	8	1	1	0	0	0
43.89	Sedan	23371	5.7	8	1	1	0	0	0
44.30	Sedan	23751	5.7	8	1	1	0	0	0
42.68	Sedan	24052	5.7	8	1	1	0	0	0
43.37	Sedan	25199	5.7	8	1	1	0	0	0
40.62	Sedan	30082	5.7	8	1	1	0	0	0
33.42	Sedan	6598	2.8	6	1	1	0	0	0
30.96	Sedan	10625	2.8	6	1	1	0	0	0
31.43	Sedan	11013	2.8	6	1	1	0	0	0
30.78	Sedan	14937	2.8	6	1	1	0	0	0
30.65	Sedan	17094	2.8	6	1	1	0	0	0
30.79	Sedan	17870	2.8	6	1	1	0	0	0
30.39	Sedan	18449	2.8	6	1	1	0	0	0
28.82	Sedan	21039	2.8	6	1	1	0	0	0
29.28	Sedan	21056	2.8	6	1	1	0	0	0
28.04	Sedan	27484	2.8	6	1	1	0	0	0
39.80	Sedan	14095	4.6	8	1	1	0	0	0
40.34	Sedan	14743	4.6	8	1	1	0	0	0
39.31	Sedan	16041	4.6	8	1	1	0	0	0
38.60	Sedan	17138	4.6	8	1	1	0	0	0
38.45	Sedan	18661	4.6	8	1	1	0	0	0
36.08	Sedan	21966	4.6	8	1	1	0	0	0
35.87	Sedan	24415	4.6	8	1	1	0	0	0
35.34	Sedan	25163	4.6	8	1	1	0	0	0
36.15	Sedan	25339	4.6	8	1	1	0	0	0
34.69	Sedan	25421	4.6	8	1	1	0	0	0
42.82	Sedan	5499	4.6	8	1	1	0	0	0
41.38	Sedan	8125	4.6	8	1	1	0	0	0
40.86	Sedan	12791	4.6	8	1	1	0	0	0
41.42	Sedan	14452	4.6	8	1	1	0	0	0
37.51	Sedan	21593	4.6	8	1	1	0	0	0
37.22	Sedan	22211	4.6	8	1	1	0	0	0
36.33	Sedan	25153	4.6	8	1	1	0	0	0
36.25	Sedan	26250	4.6	8	1	1	0	0	0
32.95	Sedan	36074	4.6	8	1	1	0	0	0
32.54	Sedan	41829	4.6	8	1	1	0	0	0
35.72	Sedan	6447	4.6	8	1	1	0	0	0
35.65	Sedan	10555	4.6	8	1	1	0	0	0
35.13	Sedan	11975	4.6	8	1	1	0	0	0
35.17	Sedan	13449	4.6	8	1	1	0	0	0
32.50	Sedan	17508	4.6	8	1	1	0	0	0
33.22	Sedan	18661	4.6	8	1	1	0	0	0
32.51	Sedan	20910	4.6	8	1	1	0	0	0
31.13	Sedan	23124	4.6	8	1	1	0	0	0
31.18	Sedan	26222	4.6	8	1	1	0	0	0
31.06	Sedan	27544	4.6	8	1	1	0	0	0
42.74	Sedan	2846	3.6	6	1	1	0	0	0
40.97	Sedan	7476	3.6	6	1	1	0	0	0
38.80	Sedan	13973	3.6	6	1	1	0	0	0
38.30	Sedan	16754	3.6	6	1	1	0	0	0
37.19	Sedan	19100	3.6	6	1	1	0	0	0
36.21	Sedan	21778	3.6	6	1	1	0	0	0
36.63	Sedan	22042	3.6	6	1	1	0	0	0
35.90	Sedan	23056	3.6	6	1	1	0	0	0
34.97	Sedan	25796	3.6	6	1	1	0	0	0
32.04	Sedan	35326	3.6	6	1	1	0	0	0
48.31	Sedan	788	4.6	8	1	1	0	0	0
48.37	Sedan	2616	4.6	8	1	1	0	0	0
45.06	Sedan	13829	4.6	8	1	1	0	0	0
44.21	Sedan	15104	4.6	8	1	1	0	0	0
42.38	Sedan	18581	4.6	8	1	1	0	0	0
41.67	Sedan	20575	4.6	8	1	1	0	0	0
41.52	Sedan	23861	4.6	8	1	1	0	0	0
41.05	Sedan	25717	4.6	8	1	1	0	0	0
38.21	Sedan	31303	4.6	8	1	1	0	0	0
39.07	Sedan	31587	4.6	8	1	1	0	0	0
12.65	Sedan	3629	1.6	4	0	1	0	0	0
12.31	Sedan	4142	1.6	4	0	1	0	0	0
11.32	Sedan	11156	1.6	4	0	1	0	0	0
12.41	Sedan	11981	1.6	4	1	1	0	0	0
11.56	Sedan	13404	1.6	4	1	1	0	0	0
11.70	Sedan	15253	1.6	4	1	1	0	0	0
11.22	Sedan	19945	1.6	4	0	1	0	0	0
10.14	Sedan	23963	1.6	4	1	1	0	0	0
10.49	Sedan	30948	1.6	4	0	1	0	0	0
9.95	Sedan	37345	1.6	4	0	1	0	0	0
11.92	Sedan	7278	1.6	4	0	1	0	0	0
12.41	Sedan	10213	1.6	4	0	1	0	0	0
11.30	Sedan	14627	1.6	4	0	1	0	0	0
11.62	Sedan	19014	1.6	4	0	1	0	0	0
10.81	Sedan	21013	1.6	4	1	1	0	0	0
11.17	Sedan	22380	1.6	4	0	1	0	0	0
10.77	Sedan	25065	1.6	4	0	1	0	0	0
10.87	Sedan	25869	1.6	4	0	1	0	0	0
10.92	Sedan	27776	1.6	4	1	1	0	0	0
9.92	Sedan	34621	1.6	4	0	1	0	0	0
10.97	Sedan	7091	1.6	4	1	1	0	0	0
10.32	Sedan	14438	1.6	4	0	1	0	0	0
9.65	Sedan	19183	1.6	4	0	1	0	0	0
9.56	Sedan	19273	1.6	4	1	1	0	0	0
9.67	Sedan	19565	1.6	4	0	1	0	0	0
9.48	Sedan	24842	1.6	4	1	1	0	0	0
8.64	Sedan	25216	1.6	4	0	1	0	0	0
9.04	Sedan	26191	1.6	4	0	1	0	0	0
8.87	Sedan	32914	1.6	4	1	1	0	0	0
8.77	Sedan	35299	1.6	4	0	1	0	0	0
14.89	Sedan	2464	2.2	4	0	1	0	0	0
14.20	Sedan	11322	2.2	4	1	1	0	0	0
14.68	Sedan	11488	2.2	4	1	1	0	0	0
13.17	Sedan	14630	2.2	4	0	1	0	0	0
13.47	Sedan	18910	2.2	4	1	1	0	0	0
12.57	Sedan	25048	2.2	4	1	1	0	0	0
12.38	Sedan	25069	2.2	4	1	1	0	0	0
13.23	Sedan	25862	2.2	4	0	1	0	0	0
11.08	Sedan	36855	2.2	4	0	1	0	0	0
11.33	Sedan	39946	2.2	4	1	1	0	0	0
14.22	Sedan	8427	2.2	4	0	1	0	0	0
14.27	Sedan	8615	2.2	4	0	1	0	0	0
14.26	Sedan	16958	2.2	4	0	1	0	0	0
13.76	Sedan	18040	2.2	4	1	1	0	0	0
14.28	Sedan	18533	2.2	4	1	1	0	0	0
13.69	Sedan	18766	2.2	4	1	1	0	0	0
13.31	Sedan	20043	2.2	4	0	1	0	0	0
14.15	Sedan	20512	2.2	4	1	1	0	0	0
12.94	Sedan	21684	2.2	4	0	1	0	0	0
12.85	Sedan	27560	2.2	4	1	1	0	0	0
14.06	Sedan	4922	2.2	4	0	1	0	0	0
13.07	Sedan	14311	2.2	4	0	1	0	0	0
11.70	Sedan	19816	2.2	4	1	1	0	0	0
12.26	Sedan	21492	2.2	4	1	1	0	0	0
11.57	Sedan	21525	2.2	4	0	1	0	0	0
11.54	Sedan	24163	2.2	4	0	1	0	0	0
12.24	Sedan	25014	2.2	4	1	1	0	0	0
11.67	Sedan	25727	2.2	4	1	1	0	0	0
11.46	Sedan	29410	2.2	4	1	1	0	0	0
10.55	Sedan	38866	2.2	4	1	1	0	0	0
15.55	Sedan	7695	2.2	4	0	1	0	0	0
15.05	Sedan	12305	2.2	4	1	1	0	0	0
13.54	Sedan	17343	2.2	4	0	1	0	0	0
14.08	Sedan	17445	2.2	4	0	1	0	0	0
12.98	Sedan	20309	2.2	4	1	1	0	0	0
13.44	Sedan	20530	2.2	4	0	1	0	0	0
13.16	Sedan	21145	2.2	4	1	1	0	0	0
14.22	Sedan	23069	2.2	4	1	1	0	0	0
12.38	Sedan	31199	2.2	4	1	1	0	0	0
11.58	Sedan	36566	2.2	4	0	1	0	0	0
15.00	Sedan	8880	2.2	4	0	1	0	0	0
14.85	Sedan	12980	2.2	4	0	1	0	0	0
15.13	Sedan	13828	2.2	4	1	1	0	0	0
15.00	Sedan	14504	2.2	4	0	1	0	0	0
14.59	Sedan	18790	2.2	4	0	1	0	0	0
14.30	Sedan	21128	2.2	4	0	1	0	0	0
13.69	Sedan	21611	2.2	4	1	1	0	0	0
13.74	Sedan	23748	2.2	4	0	1	0	0	0
13.55	Sedan	27431	2.2	4	0	1	0	0	0
12.74	Sedan	34815	2.2	4	0	1	0	0	0
16.12	Sedan	865	2.2	4	1	1	0	0	0
16.43	Sedan	9882	2.2	4	0	1	0	0	0
15.08	Sedan	14824	2.2	4	1	1	0	0	0
15.16	Sedan	17158	2.2	4	1	1	0	0	0
14.90	Sedan	18210	2.2	4	1	1	0	0	0
14.51	Sedan	18910	2.2	4	0	1	0	0	0
14.42	Sedan	19818	2.2	4	0	1	0	0	0
14.19	Sedan	21181	2.2	4	1	1	0	0	0
14.40	Sedan	21527	2.2	4	0	1	0	0	0
14.18	Sedan	21627	2.2	4	0	1	0	0	0
14.43	Sedan	6114	2.2	4	1	1	0	0	0
14.70	Sedan	6709	2.2	4	1	1	0	0	0
14.58	Sedan	7115	2.2	4	1	1	0	0	0
14.19	Sedan	9561	2.2	4	0	1	0	0	0
14.07	Sedan	15233	2.2	4	0	1	0	0	0
13.99	Sedan	17270	2.2	4	0	1	0	0	0
13.83	Sedan	17594	2.2	4	0	1	0	0	0
13.16	Sedan	22740	2.2	4	1	1	0	0	0
12.50	Sedan	26204	2.2	4	0	1	0	0	0
12.68	Sedan	28683	2.2	4	0	1	0	0	0
21.76	Sedan	1853	3.8	6	1	1	0	0	0
19.53	Sedan	14115	3.8	6	1	1	0	0	0
19.08	Sedan	18198	3.8	6	1	1	0	0	0
19.41	Sedan	18795	3.8	6	1	1	0	0	0
18.53	Sedan	19874	3.8	6	1	1	0	0	0
18.91	Sedan	21512	3.8	6	1	1	0	0	0
17.84	Sedan	25453	3.8	6	1	1	0	0	0
17.79	Sedan	26980	3.8	6	1	1	0	0	0
17.29	Sedan	29368	3.8	6	1	1	0	0	0
18.08	Sedan	29420	3.8	6	1	1	0	0	0
20.02	Sedan	1787	3.8	6	1	1	0	0	0
18.84	Sedan	8211	3.8	6	1	1	0	0	0
18.73	Sedan	14054	3.8	6	1	1	0	0	0
16.81	Sedan	19498	3.8	6	1	1	0	0	0
17.15	Sedan	21567	3.8	6	1	1	0	0	0
16.64	Sedan	22383	3.8	6	1	1	0	0	0
15.95	Sedan	26070	3.8	6	1	1	0	0	0
16.51	Sedan	27460	3.8	6	1	1	0	0	0
15.83	Sedan	31202	3.8	6	1	1	0	0	0
15.55	Sedan	33357	3.8	6	1	1	0	0	0
25.95	Sedan	636	3.8	6	1	1	0	0	0
27.71	Sedan	5379	3.8	6	1	1	0	0	0
25.10	Sedan	14461	3.8	6	1	1	0	0	0
24.81	Sedan	16111	3.8	6	1	1	0	0	0
23.35	Sedan	22964	3.8	6	1	1	0	0	0
22.89	Sedan	26272	3.8	6	1	1	0	0	0
22.06	Sedan	27384	3.8	6	1	1	0	0	0
23.15	Sedan	27940	3.8	6	1	1	0	0	0
22.12	Sedan	28242	3.8	6	1	1	0	0	0
20.29	Sedan	33892	3.8	6	1	1	0	0	0
19.16	Sedan	1480	3.5	6	1	1	0	0	0
18.80	Sedan	7961	3.5	6	0	1	0	0	0
17.46	Sedan	15144	3.5	6	1	1	0	0	0
17.16	Sedan	21417	3.5	6	0	1	0	0	0
16.47	Sedan	21675	3.5	6	1	1	0	0	0
16.99	Sedan	23621	3.5	6	0	1	0	0	0
16.30	Sedan	25697	3.5	6	1	1	0	0	0
15.62	Sedan	27476	3.5	6	0	1	0	0	0
15.14	Sedan	32462	3.5	6	0	1	0	0	0
15.23	Sedan	32535	3.5	6	0	1	0	0	0
19.45	Sedan	932	3.5	6	0	1	0	0	0
17.12	Sedan	18277	3.5	6	1	1	0	0	0
17.32	Sedan	19593	3.5	6	1	1	0	0	0
16.86	Sedan	19883	3.5	6	1	1	0	0	0
17.31	Sedan	21420	3.5	6	1	1	0	0	0
16.40	Sedan	23133	3.5	6	1	1	0	0	0
16.54	Sedan	24218	3.5	6	1	1	0	0	0
16.34	Sedan	25394	3.5	6	0	1	0	0	0
16.71	Sedan	26328	3.5	6	1	1	0	0	0
16.30	Sedan	28239	3.5	6	0	1	0	0	0
17.09	Sedan	8732	3.5	6	0	1	0	0	0
17.46	Sedan	11393	3.5	6	1	1	0	0	0
17.22	Sedan	14579	3.5	6	1	1	0	0	0
17.16	Sedan	15903	3.5	6	0	1	0	0	0
16.51	Sedan	17451	3.5	6	0	1	0	0	0
16.75	Sedan	18562	3.5	6	1	1	0	0	0
16.65	Sedan	20154	3.5	6	0	1	0	0	0
15.62	Sedan	21272	3.5	6	1	1	0	0	0
15.66	Sedan	25787	3.5	6	1	1	0	0	0
15.68	Sedan	25956	3.5	6	0	1	0	0	0
25.45	Sedan	11892	4.6	8	1	1	0	0	0
23.45	Sedan	17273	4.6	8	1	1	0	0	0
23.58	Sedan	19148	4.6	8	1	1	0	0	0
22.53	Sedan	19521	4.6	8	1	1	0	0	0
21.98	Sedan	20472	4.6	8	1	1	0	0	0
22.23	Sedan	21929	4.6	8	1	1	0	0	0
22.19	Sedan	25651	4.6	8	1	1	0	0	0
21.77	Sedan	25794	4.6	8	1	1	0	0	0
21.40	Sedan	27168	4.6	8	1	1	0	0	0
21.20	Sedan	31197	4.6	8	1	1	0	0	0
19.68	Sedan	11554	3.8	6	1	1	0	0	0
18.68	Sedan	16496	3.8	6	1	1	0	0	0
20.32	Sedan	17583	3.8	6	1	1	0	0	0
20.13	Sedan	18419	3.8	6	1	1	0	0	0
19.75	Sedan	20510	3.8	6	1	1	0	0	0
17.84	Sedan	21121	3.8	6	1	1	0	0	0
18.86	Sedan	22423	3.8	6	1	1	0	0	0
18.57	Sedan	24747	3.8	6	1	1	0	0	0
18.06	Sedan	27574	3.8	6	1	1	0	0	0
17.77	Sedan	28385	3.8	6	1	1	0	0	0
23.20	Sedan	2295	3.8	6	1	1	0	0	0
23.10	Sedan	5653	3.8	6	1	1	0	0	0
22.46	Sedan	8928	3.8	6	1	1	0	0	0
21.61	Sedan	11069	3.8	6	1	1	0	0	0
22.00	Sedan	15516	3.8	6	1	1	0	0	0
20.83	Sedan	19419	3.8	6	1	1	0	0	0
20.11	Sedan	22891	3.8	6	1	1	0	0	0
19.12	Sedan	26252	3.8	6	1	1	0	0	0
19.69	Sedan	27077	3.8	6	1	1	0	0	0
19.34	Sedan	27966	3.8	6	1	1	0	0	0
21.90	Sedan	4537	3.5	6	1	1	0	0	0
22.74	Sedan	5690	3.5	6	1	1	0	0	0
22.10	Sedan	9049	3.5	6	1	1	0	0	0
22.31	Sedan	11221	3.5	6	1	1	0	0	0
21.88	Sedan	12313	3.5	6	1	1	0	0	0
20.63	Sedan	20770	3.5	6	1	1	0	0	0
19.54	Sedan	22628	3.5	6	1	1	0	0	0
19.20	Sedan	26477	3.5	6	1	1	0	0	0
18.16	Sedan	28354	3.5	6	1	1	0	0	0
18.53	Sedan	30063	3.5	6	1	1	0	0	0
21.38	Sedan	7287	3.5	6	1	1	0	0	0
20.45	Sedan	10338	3.5	6	1	1	0	0	0
20.68	Sedan	11204	3.5	6	1	1	0	0	0
19.29	Sedan	19539	3.5	6	1	1	0	0	0
18.55	Sedan	20870	3.5	6	1	1	0	0	0
18.04	Sedan	21702	3.5	6	1	1	0	0	0
18.62	Sedan	25516	3.5	6	1	1	0	0	0
17.02	Sedan	30404	3.5	6	1	1	0	0	0
16.22	Sedan	35624	3.5	6	1	1	0	0	0
15.79	Sedan	41566	3.5	6	1	1	0	0	0
15.98	Sedan	3946	2.2	4	1	1	0	0	0
16.38	Sedan	4188	2.2	4	1	1	0	0	0
15.33	Sedan	4318	2.2	4	0	1	0	0	0
15.85	Sedan	5350	2.2	4	0	1	0	0	0
15.60	Sedan	5788	2.2	4	1	1	0	0	0
14.84	Sedan	12420	2.2	4	0	1	0	0	0
15.08	Sedan	13262	2.2	4	0	1	0	0	0
13.96	Sedan	19602	2.2	4	0	1	0	0	0
13.03	Sedan	23976	2.2	4	0	1	0	0	0
13.16	Sedan	24542	2.2	4	0	1	0	0	0
18.25	Sedan	16554	3.8	6	1	1	0	0	0
17.10	Sedan	18720	3.8	6	1	1	0	0	0
17.16	Sedan	20829	3.8	6	1	1	0	0	0
16.39	Sedan	21304	3.8	6	1	1	0	0	0
15.79	Sedan	25295	3.8	6	1	1	0	0	0
16.57	Sedan	25777	3.8	6	1	1	0	0	0
17.00	Sedan	25830	3.8	6	1	1	0	0	0
16.28	Sedan	26511	3.8	6	1	1	0	0	0
15.46	Sedan	29925	3.8	6	1	1	0	0	0
14.96	Sedan	31471	3.8	6	1	1	0	0	0
21.23	Sedan	11229	3.8	6	1	1	0	0	0
22.10	Sedan	12314	3.8	6	1	1	0	0	0
21.30	Sedan	12772	3.8	6	1	1	0	0	0
21.28	Sedan	17417	3.8	6	1	1	0	0	0
19.65	Sedan	21132	3.8	6	1	1	0	0	0
20.17	Sedan	21211	3.8	6	1	1	0	0	0
18.70	Sedan	24992	3.8	6	1	1	0	0	0
19.42	Sedan	25557	3.8	6	1	1	0	0	0
19.96	Sedan	26028	3.8	6	1	1	0	0	0
19.45	Sedan	27721	3.8	6	1	1	0	0	0
19.82	Sedan	1592	3.8	6	1	1	0	0	0
19.57	Sedan	2189	3.8	6	1	1	0	0	0
16.85	Sedan	17959	3.8	6	1	1	0	0	0
16.52	Sedan	20751	3.8	6	1	1	0	0	0
15.98	Sedan	21974	3.8	6	1	1	0	0	0
16.26	Sedan	22637	3.8	6	1	1	0	0	0
15.72	Sedan	23989	3.8	6	1	1	0	0	0
15.97	Sedan	25598	3.8	6	1	1	0	0	0
16.04	Sedan	27800	3.8	6	1	1	0	0	0
15.76	Sedan	29325	3.8	6	1	1	0	0	0
29.25	Sedan	3907	2	4	1	1	0	0	0
26.34	Sedan	16068	2	4	1	1	0	0	0
26.78	Sedan	16688	2	4	1	1	0	0	0
25.30	Sedan	19569	2	4	1	1	0	0	0
24.90	Sedan	21266	2	4	1	1	0	0	0
26.00	Sedan	21433	2	4	1	1	0	0	0
24.80	Sedan	26345	2	4	1	1	0	0	0
24.06	Sedan	27674	2	4	1	1	0	0	0
23.25	Sedan	27686	2	4	1	1	0	0	0
22.24	Sedan	50387	2	4	1	1	0	0	0
26.84	Sedan	10003	2	4	1	1	0	0	0
27.83	Sedan	10014	2	4	1	1	0	0	0
27.28	Sedan	14281	2	4	1	1	0	0	0
27.06	Sedan	17319	2	4	1	1	0	0	0
25.62	Sedan	20208	2	4	1	1	0	0	0
25.79	Sedan	21160	2	4	1	1	0	0	0
25.15	Sedan	22272	2	4	1	1	0	0	0
24.85	Sedan	22814	2	4	1	1	0	0	0
24.17	Sedan	27015	2	4	1	1	0	0	0
23.73	Sedan	27600	2	4	1	1	0	0	0
32.20	Sedan	3867	2	4	1	1	0	0	0
32.05	Sedan	5144	2	4	1	1	0	0	0
30.27	Sedan	10800	2	4	1	1	0	0	0
30.35	Sedan	11273	2	4	1	1	0	0	0
30.12	Sedan	14568	2	4	1	1	0	0	0
26.79	Sedan	22189	2	4	1	1	0	0	0
28.29	Sedan	22328	2	4	1	1	0	0	0
27.11	Sedan	22598	2	4	1	1	0	0	0
27.26	Sedan	26400	2	4	1	1	0	0	0
25.27	Sedan	34175	2	4	1	1	0	0	0
35.03	Sedan	1676	2.3	4	1	1	0	0	0
32.75	Sedan	7924	2.3	4	1	1	0	0	0
33.18	Sedan	9795	2.3	4	1	1	0	0	0
31.00	Sedan	15087	2.3	4	1	1	0	0	0
30.08	Sedan	22052	2.3	4	1	1	0	0	0
29.84	Sedan	23143	2.3	4	1	1	0	0	0
28.43	Sedan	25247	2.3	4	1	1	0	0	0
28.05	Sedan	26276	2.3	4	1	1	0	0	0
28.50	Sedan	28598	2.3	4	1	1	0	0	0
24.91	Sedan	38717	2.3	4	1	1	0	0	0
30.80	Sedan	8017	2.3	4	1	1	0	0	0
28.42	Sedan	14613	2.3	4	1	1	0	0	0
28.19	Sedan	19854	2.3	4	1	1	0	0	0
28.20	Sedan	22021	2.3	4	1	1	0	0	0
26.65	Sedan	22590	2.3	4	1	1	0	0	0
27.61	Sedan	22881	2.3	4	1	1	0	0	0
26.70	Sedan	23055	2.3	4	1	1	0	0	0
27.24	Sedan	23204	2.3	4	1	1	0	0	0
27.70	Sedan	24738	2.3	4	1	1	0	0	0
24.41	Sedan	31344	2.3	4	1	1	0	0	0
14.74	Sedan	1737	2.2	4	0	1	0	0	0
15.11	Sedan	2392	2.2	4	1	1	0	0	0
14.20	Sedan	11836	2.2	4	0	1	0	0	0
15.19	Sedan	12412	2.2	4	0	1	0	0	0
14.12	Sedan	12878	2.2	4	1	1	0	0	0
13.17	Sedan	13318	2.2	4	0	1	0	0	0
13.26	Sedan	14938	2.2	4	1	1	0	0	0
12.79	Sedan	16163	2.2	4	0	1	0	0	0
12.29	Sedan	17139	2.2	4	1	1	0	0	0
14.00	Sedan	18257	2.2	4	0	1	0	0	0
14.57	Sedan	18511	2.2	4	0	1	0	0	0
13.12	Sedan	19101	2.2	4	0	1	0	0	0
13.49	Sedan	19500	2.2	4	1	1	0	0	0
12.04	Sedan	19853	2.2	4	0	1	0	0	0
12.16	Sedan	21770	2.2	4	0	1	0	0	0
12.33	Sedan	21877	2.2	4	0	1	0	0	0
12.10	Sedan	22758	2.2	4	1	1	0	0	0
12.12	Sedan	22826	2.2	4	0	1	0	0	0
11.68	Sedan	23388	2.2	4	0	1	0	0	0
13.22	Sedan	24069	2.2	4	0	1	0	0	0
12.41	Sedan	24664	2.2	4	0	1	0	0	0
12.28	Sedan	24740	2.2	4	1	1	0	0	0
12.59	Sedan	26328	2.2	4	0	1	0	0	0
12.11	Sedan	28298	2.2	4	0	1	0	0	0
11.87	Sedan	28398	2.2	4	0	1	0	0	0
12.97	Sedan	29707	2.2	4	0	1	0	0	0
10.56	Sedan	32458	2.2	4	0	1	0	0	0
11.41	Sedan	32619	2.2	4	1	1	0	0	0
11.50	Sedan	33962	2.2	4	0	1	0	0	0
11.52	Sedan	34998	2.2	4	0	1	0	0	0
18.17	Sedan	5826	3	6	1	1	0	0	0
18.49	Sedan	7755	3	6	1	1	0	0	0
17.32	Sedan	10102	3	6	1	1	0	0	0
17.98	Sedan	10986	3	6	1	1	0	0	0
16.43	Sedan	14242	3	6	1	1	0	0	0
16.51	Sedan	16229	3	6	1	1	0	0	0
16.18	Sedan	19095	3	6	1	1	0	0	0
15.73	Sedan	20484	3	6	1	1	0	0	0
15.12	Sedan	25979	3	6	1	1	0	0	0
13.59	Sedan	35662	3	6	1	1	0	0	0
16.39	SUV	18096	1.8	4	1	0	0	0	0
16.03	SUV	18391	1.8	4	0	0	0	0	0
16.11	SUV	19465	1.8	4	1	0	0	0	0
16.55	SUV	19531	1.8	4	1	0	0	0	0
17.33	SUV	19894	1.8	4	1	0	0	0	0
16.08	SUV	22779	1.8	4	0	0	0	0	0
15.30	SUV	23062	1.8	4	0	0	0	0	0
15.51	SUV	24239	1.8	4	1	0	0	0	0
15.17	SUV	27887	1.8	4	0	0	0	0	0
14.55	SUV	33374	1.8	4	0	0	0	0	0
17.80	SUV	12303	1.8	4	1	0	0	0	0
16.35	SUV	16078	1.8	4	0	0	0	0	0
15.98	SUV	17053	1.8	4	0	0	0	0	0
15.57	SUV	18206	1.8	4	0	0	0	0	0
15.59	SUV	21307	1.8	4	0	0	0	0	0
15.73	SUV	21391	1.8	4	0	0	0	0	0
15.80	SUV	21461	1.8	4	0	0	0	0	0
15.09	SUV	27438	1.8	4	0	0	0	0	0
14.40	SUV	31424	1.8	4	0	0	0	0	0
14.87	SUV	31791	1.8	4	1	0	0	0	0
16.93	SUV	2973	1.8	4	0	0	0	0	0
17.42	SUV	4463	1.8	4	1	0	0	0	0
16.38	SUV	8754	1.8	4	0	0	0	0	0
16.71	SUV	9150	1.8	4	0	0	0	0	0
17.21	SUV	12610	1.8	4	1	0	0	0	0
15.82	SUV	14304	1.8	4	0	0	0	0	0
14.40	SUV	21688	1.8	4	0	0	0	0	0
15.62	SUV	23217	1.8	4	1	0	0	0	0
14.91	SUV	23323	1.8	4	0	0	0	0	0
14.85	SUV	24270	1.8	4	0	0	0	0	0
31.85	SUV	16956	2.3	4	1	0	0	0	0
32.65	SUV	16975	2.3	4	1	0	0	0	0
29.96	SUV	20015	2.3	4	1	0	0	0	0
31.55	SUV	20103	2.3	4	1	0	0	0	0
29.91	SUV	22105	2.3	4	1	0	0	0	0
30.58	SUV	22298	2.3	4	1	0	0	0	0
30.27	SUV	23426	2.3	4	1	0	0	0	0
28.68	SUV	25380	2.3	4	1	0	0	0	0
28.83	SUV	26503	2.3	4	1	0	0	0	0
26.96	SUV	31773	2.3	4	1	0	0	0	0
33.01	SUV	6409	2.3	4	1	0	0	0	0
30.66	SUV	14278	2.3	4	1	0	0	0	0
30.44	SUV	15050	2.3	4	1	0	0	0	0
30.32	SUV	16225	2.3	4	1	0	0	0	0
31.15	SUV	17317	2.3	4	1	0	0	0	0
31.08	SUV	18187	2.3	4	1	0	0	0	0
31.16	SUV	18805	2.3	4	1	0	0	0	0
29.11	SUV	21960	2.3	4	1	0	0	0	0
25.85	SUV	36557	2.3	4	1	0	0	0	0
24.90	SUV	40719	2.3	4	1	0	0	0	0
30.96	SUV	17673	2.3	4	1	0	0	0	0
29.99	SUV	18464	2.3	4	1	0	0	0	0
29.91	SUV	19830	2.3	4	1	0	0	0	0
28.33	SUV	20685	2.3	4	1	0	0	0	0
29.20	SUV	20907	2.3	4	1	0	0	0	0
29.32	SUV	21545	2.3	4	1	0	0	0	0
29.48	SUV	21822	2.3	4	1	0	0	0	0
26.79	SUV	25357	2.3	4	1	0	0	0	0
27.79	SUV	26786	2.3	4	1	0	0	0	0
26.01	SUV	34269	2.3	4	1	0	0	0	0
27.28	SUV	4836	2.5	4	1	0	0	0	0
25.96	SUV	17431	2.5	4	1	0	0	0	0
23.27	SUV	21616	2.5	4	1	0	0	0	0
23.33	SUV	25218	2.5	4	1	0	0	0	0

Multiple regression

Data for this exercise set can be found in the worksheet “Week 7 – Data.xlsx”.

Q1. A researcher wants to determine car prices based on a variety of characteristics such as mileage, model, engine size (number of cylinders and volume (or displacement, in litres)), cruise control etc. The data were collected from Kelly Blue Book for several hundred 2005 used General Motors (GM) cars. (Data are in the Excel file “Week 7 – Data.xlsx”, worksheet “Question 1”.)

1. Using Minitab, determine the estimated regression equation that can be used to predict the price (in $1000s) given the Mileage, Volume, Cylinders, and CruiseControl. Cruise control is an indicator variable, which is 1 if the car has cruise control, and 0 if itdoes not.

• Use Minitab to perform the F-test to determine the overall significance of the relationship. What is your conclusion at the 0.05 level of significance?

• Use Minitab to perform t-tests to determine the significance of each predictor variable. What is your conclusion at the 0.05 level of significance?

• Remove any predictor variables that are not significant from the estimated regression equation and fit the smaller model. What is your estimated regression equation now? Use R-squared and R-squared (adjusted) to compare this model to the model in part a.

• The data file also contains indicator variables (“dummy variables”) to account for the vehicle type (Sedan, Coupe, Convertible, and Compact). Why is there no indicator variable for SUV? Add these four indicator variables to the model in part d. Use Minitab to develop the multiple linear regression equation. Make sure to select the option

“Sequential sums of squares” when fitting the model. Compare this model to the model in part d. based on R-squared and R-squared (adjusted).

• Carefully interpret the coefficient of the predictor Sedan.

• Do the indicator variables for car type (collectively) add value to the model? (Perform a partial F-test, using a 0.05 level of significance.)

Q2. (Continues Q1 in Week 3) In week 3 you saw a data set that studied the participation rate of 17–24-year-olds in institutions of post-secondary education (universities and colleges). Additionally, the region of the country (Maritimes, Quebec, Ontario, West) was recorded. At the time you developed a one-way analysis of variance to study regional differences.

1. Using Minitab, develop indicator variables to account for the regions. You can do this very conveniently with the menu selection Calc > Make Indicator Variables.

• Develop a multiple linear regression equation that can be used to predict the percentage of 17–24-year-olds who are attending college given the indicator variables you developed in part a. (Your model should only have three predictors; omit the indicator variable for the West.)
• Is the overall model useful to predict participation rates? (Use   =0.05.)

• Carefully interpret the least-squares coefficients returned by Excel, including the intercept.

• Perform t-tests to determine the significance of each indicator variable. What is your conclusion at the 0.05 level of significance? Carefully interpret your findings.

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at EssayBell.com