Transformer Requirements: 2006 January February March April May June July August September October November December Total 2007 779 802 818 888 898 902 916 708 695 708 716 784 9614 845 739 871 927 1133 1124 1056 889 857 772 751 820 10784 2008 2009 857 881 937 1159 1072 1246 1198 922 798 879 945 990 11884 917 956 1001 1142 1276 1356 1288 1082 877 109 1100 998 12102 2008 4826 6492 4765 4972 21055 2009 5411 7678 5771 6007 24867 Refrigerator Sales Figures: Quarter I II III IV Total Quarterly Figures For each Year I I I I I II II II II II III III III III III IV IV 2006 2007 3832 5032 3947 3291 16102 4007 5903 4274 3692 17876 Sales (X) 3832 4007 4826 5411 6290 5032 5903 6492 7678 8332 3947 4274 4765 5771 6107 3291 3692 Transformers (Y) 2399 2455 2675 2874 2776 2688 3184 3477 3774 3571 2319 2802 2918 3247 3354 2208 2343 IV IV IV 4972 6007 6729 2814 2207 3513 2010 887 892 997 1118 1197 1256 1202 1170 982 1297 1163 1053 13214 Transformer Requirements: Quarter 2006 I 2399 II 2688 III 2319 IV 2208 Total 9614 2007 2455 3184 2802 2343 10784 2008 2675 3477 2918 2814 11884 2009 2874 3774 3247 2207 12102 2010 2776 3571 3354 3513 13214 2399 2688 2319 2208 2455 3184 2802 2343 2675 3477 2918 2814 2874 3774 3247 2207 2776 3571 3354 3513 5000 6000 7000 8000 9000 2010 6290 8332 6107 6729 27458 4000 3500 3000 2500 2000 Transformers 1500 1000 500 0 3000 4000 Refrigerator Sales 9000 Sales Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Transformers 5367.9 2879.9 303.35746588 108.90374553 5221.5 2808 #N/A #N/A 1356.6558304 487.032356 1840515.0421 237200.51579 -0.2711187069 -1.0837430822 0.4570386759 0.2789056515 5041 1567 3291 2207 8332 3774 107358 57598 20 20 Sales (X) Sales (X) Transformers (Y) 1 0.8327877515 Transformers (Y) 1 Year Annual Transformer Requirements Annual Sales Total 2006 9,614 16,102 25,716 2007 10,784 17,876 28,660 2008 11,884 21,055 32,939 2009 12,102 24,867 36,969 2010 13,214 27,458 40,672 Total 57,598 107,358 164,956 SUMMARY OUTPUT Regression Statistics Multiple R 0.833 R Square 0.694 Adjusted R Square 0.677 Standard Error 277.006 Observations 20.000 ANOVA df Regression Residual Total Intercept Sales (X) 1.000 18.000 19.000 SS MS 3125632.313 3125632.313 1381177.487 76732.083 4506809.800 Coefficients Standard Error 1275.078 258.964 0.299 0.047 t Stat 4.924 6.382 F Significance F 40.734 0.000 P-value 0.000 0.000 Lower 95% 731.015 0.201 Upper 95% Lower 95.0% Upper 95.0% 1819.140 731.015 1819.140 0.397 0.201 0.397 Anova: Single Factor SUMMARY Groups Count 2006 2007 2008 2009 2010 12 12 12 12 12 ANOVA Source of Variation Between Groups Within Groups SS 626282.26667 1862999.6667 Total 2489281.9333 Sum Average Variance 9614 801.16666667 7020.5151515 10784 898.66666667 18750.060606 11884 990.33333333 21117.878788 12102 1008.5 103610.63636 13214 1101.1666667 18864.515152 df MS F P-value F crit 4 156570.56667 4.6223202938 0.002738 2.539689 55 33872.721212 59 Quarter I II III IV 2006 3832 5032 3947 3291 Year 2007 4007 5903 4274 3692 Quarter 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 2008 4826 6492 4765 4972 Time 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 2009 5411 7678 5771 6007 Quarter 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2011Q1 1 21 1 0 0 7,101 2010 6290 8332 6107 6729 Quarter 2 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 2011Q2 1 22 0 1 0 8,915 Quarter 3 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 Sales 3832 5032 3947 3291 4007 5903 4274 3692 4826 6492 4765 4972 5411 7678 5771 6007 6290 8332 6107 6729 1 24 0 0 0 7,166 30,383 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 2011Q3 1 23 0 0 1 7,201 2011Q4 SUMMARY OUTPUT Regression Statistics Multiple R 0.9815233849 R Square 0.9633881551 Adjusted R Square 0.9536249964 Standard Error 292.15388354 Observations 20 ANOVA df Regression Residual Total Intercept Time Quarter 1 Quarter 2 Quarter 3 4 15 19 SS MS F 33689477.425 8422369.3563 98.675868104 1280308.375 85353.891667 34969785.8 Coefficients 2710.475 185.64375 491.93125 2120.4875 220.24375 Standard Error t Stat P-value 190.4610300254 14.231126439 4.07070E-010 11.5483962406 16.07528406 7.27716E-011 187.9942705729 2.6167353319 0.0194400306 186.2122941419 11.387473151 8.81579E-009 185.1348754892 1.1896394422 0.2526783141 Significance F 1.387777E-010 Lower 95% Upper 95% Lower 95.0% 2304.51692411 3116.4330759 2304.5169241 161.028926081 210.25857392 161.02892608 91.2309474196 892.63155258 91.23094742 1723.58539027 2517.3896097 1723.5853903 -174.36189623 614.84939623 -174.36189623 Upper 95.0% 3116.4330759 210.25857392 892.63155258 2517.3896097 614.84939623 Transformers (Y) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%) 2879.9 Sample Mean 108.90374553 2808 #N/A 487.032356 237200.51579 -1.0837430822 0.2789056515 1567 2207 3774 57598 20 227.938159 Error Quarterly Interval 2652 3108 Monthly Transfomers 779 802 818 888 898 902 916 708 695 708 716 784 845 739 871 927 1133 1124 1056 889 857 772 751 820 857 881 937 1159 1072 1246 1198 922 798 879 945 990 917 956 1001 1142 1276 1356 1288 1082 877 109 Monthly Transfomers Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%) 959.9667 26.51767 924.5 708 205.405 42191.22 3.629996 -0.871281 1247 109 1356 57598 60 53.06174 Monthly Interval 907 1013 1100 998 887 892 997 1118 1197 1256 1202 1170 982 1297 1163 1053