2. We consider a population of cars from a given model year. A sample of 24 such cars has been recently sold. The sale price as a function of the age of the car is in the Excel file Data-AS2.XLSX (Car) in the Excel directory. a. Try a linear regression and an exponential (non-linear) regression with Excel to fit these data. Comment your results. b. Which regression model seems to fit the data better and why?

3. To find the relationship between advertising and sales, a sale manger of computer store recorded the monthly advertising budget ($thousands) and the sales (millions) for a sample of 12 months. The data are listed below. Advertising 24 35 59 51 26 30 23 30 33 80 89 95 Sales 8.2 10.7 13.8 10.7 9.9 11.4 12.3 11.8 10.7 13.8 14.2 14.6

Draw a scatter diagram. Does it appear a linear relationship between these two variables? Explain. b. Compute coefficients (0 1) - manual approach c. Compute standard error of estimate () - manual approach d. Compute coefficient of determination ( 2 ) - manual approach e. Run the LINEST function in Excel. Provide the result table

Construction company
Residence	Sales Price (1000)	Floor Area	Bedrooms	Age	Material Quality	Sale Agent Skill	Distance from Downtown	Design Score
1	373	2930	4	7	5	1	23	8
2	389	3315	3	5	5	1	25	9
3	389	3340	3	2	5	3	25	9
4	234	1594	2	2	1	3	9	3
5	399	2750	2	7	3	3	18	8
6	251	1887	2	2	2	1	11	4
7	235	1598	4	8	1	1	9	3
8	281	2111	2	7	3	1	15	6
9	376	2982	4	5	5	2	23	9
10	293	2225	3	2	3	1	16	6
11	238	1785	3	2	1	3	10	5
12	291	2220	3	6	3	3	16	6
13	399	2773	3	5	5	1	26	8
14	360	2866	3	4	4	3	22	7
15	367	3135	4	4	5	3	23	8
16	394	3244	2	8	5	3	26	9
17	321	2476	4	4	4	3	19	6
18	270	1887	3	4	2	1	13	5
19	347	2750	4	9	4	1	21	7
20	397	3315	3	6	5	3	26	9
21	375	2971	4	8	5	2	23	8
22	330	2614	4	6	4	1	20	7
23	357	2853	3	7	4	3	22	7
24	380	3034	2	7	5	1	24	9
25	240	1661	2	3	1	3	10	5
26	253	1903	3	4	2	2	11	4
27	286	1903	2	6	3	3	16	5
28	396	3290	2	5	5	2	26	9
29	269	1951	2	2	2	3	13	5
30	310	2364	3	7	3	1	17	6
31	222	1507	3	2	1	3	8	3
32	237	1777	4	3	1	3	10	3
33	341	2407	2	5	4	1	20	8
34	342	2717	2	5	4	3	21	7
35	383	3037	2	7	5	2	24	9
36	392	2773	3	9	5	2	25	9
37	362	3067	2	7	4	2	22	8
38	230	1558	4	2	1	3	9	3
39	398	3340	2	6	5	3	26	9
40	246	1766	3	6	1	1	11	3
41	309	2321	3	8	3	2	17	6
42	266	1936	4	9	2	1	13	5
43	228	1620	2	7	1	3	9	3
44	233	1620	4	5	1	3	9	3
45	327	2516	3	6	4	2	20	7
46	241	1700	4	3	1	3	10	3
47	274	2024	2	6	2	3	14	5
48	260	1913	3	3	2	3	12	4
49	279	1630	3	2	3	1	15	5
50	276	2071	3	2	2	2	15	5
51	238	1630	2	8	1	1	10	5
52	305	2372	3	4	3	2	17	6
53	353	2825	2	8	4	1	22	8
54	366	3131	2	3	5	3	23	8
55	246	1769	3	2	1	1	11	3
56	383	3038	2	7	5	2	24	9
57	233	1630	3	4	1	1	9	3
58	326	2511	3	9	4	1	20	7
59	377	3019	2	4	5	2	24	9
60	285	2169	2	2	3	3	15	5
61	357	2859	2	6	4	1	22	7
62	232	1613	3	7	1	3	9	3
63	387	3109	2	9	4	3	19	9
64	358	2866	2	5	4	2	22	7
65	222	1514	4	4	1	2	8	3
66	261	1917	4	9	2	2	13	4
67	276	1529	2	6	2	1	15	5
68	329	2604	2	4	4	1	20	7
69	333	2624	2	3	4	1	20	8
70	305	2381	4	2	3	1	17	5
71	263	1921	4	6	2	1	13	5
72	230	1564	2	5	1	3	9	3
73	362	3067	4	9	5	3	23	8
74	341	2705	2	4	4	1	20	7
75	306	2305	2	8	3	3	17	5
76	398	3343	3	5	5	3	26	9
77	273	2021	4	8	2	2	14	5
78	410	3470	3	6	3	2	17	9
79	320	2476	4	3	4	1	19	6
80	279	1558	2	7	3	2	15	5
81	345	2725	2	5	4	2	21	7
82	376	2997	3	3	5	3	23	9
83	388	3131	3	5	5	3	25	9
84	383	3041	2	5	5	2	25	9
85	361	3060	2	8	4	2	22	8
86	238	1633	3	7	1	2	10	5
87	250	1785	4	6	2	3	11	4
88	378	3026	2	7	5	1	24	9
89	305	2407	2	5	3	2	17	5
90	274	2029	3	3	2	3	15	5
91	296	2242	4	2	3	2	16	6
92	227	1613	3	8	1	2	8	3
93	330	2617	3	6	4	3	20	7
94	307	2308	4	2	3	3	17	5
95	260	1915	4	8	2	1	12	4
96	406	3463	3	7	4	1	19	9
97	253	1912	2	7	2	3	11	4
98	258	1853	2	6	2	3	12	3
99	246	1772	3	9	1	2	11	3
100	278	1620	4	8	2	2	15	5
101	309	2327	3	5	3	3	17	6
102	325	2488	3	6	4	3	20	6
103	327	2516	2	3	4	3	20	7
104	341	2717	4	9	4	3	20	7
105	253	1913	4	3	2	2	11	4
106	387	3120	3	8	5	1	25	9
107	342	2722	4	4	4	3	20	7
108	364	3109	3	5	5	3	23	8
109	372	2930	3	2	5	1	23	8
110	242	1750	3	4	1	3	10	3
111	388	3302	3	8	3	2	16	9
112	394	3247	3	4	5	2	25	9
113	261	1919	4	3	2	3	12	4
114	296	2255	3	4	3	3	16	6
115	249	1777	3	2	2	2	11	3
116	282	2146	2	5	3	2	15	5
117	381	3037	2	4	5	2	24	9
118	290	2217	4	6	3	1	16	6
119	349	2773	4	3	4	2	21	7
120	256	1825	2	2	2	3	12	3
121	287	1912	3	9	3	2	16	5
122	316	2431	4	2	3	1	18	6
123	263	1923	4	7	2	2	13	5
124	225	1524	3	6	1	3	8	3
125	351	2790	2	5	4	2	21	7
126	354	2852	3	6	4	2	22	7
127	242	1750	4	2	1	3	11	3
128	374	2936	3	4	5	1	23	8
129	367	2922	2	9	5	2	23	8
130	258	1887	2	4	2	3	12	3
131	377	3022	3	7	5	1	24	9
132	309	2334	4	7	3	3	17	6
133	327	2525	3	9	4	2	20	7
134	231	1570	4	3	1	2	9	3
135	411	3487	3	4	3	1	16	9
136	399	2778	2	3	4	3	19	8
137	236	1772	4	4	1	2	9	3
138	392	2778	2	3	5	2	25	9
139	386	3067	2	5	3	3	16	9
140	259	1912	4	9	2	3	12	4
141	226	1526	3	8	1	3	8	3
142	392	2790	4	6	5	3	25	9
143	345	2726	3	5	4	3	21	7
144	324	2484	2	5	4	1	19	6
145	351	2801	2	6	4	2	21	7
146	241	1740	2	7	1	2	10	3
147	300	2260	2	4	3	1	17	6
148	395	3271	2	8	3	1	18	9
149	353	2837	3	5	4	2	22	8
150	328	2548	3	4	4	3	20	7
151	269	1956	2	3	2	2	13	5
152	237	1781	2	7	1	1	10	3
153	351	2808	3	5	4	3	21	7
154	309	2348	3	6	3	2	17	6
155	319	2447	2	3	4	1	19	6
156	316	2437	3	4	3	1	18	6
157	293	2235	2	3	3	3	16	6
158	369	2927	3	6	5	1	23	8
159	312	2372	4	9	3	1	18	6
160	396	3294	3	5	5	1	26	9
161	263	1928	2	6	2	1	13	5
162	279	2110	2	6	3	1	15	6
163	374	2954	3	2	5	2	23	8
164	335	2642	3	7	4	3	20	8
165	317	2439	4	7	4	1	19	6
166	330	2620	4	6	4	1	20	7
167	274	2035	2	6	2	3	15	5
168	398	2744	4	3	5	3	26	8
169	336	2372	2	9	4	1	20	8
170	226	1529	2	4	1	1	8	3
171	315	2407	4	7	3	3	18	6
172	281	2133	2	9	3	2	15	6
173	351	2811	3	7	4	2	21	7
174	384	3060	2	8	5	3	25	9
175	385	3067	3	7	3	3	16	9
176	285	1887	4	8	3	3	15	5
177	297	2256	2	3	3	1	16	6
178	289	1913	3	4	3	2	16	5
179	257	1832	2	6	2	1	12	3
180	270	1903	4	3	2	3	14	5
181	258	1903	2	6	2	2	12	3
182	340	2381	4	6	4	2	20	8
183	272	1913	2	3	2	1	14	5
184	245	1763	4	9	1	3	11	3
185	377	3024	2	4	5	2	24	9
186	276	1613	3	3	2	1	15	5
187	272	2010	2	7	2	2	14	5
188	263	1933	2	2	2	3	13	5
189	395	3280	2	6	3	2	18	9
190	374	2962	2	4	5	1	23	8
191	353	2840	3	7	4	3	22	8
192	394	3259	2	9	5	3	25	9
193	300	2276	3	7	3	1	17	6
194	400	2790	4	7	5	3	26	8
195	389	3343	3	9	5	3	25	9
196	249	1781	2	2	2	3	11	4
197	229	1630	2	9	1	2	9	3
198	351	2823	3	8	4	1	21	7
199	267	1942	3	7	2	3	13	5
200	400	3398	4	4	5	1	26	9
201	271	1912	4	2	2	2	14	5
202	281	2133	4	6	3	1	15	6
203	396	3302	2	4	5	2	26	9
204	345	2737	2	4	4	3	21	7
205	349	2778	3	4	4	3	21	7
206	274	2039	2	4	2	3	14	5
207	281	2143	4	6	3	2	15	5
208	400	3452	2	4	4	2	19	9
209	269	1960	4	3	2	3	13	5
210	314	2381	4	2	3	2	18	6
211	364	3120	2	6	5	2	23	8
212	255	1824	3	3	2	3	12	4
213	345	2744	3	6	4	1	21	7