4. Use the Applewood care sales dataset and run a regression with prot as the dependent variable and age (this is the age of the customer at the time of purchase) as the independent variable. a) Interpret the r-square{d) term. b) What is the slope coefcient? Interpret this result. c) Does the slope coefcient have the direction (i.e. positive or negative) you might have expected prior to running the regression? Explain why you think these two variables have this relationship. (1) Test the hypothesis that the slope (B) is different than 0. (You can feel free to use any aspects of the Excel regression output in your test, instead of calculating it by hand). 6) Run an alternative regression with square root of age as the independent variable. Does this regression do a better or worse job at predicting prot? Explain your answer. Age Profit Location Vehicle-Type Previous 21 1387 Tionesta Sedan 0 23 1754 Sheffield SUV 24 1817 Sheffield Hybrid 1 25 1040 Sheffield Compact O 26 1273 Kane Sedan 1 27 1529 Sheffield Sedan 27 3082 Kane Truck O 28 1951 Kane SUV 1 28 2692 Tionesta Compact 0 29 1342 Kane Sedan 2 29 1206 Sheffield Sedan O 30 443 Kane Sedan 30 1621 Sheffield Truck 30 754 Olean Sedan 2 31 1174 Kane Truck 0 31 2415 Kane Sedan O 31 1412 Sheffield Sedan 31 870 Tionesta Sedan 31 1809 Tionesta Sedan 32 2207 Sheffield Compact O 32 1546 Sheffield Truck 3 32 2252 Tionesta SUV O 32 2148 Tionesta SUV N 33 1889 Olean SUV 33 1428 Kane SUV N 34 1320 Tionesta Sedan 34 1166 Olean Sedan 134 1320 Tionesta Sedan 34 1166 Olean Sedan 34 2265 Olean Sedan 35 1919 Tionesta SUV 35 1323 Olean Sedan 35 1761 Kane Sedan 36 2357 Kane SUV 2 36 2866 Kane Sedan 37 1464 Olean Sedan 3 37 1761 Olean SUV 37 1626 Tionesta Compact 4 37 1915 Tionesta SUV 2 37 2119 Kane Hybrid 37 732 Olean SUV 38 1766 Sheffield SUV 0 38 2201 Sheffield Hybrid 2 39 2813 Tionesta SUV 0 39 996 Kane Compact 2 40 1961 Sheffield Sedan 40 1509 Kane SUV N 40 2430 Tionesta Sedan 40 1144 Tionesta Truck 40 323 Kane Sedan 40 1638 Sheffield Sedan 40 1485 Sheffield Compact 40 352 Sheffield Compact 40 482 Olean Sedan O H 40 2127 Olean Truck48 2454 Kane Sedan 49 1827 Tionesta Truck W 49 1680 Kane SUV 3 49 1915 Tionesta SUV 49 2084 Tionesta Sedan O O 49 1606 Olean Compact 49 2639 Sheffield SUV O O 50 3043 Kane Sedan 50 2059 Sheffield Sedan 50 1963 Sheffield Sedan 50 842 Kane SUV O 50 2338 Tionesta SUV O 51 1674 Sheffield Sedan 51 1059 Kane SUV 51 1807 Tionesta Sedan 51 2928 Kane SUV O 51 2056 Sheffield Hybrid O 51 2236 Tionesta SUV N 52 1269 Tionesta Sedan 52 1797 Kane Sedan 52 1955 Olean Hybrid 2 52 1717 Sheffield SUV 52 2701 Sheffield SUV O 52 2482 Olean Compact O 52 2199 Tionesta SUV O 52 3210 Olean Truck 4 53 1220 Olean Sedan O 53 1401 Tionesta Sedan 253 377 Olean SUV 53 2175 Olean Sedan 54 2991 Tionesta Sedan O 54 1118 Sheffield Compact 54 2666 Tionesta Truck O 54 2584 Olean Compact N 55 2063 Kane SUV 55 2083 Sheffield Sedan 55 2856 Olean Hybrid 55 934 Sheffield Truck 55 2989 Tionesta Compact 56 2695 Kane Sedan N 56 1957 Sheffield SUV 56 1536 Kane Sedan O 56 2240 Olean Sedan O 56 910 Sheffield SUV O 57 1325 Olean Sedan 57 2250 Sheffield Sedan IN 57 2626 Sheffield Sedan N 57 2279 Sheffield Hybrid 58 2058 Kane SUV 58 1752 Kane Sedan 58 2637 Sheffield SUV 58 1501 Sheffield Hybrid 58 2370 Tionesta Compact O 59 1426 Sheffield Sedan O 59 2944 Olean SUV N 60 2147 Olean Sedan 261 1973 Kane SUV O W 61 2502 Olean Sedan 62 783 Sheffield Hybrid 62 1538 Olean Truck 63 2339 Olean Compact O K 64 2700 Kane Truck 65 2597 Sheffield Truck O 65 2222 Kane Truck 65 2742 Tionesta SUV 2 68 1837 Sheffield Sedan 69 2842 Kane SUV O 70 2434 Olean Sedan 72 1640 Olean Sedan 72 1821 Tionesta SUV 73 2487 Olean Compact 4