Problem 1 (17 total points)

Weekly sales data for 3 different geographically located stores belonging to a retail chain was collected across the years 2010 to 2012, along with average temperatures of the week.

The retail chain runs several promotional markdown events throughout the year. These markdowns are held during prominent holidays, the three biggest being Labor Day, Thanksgiving, and Christmas. You are interested in how the "holiday effect" impacts the retail chain's weekly sales.

The file problem1.xlsx contains historical weekly sales data of these 3 stores. The data file has information on the following variables.

VariablesDescription

Store Store number (1, 2 or 3)

DateThe date (week)

Weekly_sales ($)Sales for the given store in the given week

Temp (⁰F)Average temperature in the area where the particular store is located

IsHolidayWhether the week is a special holiday week (TRUE - yes, it is a special holiday week, FALSE - no, it is not)

(a) (3 points) Run a regression using:

"Weekly_sales" as dependent variable.

"Store", "Temp", and "IsHoliday" as independent variables.

Report and interpret the R-square measure (please round the R-square to four decimal digits)

(b) (3 points) Report the estimated intercept and interpret it.

(c) (3 points) Report the coefficients relating to the stores and interpret each coefficient.

(d) (4 points) Is there a 'holiday effect' on sales at these three stores? Briefly explain your answer.

(e) (4 points) What is the estimate of difference in sales between Store 2 and Store 3, given that the week is a special holiday week and that the temperature in the areas where the stores are located is 60 Fahrenheit.

