use these data to answer the following questions via excel:

date	year	quarter	cogs	revenue	op income	op exp	sga exp	net income
31-Mar-90	1989	4	8.498	9.908	0.6	9.028	0.53	0.122
30-Jun-90	1990	1	9.962	11.757	0.667	10.629	0.667	0.266
30-Sep-90	1990	2	7.51	8.577	0.222	7.995	0.485	-0.062
31-Dec-90	1990	3	7.649	8.706	0.232	8.114	0.465	-0.04
31-Mar-91	1990	4	7.773	8.716	0.314	8.077	0.304	0.007
30-Jun-91	1991	1	9.823	11.414	0.498	10.451	0.628	0.147
30-Sep-91	1991	2	7.218	8.38	0.387	7.647	0.429	0.134
31-Dec-91	1991	3	7.301	8.526	0.426	7.763	0.462	0.19
31-Mar-92	1991	4	7.703	8.78	0.309	8.139	0.436	0.538
30-Jun-92	1992	1	9.794	11.354	0.559	10.368	0.574	0.262
30-Sep-92	1992	2	7.64	8.761	0.334	8.073	0.433	0.114
31-Dec-92	1992	3	7.854	9.062	0.4	8.304	0.45	0.231
31-Mar-93	1992	4	8.386	9.531	0.305	8.846	0.46	0.283
30-Jun-93	1993	1	10.622	12.341	0.607	11.24	0.618	0.321
30-Sep-93	1993	2	8.026	9.521	0.674	8.476	0.45	0.115
31-Dec-93	1993	3	8.03	9.444	0.561	8.512	0.482	0.293
31-Mar-94	1993	4	8.493	9.916	0.507	9.009	0.516	0.945
30-Jun-94	1994	1	18.884	21.824	1.005	20.176	1.292	0.609
30-Sep-94	1994	2	14.385	16.494	0.66	15.35	0.965	0.363
31-Dec-94	1994	3	14.367	17.166	1.239	15.441	1.074	0.894
31-Mar-95	1994	4	14.992	17.78	1.414	15.843	0.851	0.885
30-Jun-95	1995	1	19.93	23.671	1.898	21.112	1.182	1.111
30-Sep-95	1995	2	15.043	17.699	1.17	16.042	0.999	0.689
31-Dec-95	1995	3	15.355	18.969	2.055	16.383	1.028	1.309
31-Mar-96	1995	4	17.06	21.267	1.878	18.652	1.592	1.301
30-Jun-96	1996	1	21.26	25.605	2.216	22.586	1.326	1.303
30-Sep-96	1996	2	16.062	19.176	1.452	17.114	1.052	0.841
31-Dec-96	1996	3	16.247	19.826	2.271	17.031	0.784	1.402
31-Mar-97	1996	4	16.908	20.597	2.144	17.963	1.055	1.401
30-Jun-97	1997	1	22.794	27.589	2.648	24.177	1.383	1.64
30-Sep-97	1997	2	17.672	21.192	1.729	18.824	1.152	1.14
31-Dec-97	1997	3	19.358	24.096	2.613	20.742	1.384	1.562
31-Mar-98	1997	4	21.587	26.88	2.948	23.076	1.489	1.598
30-Jun-98	1998	1	29.621	34.818	2.211	31.405	1.784	1.168
30-Sep-98	1998	2	22.035	26.347	2.059	23.373	1.338	1.145
31-Dec-98	1998	3	22.408	27.899	3.153	23.821	1.413	1.753
31-Mar-99	1998	4	23.412	30.085	4.219	25.021	1.609	2.452
30-Jun-99	1999	1	32.633	39.681	3.861	34.503	1.87	2.338
30-Sep-99	1999	2	24.768	29.933	2.598	26.347	1.579	1.529
31-Dec-99	1999	3	25.752	32.189	3.752	27.414	1.662	2.167
31-Mar-00	1999	4	27.913	35.674	4.622	30.031	2.118	2.699
30-Jun-00	2000	1	37.025	47.069	4.017	41.581	4.556	2.435
30-Sep-00	2000	2	29.104	36.697	2.818	32.682	3.578	1.589
31-Dec-00	2000	3	28.824	37.261	3.572	32.454	3.63	2.189
31-Mar-01	2000	4	32.597	42.216	4.965	35.976	3.379	2.878
30-Jun-01	2001	1	40.4	50.935	3.96	45.438	5.038	2.447
30-Sep-01	2001	2	31.664	37.486	0.956	35.222	3.558	0.382
31-Dec-01	2001	3	31.471	40.182	3.893	34.782	3.311	2.339
31-Mar-02	2001	4	33.028	42.904	5.636	35.722	2.694	3.661
30-Jun-02	2002	1	45.745	57.159	4.473	50.689	4.944	2.79
30-Sep-02	2002	2	34.594	41.958	2.301	38.091	3.497	1.452
31-Dec-02	2002	3	34.56	43.822	3.523	38.456	3.896	2.167
31-Mar-03	2002	4	35.633	46.305	5.043	39.293	3.66	3.064
30-Jun-03	2003	1	48.595	61.102	4.791	53.851	5.256	2.952
30-Sep-03	2003	2	35.596	44.235	2.192	40.089	4.493	1.319
31-Dec-03	2003	3	37.372	46.972	3.035	41.915	4.543	1.848
31-Mar-04	2003	4	39.4	50.654	4.875	43.558	4.158	2.853
30-Jun-04	2004	1	52.718	65.391	3.244	59.303	6.585	1.912
30-Sep-04	2004	2	37.898	48.11	2.785	43.146	5.248	1.661
31-Dec-04	2004	3	38.627	50.051	3.334	44.458	5.831	2.017
31-Mar-05	2004	4	41.117	54.779	6.528	45.696	4.579	2.23
30-Jun-05	2005	1	56.94	74.065	7.293	63.485	6.545	4.498
30-Sep-05	2005	2	42.163	54.622	4.71	47.375	5.212	2.845
31-Dec-05	2005	3	42.478	55.644	5.448	47.656	5.178	3.3
31-Mar-06	2005	4	44.97	61.222	5.692	51.998	7.028	3.919
30-Jun-06	2006	1	60.976	79.893	6.82	68.706	7.73	4.521
30-Sep-06	2006	2	46.687	58.929	3.919	51.974	5.287	2.623
31-Dec-06	2006	3	48.117	62.202	5.169	53.802	5.685	3.279
31-Mar-07	2006	4	55.821	71.625	5.888	62.465	6.644	4.072
30-Jun-07	2007	1	68.482	89.935	6.568	78.217	9.735	4.206
30-Sep-07	2007	2	52.321	66.969	3.846	59.113	6.792	2.509
31-Dec-07	2007	3	53.861	69.814	4.608	61.296	7.435	3.171
31-Mar-08	2007	4	55.815	70.228	2.566	63.385	7.57	2.907
30-Jun-08	2008	1	75.81	94.46	3.429	85.321	9.511	2.192
30-Sep-08	2008	2	56.518	69.98	3.366	62.513	5.995	1.971
31-Dec-08	2008	3	53.01	67.214	3.114	59.814	6.804	-10.392
31-Mar-09	2008	4	57.469	73.953	4.876	64.413	6.944	1.164
30-Jun-09	2009	1	79.758	95.972	1.98	87.991	8.233	1.092
30-Sep-09	2009	2	61.441	69.348	-1.933	66.56	5.119	-0.839
31-Dec-09	2009	3	59.18	70.378	1.643	63.946	4.766	-10.887
31-Mar-10	2009	4	62.463	77.826	4.219	68.715	6.252	1.691
30-Jun-10	2010	1	82.318	100.769	4.231	90.023	7.705	1.609
30-Sep-10	2010	2	59.54	72.19	0.292	65.744	6.204	-3.002
31-Dec-10	2010	3	59.812	72.895	3.097	65.325	5.513	2.179
31-Mar-11	2010	4	65.954	81.786	5.213	72.113	6.159	0.549
30-Jun-11	2011	1	87.048	106.544	3.51	97.068	10.02	1.949
30-Sep-11	2011	2	64.13	76.241	1.643	70.084	5.954	0.928
31-Dec-11	2011	3	63.109	77.003	2.108	70.348	7.239	1.039
31-Mar-12	2011	4	75.495	92.289	3.001	84.377	8.882	0.081

