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 Color
23200	41430	Auction
23100	42524	Auction
23100	42692	Auction
23200	39911	Auction
24500	33199	Online
22600	43090	Auction
24900	33960	Online
23900	38089	Auction
22600	45909	Auction
22700	41355	Auction
24000	36396	Auction
24000	36108	Auction
23800	40743	Auction
24000	35497	Auction
22800	46867	Auction
24200	36563	Auction
24000	34486	Auction
24200	37157	Auction
23200	36729	Auction
22800	47330	Auction
22200	44996	Auction
22250	44102	Auction
22600	47993	Auction
24100	33188	Auction
23500	34669	Auction
22250	42809	Auction
22000	46830	Auction
23000	36946	Auction
22000	45160	Auction
25300	31707	Online
24400	32371	Auction
24400	32262	Auction
24600	33664	Auction
24000	36554	Online
24300	31790	Auction
21800	47163	Auction
24600	32500	Auction
23500	33577	Auction
23100	47936	Auction
23400	33855	Auction
21900	50928	Auction
21750	46651	Auction
21750	50550	Auction
21900	43163	Auction
21500	50750	Auction
24900	31062	Auction
25000	31089	Auction
21500	46920	Auction
21400	51764	Auction
25000	36528	Online
22800	35396	Auction
23800	37694	Online
25000	35082	Auction
23900	38719	Online
23800	46064	Auction
24800	28358	Auction
21300	52497	Auction
22000	40623	Auction
24000	39163	Online
22600	36054	Auction
23900	33247	Online
25000	28236	Auction
24800	38470	Auction
24500	38935	Online
25200	33427	Auction
23900	39226	Online
25300	31797	Auction
25200	27968	Auction
25100	36136	Auction
25400	30976	Auction
21600	55975	Auction
22600	34834	Auction
23200	31358	Auction
25500	34349	Online
25500	31468	Auction
25500	27539	Auction
23200	51254	Auction
25700	32305	Online
24600	42673	Auction
25500	33430	Auction
24800	38894	Online
23800	27915	Auction
22400	35243	Auction
23700	49201	Auction
21000	46865	Auction
24000	47527	Auction
25400	35688	Auction
25200	38277	Auction
25800	29514	Auction
24000	26495	Auction
25800	26488	Auction
20600	55330	Auction
24000	26443	Auction
23800	41064	Online
25300	37839	Auction
25750	24347	Auction
25600	34649	Auction
24600	44154	Auction
25700	33390	Auction
25500	36054	Auction
26000	28140	Auction
21000	44867	Auction
26000	28446	Auction
23400	52289	Auction
22700	31720	Auction
25500	37006	Auction
25000	25903	Online
26000	30802	Auction
26000	23047	Auction
26000	31324	Auction
20600	48188	Auction
26200	28399	Auction
20200	54133	Auction
20800	61340	Auction
24000	29465	Online
26000	26565	Online
21200	41239	Auction
25000	43243	Auction
26300	28832	Auction
20100	59942	Auction
25700	19846	Auction
21000	62363	Auction
22000	60501	Auction
25600	39122	Auction
26500	27503	Auction
25200	42810	Auction
26200	32877	Auction
26600	27047	Auction
24200	21939	Auction
20000	51148	Auction
26600	28304	Auction
23500	24473	Auction
25200	44276	Auction
26500	32565	Auction
25200	45061	Auction
20200	66514	Auction
25500	16295	Auction
24800	24297	Online
21000	66214	Auction
21600	33564	Auction
20800	67134	Auction
26500	34650	Auction
23100	24278	Auction
26000	14256	Auction
22800	38544	Online
26000	22370	Online
20400	68940	Auction
22600	25909	Auction
25000	49010	Auction
19300	69496	Auction
22600	25406	Auction
24800	15087	Auction
18800	70330	Auction
22600	23672	Auction
19000	73520	Auction
19500	74715	Auction
19400	45498	Auction
27000	27832	Online
19650	76813	Auction
18000	76774	Auction
23300	16381	Auction
20400	33955	Auction