You can analyze these data to determine whether there is a difference between the price paid at an auction and an online sale. Take the following actions:

1. Save this Web page in source file format (File>Save As)
2. Import the saved file into Excel
3. Add-in the Analysis Tool Pack, if you have not done so already (Tools>Add-ins>)
4. Use linear regression analysis to compute price as a function of miles for auction and online sales. That is, you do two linear regressions, one for the auction subset and the other for the online subset (hint: first sort the data by type of sale).
5. Estimate the price of a car that has done 30,000 miles using the linear regression functions for auction and online sales.

Price	Miles	Sale
33400	13469	Auction
34000	13704	Auction
33000	16839	Auction
32500	17695	Auction
33000	19258	Auction
31500	19418	Auction
32000	19738	Auction
33000	21165	Auction
30200	21383	Auction
34000	21387	Auction
30700	21481	Auction
31400	21483	Auction
29600	22183	Auction
32900	22945	Auction
32800	23384	Auction
33400	24082	Auction
32800	24719	Auction
32500	25378	Auction
32200	25427	Auction
33400	25645	Auction
31400	25908	Auction
35400	25988	Auction
32200	26283	Auction
30200	26674	Auction
31000	26971	Auction
33600	27019	Auction
31000	27142	Auction
30200	27242	Auction
34200	27304	Auction
32500	27873	Auction
32000	27970	Auction
32000	28149	Auction
32600	28151	Auction
31000	28329	Auction
34100	28664	Auction
32000	29180	Auction
32500	29414	Auction
31800	29867	Auction
31200	29903	Auction
31600	29966	Auction
33000	30298	Auction
33500	30330	Auction
29800	30495	Auction
32500	30656	Auction
33200	30814	Auction
31500	30838	Auction
31400	30978	Auction
34000	31244	Auction
33500	31372	Auction
28800	31392	Auction
33000	31573	Auction
31200	32162	Auction
30200	32238	Auction
32750	32414	Auction
31250	32439	Auction
32750	32562	Auction
32500	32586	Auction
30000	32788	Auction
32800	32861	Auction
30000	33219	Auction
31800	33244	Auction
32250	33305	Auction
31500	33459	Auction
31800	33483	Auction
32000	33758	Auction
31500	33912	Auction
32500	33981	Auction
27000	34007	Auction
34400	34024	Auction
30000	34112	Auction
32500	34387	Auction
32500	34389	Auction
32500	34393	Auction
31400	34421	Auction
32700	34685	Auction
32500	34898	Auction
32100	35001	Auction
31750	35127	Auction
30500	35183	Auction
30000	35415	Auction
30200	35530	Auction
28000	35566	Auction
32100	35725	Auction
31000	35858	Auction
31700	35942	Auction
32500	35987	Auction
32000	36002	Auction
30500	36045	Auction
30800	36112	Auction
32000	36135	Auction
33600	36263	Auction
32500	36405	Auction
31400	36609	Auction
30200	36624	Auction
32750	36767	Auction
31500	37237	Auction
33200	37246	Auction
30500	37315	Auction
32750	37423	Auction
33000	37613	Auction
29800	37728	Auction
27400	37783	Auction
27000	38293	Auction
32500	38474	Auction
32500	38487	Auction
29800	38705	Auction
28000	38901	Auction
31700	39148	Auction
31800	39385	Auction
30500	39392	Auction
30000	39654	Auction
29800	39705	Auction
33000	39763	Auction
31400	39858	Auction
27000	39961	Auction
28800	39966	Auction
29800	40089	Auction
32600	40253	Auction
34000	40427	Auction
30400	40593	Auction
30800	40901	Auction
31000	40903	Auction
27600	40980	Auction
30100	41081	Auction
26000	41550	Auction
29600	41810	Auction
31200	41827	Auction
28800	41910	Auction
29500	41912	Auction
30800	41922	Auction
28500	41939	Auction
26900	41954	Auction
28000	41954	Auction
29000	42391	Auction
33400	42590	Auction
28000	42688	Auction
28200	42842	Auction
31500	42864	Auction
29000	43252	Auction
30500	43318	Auction
27000	43328	Auction
29800	43353	Auction
30500	43356	Auction
29600	43377	Auction
32000	43477	Auction
27400	43498	Auction
30500	43532	Auction
31600	43664	Auction
29200	44005	Auction
32100	44132	Auction
29000	44164	Auction
30400	44195	Auction
29000	44309	Auction
30500	44318	Auction
29800	44377	Auction
29400	44533	Auction
29000	44568	Auction
31500	44663	Auction
30400	44764	Auction
29600	45050	Auction
29800	45058	Auction
30000	45286	Auction
29900	45472	Auction
29000	45474	Auction
29500	45848	Auction
31200	46105	Auction
32200	46258	Auction
27400	46425	Auction
28700	46624	Auction
26400	46698	Auction
29000	46901	Auction
26400	46980	Auction
28000	46990	Auction
31000	47224	Auction
27400	47308	Auction
29200	47546	Auction
27400	47757	Auction
29700	48004	Auction
27000	48081	Auction
28500	48135	Auction
29400	48249	Auction
27800	48465	Auction
28400	48465	Auction
28700	48623	Auction
28250	48653	Auction
32000	48743	Auction
28250	48952	Auction
28000	48976	Auction
28000	49598	Auction
25000	49609	Auction
30100	49779	Auction
30200	49831	Auction
29300	49872	Auction
26800	49950	Auction
28000	50526	Auction
26600	51163	Auction
31900	51492	Auction
24000	52075	Auction
29600	52501	Auction
25400	52776	Auction
25000	52908	Auction
25800	52940	Auction
25800	53078	Auction
26600	53078	Auction
26200	53399	Auction
26800	53611	Auction
26200	53854	Auction
25500	53920	Auction
26300	53996	Auction
26700	54191	Auction
29100	54226	Auction
25300	54423	Auction
29000	54962	Auction
28500	55188	Auction
26000	55372	Auction
28800	55653	Auction
27800	55674	Auction
29200	55809	Auction
26500	56204	Auction
27000	56279	Auction
27200	56500	Auction
26900	56550	Auction
27400	56706	Auction
24500	56885	Auction
28100	57351	Auction
27900	57962	Auction
26400	58255	Auction
25500	58301	Auction
26500	58326	Auction
27200	58415	Auction
26000	58745	Auction
25250	59059	Auction
27500	59719	Auction
26200	59883	Auction
29600	60081	Auction
25100	60288	Auction
30000	60961	Auction
27000	61076	Auction
24700	61383	Auction
26400	62289	Auction
27500	62922	Auction
25600	62990	Auction
24400	63179	Auction
26700	63620	Auction
27000	63795	Auction
25800	63957	Auction
27800	64228	Auction
27700	64564	Auction
25500	65636	Auction
25400	66362	Auction
27200	68396	Auction
24400	68402	Auction
25400	68546	Auction
26200	69205	Auction
23600	69286	Auction
26200	69626	Auction
25900	69670	Auction
25800	71054	Auction
25800	73250	Auction
27000	74087	Auction
23400	74535	Auction
24200	76308	Auction
32500	19235	Online
32000	22165	Online
32500	23051	Online
32500	25334	Online
32500	26099	Online
32900	27728	Online
33000	27900	Online
33000	28912	Online
32500	28935	Online
32500	29784	Online
31500	30336	Online
31000	31126	Online
31500	31331	Online
30500	32554	Online
32300	32679	Online
32300	32679	Online
31900	32909	Online
32200	33181	Online
31900	33195	Online
30500	33579	Online
32000	33676	Online
30700	33954	Online
30700	33954	Online
31900	34370	Online
31000	34896	Online
32000	34936	Online
30800	35118	Online
32900	35176	Online
31500	35617	Online
31800	35642	Online
31500	35777	Online
31900	36010	Online
31300	36026	Online
31000	36107	Online
30300	36371	Online
30800	36627	Online
30000	36931	Online
30100	36956	Online
30400	37562	Online
31500	39444	Online
31000	39796	Online
31200	39944	Online
29600	41209	Online
30500	42244	Online
30800	42482	Online
29800	43612	Online