Store Date Weekly_Sales ($) Temp IsHoliday 1 10/19/2012 24185.27 67.97 FALSE 1 7/13/2012 16566.18 77.12 FALSE 1 7/22/2011 15766.6 85.77 FALSE 3 10/8/2010 10081.8 62.99 FALSE 1 9/28/2012 18947.81 76.08 FALSE 3 9/30/2011 10434.83 69.24 FALSE 3 5/6/2011 10420.92 66.66 FALSE 3 6/3/2011 8853.89 78.02 FALSE 1 7/27/2012 15731.18 82.66 FALSE 3 12/17/2010 11986.84 56.02 FALSE 2 10/28/2011 41682.4 87.96 FALSE 3 2/12/2010 10887.84 83.96 TRUE 1 8/12/2011 14539.79 90.76 FALSE 1 7/23/2010 15360.45 83.36 FALSE 3 6/18/2010 8201.06 78.39 FALSE 1 3/23/2012 22107.7 65.93 FALSE 1 10/7/2011 20797.58 69.31 FALSE 2 9/3/2010 49015.05 80.91 FALSE 1 3/30/2012 28952.86 67.61 FALSE 1 4/15/2011 28762.37 71.27 FALSE 1 8/19/2011 14689.24 89.94 FALSE 3 10/14/2011 9870.22 65.8 FALSE 1 12/2/2011 25293.49 48.91 FALSE 1 1/28/2011 18461.18 43.83 FALSE 1 6/18/2010 16216.27 84.11 FALSE 1 5/25/2012 16963.55 77.22 FALSE 1 3/2/2012 20113.03 60.96 FALSE 3 2/3/2012 12485.78 38.25 FALSE 1 7/29/2011 15922.41 86.83 FALSE 1 12/24/2010 55931.23 52.33 FALSE 1 3/19/2010 22136.64 54.58 FALSE 1 12/17/2010 44912.86 49.84 FALSE 1 5/18/2012 18517.79 70.33 FALSE 2 12/17/2010 49303.28 67.18 FALSE 2 12/10/2010 46955.82 63.93 FALSE 1 1/7/2011 15984.24 48.27 FALSE 3 10/22/2010 8614.41 69.16 FALSE 1 3/18/2011 20334.23 62.76 FALSE 3 3/26/2010 10366.85 67.97 FALSE 1 4/2/2010 57258.43 62.27 FALSE 3 11/26/2010 10706.81 52.34 TRUE 1 6/29/2012 15722.82 84.88 FALSE 3 3/11/2011 10689.97 50.81 FALSE 3 2/4/2011 11012.52 56.46 FALSE 1 7/15/2011 15654.85 88.54 FALSE 3 8/26/2011 49775.52 87.12 FALSE 1 8/5/2011 15295.55 91.65 FALSE 3 8/31/2012 50701.3 93.34 FALSE 1 10/15/2010 26978.34 67.18 FALSE 2 7/27/2012 45008.22 77.22 FALSE 2 10/15/2010 43110.79 87.00 FALSE 2 5/28/2010 44619.52 51.45 FALSE 3 12/30/2011 8848.44 47.3 TRUE 2 9/17/2010 44681.64 83.15 FALSE 3 5/20/2011 7939.01 69.53 FALSE 1 12/10/2010 31497.65 46.33 FALSE 3 7/1/2011 8070.64 83.94 FALSE 3 3/25/2011 9049.02 63.42 FALSE 3 6/4/2010 8001.41 44.79 FALSE 2 11/12/2010 43194.49 78.69 FALSE 3 7/2/2010 7857.88 81.57 FALSE 2 8/27/2010 49623.53 84.34 FALSE 3 2/26/2010 11135.17 69.87 FALSE 2 9/30/2011 46045.09 86.83 FALSE 2 5/4/2012 50501.3 60.96 FALSE 1 12/31/2010 19124.58 48.43 TRUE 1 11/18/2011 19050.66 62.25 FALSE 3 12/31/2010 8266.14 56.24 TRUE 2 10/12/2012 42112.67 85.05 FALSE 3 8/12/2011 32148.93 89.05 FALSE 2 5/21/2010 44319.15 54.58 FALSE 1 1/27/2012 18378.16 54.26 FALSE 1 9/30/2011 18337.68 79.69 FALSE 3 1/21/2011 12532.94 42.92 FALSE 1 5/14/2010 18926.74 74.78 FALSE 3 8/6/2010 26719.02 85.05 FALSE 3 3/9/2012 11925.71 52.7 FALSE 3 2/19/2010 11523.47 74.97 FALSE 2 4/6/2012 51805.88 56.55 FALSE 2 7/13/2012 44411.95 73.77 FALSE 3 8/3/2012 30331.69 93.34 FALSE 3 10/5/2012 11676.98 78.14 FALSE 1 5/4/2012 17147.44 75.55 FALSE 2 4/16/2010 45025.02 38.51 FALSE 3 5/27/2011 8120.7 77.19 FALSE 1 11/26/2010 18820.29 64.52 TRUE 2 6/17/2011 42939.63 71.27 FALSE 1 10/21/2011 23351.8 63.71 FALSE 3 10/19/2012 8548.87 71.67 FALSE 1 3/26/2010 26229.21 51.45 FALSE 3 1/27/2012 10613.17 42.83 FALSE 2 9/21/2012 43541.07 80.42 FALSE 1 6/24/2011 15682.81 83.58 FALSE 3 5/13/2011 8732.46 63.9 FALSE 3 4/1/2011 8734.19 51 FALSE 1 7/16/2010 17150.84 83.15 FALSE 3 6/11/2010 7742.75 79.35 FALSE 2 7/22/2011 45113.56 67.63 FALSE 2 2/18/2011 49202.06 49.84 FALSE 2 12/3/2010 44405.02 71.89 FALSE 2 4/20/2012 45561.85 45.32 FALSE 2 12/9/2011 49357.43 69.31 FALSE 1 3/4/2011 20327.61 59.58 FALSE 2 12/30/2011 43539.94 66.57 TRUE 3 4/15/2011 8212.97 62.72 FALSE 1 7/2/2010 16333.14 80.91 FALSE 2 6/11/2010 47089.54 65.86 FALSE 2 1/13/2012 43353.09 59.11 FALSE 3 3/18/2011 8148.69 55.33 FALSE 2 11/18/2011 43997.78 79.94 FALSE 2 4/13/2012 43991.18 48.02 FALSE 1 11/12/2010 19549.39 59.61 FALSE 2 4/22/2011 46544.56 57.36 FALSE 1 9/24/2010 18122.52 80.94 FALSE 2 1/21/2011 41596.99 51.41 FALSE 3 11/18/2011 10104.36 50.81 FALSE 1 2/26/2010 19403.54 46.63 FALSE 3 3/5/2010 12275.58 76.08 FALSE 2 3/4/2011 53035.54 48.43 FALSE 1 6/8/2012 17666 78.30 FALSE 1 1/13/2012 16894.4 48.53 FALSE 2 5/20/2011 44302.11 62.76 FALSE 1 9/23/2011 17859.3 75.80 FALSE 2 2/11/2011 47595.35 46.33 TRUE 3 5/4/2012 10655.35 61.48 FALSE 2 8/6/2010 50031.73 80.69 FALSE 3 1/7/2011 15808.15 41.73 FALSE 1 4/9/2010 42960.91 65.86 FALSE 2 11/11/2011 44936.47 76.00 FALSE 1 4/8/2011 23873.79 67.84 FALSE 2 6/3/2011 47844.27 59.17 FALSE 3 8/27/2010 51159.17 80.49 FALSE 2 11/4/2011 47313.62 87.83 FALSE 3 9/3/2010 19081.8 83.96 FALSE 3 11/11/2011 9959.64 59.69 FALSE 3 6/10/2011 7508.71 76.44 FALSE 1 1/21/2011 17341.47 44.04 FALSE 2 1/20/2012 43753.43 62.25 FALSE 2 9/7/2012 47344.5 81.57 TRUE 2 10/21/2011 42487.67 89.94 FALSE 3 2/25/2011 10473.78 50.25 FALSE 2 10/29/2010 44081.33 85.22 FALSE 1 4/1/2011 20398.09 59.17 FALSE 1 7/30/2010 15381.82 81.84 FALSE 3 9/9/2011 12778.28 79.09 TRUE 2 5/25/2012 45817.07 65.93 FALSE 1 9/14/2012 19616.22 74.97 FALSE 1 12/30/2011 23350.88 44.55 TRUE 2 1/27/2012 41556.23 60.14 FALSE 2 8/12/2011 45341.92 83.13 FALSE 2 9/16/2011 42963.96 88.54 FALSE 3 9/17/2010 10722.46 69.87 FALSE 2 12/16/2011 51137.42 71.74 FALSE 3 1/6/2012 13926.04 44.69 FALSE 1 5/7/2010 17413.94 72.55 FALSE 2 10/19/2012 42354.72 84.85 FALSE 1 9/21/2012 19251.5 69.87 FALSE 1 9/17/2010 19354.23 82.11 FALSE 3 6/17/2011 7658.75 79.86 FALSE 3 9/7/2012 18368.51 89.64 TRUE 2 7/15/2011 43260.96 75.64 FALSE 2 4/8/2011 48501.79 42.27 FALSE 3 7/27/2012 22716.7 90.07 FALSE 1 2/17/2012 54060.1 45.32 FALSE 2 2/24/2012 47080.12 47.96 FALSE 2 10/1/2010 45829.02 81.84 FALSE 3 10/28/2011 9421.2 66.24 FALSE 3 12/9/2011 12955.55 45.5 FALSE 2 5/11/2012 46717.76 58.76 FALSE 1 4/29/2011 41512.39 72.03 FALSE 2 6/22/2012 46075 66.76 FALSE 1 7/1/2011 15363.5 85.55 FALSE 2 7/29/2011 43191.02 77.72 FALSE 1 6/1/2012 16065.49 77.95 FALSE 2 6/10/2011 46363.93 67.84 FALSE 2 2/26/2010 44292.87 56.23 FALSE 2 2/25/2011 46165.25 52.33 FALSE 3 12/23/2011 13667.88 49.97 FALSE 3 5/18/2012 8609.82 67.14 FALSE 2 4/1/2011 46991.58 43.83 FALSE 2 4/29/2011 43682.41 62.90 FALSE 3 8/10/2012 28257.3 91.58 FALSE 3 9/16/2011 10412.88 82.05 FALSE 2 4/2/2010 47450.5 44.79 FALSE 3 2/11/2011 11428.25 56.67 TRUE 3 4/20/2012 8647.36 69.39 FALSE 2 12/31/2010 35819.83 69.64 TRUE 3 3/30/2012 9129.23 55.43 FALSE 3 10/29/2010 9283.09 55.32 FALSE 2 3/5/2010 48397.98 52.34 FALSE 3 5/21/2010 7813.91 48.89 FALSE 2 6/1/2012 47425.29 67.61 FALSE 3 11/12/2010 9146.77 52.92 FALSE 2 2/12/2010 44682.74 61.24 TRUE 3 6/8/2012 8614.64 83.4 FALSE 1 5/27/2011 15741.6 77.72 FALSE 3 6/22/2012 7301.41 85.17 FALSE 2 9/9/2011 43315.85 85.83 TRUE 2 4/9/2010 46549.73 42.31 FALSE 1 10/26/2012 27390.81 69.16 FALSE 2 4/23/2010 44418.11 39.93 FALSE 1 2/11/2011 37887.17 36.39 TRUE 3 8/24/2012 43712.78 90.45 FALSE 2 3/12/2010 43751.94 64.12 FALSE 1 11/11/2011 18689.54 59.11 FALSE 1 4/13/2012 34684.21 69.07 FALSE 1 8/27/2010 15793.87 85.22 FALSE 1 1/14/2011 17359.7 35.40 FALSE 1 3/25/2011 20881.1 69.97 FALSE 3 9/2/2011 19604.47 81.83 FALSE 3 10/7/2011 9977.96 63.19 FALSE 3 5/25/2012 8345.33 76.42 FALSE 1 11/4/2011 39886.06 54.98 FALSE 3 11/4/2011 9189.2 57.85 FALSE 2 6/4/2010 48754.47 62.27 FALSE 1 10/1/2010 20094.19 71.89 FALSE 2 8/24/2012 44972.52 78.39 FALSE 1 6/10/2011 15883.52 83.13 FALSE 2 9/24/2010 42477.49 83.36 FALSE 1 8/20/2010 15740.13 86.65 FALSE 2 12/2/2011 45928.14 79.69 FALSE 2 4/15/2011 44464.74 36.39 FALSE 3 7/30/2010 20915.95 86.11 FALSE 1 10/12/2012 22764.01 62.99 FALSE 1 2/12/2010 46039.49 38.51 TRUE 2 9/28/2012 45784.76 82.66 FALSE 2 11/25/2011 44259.59 75.80 TRUE 1 10/28/2011 31579.9 66.57 FALSE 1 12/23/2011 46788.75 47.96 FALSE 3 11/25/2011 9317.56 62.98 TRUE 2 1/14/2011 39857.4 59.61 FALSE 2 7/8/2011 44623.23 64.61 FALSE 1 2/18/2011 46845.87 57.36 FALSE 1 5/20/2011 15136.78 67.63 FALSE 1 11/19/2010 19552.84 51.41 FALSE 2 12/23/2011 65615.36 63.71 FALSE 3 7/8/2011 7366.5 79.85 FALSE 3 1/28/2011 11983.34 53.37 FALSE 1 9/10/2010 18194.74 78.69 TRUE 2 9/10/2010 45182.5 80.48 TRUE 3 2/5/2010 13740.12 80.49 FALSE 2 12/24/2010 59889.32 69.86 FALSE 3 12/3/2010 10856.85 64.12 FALSE 3 1/20/2012 11702.08 41.4 FALSE 3 9/10/2010 12134.69 74.97 TRUE 3 5/14/2010 7919.86 64.12 FALSE 1 4/30/2010 16555.11 67.41 FALSE 3 6/24/2011 6165.73 81.35 FALSE 2 2/17/2012 46085.47 51.63 FALSE 1 9/2/2011 15277.27 87.83 FALSE 3 3/12/2010 10123.45 68.55 FALSE 2 8/3/2012 49424.06 77.95 FALSE 3 8/19/2011 41603.11 88.7 FALSE 2 4/27/2012 45456.23 57.25 FALSE 1 10/29/2010 38640.93 69.64 FALSE 3 4/27/2012 8635.62 69.21 FALSE 1 9/16/2011 18535.48 79.94 FALSE 3 7/22/2011 16069.5 79.26 FALSE 3 7/23/2010 16930.62 82.66 FALSE 2 3/11/2011 48465.72 48.27 FALSE 3 7/15/2011 11578.11 83.12 FALSE 2 7/2/2010 47077.72 67.41 FALSE 3 4/8/2011 10417.33 58.59 FALSE 3 2/10/2012 12388.85 33.19 TRUE 2 10/8/2010 46387.54 87.16 FALSE 2 9/23/2011 43390.94 85.77 FALSE 2 3/26/2010 41892.55 56.02 FALSE 1 6/4/2010 17558.09 80.69 FALSE 3 10/1/2010 9775.17 68.55 FALSE 1 6/25/2010 16328.72 84.34 FALSE 3 9/21/2012 13403.63 78.85 FALSE 3 9/24/2010 8097.92 76.08 FALSE 1 9/3/2010 16241.78 81.21 FALSE 1 5/13/2011 17235.15 75.64 FALSE 3 4/23/2010 8868.93 52.92 FALSE 1 11/5/2010 34238.88 58.74 FALSE 1 7/20/2012 16348.06 80.42 FALSE 3 1/14/2011 13275.87 50.32 FALSE 2 3/19/2010 43615.49 48.89 FALSE 1 3/16/2012 22366.88 64.74 FALSE 1 10/22/2010 25543.04 69.86 FALSE 2 8/26/2011 47659.93 83.58 FALSE 3 4/2/2010 11157.08 69.16 FALSE 1 9/7/2012 18322.37 83.96 TRUE 1 4/22/2011 50510.31 72.99 FALSE 1 12/9/2011 33305.92 43.93 FALSE 1 4/20/2012 16976.19 66.76 FALSE 2 10/26/2012 43134.88 77.66 FALSE 2 6/29/2012 47629.14 67.23 FALSE 3 5/11/2012 10342.72 74.61 FALSE 2 2/5/2010 50605.27 55.32 FALSE 2 9/14/2012 44493.61 77.12 FALSE 1 8/3/2012 16628.31 86.11 FALSE 3 1/13/2012 13822.49 33.02 FALSE 1 8/24/2012 16286.4 77.66 FALSE 3 6/29/2012 7577.59 85.69 FALSE 3 3/19/2010 9001.37 62.99 FALSE 3 3/2/2012 11387.31 57.77 FALSE 2 5/27/2011 45072.11 69.97 FALSE 3 10/26/2012 9350.9 64.53 FALSE 2 3/30/2012 46529.68 54.26 FALSE 1 8/26/2011 14537.37 87.96 FALSE 2 8/31/2012 50995.5 84.88 FALSE 3 4/13/2012 7927.73 69.48 FALSE 2 8/20/2010 49754.17 84.11 FALSE 3 8/13/2010 30640.54 84.85 FALSE 1 2/19/2010 41595.55 39.93 FALSE 1 3/9/2012 21140.07 58.76 FALSE 1 4/27/2012 16347.6 67.23 FALSE 1 2/3/2012 23510.49 56.55 FALSE 1 1/20/2012 18365.1 54.11 FALSE 3 10/21/2011 10136.78 68.5 FALSE 2 11/19/2010 41443.25 82.11 FALSE 1 8/31/2012 16680.24 80.49 FALSE 3 6/25/2010 6591.22 84.88 FALSE 2 1/28/2011 41651.01 64.52 FALSE 1 11/25/2011 20911.25 60.14 TRUE 2 5/13/2011 44274.15 53.56 FALSE 2 3/25/2011 44293.54 44.04 FALSE 3 11/19/2010 9202.11 56.23 FALSE 2 4/30/2010 45971.3 46.63 FALSE 3 4/29/2011 8653.62 59.23 FALSE 3 7/16/2010 13751.3 80.42 FALSE 1 7/9/2010 17688.76 80.48 FALSE 3 11/5/2010 9825.22 61.24 FALSE 2 7/30/2010 45833.77 80.44 FALSE 2 10/22/2010 42371.48 86.65 FALSE 1 6/17/2011 14978.09 86.41 FALSE 1 3/5/2010 21827.9 46.50 FALSE 2 7/9/2010 46752.12 72.55 FALSE 3 12/10/2010 11219.78 48.89 FALSE 1 4/16/2010 17596.96 66.32 FALSE 3 8/17/2012 31905.97 89.86 FALSE 2 2/4/2011 46829.12 49.27 FALSE 3 12/2/2011 10146.54 49.33 FALSE 3 10/15/2010 9735.73 67.97 FALSE 2 10/7/2011 49880.69 91.65 FALSE 1 8/10/2012 16119.92 85.05 FALSE 2 2/19/2010 47928.89 52.92 FALSE 3 7/20/2012 20126.95 89.34 FALSE 3 8/20/2010 41101.93 77.66 FALSE 3 7/29/2011 21331.51 81.54 FALSE 2 7/23/2010 44763.33 76.44 FALSE 3 3/16/2012 8845.73 62.32 FALSE 1 12/3/2010 22517.56 49.27 FALSE 2 3/16/2012 47346.32 48.53 FALSE 1 3/11/2011 21280.4 53.56 FALSE 3 5/28/2010 8412.69 56.02 FALSE 3 10/12/2012 10487.17 69.92 FALSE 3 6/15/2012 8016.26 86.53 FALSE 1 8/17/2012 17330.7 84.85 FALSE 1 1/6/2012 16567.69 49.01 FALSE 3 2/17/2012 10237.78 57.83 FALSE 1 6/3/2011 16434.15 83.00 FALSE 2 2/10/2012 50581.06 43.93 TRUE 2 5/14/2010 43675.61 57.79 FALSE 1 8/6/2010 17508.41 87.16 FALSE 3 9/23/2011 9755.56 81.79 FALSE 2 5/6/2011 50139.92 59.58 FALSE 2 6/24/2011 42415.81 72.99 FALSE 2 8/5/2011 49359.75 83.00 FALSE 3 9/28/2012 13085.95 75.58 FALSE 1 5/11/2012 18164.2 73.77 FALSE 1 10/5/2012 21904.47 68.55 FALSE 1 10/14/2011 23077.55 71.74 FALSE 1 3/12/2010 21043.39 57.79 FALSE 2 7/20/2012 45108.22 70.33 FALSE 2 11/5/2010 46381.43 81.21 FALSE 2 10/5/2012 48577.08 86.11 FALSE 1 5/21/2010 14773.04 76.44 FALSE 2 11/26/2010 45681.98 80.94 TRUE 1 2/5/2010 24924.5 42.31 FALSE 1 2/10/2012 36988.49 48.02 TRUE 2 6/8/2012 49439.58 70.43 FALSE 1 2/25/2011 19363.83 62.90 FALSE 2 7/16/2010 44339.2 74.78 FALSE 1 10/8/2010 23388.03 63.93 FALSE 1 6/11/2010 16637.62 80.43 FALSE 3 4/30/2010 9337.44 56.23 FALSE 1 5/28/2010 15580.43 80.44 FALSE 2 3/2/2012 52608.51 44.55 FALSE 1 12/16/2011 45773.03 51.63 FALSE 3 5/7/2010 9372.8 52.34 FALSE 3 4/16/2010 9226.8 61.24 FALSE 3 12/16/2011 13180.05 47.55 FALSE 3 6/1/2012 7175.77 83.07 FALSE 1 4/6/2012 57592.12 70.43 FALSE 2 6/25/2010 45299.92 64.84 FALSE 3 4/9/2010 10179.29 55.32 FALSE 1 7/6/2012 17823.37 81.57 FALSE 2 3/18/2011 45222.3 35.40 FALSE 1 4/23/2010 16145.35 64.84 FALSE 2 5/7/2010 47903.01 46.50 FALSE 3 2/24/2012 10502.4 60.8 FALSE 1 5/6/2011 20138.19 64.61 FALSE 2 9/2/2011 49419.75 85.55 FALSE 3 7/6/2012 8473.71 87.7 FALSE 2 6/15/2012 46637.48 69.07 FALSE 1 6/15/2012 17558.82 79.35 FALSE 2 3/23/2012 44796.03 54.11 FALSE 1 7/8/2011 16148.87 85.83 FALSE 2 6/18/2010 44428.71 66.32 FALSE 2 1/7/2011 43202.29 58.74 FALSE 3 8/5/2011 31248.98 89.53 FALSE 1 8/13/2010 15536.4 87.00 FALSE 2 10/14/2011 43306.38 90.76 FALSE 3 4/6/2012 9335.24 67 FALSE 2 8/17/2012 46350.97 79.35 FALSE 3 3/23/2012 7910.22 69.42 FALSE 2 8/10/2012 46729.91 78.30 FALSE 2 7/1/2011 45247.74 72.03 FALSE 3 7/13/2012 13126.15 89.83 FALSE 1 6/22/2012 16633.41 78.39 FALSE 3 2/18/2011 11724.98 49.66 FALSE 3 9/14/2012 14288.22 77.97 FALSE 2 1/6/2012 44481.38 54.98 FALSE 3 4/22/2011 8468.72 67.1 FALSE 2 3/9/2012 48563.69 49.01 FALSE 2 5/18/2012 44411.23 64.74 FALSE 2 2/3/2012 54322.24 48.91 FALSE 1 2/24/2012 20124.22 57.25 FALSE 3 12/24/2010 12080.36 44.79 FALSE 3 3/4/2011 11039.12 48.01 FALSE 1 9/9/2011 17746.68 76.00 TRUE 1 2/4/2011 21665.76 42.27 FALSE 2 8/13/2010 45475.69 80.43 FALSE 3 7/9/2010 8112.67 77.12 FALSE 2 8/19/2011 46391.12 86.41 FALSE 2 7/6/2012 49771.92 75.55 FALSE