ReviewChicago Data below (towards the end of the question) Read "The Nielsen Frozen Orange Juice Data" (follows). For the Sunshine Valley data,help me create new variable SVAVPR, which is the weekly average price. Clearly this equals the total revenue dollars (SV$) divided by total units sold (SVE) for each week.

2. Use Excel's Chart Wizard to help me to create an appropriately labeled Scatterplot of units sold (SVE) versus weekly average price (SVAVPR) for Sunshine Valley (i.e., with SVE on the Y-axis and SVAVPR on the X-axis). "Right-click" on any of the data points and insert a linear trend line.

3. Estimate a linear demand function for the Sunshine Valley brand by calculating the simple regression ofof units sold (SVE) on weekly average price (SVAVPR). Include the following:

a. The regression output.

b. A plot of the residual values as a function of weekly average price.

c. A calculation of the estimate of the demand for the Sunshine Valley brand at prices of $25, $30, and $35.

THE NIELSEN FROZEN ORANGE JUICE DATA

The "orange juice" data set is data on the sales of frozen orange juice concentrate collected from supermarket scanner records throughout the Chicago area. The data was collected by Nielsen Marketing Research Corp., and kindly supplied to us by Dr. John Totten. The data has been extracted from a more extensive data set covering the sales of a number of brands and sizes of frozen orange juice weekly over a two-year period.

The Nielsen software organizes all scanner data in terms of four dimensions: markets (including both cities and supermarket chains), products (brand/size combinations), "facts" (to be explained below), and time periods. The complete frozen concentrated orange juice data set contains 97 facts for 7 products in 5 markets for 2 years. The substantially reduced version of this data that you will be working with contains 2 facts in one market (Chicago) for 2 years (104 weeks), and is contained below (Chicago data below) . The two facts are for a single product ("Sunshine Valley" orange juice).

NO. LABEL DESCRIPTION

1 SVE Number of cases sold for Sunshine Valley (equivalized to 288- ounce cases, no matter what the size of the can)

2 SV$ Total sales revenue (dollars) for Sunshine Valley

CHICAGO
	SVE	SV$
