Search for question
Question

1 Download a copy of the CHICAGO.XLSX worksheet. Read “The Nielsen Frozen Orange Juice Data” (follows). For the Sunshine Valley data, create a 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. Print out a few lines of data to show that you have done this step correctly.

Fig: 1

Fig: 2

Fig: 3