Please use the Applewood Auto Group excel file
a. Given the data in the file, please perform an analysis of variance to investigate whether there is a difference in the variance in the October profits of the SUV and Sedan types. Use a .05 significance level.
b. Perform an ANOVA Test to investigate whether there is a difference in the mean of the September profits from the SUV, Sedan, and Compact types at .05 significance level.
Age O ON NO Location Vehicle-Type Previous Profit November Profit October Profit September 21 Tionesta Sedan 0 2488 2510 1387 23 Sheffield SUV 1 2659 1252 1754 24 Sheffield Hybrid 1 578 1807 1817 25 Sheffield Compact 0 678 2892 1040 26 Kane Sedan 1 2174 951 1273 27 Sheffield Sedan 1 1664 2899 1529 27 Kane Truck 0 2660 1061 3082 28 Kane SUV 1 1682 2501 1951 28 Tionesta Compact o 775 1272 2692 29 Kane Sedan 2 944 2219 1342 29 Sheffield Sedan 1544 2610 1206 30 Kane Sedan 3 748 2054 443 30 Sheffield Truck 1 2913 1491 1621 30 Olean Sedan 2217 1694 754 31 Kane Truck 1852 2038 1174 31 Kane Sedan 0 657 1164 2415 31 Sheffield Sedan 1 1425 1444 1412 31 Tionesta Sedan 1 1293 1570 870 31 Tionesta Sedan 1 783 807 1809 32 Sheffield Compact 0 2175 2283 2207 32 Sheffield Truck 3 2771 797 1546 32 Tionesta SUV 0 1482 2202 2252 32 Tionesta SUV 2 2299 2207 2148 33 Olean SUV 1 643 2760 1889 33 Kane SUV 2 693 2414 1428 34 Tionesta Sedan 1 631 1036 1320 34 Olean Sedan 1 1369 2923 1166 34 Olean Sedan 0 533 969 2265 35 Tionesta SUV 1 1687 2732 1919 35 Olean Sedan 2 836 2290 1323 35 Kane Sedan 1 2785 1580 1761 36 Kane SUV 2 2806 566 2357 36 Kane Sedan 1 1208 1946 2866 37 Olean Sedan 3 1513 2655 1464 37 Olean SUV 1 2134 1064 1761 37 Tionesta Compact 4 2676 1371 1626 37 Tionesta SUV 2 1883 2809 1915 37 Kane Hybrid 1 2668 547 2119 37 Olean SUV 1 1709 1102 732 38 Sheffield SUV 1774 2172 1766 38 Sheffield Hybrid 2 2000 1832 2201 39 Tionesta SUV 2049 1004 2813 39 Kane Compact 2 1177 2003 996 40 Sheffield Sedan 1 2453 1635 1961 O PURPM NONO 2 1 0 0 2550 1091 1516 1075 531 2085 2215 2594 0 0 0 1 0 1 0 2 2 1 1 0 2250 1746 534 2292 1387 1065 523 668 2673 2441 2287 1874 2785 1285 1571 2465 2518 1811 1704 1531 1532 1257 1701 2676 2520 1616 981 2801 0 1 40 Kane 40 Tionesta 40 Tionesta 40 Kane 40 Sheffield 40 Sheffield 40 Sheffield 40 Olean 40 Olean 41 Kane 41 Tionesta 41 Kane 41 Tionesta 41 Tionesta 41 Sheffield 42 Tionesta 42 Kane 42 Tionesta 42 Kane 42 Olean 42 Kane 42 Kane 42 Olean 43 Tionesta 43 Tionesta 43 Tionesta 43 Kane 44 Tionesta 44 Sheffield 44 Kane 44 Kane 44 Kane 44 Kane 44 Tionesta 44 Kane 44 Olean 45 Olean 45 Tionesta 45 Kane 45 Kane 45 Olean 45 Sheffield 45 Olean 45 Olean 46 Olean 0 SUV Sedan Truck Sedan Sedan Compact Compact Sedan Truck Truck SUV Sedan SUV Sedan Sedan Compact Sedan Sedan SUV SUV Compact SUV SUV Sedan Sedan SUV SUV SUV Compact SUV Truck SUV SUV Compact Sedan SUV Sedan Sedan Sedan Compact Compact Compact Compact Compact Sedan 1509 2430 1144 323 1638 1485 352 482 2127 2389 2165 1876 2231 2010 1704 1553 963 1298 2071 335 2116 1410 1648 1500 2348 2498 1549 1532 1897 294 1115 2445 1 2 2 1409 1069 1275 2915 2959 1972 2381 2659 2319 505 1682 687 1935 1243 1907 712 906 925 603 1663 2008 1362 682 965 2873 1499 1331 1174 1770 717 2936 1325 621 2955 2438 2794 891 O O ONN 1 2 3 0 1 0 0 0 2 4 1 0 1 1 759 730 513 1324 1642 1518 2289 1323 1058 1227 592 1016 2741 2342 1413 1477 1177 1822 1124 1688 2886 1266 1932 2422 820 1772 2350 2446 1741 369 1 1 0 1 2 1 1 OP 0 3 0 1 2 0 1 HO 1649 855 1371 2397 1441 2455 2204 2847 1128 2089 1280 1485 554 1300 1916 1947 2074 903 1684 1991 928 1099 541 1358 2385 819 O . 0 2 1 1 1 1 0 1 1 1 1 46 Sheffield 46 Kane 46 Olean 46 Kane 46 Kane 46 Kane 46 Tionesta 46 Olean 46 Sheffield 47 Kane 47 Tionesta 47 Olean 47 Tionesta 47 Sheffield 48 Tionesta 48 Kane 48 Sheffield 48 Sheffield 48 Sheffield 48 Kane 48 Kane 49 Tionesta 49 Kane 49 Tionesta 49 Tionesta 49 Olean 49 Sheffield 50 Kane 50 Sheffield 50 Sheffield 50 Kane 50 Tionesta 51 Sheffield 51 Kane 51 Tionesta 51 Kane 51 Sheffield 51 Tionesta 52 Tionesta 52 Kane 52 Olean 52 Sheffield 52 Sheffield 52 Olean 52 Tionesta Compact SUV Sedan Truck Sedan Sedan Sedan Truck Sedan Sedan Compact Sedan Sedan SUV Compact SUV SUV SUV Sedan Sedan Sedan Truck SUV SUV Sedan Compact SUV Sedan Sedan Sedan SUV SUV Sedan SUV Sedan SUV Hybrid SUV Sedan Sedan Hybrid SUV SUV Compact SUV 3 3 1 1635 974 2548 2093 2070 1000 1543 1521 642 2656 535 803 1635 599 1473 1700 1727 1303 783 OO 1238 1818 1907 1940 1938 978 2646 1824 2197 1461 1731 3292 2230 2341 1952 2070 1344 1295 1108 1906 2454 1827 1680 1915 2084 1606 2639 3043 2059 1963 842 2338 1674 1059 1807 2928 2056 2236 1269 1797 1955 1717 2701 2482 2199 0 1550 1816 1344 524 1093 2650 617 1086 1387 2198 2087 2249 1274 1011 2286 1552 750 2395 2593 595 845 1548 2669 2536 2441 1080 2753 2225 1740 964 1122 2112 2061 1660 988 0 1 1 OOP 0 1 1 1 0 0 2 1 1 1802 1666 1700 1443 1716 717 930 1629 2193 2510 2 3 mooo 0 0 4 52 Olean 53 Olean 53 Tionesta 53 Olean 53 Olean 54 Tionesta 54 Sheffield 54 Tionesta 54 Olean 55 Kane 55 Sheffield 55 Olean 55 Sheffield 55 Tionesta 56 Kane 56 Sheffield 56 Kane 56 Olean 56 Sheffield 57 Olean 57 Sheffield 57 Sheffield 57 Sheffield 58 Kane 58 Kane 58 Sheffield 58 Sheffield 58 Tionesta 59 Sheffield 59 Olean 60 Olean 61 Kane 61 Olean 62 Sheffield 62 Olean 63 Olean 64 Kane 65 Sheffield 65 Kane 65 Tionesta 68 Sheffield 69 Kane 70 Olean 72 Olean 72 Tionesta 73 Olean Truck Sedan Sedan SUV Sedan Sedan Compact Truck Compact SUV Sedan Hybrid Truck Compact Sedan SUV Sedan Sedan SUV Sedan Sedan Sedan Hybrid SUV Sedan SUV Hybrid Compact Sedan SUV Sedan SUV Sedan Hybrid Truck Compact Truck Truck Truck SUV Sedan SUV Sedan Sedan SUV Compact 0 2 1 1 0 1 0 2 1 1 1 1 1 2 1 0 0 0 1 2 2 1 1 3 1 2757 2318 707 2852 926 1751 2934 2762 830 1285 1678 2081 910 745 1454 2354 893 1287 1473 2924 2616 944 983 1907 2692 1427 1581 795 857 2031 1229 1321 978 678 936 2426 614 1428 1933 1815 2105 1260 1852 2165 1506 2846 1911 2317 940 2474 2564 2522 1774 952 954 1448 1768 1577 2462 879 2062 2174 594 2263 1924 2970 2444 1371 1762 2937 2689 1720 2388 3210 1220 1401 377 2175 2991 1118 2666 2584 2063 2083 2856 934 2989 2695 1957 1536 2240 910 1325 2250 2626 2279 2058 1752 2637 1501 2370 1426 2944 2147 1973 2502 783 1538 2339 2700 2597 2222 2742 1837 2842 2434 1640 1821 2487 874 1 0 0 2 2 3 0 1 1 1 0 0 1 2 1 0 1172 2933 2056 2983 2167 2544 959 810 1873 731 2722 1784 1372 506 2490 999 2009 1496 4 1 1 4
