Week Of 6-Dec-04 13-Dec-04 20-Dec-04 27-Dec-04 3-Jan-05 10-Jan-05 17-Jan-05 24-Jan-05 31-Jan-05 7-Feb-05 14-Feb-05 21-Feb-05 28-Feb-05 7-Mar-05 14-Mar-05 21-Mar-05 28-Mar-05 4-Apr-05 11-Apr-05 18-Apr-05 25-Apr-05 2-May-05 9-May-05 16-May-05 23-May-05 30-May-05 Expenses ($) 103,084 99,584 94,936 100,757 102,736 94,866 96,158 97,013 97,796 106,315 92,307 89,923 100,546 99,270 98,632 100,273 100,006 105,531 92,774 103,169 105,794 98,534 97,474 102,492 105,295 99,640 Revenues ($) 122,533 131,036 137,813 114,495 120,579 182,122 137,983 104,668 117,807 157,735 145,685 129,758 130,642 85,895 125,994 113,194 127,209 114,713 145,468 151,959 68,623 126,485 97,000 121,350 137,074 152,589 Week Of 6-Jun-05 13-Jun-05 20-Jun-05 27-Jun-05 4-Jul-05 11-Jul-05 18-Jul-05 25-Jul-05 1-Aug-05 8-Aug-05 15-Aug-05 22-Aug-05 29-Aug-05 5-Sep-05 12-Sep-05 19-Sep-05 26-Sep-05 3-Oct-05 10-Oct-05 17-Oct-05 24-Oct-05 31-Oct-05 7-Nov-05 14-Nov-05 21-Nov-05 28-Nov-05 Expenses ($) 101,201 99,726 96,206 100,878 99,439 95,537 105,354 89,897 91,257 104,675 93,216 102,284 103,959 97,823 97,765 108,032 101,433 96,548 93,295 100,227 97,876 102,985 100,099 102,245 102,353 105,811 Revenues ($) 153,171 136,244 101,012 156,135 125,567 154,901 128,439 116,745 168,639 148,706 141,687 141,879 106,889 169,328 126,747 154,728 162,576 138,661 158,689 135,165 112,240 118,904 141,778 161,104 140,226 133,108 Week Expenses Revenues 6-Dec-04 103,084 122,533 13-Dec-04 99,584 131,036 20-Dec-04 94,936 137,813 27-Dec-04 100,757 114,495 3-Jan-05 102,736 120,579 10-Jan-05 94,866 182,122 17-Jan-05 96,158 137,983 24-Jan-05 97,013 104,668 31-Jan-05 97,796 117,807 7-Feb-05 106,315 157,735 14-Feb-05 92,307 145,685 21-Feb-05 89,923 129,758 28-Feb-05 100,546 130,642 7-Mar-05 99,270 85,895 14-Mar-05 98,632 125,994 21-Mar-05 100,273 113,194 28-Mar-05 100,006 127,209 4-Apr-05 105,531 114,713 11-Apr-05 92,774 145,468 18-Apr-05 103,169 151,959 25-Apr-05 105,794 68,623 2-May-05 98,534 126,485 9-May-05 97,474 97,000 16-May-05 102,492 121,350 23-May-05 105,295 137,074 30-May-05 99,640 152,589 6-Jun-05 101,201 153,171 13-Jun-05 99,726 136,244 20-Jun-05 96,206 101,012 27-Jun-05 100,878 156,135 4-Jul-05 99,439 125,567 11-Jul-05 95,537 154,901 18-Jul-05 105,354 128,439 25-Jul-05 89,897 116,745 1-Aug-05 91,257 168,639 8-Aug-05 104,675 148,706 15-Aug-05 93,216 141,687 22-Aug-05 102,284 141,879 29-Aug-05 103,959 106,889 5-Sep-05 97,823 169,328 12-Sep-05 97,765 126,747 19-Sep-05 108,032 154,728 26-Sep-05 101,433 162,576 3-Oct-05 96,548 138,661 10-Oct-05 93,295 158,689 17-Oct-05 100,227 135,165 24-Oct-05 97,876 112,240 31-Oct-05 102,985 118,904 7-Nov-05 100,099 141,778 14-Nov-05 102,245 161,104 21-Nov-05 102,353 140,226 28-Nov-05 105,811 133,108 Profit 19,449 31,452 42,877 13,738 17,843 87,256 41,825 7,655 20,011 51,420 53,378 39,835 30,096 -13,375 27,362 12,921 27,203 9,182 52,694 48,790 -37,171 27,951 -474 18,858 31,779 52,949 51,970 36,518 4,806 55,257 26,128 59,364 23,085 26,848 77,382 44,031 48,471 39,595 2,930 71,505 28,982 46,696 61,143 42,113 65,394 34,938 14,364 15,919 41,679 58,859 37,873 27,297 Column1 Descriptive statistivs Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(99.0%) 33820 3182 33359 #N/A 22948 526631227 1 0 124427 -37171 87256 1758651 52 8515 Fre que ncy Bin Frequency -37171 1 -19396 0 -1620 1 16155 9 33930 14 51705 14 69481 9 More 3 15 10 5 0 Histogram Frequency Bin a) The modes of the histogram were There were repeated 14 times. 33930 and b) The histogram is a chart showing the values agaist their frequencies. In this case, the Histogram could be said to be having a close to normal distribution with a few outliers on the left. It resembles a normal probability distribution. c)What was the average weekly profit for the prior 12-month period? The average was 33,820 d) The standard deviation was The variance was 526631227 The calculations were done at 99% confidence e) The confidence interval at 99% was This means that the values of profits fell over or below the mean by 8515 22948 8515 f) The expected exposure on the lost profits claim was defined by the mean negative confidence interval -8515 51705 Week Expenses Revenues 6-Dec-04 103,084 122,533 13-Dec-04 99,584 131,036 20-Dec-04 94,936 137,813 27-Dec-04 100,757 114,495 3-Jan-05 102,736 120,579 10-Jan-05 94,866 182,122 17-Jan-05 96,158 137,983 24-Jan-05 97,013 104,668 31-Jan-05 97,796 117,807 7-Feb-05 106,315 157,735 14-Feb-05 92,307 145,685 21-Feb-05 89,923 129,758 28-Feb-05 100,546 130,642 7-Mar-05 99,270 85,895 14-Mar-05 98,632 125,994 21-Mar-05 100,273 113,194 28-Mar-05 100,006 127,209 4-Apr-05 105,531 114,713 11-Apr-05 92,774 145,468 18-Apr-05 103,169 151,959 25-Apr-05 105,794 68,623 2-May-05 98,534 126,485 9-May-05 97,474 97,000 16-May-05 102,492 121,350 23-May-05 105,295 137,074 30-May-05 99,640 152,589 6-Jun-05 101,201 153,171 13-Jun-05 99,726 136,244 20-Jun-05 96,206 101,012 27-Jun-05 100,878 156,135 4-Jul-05 99,439 125,567 11-Jul-05 95,537 154,901 18-Jul-05 105,354 128,439 25-Jul-05 89,897 116,745 1-Aug-05 91,257 168,639 8-Aug-05 104,675 148,706 15-Aug-05 93,216 141,687 22-Aug-05 102,284 141,879 29-Aug-05 103,959 106,889 5-Sep-05 97,823 169,328 12-Sep-05 97,765 126,747 19-Sep-05 108,032 154,728 26-Sep-05 101,433 162,576 3-Oct-05 96,548 138,661 10-Oct-05 93,295 158,689 17-Oct-05 100,227 135,165 24-Oct-05 97,876 112,240 31-Oct-05 102,985 118,904 7-Nov-05 100,099 141,778 14-Nov-05 102,245 161,104 21-Nov-05 102,353 140,226 28-Nov-05 105,811 133,108 Profit 19,449 31,452 42,877 13,738 17,843 87,256 41,825 7,655 20,011 51,420 53,378 39,835 30,096 -13,375 27,362 12,921 27,203 9,182 52,694 48,790 -37,171 27,951 -474 18,858 31,779 52,949 51,970 36,518 4,806 55,257 26,128 59,364 23,085 26,848 77,382 44,031 48,471 39,595 2,930 71,505 28,982 46,696 61,143 42,113 65,394 34,938 14,364 15,919 41,679 58,859 37,873 27,297 Column1 Descriptive statistivs Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(99.0%) 33820 3182 33359 #N/A 22948 526631227 1 0 124427 -37171 87256 1758651 52 8515 Fre que ncy Bin Frequency -37171 1 -19396 0 -1620 1 16155 9 33930 14 51705 14 69481 9 More 3 15 10 5 0 Histogram Frequency Bin a) The modes of the histogram were There were repeated 14 times. 33930 and b) The histogram is a chart showing the values agaist their frequencies. In this case, the Histogram could be said to be having a close to normal distribution with a few outliers on the left. It resembles a normal probability distribution. c)What was the average weekly profit for the prior 12-month period? The average was 33,820 d) The standard deviation was The variance was 526631227 The calculations were done at 99% confidence e) The confidence interval at 99% was This means that the values of profits fell over or below the mean by 8515 22948 8515 f) The expected exposure on the lost profits claim was defined by the mean negative confidence interval -8515 51705