textBox1. X 1 K M N O P 0 & 5 3 5 A B D E F G H 1 date year quarter cogs revenue op income op exp sea exp net income 31-Mar-90 1999 4 8.498 9.908 0.6 9.028 0.53 0.122 30-Jun-90 1990 1 9.962 11.757 0.667 10629 0.667 0.266 30-Sep-90 1990 2 7.51 8.577 0.222 7.995 0.485 -0.062 31-Dec-90 1990 3 7,649 8.706 0.232 8.114 0.465 -0.04 31 Mar 91 1990 4 7.773 8.716 0.314 8.077 0.304 0.007 30-Jun-91 1991 1 9.823 11.414 0498 10.451 0.628 0.147 30-Sep-91 1991 2 7.218 8.38 0.387 7.647 0.429 0.134 31-Dec-91 1991 3 7.301 1526 0426 7.763 0.462 0.19 31 Mar 92 1991 4 7.703 8.78 0.309 8.139 0.436 0.538 30-Jun-92 1992 1 9.794 11.354 0.559 10 368 0.574 0.262 30-Sep-92 1992 2 7.64 8.763 0.334 8.073 0.433 0.114 31-Dec-92 1992 3 7.854 9.062 04 8.304 0.45 0.231 31 Mar 93 1992 4 8.386 9.531 0.305 8.846 0.46 0.283 30-Jun-93 1993 1 10.622 12.341 0.607 11.24 0.618 0.321 30-Sep-93 1993 2 8.026 9.521 0.674 8.476 0.45 0.115 31-Dec-93 1993 3 8.03 9.444 0.561 8.512 0.482 0.293 31-Mar-94 1993 4 8.493 9.916 0.507 9.009 0.516 0.945 30-Jun-94 1994 1 18.884 21.824 1.005 20.176 1.292 0.609 30-Sep-94 1994 2 14.385 16.494 0.66 15.35 0.965 0.363 31-Dec-94 1994 3 14.367 17.166 1.239 15.441 1.074 0.894 31-Mar-95 1994 4 14.992 17.78 1.414 15.843 0.851 0.885 30-Jun-95 1995 1 19.93 23.671 1.898 21.112 1.182 1.111 30-Sep-95 1995 2 15.043 17.699 1.17 16.042 0.999 0.689 31-Dec-95 1995 3 15.355 18.969 16.383 1.028 1.309 31 Mar 96 1995 4. 17.06 21.267 1.878 18.652 1.592 1.301 30-Jun-96 1996 1 21.26 25.505 2216 22 586 1.326 1.303 30-Sep-96 1956 2 16.062 19.176 1.452 17.114 1.052 0.841 Instruction: 1. Use the regression function in Excel to predict net income by revenue and cogs Include the regression output in your Excel file. Save the regression output on a separate worksheet and answer the following questions on the output worksheet. 2. How much of net income variance explained by revenue and cops? Answer 3. For every one dollar increase in revenue, how much wil net income increase? Answer: 4. For every one dollar increase in cogs, how much will net income increase? Answe: 5. If revenue = $1000, cops - 5500, how much is the estimate for net income? Write down your calculation for on the print out. Answer: Show your work. 3 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 2055 textBox1. X 1 K M N O P 0 & 5 3 5 A B D E F G H 1 date year quarter cogs revenue op income op exp sea exp net income 31-Mar-90 1999 4 8.498 9.908 0.6 9.028 0.53 0.122 30-Jun-90 1990 1 9.962 11.757 0.667 10629 0.667 0.266 30-Sep-90 1990 2 7.51 8.577 0.222 7.995 0.485 -0.062 31-Dec-90 1990 3 7,649 8.706 0.232 8.114 0.465 -0.04 31 Mar 91 1990 4 7.773 8.716 0.314 8.077 0.304 0.007 30-Jun-91 1991 1 9.823 11.414 0498 10.451 0.628 0.147 30-Sep-91 1991 2 7.218 8.38 0.387 7.647 0.429 0.134 31-Dec-91 1991 3 7.301 1526 0426 7.763 0.462 0.19 31 Mar 92 1991 4 7.703 8.78 0.309 8.139 0.436 0.538 30-Jun-92 1992 1 9.794 11.354 0.559 10 368 0.574 0.262 30-Sep-92 1992 2 7.64 8.763 0.334 8.073 0.433 0.114 31-Dec-92 1992 3 7.854 9.062 04 8.304 0.45 0.231 31 Mar 93 1992 4 8.386 9.531 0.305 8.846 0.46 0.283 30-Jun-93 1993 1 10.622 12.341 0.607 11.24 0.618 0.321 30-Sep-93 1993 2 8.026 9.521 0.674 8.476 0.45 0.115 31-Dec-93 1993 3 8.03 9.444 0.561 8.512 0.482 0.293 31-Mar-94 1993 4 8.493 9.916 0.507 9.009 0.516 0.945 30-Jun-94 1994 1 18.884 21.824 1.005 20.176 1.292 0.609 30-Sep-94 1994 2 14.385 16.494 0.66 15.35 0.965 0.363 31-Dec-94 1994 3 14.367 17.166 1.239 15.441 1.074 0.894 31-Mar-95 1994 4 14.992 17.78 1.414 15.843 0.851 0.885 30-Jun-95 1995 1 19.93 23.671 1.898 21.112 1.182 1.111 30-Sep-95 1995 2 15.043 17.699 1.17 16.042 0.999 0.689 31-Dec-95 1995 3 15.355 18.969 16.383 1.028 1.309 31 Mar 96 1995 4. 17.06 21.267 1.878 18.652 1.592 1.301 30-Jun-96 1996 1 21.26 25.505 2216 22 586 1.326 1.303 30-Sep-96 1956 2 16.062 19.176 1.452 17.114 1.052 0.841 Instruction: 1. Use the regression function in Excel to predict net income by revenue and cogs Include the regression output in your Excel file. Save the regression output on a separate worksheet and answer the following questions on the output worksheet. 2. How much of net income variance explained by revenue and cops? Answer 3. For every one dollar increase in revenue, how much wil net income increase? Answer: 4. For every one dollar increase in cogs, how much will net income increase? Answe: 5. If revenue = $1000, cops - 5500, how much is the estimate for net income? Write down your calculation for on the print out. Answer: Show your work. 3 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 2055