Hello.

I need help with this assignment. It is due before 11:58 pm today.

Use Hypothesis Testing and the data in the course materials folder to analyze the difference in milk production between California and Wisconsin from 1900 through 1995 and decide if there is a significant difference in production between the states.Please remember to:

• Develop a research question.
• Formulate both a numerical and verbal hypothesis statement regarding your research issue.
• What is the independent variable?
• What is the dependent variable?
• Select a level of significance.
• Identify the test statistic.
• Describe the results of your test, and explain how the findings from this hypothesis testing can be used to answer your research question.
• Compare leas week's findings with this analysis.
• Explain why two-factor ANOVA would have been a better statistic in analyzing this question.

Milk Cows & Production California Year Period 1990 Jan 1990 Feb 1990 Mar 1990 Apr 1990 May 1990 Jun 1990 Jul 1990 Aug 1990 Sep 1990 Oct 1990 Nov 1990 Dec 1991 Jan 1991 Feb 1991 Mar 1991 Apr 1991 May 1991 Jun 1991 Jul 1991 Aug 1991 Sep 1991 Oct 1991 Nov 1991 Dec 1992 Jan 1992 Feb 1992 Mar 1992 Apr 1992 May 1992 Jun 1992 Jul 1992 Aug 1992 Sep 1992 Oct 1992 Nov 1992 Dec 1993 Jan 1993 Feb 1993 Mar 1993 Apr 1993 May 1993 Jun 1993 Jul 1993 Aug 1993 Sep 1993 Oct 1993 Nov 1993 Dec 1994 Jan 1994 Feb Pounds of Milk per Cow Milk Cows (000) 1118 1122 1126 1130 1133 1136 1138 1140 1142 1144 1146 1148 1150 1152 1153 1154 1155 1156 1156 1157 1157 1157 1158 1159 1160 1164 1169 1171 1174 1177 1182 1187 1191 1193 1196 1198 1202 1204 1207 1210 1212 1214 1218 1220 1222 1224 1226 1228 1230 1233 Production (000,000 lbs) 1485 1660 1360 1526 1580 1779 1560 1763 1640 1858 1580 1795 1605 1826 1590 1813 1520 1736 1540 1762 1480 1696 1510 1733 1535 1765 1430 1647 1585 1828 1555 1794 1620 1871 1560 1803 1585 1832 1595 1845 1500 1736 1530 1770 1495 1731 1540 1785 1540 1786 1465 1705 1605 1876 1570 1838 1625 1908 1680 1860 1605 1897 1550 1840 1525 1816 1575 1879 1520 1818 1560 1869 1515 1821 1400 1686 1585 1913 1575 1906 1640 1988 1575 1912 1640 1998 1630 1989 1570 1919 1600 1958 1540 1888 1585 1946 1630 2005 1490 1837 1994 Mar 1994 Apr 1994 May 1994 Jun 1994 Jul 1994 Aug 1994 Sep 1994 Oct 1994 Nov 1994 Dec 1995 Jan 1995 Feb 1995 Mar 1995 Apr 1995 May 1995 Jun 1995 Jul 1995 Aug 1995 Sep 1995 Oct 1995 Nov 1995 Dec 1996 Jan 1996 Feb 1996 Mar 1996 Apr 1996 May 1996 Jun 1996 Jul 1996 Aug 1996 Sep 1996 Oct 1996 Nov 1996 Dec 1997 Jan 1997 Feb 1997 Mar 1997 Apr 1997 May 1997 Jun 1997 Jul 1997 Aug 1997 Sep 1997 Oct 1997 Nov 1997 Dec 1998 Jan 1998 Feb 1998 Mar 1998 Apr 1998 May 1998 Jun 1998 Jul 1998 Aug 1236 1239 1243 1247 1251 1254 1259 1263 1267 1270 1272 1275 1279 1283 1287 1291 1296 1300 1305 1309 1314 1319 1322 1326 1329 1335 1341 1347 1351 1356 1362 1367 1373 1378 1382 1384 1385 1387 1389 1390 1391 1392 1394 1395 1397 1400 1402 1406 1408 1411 1414 1417 1421 1424 1710 1705 1770 1715 1740 1725 1675 1710 1640 1685 1660 1515 1690 1660 1730 1645 1685 1655 1580 1620 1545 1585 1595 1505 1635 1620 1665 1590 1615 1570 1570 1620 1570 1605 1575 1465 1705 1700 1740 1665 1715 1700 1620 1685 1620 1645 1670 1480 1665 1640 1720 1635 1625 1595 2114 2112 2200 2139 2177 2163 2109 2160 2078 2140 2112 1932 2162 2130 2227 2124 2184 2152 2062 2121 2030 2091 2109 1996 2173 2163 2233 2142 2182 2129 2138 2215 2156 2212 2177 2028 2361 2358 2417 2314 2386 2366 2258 2351 2263 2303 2341 2081 2344 2314 2432 2317 2309 2271 1998 Sep 1998 Oct 1998 Nov 1998 Dec 1999 Jan 1999 Feb 1999 Mar 1999 Apr 1999 May 1999 Jun 1999 Jul 1999 Aug 1999 Sep 1999 Oct 1999 Nov 1999 Dec 2000 Jan 2000 Feb 2000 Mar 2000 Apr 2000 May 2000 Jun 2000 Jul 2000 Aug 2000 Sep 2000 Oct 2000 Nov 2000 Dec 2001 Jan 2001 Feb 2001 Mar 2001 Apr 2001 May 2001 Jun 2001 Jul 2001 Aug 2001 Sep 2001 Oct 2001 Nov 2001 Dec 2002 Jan 2002 Feb 2002 Mar 2002 Apr 2002 May 2002 Jun 2002 Jul 2002 Aug 2002 Sep 2002 Oct 2002 Nov 2002 Dec 2003 Jan 2003 Feb 1428 1432 1436 1438 1443 1444 1451 1455 1457 1464 1468 1470 1476 1480 1482 1484 1493 1500 1506 1510 1516 1523 1529 1536 1541 1547 1553 1558 1563 1566 1570 1575 1581 1586 1591 1596 1602 1607 1613 1619 1624 1628 1633 1638 1642 1646 1652 1656 1662 1664 1666 1667 1672 1676 1530 1650 1590 1655 1690 1555 1795 1770 1825 1710 1710 1770 1705 1760 1715 1780 1815 1705 1820 1810 1845 1755 1820 1745 1685 1735 1665 1735 1760 1615 1790 1770 1825 1755 1770 1765 1690 1745 1685 1735 1755 1625 1835 1800 1880 1810 1815 1815 1705 1770 1695 1770 1790 1655 2185 2363 2283 2380 2439 2245 2605 2575 2659 2503 2510 2602 2517 2605 2542 2642 2710 2558 2741 2733 2797 2673 2783 2680 2597 2684 2586 2703 2751 2529 2810 2788 2885 2783 2816 2817 2707 2804 2718 2809 2850 2646 2997 2948 3087 2979 2998 3006 2834 2945 2824 2951 2993 2774 2003 Mar 2003 Apr 2003 May 2003 Jun 2003 Jul 2003 Aug 2003 Sep 2003 Oct 2003 Nov 2003 Dec 2004 Jan 2004 Feb 2004 Mar 2004 Apr 2004 May 2004 Jun 2004 Jul 2004 Aug 2004 Sep 2004 Oct 2004 Nov 2004 Dec 2005 Jan 2005 Feb 2005 Mar 2005 Apr 2005 May 2005 Jun 2005 Jul 2005 Aug 2005 Sep 2005 Oct 2005 Nov 2005 Dec 1681 1685 1685 1684 1690 1693 1695 1698 1694 1697 1701 1706 1710 1716 1720 1724 1729 1733 1737 1740 1741 1741 1739 1742 1744 1747 1751 1753 1756 1759 1762 1765 1770 1771 1850 1800 1835 1765 1755 1755 1670 1720 1665 1740 1760 1675 1815 1790 1830 1755 1780 1775 1715 1770 1700 1775 1770 1635 1850 1825 1880 1815 1780 1795 1750 1785 1725 1795 3110 3033 3092 2972 2966 2971 2831 2921 2821 2953 2994 2858 3104 3072 3148 3026 3078 3076 2979 3080 2960 3090 3078 2848 3226 3188 3292 3182 3126 3157 3084 3151 3053 3179 Wisconsin Milk Cows (000) Pounds of Milk Production per Cow (000,000 lbs) 1738 1145 1990 1733 1075 1863 1725 1225 2113 1730 1205 2085 1732 1265 2191 1735 1225 2125 1735 1220 2117 1729 1185 2049 1730 1105 1912 1730 1120 1938 1729 1075 1859 1729 1125 1945 1717 1160 1992 1705 1085 1850 1695 1230 2085 1689 1220 2061 1688 1285 2169 1681 1215 2042 1678 1210 2030 1673 1200 2008 1671 1130 1888 1662 1150 1911 1657 1095 1814 1655 1160 1920 1645 1195 1966 1638 1145 1876 1623 1245 2021 1622 1215 1971 1617 1300 2102 1617 1300 2102 1617 1315 2126 1613 1285 2073 1611 1190 1917 1610 1200 1932 1603 1145 1835 1596 1205 1923 1584 1230 1948 1578 1130 1783 1573 1280 2013 1562 1265 1976 1552 1360 2111 1546 1325 2048 1538 1300 1999 1533 1245 1909 1523 1180 1797 1514 1180 1787 1505 1125 1693 1502 1185 1780 1495 1205 1801 1489 1100 1638 1483 1487 1488 1495 1500 1500 1498 1498 1497 1499 1500 1498 1498 1496 1494 1492 1490 1488 1485 1482 1480 1478 1475 1470 1470 1465 1460 1455 1448 1441 1435 1428 1421 1414 1408 1404 1400 1395 1393 1392 1392 1390 1390 1388 1385 1382 1378 1376 1373 1368 1368 1368 1366 1366 1260 1255 1360 1325 1330 1300 1225 1240 1175 1225 1265 1165 1315 1295 1390 1355 1350 1300 1250 1255 1200 1255 1290 1215 1325 1290 1345 1305 1320 1310 1255 1285 1220 1285 1315 1210 1355 1330 1420 1410 1415 1400 1305 1320 1250 1325 1360 1255 1410 1395 1480 1435 1445 1425 1869 1866 2024 1981 1995 1950 1835 1858 1759 1836 1898 1745 1970 1937 2077 2022 2012 1934 1856 1860 1776 1855 1903 1786 1948 1890 1964 1899 1911 1888 1801 1835 1734 1817 1852 1699 1897 1855 1978 1963 1970 1946 1814 1832 1731 1831 1874 1727 1936 1908 2025 1963 1974 1947 1366 1366 1368 1370 1368 1366 1366 1365 1366 1368 1368 1366 1364 1362 1362 1360 1358 1355 1352 1349 1347 1345 1345 1343 1339 1336 1334 1330 1322 1310 1300 1295 1295 1290 1288 1282 1282 1281 1280 1280 1279 1278 1276 1275 1272 1270 1265 1265 1268 1268 1266 1266 1265 1265 1360 1380 1325 1410 1415 1300 1465 1435 1510 1440 1420 1410 1360 1385 1340 1420 1445 1375 1495 1450 1515 1450 1480 1465 1405 1430 1370 1420 1445 1335 1495 1460 1530 1460 1455 1415 1385 1400 1365 1435 1460 1350 1510 1475 1525 1450 1455 1470 1405 1420 1385 1465 1500 1370 1858 1885 1813 1932 1936 1776 2001 1959 2063 1970 1943 1926 1855 1886 1825 1931 1962 1863 2021 1956 2041 1950 1991 1967 1881 1910 1828 1889 1910 1749 1944 1891 1981 1883 1874 1814 1776 1793 1747 1837 1867 1725 1927 1881 1940 1842 1841 1860 1782 1801 1753 1855 1898 1733 1263 1260 1257 1256 1255 1254 1253 1250 1249 1247 1245 1245 1244 1242 1242 1241 1240 1240 1239 1238 1237 1236 1235 1234 1233 1234 1234 1235 1236 1236 1237 1238 1238 1239 1530 1480 1540 1505 1515 1495 1430 1465 1410 1485 1505 1405 1510 1485 1560 1485 1520 1510 1440 1475 1415 1490 1515 1400 1560 1540 1630 1590 1600 1595 1510 1535 1480 1550 1932 1865 1936 1890 1901 1875 1792 1831 1761 1852 1874 1749 1878 1844 1938 1843 1885 1872 1784 1826 1750 1842 1871 1728 1923 1900 2011 1964 1978 1971 1868 1900 1832 1920 1 Week Four Assignment 95% Please see my comments below Week 4 Assignment Sarah Jimenez QNT/275- Week 4 Instructor: Jeff Jung Date: 08/28/2017 2 Week Four Assignment Discussion Question 2: Use Hypothesis Testing and the data in the course materials folder to analyze the difference in milk production in California and Wisconsin from 2000 through 2005 and decide if there is a significant difference in production between the states. Please remember to: Develop a research question. Is there a significant difference in milk production in California and Wisconsin from 2000 through 2005? Perfect! Formulate both a numerical and verbal hypothesis statement regarding your research issue. Hypothesis 0, the null hypothesis states that there was not a significant difference in production between the two samples (populations). H0 1 = 2 Hypothesis 1 states that there was a major difference between the two samples (populations). H1 1 2 Perfect! What is the independent variable? The independent variable is the number of cows in the population. Location; California - Wisconsin What is the dependent variable? The dependent variable is the production of milk for the population. 3 Week Four Assignment Perfect! Select a level of significance. The level of significance is equal to .05 Perfect! Identify the test statistic. Excel: Data Analysis t-Test: Two-Sample Assuming Equal Variances Mean Variance Observations Pooled Variance Hypothesized Mean Difference df t Stat P(T