Need help with Excel project on Frequencies and variables

profileJustClarke
Correlation.xlsx
Home>Mathematics homework help>Statistics homework help>Need help with Excel project on Frequencies and variables

Corr applewood

Buyer's Age Profit Location Vehicle-Type Previously Owned (Yes=1)
21 1387 Tionesta Sedan 0
23 1754 Sheffield SUV 1
24 1817 Sheffield Hybrid 1
25 1040 Sheffield Compact 0
26 1273 Kane Sedan 1
27 1529 Sheffield Sedan 1
27 3082 Kane Truck 0
28 1951 Kane SUV 1
28 2692 Tionesta Compact 0
29 1342 Kane Sedan 2
29 1206 Sheffield Sedan 0
30 443 Kane Sedan 3
30 1621 Sheffield Truck 1
30 754 Olean Sedan 2
31 1174 Kane Truck 0
31 2415 Kane Sedan 0
31 1412 Sheffield Sedan 1
31 870 Tionesta Sedan 1
31 1809 Tionesta Sedan 1
32 2207 Sheffield Compact 0
32 1546 Sheffield Truck 3
32 2252 Tionesta SUV 0
32 2148 Tionesta SUV 2
33 1889 Olean SUV 1
33 1428 Kane SUV 2
34 1320 Tionesta Sedan 1
34 1166 Olean Sedan 1
34 2265 Olean Sedan 0
35 1919 Tionesta SUV 1
35 1323 Olean Sedan 2
35 1761 Kane Sedan 1
36 2357 Kane SUV 2
36 2866 Kane Sedan 1
37 1464 Olean Sedan 3
37 1761 Olean SUV 1
37 1626 Tionesta Compact 4
37 1915 Tionesta SUV 2
37 2119 Kane Hybrid 1
37 732 Olean SUV 1
38 1766 Sheffield SUV 0
38 2201 Sheffield Hybrid 2
39 2813 Tionesta SUV 0
39 996 Kane Compact 2
40 1961 Sheffield Sedan 1
40 1509 Kane SUV 2
40 2430 Tionesta Sedan 1
40 1144 Tionesta Truck 0
40 323 Kane Sedan 0
40 1638 Sheffield Sedan 0
40 1485 Sheffield Compact 0
40 352 Sheffield Compact 0
40 482 Olean Sedan 1
40 2127 Olean Truck 0
41 2389 Kane Truck 1
41 2165 Tionesta SUV 0
41 1876 Kane Sedan 2
41 2231 Tionesta SUV 2
41 2010 Tionesta Sedan 1
41 1704 Sheffield Sedan 1
42 1553 Tionesta Compact 0
42 963 Kane Sedan 0
42 1298 Tionesta Sedan 1
42 2071 Kane SUV 0
42 335 Olean SUV 1
42 2116 Kane Compact 2
42 1410 Kane SUV 2
42 1648 Olean SUV 0
43 1500 Tionesta Sedan 0
43 2348 Tionesta Sedan 0
43 2498 Tionesta SUV 1
43 1549 Kane SUV 2
44 1532 Tionesta SUV 3
44 1897 Sheffield Compact 0
44 294 Kane SUV 1
44 1115 Kane Truck 0
44 2445 Kane SUV 0
44 1822 Kane SUV 0
44 1124 Tionesta Compact 2
44 1688 Kane Sedan 4
44 2886 Olean SUV 1
45 1266 Olean Sedan 0
45 1932 Tionesta Sedan 1
45 2422 Kane Sedan 1
45 820 Kane Compact 1
45 1772 Olean Compact 1
45 2350 Sheffield Compact 0
45 2446 Olean Compact 1
45 1741 Olean Compact 2
46 369 Olean Sedan 1
46 1238 Sheffield Compact 1
46 1818 Kane SUV 0
46 1907 Olean Sedan 0
46 1940 Kane Truck 3
46 1938 Kane Sedan 0
46 978 Kane Sedan 1
46 2646 Tionesta Sedan 2
46 1824 Olean Truck 0
46 2197 Sheffield Sedan 1
47 1461 Kane Sedan 0
47 1731 Tionesta Compact 0
47 3292 Olean Sedan 2
47 2230 Tionesta Sedan 1
47 2341 Sheffield SUV 1
48 1952 Tionesta Compact 1
48 2070 Kane SUV 1
48 1344 Sheffield SUV 0
48 1295 Sheffield SUV 1
48 1108 Sheffield Sedan 1
48 1906 Kane Sedan 1
48 2454 Kane Sedan 1
49 1827 Tionesta Truck 3
49 1680 Kane SUV 3
49 1915 Tionesta SUV 1
49 2084 Tionesta Sedan 0
49 1606 Olean Compact 0
49 2639 Sheffield SUV 0
50 3043 Kane Sedan 0
50 2059 Sheffield Sedan 1
50 1963 Sheffield Sedan 1
50 842 Kane SUV 0
50 2338 Tionesta SUV 0
51 1674 Sheffield Sedan 1
51 1059 Kane SUV 1
51 1807 Tionesta Sedan 1
51 2928 Kane SUV 0
51 2056 Sheffield Hybrid 0
51 2236 Tionesta SUV 2
52 1269 Tionesta Sedan 1
52 1797 Kane Sedan 1
52 1955 Olean Hybrid 2
52 1717 Sheffield SUV 3
52 2701 Sheffield SUV 0
52 2482 Olean Compact 0
52 2199 Tionesta SUV 0
52 3210 Olean Truck 4
53 1220 Olean Sedan 0
53 1401 Tionesta Sedan 2
53 377 Olean SUV 1
53 2175 Olean Sedan 1
54 2991 Tionesta Sedan 0
54 1118 Sheffield Compact 1
54 2666 Tionesta Truck 0
54 2584 Olean Compact 2
55 2063 Kane SUV 1
55 2083 Sheffield Sedan 1
55 2856 Olean Hybrid 1
55 934 Sheffield Truck 1
55 2989 Tionesta Compact 1
56 2695 Kane Sedan 2
56 1957 Sheffield SUV 1
56 1536 Kane Sedan 0
56 2240 Olean Sedan 0
56 910 Sheffield SUV 0
57 1325 Olean Sedan 1
57 2250 Sheffield Sedan 2
57 2626 Sheffield Sedan 2
57 2279 Sheffield Hybrid 1
58 2058 Kane SUV 1
58 1752 Kane Sedan 3
58 2637 Sheffield SUV 1
58 1501 Sheffield Hybrid 1
58 2370 Tionesta Compact 0
59 1426 Sheffield Sedan 0
59 2944 Olean SUV 2
60 2147 Olean Sedan 2
61 1973 Kane SUV 3
61 2502 Olean Sedan 0
62 783 Sheffield Hybrid 1
62 1538 Olean Truck 1
63 2339 Olean Compact 1
64 2700 Kane Truck 0
65 2597 Sheffield Truck 0
65 2222 Kane Truck 1
65 2742 Tionesta SUV 2
68 1837 Sheffield Sedan 1
69 2842 Kane SUV 0
70 2434 Olean Sedan 4
72 1640 Olean Sedan 1
72 1821 Tionesta SUV 1
73 2487 Olean Compact 4