WEEK ENDING 09/15/90	1877	$83,367
WEEK ENDING 09/22/90	2082	$91,023
WEEK ENDING 09/29/90	3316	$132,799
WEEK ENDING 10/06/90	3791	$136,917
WEEK ENDING 10/13/90	2839	$108,080
WEEK ENDING 10/20/90	3138	$112,671
WEEK ENDING 10/27/90	3340	$123,374
WEEK ENDING 11/03/90	2356	$92,301
WEEK ENDING 11/10/90	2014	$76,558
WEEK ENDING 11/17/90	3175	$113,182
WEEK ENDING 11/24/90	2806	$99,546
WEEK ENDING 12/01/90	2565	$95,711
WEEK ENDING 12/08/90	3463	$116,818
WEEK ENDING 12/15/90	2267	$79,358
WEEK ENDING 12/22/90	2123	$79,482
WEEK ENDING 12/29/90	5053	$158,449
WEEK ENDING 01/05/91	3545	$119,275
WEEK ENDING 01/12/91	6720	$151,708
WEEK ENDING 01/19/91	4371	$102,572
WEEK ENDING 01/26/91	2928	$98,154
WEEK ENDING 02/02/91	2426	$87,164
WEEK ENDING 02/09/91	1760	$63,927
WEEK ENDING 02/16/91	1777	$64,202
WEEK ENDING 02/23/91	2392	$84,071
WEEK ENDING 03/02/91	4158	$126,472
WEEK ENDING 03/09/91	1895	$66,309
WEEK ENDING 03/16/91	2533	$78,746
WEEK ENDING 03/23/91	2303	$69,857
WEEK ENDING 03/30/91	3205	$93,825
WEEK ENDING 04/06/91	2961	$95,788
WEEK ENDING 04/13/91	1813	$59,102
WEEK ENDING 04/20/91	3076	$91,250
WEEK ENDING 04/27/91	2661	$80,772
WEEK ENDING 05/04/91	1746	$59,872
WEEK ENDING 05/11/91	4202	$97,108
WEEK ENDING 05/18/91	2345	$68,866
WEEK ENDING 05/25/91	3279	$88,504
WEEK ENDING 06/01/91	3733	$104,708
WEEK ENDING 06/08/91	5629	$147,443
WEEK ENDING 06/15/91	2347	$73,917
WEEK ENDING 06/22/91	1875	$59,523
WEEK ENDING 06/29/91	2401	$71,777
WEEK ENDING 07/06/91	1749	$54,883
WEEK ENDING 07/13/91	1685	$55,269
WEEK ENDING 07/20/91	1933	$61,121
WEEK ENDING 07/27/91	6049	$141,516
WEEK ENDING 08/03/91	8209	$184,467
WEEK ENDING 08/10/91	8851	$199,846
WEEK ENDING 08/17/91	7979	$191,024
WEEK ENDING 08/24/91	4551	$120,273
WEEK ENDING 08/31/91	1964	$61,240
WEEK ENDING 09/07/91	4587	$123,190
WEEK ENDING 09/14/91	2529	$74,947
WEEK ENDING 09/21/91	2252	$73,596
WEEK ENDING 09/28/91	1589	$50,619
WEEK ENDING 10/05/91	2048	$61,322
WEEK ENDING 10/12/91	4462	$113,787
WEEK ENDING 10/19/91	5443	$139,291
WEEK ENDING 10/26/91	3832	$107,194
WEEK ENDING 11/02/91	9182	$205,786
WEEK ENDING 11/09/91	4759	$109,335
WEEK ENDING 11/16/91	2735	$85,026
WEEK ENDING 11/23/91	2346	$73,021
WEEK ENDING 11/30/91	4591	$136,837
WEEK ENDING 12/07/91	3233	$91,569
WEEK ENDING 12/14/91	4632	$125,228
WEEK ENDING 12/21/91	6424	$166,651
WEEK ENDING 12/28/91	4474	$123,808
WEEK ENDING 01/04/92	2825	$93,434
WEEK ENDING 01/11/92	2454	$85,662
WEEK ENDING 01/18/92	5121	$158,975
WEEK ENDING 01/25/92	9425	$240,342
WEEK ENDING 02/01/92	4618	$134,319
WEEK ENDING 02/08/92	2091	$77,147
WEEK ENDING 02/15/92	3118	$104,699
WEEK ENDING 02/22/92	2094	$76,169
WEEK ENDING 02/29/92	8931	$222,142
WEEK ENDING 03/07/92	1855	$69,718
WEEK ENDING 03/14/92	2224	$80,468
WEEK ENDING 03/21/92	2600	$86,097
WEEK ENDING 03/28/92	2991	$102,195
WEEK ENDING 04/04/92	1651	$64,656
WEEK ENDING 04/11/92	1990	$75,038
WEEK ENDING 04/18/92	2411	$87,320
WEEK ENDING 04/25/92	2732	$97,509
WEEK ENDING 05/02/92	2398	$83,163
WEEK ENDING 05/09/92	1957	$71,014
WEEK ENDING 05/16/92	1973	$70,661
WEEK ENDING 05/23/92	4672	$143,414
WEEK ENDING 05/30/92	2670	$89,366
WEEK ENDING 06/06/92	5725	$143,222
WEEK ENDING 06/13/92	4127	$107,491
WEEK ENDING 06/20/92	7037	$172,282
WEEK ENDING 06/27/92	6319	$128,067
WEEK ENDING 07/04/92	1910	$64,186
WEEK ENDING 07/11/92	3643	$96,143
WEEK ENDING 07/18/92	3421	$101,056
WEEK ENDING 07/25/92	3715	$106,812
WEEK ENDING 08/01/92	3127	$100,467
WEEK ENDING 08/08/92	7078	$198,733
WEEK ENDING 08/15/92	6038	$173,233
WEEK ENDING 08/22/92	1956	$65,827
WEEK ENDING 08/29/92	6029	$159,240
WEEK ENDING 09/05/92	1946	$67,602