Annual domestic sales and advertising of Lydia E. Pinkham Medicine Compa Exported from datamarket.com Date exported On DataMarket License Provider Source URL Units 2014-10-26 21:26 https://datamarket.com/data/set/22t7/annual-domestic-sales-and-advertising-of-lydia-e-pinkham-med Unknown; please assume a restricted license (all rights reserved); contact DataMarket if you need differe Time Series Data Library Units Thousands of USD Indicator Year AdvertisingSales 1907 608 1016 1908 451 921 1909 529 934 1910 543 976 1911 525 930 1912 549 1052 1913 525 1184 1914 578 1089 1915 609 1087 1916 504 1154 1917 752 1330 1918 613 1980 1919 862 2223 1920 866 2203 1921 1016 2514 1922 1360 2726 1923 1482 3185 1924 1608 3351 1925 1800 3438 1926 1941 2917 1927 1229 2359 1928 1373 2240 1929 1611 2196 1930 1568 2111 1931 983 1806 1932 1046 1644 1933 1453 1814 1934 1504 1770 1935 807 1518 1936 339 1103 1937 562 1266 1938 745 1473 SUMMARY OUTPUT Regression Statistics Multiple R 0.8431494 R Square 0.7109009 Adjusted R 0.7053413 Standard Er 343.46595 Observation 54 ANOVA df Regression Residual Total 1 52 53 Coefficients Intercept 488.83273 Advertising 1.4345877 RESIDUAL OUTPUT Observation Predicted Sales 1 1361.062 2 1135.8318 3 1247.7296 4 1267.8138 5 1241.9913 6 1276.4214 7 1241.9913 8 1318.0244 9 1362.4966 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 749 862 1034 1054 1164 1102 1145 1012 836 941 981 974 766 920 964 811 789 802 770 639 644 564 1423 1767 2161 2336 2602 2518 2637 2177 1920 1910 1984 1787 1689 1866 1896 1684 1633 1657 1569 1390 1387 1289 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 1211.8649 1567.6427 1368.235 1725.4473 1731.1857 1946.3738 2439.872 2614.8917 2795.6497 3071.0905 3273.3674 2251.941 2458.5216 2799.9535 2738.2662 1899.0324 1989.4114 2573.2886 2646.4526 1646.545 975.15795 1295.071 1557.6006 1563.3389 1725.4473 1972.1964 2000.8881 2158.6928 2069.7484 2131.4356 1940.6355 1688.148 1838.7797 1896.1632 1886.1211 1587.7269 1808.6534 1871.7753 1652.2833 1620.7224 1639.372 1593.4652 1405.5343 1412.7072 1297.9402 Medicine Company: both in thousands of dollars. 1907-1960. (Pankratz, 1991) g-of-lydia-e-pinkham-medicine-company-both-in-thousands-of-dollars-1907-1960-pankratz-1991#!ds=22t7!2el0&display=line aMarket if you need different licensing Adver 1000 500 Residuals 0 -500 0 -1000 Adve 4000 3000 Sales 2000 1000 0 SS MS F Significance F 15084576.81496 15084576.81496 127.86914 1.26E-015 6134380.666522 117968.8589716 21218957.48148 Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0% 127.4389652339 3.8358184389 0.0003402 233.10774 744.55773 233.10774 744.55773 0.1268656998 11.3079238723 1.26E-015 1.180013 1.6891623 1.180013 1.6891623 Residuals -345.062039128 -214.831774139 -313.729612796 -291.813840247 -311.991262095 -224.421366298 -57.9912620955 -229.024408875 -275.496626803 0 50 -57.8649209187 -237.64266434 611.765022497 497.5526914007 471.8143407003 567.6261894375 286.128029208 570.1083328476 555.3502857868 366.9094521703 -356.367410017 107.0590146442 -218.521610568 -603.953477238 -627.26620721 -93.0324172847 -345.411440815 -759.288624575 -876.452596004 -128.54498647 127.8420454704 -29.0710060737 -84.6005506143 -140.338901315 41.5526914007 188.8036112859 335.1118577842 443.3072135248 448.2516493801 505.5643793514 236.3645401378 231.8519709529 71.2202650689 87.8367580655 -99.1211282089 101.2731082089 57.3466062457 24.2247485419 31.71666283 12.2775916819 17.6279519058 -24.4652424915 -15.5342570553 -25.7071954307 -8.9401814238 Histogram of Residuals 800 600 400 200 0 Residuals -2001907 1912 1917 1922 1927 1932 1937 1942 1947 1952 1957 -400 -600 -800 -1000 Year ankratz, 1991) t7!2el0&display=line Advertising Residual Plot 1000 500 Residuals 0 -500 0 500 1000 1500 2000 2500 -1000 Advertising Advertising Line Fit Plot 4000 3000 Sales Sales Predicted Sales 2000 1000 0 0 500 1000 1500 2000 2500 Advertising als 937 1942 1947 1952 1957 1) Write down the linear model Sales = 488.83 + 1.43xAdvertising 2) Identify the dependent, and the independent variable Sales is the dependent and Advertising is the independent variable 3) Conduct a regression analysis, and cut & paste the results to your report SUMMAR Y OUTPUT Regression Statistics Multiple R R Square 0.84 0.71 Adjusted R Square 0.71 Standard Error 343.47 Observati ons 54.00 ANOVA df Regressio n Residual Total 1.00 52.00 53.00 SS MS ### ### ### Coefficien Standard ts Error Intercept 488.83 127.44 Advertisin g 1.43 0.13 a. Identify estimates of 0 and 1 0 = 488.83 and 1 = 1.43 b. R-square 71.09% c. Standard error F Significan ce F ### ### 127.87 0.00 t Stat 3.84 P-value 0.00 Lower 95% 233.11 Upper 95% 744.56 Lower 95.0% 233.11 Upper 95.0% 744.56 11.31 0.00 1.18 1.69 1.18 1.69 343.47 4) Provide a line fit plot (scatter plot of the data, and the predicted y line, with the axis clearly labeled) Below is the line fit plot: Advertising Line Fit Plot 4000 3000 Sales Sales Predicted Sales 2000 1000 0 0 500 1000 1500 2000 2500 Advertising 5) Provide a histogram of the residues Below is the histogram of the residuals: Histogram of Residuals 800 600 400 200 0 Residuals -200 -400 -600 -800 -1000 Observations 6) Provide a plot of residues against the predicted y or x Below is the plot of residuals against predicted Y Advertising Residual Plot 1000 500 Residuals 0 -500 0 500 1000 1500 -1000 Advertising 2000 2500 Residuals 0 -500 0 500 1000 1500 2000 2500 -1000 Advertising 7) Provide a plot of residues over time Below is the plot of residuals over time: Histogram of Residuals 800 600 400 200 0 Residuals -2001907 1912 1917 1922 1927 1932 1937 1942 1947 1952 1957 -400 -600 -800 -1000 Year Annual domestic sales and advertising of Lydia E. Pinkham Medicine Compa Exported from datamarket.com Date exported On DataMarket License Provider Source URL Units 2014-10-26 21:26 https://datamarket.com/data/set/22t7/annual-domestic-sales-and-advertising-of-lydia-e-pinkham-med Unknown; please assume a restricted license (all rights reserved); contact DataMarket if you need differe Time Series Data Library Units Thousands of USD Year Indicator Advertising Sales 1907 1908 1909 1910 1911 1912 1913 1914 608 1016 451 921 529 934 543 976 525 930 549 1052 525 1184 578 1089 Medicine Company: both in thousands of dollars. 1907-1960. (Pankratz, 1991) ng-of-lydia-e-pinkham-medicine-company-both-in-thousands-of-dollars-1907-1960-pankratz-1991#!ds=22t7!2el0&display=line ataMarket if you need different licensing 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 609 1087 504 1154 752 1330 613 1980 862 2223 866 2203 1016 2514 1360 2726 1482 3185 1608 3351 kratz, 1991) el0&display=line 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1800 3438 1941 2917 1229 2359 1373 2240 1611 2196 1568 2111 983 1806 1046 1644 1453 1814 1504 1770 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 807 1518 339 1103 562 1266 745 1473 749 1423 862 1767 1034 2161 1054 2336 1164 2602 1102 2518 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1145 2637 1012 2177 836 1920 941 1910 981 1984 974 1787 766 1689 920 1866 964 1896 811 1684 1955 1956 1957 1958 1959 1960 789 1633 802 1657 770 1569 639 1390 644 1387 564 1289