7-2 Final Project Milestone Two (Statistical Tools and Data Analysis) Worksheet

7-2 Final Project Milestone Two (Statistical Tools and Data Analysis) Worksheet

Info icon This preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
2006 2007 2008 779 845 857 802 739 881 818 871 937 888 927 1159 898 1133 1072 902 1124 1246 916 1056 1198 708 889 922 695 857 798 708 772 879 716 751 945 784 820 990 Anova: Single Factor SUMMARY Groups Count Sum Average Variance 2006 12 9614 801.16666667 7020.5151515 2007 12 10784 898.66666667 18750.060606 2008 12 11884 990.33333333 21117.878788 ANOVA Source of Variation SS df MS F P-value Between Groups 214772.22222 2 107386.11111 6.8707390008 0.0032017671 Within Groups 515773 33 15629.484848 Total 730545.22222 35
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
F crit 3.284917651
Image of page 2
2006 2007 2008 2009 2010 779 845 857 917 887 802 739 881 956 892 818 871 937 1001 997 888 927 1159 1142 1118 898 1133 1072 1276 1197 902 1124 1246 1356 1256 916 1056 1198 1288 1202 708 889 922 1082 1170 695 857 798 877 982 708 772 879 1009 1297 716 751 945 1100 1163 784 820 990 998 1053 Anova: Single Factor SUMMARY Groups Count Sum Average Variance 2006 12 9614 801.16666667 7020.5151515 2007 12 10784 898.66666667 18750.060606 2008 12 11884 990.33333333 21117.878788 2009 12 13002 1083.5 23919.727273 2010 12 13214 1101.1666667 18864.515152 ANOVA Source of Variation SS df MS F P-value Between Groups 767642.26667 4 191910.56667 10.700613071 1.73969E-006 Within Groups 986399.66667 55 17934.539394 Total 1754041.9333 59
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
F crit
Image of page 4
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2.5396886349 Sales of Refrigerators Transformer Requirements 3832 2399 5032 2688 3947 2319 3291 2208 4007 2455 5903 3184 4274 2802 3692 2343 4826 2675 6492 3477 4765 2918 4972 2814 5411 2874 7678 3774 5774 3247 6007 3107 6290 2776 8332 3571 6107 3354 6792 3513 SUMMARY OUTPUT Regression StaTsTcs Multple R 0.9259489906 R Square 0.8573815331 AdjusTed R Square 0.8494582849 STandard Error 179.4678669907 Observatons 20 ANOVA df SS MS Regression 1 3485332.924921 3485332.9249 Residual 18 579756.8750793 32208.715282 ±oTal 19 4065089.8 CoeFcients Standard Error t Stat InTercepT 1233.4994559835 167.475484972 7.3652538232 Sales of RefrigeraTors 0.3149017992 0.030271902 10.402445121 F Signifcance F 108.21086449 4.849786E-009 P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 7.79144E-007 881.646518406 1585.3523936 881.64651841 1585.3523936 4.84979E-009 0.2513028931 0.3785007053 0.2513028931 0.3785007053...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern