Annual Food Spending ($) Annual Household Income ($) Non mortgage household debt ($) Region: 1 = NE 2 = MW 3 = S 4 = W Location: 1 = Metro 2 = Outside Metro 8909 56697 23180 1 1 5684 35945 7052 1 1...

Annual Food Spending ($)	Annual Household Income           ($)	Non mortgage household debt ($)	Region:   1 = NE     2 = MW    3 = S       4 = W	Location:   1 = Metro      2 = Outside Metro
8909	56697	23180	1	1
5684	35945	7052	1	1
10706	52687	16149	1	1
14112	74041	21839	1	1
13855	63182	18866	1	1
15619	79064	21899	1	1
2694	25981	8774	1	1
9127	57424	15766	1	1
13514	72045	27685	1	1
6314	38046	8545	1	1
7622	52408	28057	1	1
4322	41405	6998	1	1
3805	29684	4806	1	1
6674	49246	13592	1	1
7347	41491	4088	1	1
2911	26703	15876	1	1
8026	48753	16714	1	1
8567	55555	16783	1	1
10345	71483	21407	1	1
8694	50980	19114	1	1
8821	46403	7817	1	1
8678	51927	14415	1	1
14331	84769	17295	1	1
9619	59062	16687	1	1
9286	57952	14161	1	1
8206	58355	19538	1	1
16408	81694	15187	1	1
12757	69522	14651	1	1
17740	96132	0	1	1
7739	57796	22057	1	1
15383	88276	1896	1	1
4579	32264	7979	1	1
11679	65928	0	1	1
12877	69924	27330	1	1
16232	91108	9876	1	1
9621	54070	19908	1	1
8171	47238	17819	1	1
12128	77427	31340	1	1
8642	59805	4963	1	1
12400	60334	6632	1	1
9185	54114	18593	1	2
7862	40680	15202	1	2
9775	58263	1486	1	2
6771	52008	21713	1	2
3059	39643	12179	1	2
13211	70309	13221	1	2
7408	46450	5602	1	2
11581	76140	33874	1	2
14233	80833	11478	1	2
3352	31899	2762	1	2
2630	21647	2663	1	2
9093	65924	11355	1	2
12652	65923	5132	1	2
9559	62811	12613	1	2
6112	42335	3149	1	2
10431	65134	15196	1	2
12630	64621	21433	1	2
4578	36553	5502	1	2
9551	62910	11376	1	2
10262	70727	13287	1	2
9551	57634	11857	2	1
10143	56549	16136	2	1
8955	59662	11627	2	1
10197	57350	18432	2	1
11234	56447	10871	2	1
9320	61136	0	2	1
9089	51526	4902	2	1
12300	79979	17270	2	1
11484	66733	15145	2	1
11215	75359	15611	2	1
7204	40795	8975	2	1
5579	39128	6576	2	1
11723	75482	12508	2	1
9353	63998	0	2	1
7761	45845	6671	2	1
4261	38223	8576	2	1
9830	66787	1178	2	1
12386	77852	936	2	1
8673	55825	14167	2	1
10944	57022	9018	2	1
9910	64263	12768	2	1
9928	75881	17423	2	1
4264	34343	21323	2	1
7971	41243	21009	2	1
8290	53021	20151	2	1
12669	66991	9250	2	1
7272	49719	20838	2	1
9784	58399	16065	2	1
9187	50477	9407	2	1
5866	39112	20409	2	1
9456	51886	11668	2	2
6270	34797	146	2	2
9518	62348	5201	2	2
10968	78704	17002	2	2
8865	53620	32004	2	2
9226	51577	15922	2	2
4913	34761	17704	2	2
6976	60968	17799	2	2
8152	51281	8167	2	2
2887	25013	18763	2	2
8062	59238	10815	2	2
8895	47344	11814	2	2
8444	52645	22469	2	2
6148	35309	17139	2	2
4563	34355	10612	2	2
8185	50630	21187	3	1
3391	29056	15735	3	1
7436	48721	18363	3	1
9522	50459	16478	3	1
11290	72805	21238	3	1
10403	56954	22218	3	1
4693	39343	24696	3	1
5626	38833	14371	3	1
11869	55021	35576	3	1
13055	77605	817	3	1
8783	57937	18591	3	1
13031	63343	25531	3	1
3681	36479	17950	3	1
5549	40381	14257	3	1
4108	26309	26581	3	1
6314	41421	22470	3	1
7700	54579	29065	3	1
7479	40551	31757	3	1
9093	50369	6404	3	1
9863	54422	24334	3	1
8043	51836	26213	3	2
9552	73600	36374	3	2
9286	51873	29631	3	2
7987	48003	17261	3	2
3875	36519	13579	3	2
10746	75152	10659	3	2
6888	44974	23711	3	2
5479	48923	4594	3	2
6949	43769	21221	3	2
10650	75947	33357	3	2
5188	41423	33641	3	2
5311	40189	17791	3	2
4691	36772	5829	3	2
8056	59690	19594	3	2
11304	53654	23066	3	2
8112	59067	240	3	2
8696	65962	0	3	2
5869	37254	10157	3	2
3776	33568	14143	3	2
11829	56934	0	3	2
13087	88822	17565	4	1
10986	59635	27863	4	1
5762	38407	18867	4	1
11617	78627	11894	4	1
9895	47710	22930	4	1
16293	64443	31687	4	1
8185	58871	35424	4	1
13972	87954	11549	4	1
11243	54778	12552	4	1
4635	39825	19494	4	1
10063	49536	12195	4	1
8426	60102	13787	4	1
7436	49139	22356	4	1
11747	51052	4553	4	1
15397	70500	12025	4	1
6842	54894	16217	4	1
9678	60570	4106	4	1
12852	57625	31228	4	1
10114	56956	25907	4	1
8496	61400	1093	4	1
6689	50532	17106	4	1
15696	72774	17793	4	1
9841	69981	21607	4	1
12529	66891	17689	4	1
10210	67431	19995	4	1
8868	64782	14489	4	1
6426	38987	17864	4	1
11096	64867	5839	4	1
10086	50421	8689	4	1
2587	27076	17534	4	1
12492	51784	20284	4	2
8456	54135	22037	4	2
6801	53291	23342	4	2
6339	49804	34943	4	2
7802	52205	28579	4	2
9717	72841	22349	4	2
6026	46238	20165	4	2
5618	45938	10538	4	2
10217	77716	18516	4	2
8338	59711	7980	4	2
9048	42106	19786	4	2
4017	36462	9935	4	2
10906	53403	18177	4	2
15148	71290	6696	4	2
8830	66759	20972	4	2
8481	57616	28767	4	2
11358	76221	1373	4	2
10553	78202	5920	4	2
6969	55164	24795	4	2
13219	61171	21482	4	2
3543	34093	25969	4	2
7326	50647	10750	4	2
8458	59898	22940	4	2
11766	52884	25970	4	2
9908	73629	7112	4	2

Extracted text: Use Excel to develop a regression model for the Consumer Food Database (using the "Excel Databases.xls" file on Blackboard) to predict Annual Food Spending by Annual Household Income. Suppose a households annual income is $60,000. Predict how much they spend on food per year. Write your answer as a number (do not include the $ sign or comma) and round to 1 decimal place.