Assignment 2

Use Category Percentage of Respondents Use Category Checking sports 27% #NAME? Checking the news 40% #NAME? Checking weather/traffic 49% #NAME? Controlling lighting 26% #NAME? Finding local information 30% #NAME? Fun stuff (jokes, etc.) 36% #NAME? Listening to music 74% #NAME? Looking up facts 39% #NAME? Making phone calls 24% #NAME? Setting reminders/alarms 35% #NAME? Using a kitchen assistant 24% #NAME? Part 1. Part 2. Most popular Listening to Music Least popular Making Phone call, Using a kitchen Assistant.

Percentage of Respondents #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME ? #NAME ? #NAME ? #NAME ? #NAME ? #NAME ? #NAME ? 0% 200% 400% 600% 800% 1000% 1200% People and Smart Speaker Us

Age Percentage who use Rideshare Age Percentage who use Rideshare 18-29 45% #NAME? #NAME? 30-49 36% #NAME? #NAME? 50-64 23% #NAME? #NAME? 65+ 13% #NAME? #NAME? Part 3. Part 4. Most usage 18-29 years Least usage 65+ years

#NAME? #NAME? #NAME? #NAME? 0% 200% 400% 600% 800% 1000% 1200% Rideshare Usage Age (Years)

Year Founded Tuition & Fees % Graduate 1636 $38,415 97 1701 $38,300 98 1740 $42,098 96 1746 $37,000 96 1754 $41,160 96 1764 $42,230 95 1769 $40,437 95 1789 $40,203 93 1818 $32,656 72 1819 $41,870 88 1821 $42,905 81 1826 $38,088 84 1826 $39,115 89 1830 $43,170 87 1831 $29,970 79 1833 $30,560 61 1834 $41,576 89 1834 $41,884 70 1837 $38,866 91 1838 $40,243 95 1839 $39,864 84 1841 $23,932 73 1841 $38,277 79 1842 $39,665 90 1842 $41,417 96 1845 $29,754 70 1846 $43,866 91 1847 $26,534 68 1849 $33,612 65 1850 $29,930 78 1851 $37,368 87 1851 $40,224 93 1852 $39,350 82 1853 $28,650 59 1853 $29,800 73 1854 $28,076 66 1854 $31,710 82 1855 $30,558 73 1855 $37,424 69 1856 $25,650 68 1856 $31,890 63 1858 $26,895 68 1859 $31,040 70 1863 $35,140 69 1863 $40,542 91 1864 $37,833 76 $0 $5,000 $10,000 0 20 40 60 80 100 120 Graduation Rate (%)

1865 $30,470 64 1865 $39,666 93 1865 $39,780 88 1867 $17,905 65 1870 $30,077 70 1870 $31,980 58 1870 $33,294 68 1870 $36,302 83 1872 $28,332 46 1873 $32,490 74 1873 $39,930 91 1875 $4,560 78 1877 $30,754 58 1878 $27,502 75 1878 $30,578 77 1880 $41,022 89 1881 $28,382 75 1881 $31,822 81 1883 $35,081 61 1883 $35,820 66 1884 $17,280 54 1887 $22,520 52 1887 $30,925 82 1889 $27,881 81 1891 $23,494 56 1891 $33,005 67 1891 $41,006 95 1893 $36,697 79 1894 $28,310 65 1897 $25,424 78 1898 $28,858 68 1898 $36,792 77 1901 $33,538 77 1904 $13,572 37 1905 $22,410 48 1911 $39,430 74 1912 $35,551 93 1917 $39,435 88 1921 $21,550 61 1925 $37,836 80 1929 $27,650 80 1929 $36,130 75 1934 $26,600 41 1935 $31,800 60 1937 $28,985 73 1937 $39,080 80 1940 $30,192 63

$15,000 $20,000 $25,000 $30,000 $35,000 $40,000 $45,000 $50,000 Graduation Rate versus Tuition Tuition

Sector Company Score Transportation / Logistics UPS 71.2 Technology Amazon 120.2 Technology Microsoft 97.6 Technology Apple 92.1 Technology Alphabet 85.5 Technology Cisco Systems 85.2 Technology Facebook 80.8 Technology IBM 80.8 Technology Intel 79.5 Technology HP 78.9 Technology Adobe 73.5 Technology Nividia 73.2 Technology Intuit 73.0 Retail/Wholesale Walmart 76.4 Health Care / Life Sciences Johnson & Johnson 79.9 Health Care / Life Sciences Edwards Lifesciences 70.7 Financial Services Mastercard 76.6 Financial Services Visa 72.1 Financial Services Allstate 70.9 Energy Exxon Mobil 71.1 Consumer Goods PepsiCo 77.3 Consumer Goods Procter & Gamble 75.6 Consumer Goods Nike 75.0 Business / Consumer Services 3M 79.4 Business / Consumer Services Accenture 73.5 Part 7. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the char

rt.

Washington 3,375 West Virginia 2,873 Wisconsin 2,869 Wyoming 3,184 Part 9. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.

Part 10. Texas and California

Year Price of Admission Adjusted Price of Admission 2000 $46 $70.30 2001 $48 $70.72 2002 $50 $71.26 2003 $52 $73.02 2004 $55 $75.37 2005 $60 $80.83 2006 $67 $84.77 2007 $71 $88.09 2008 $75 $88.31 2009 $79 $94.42 2010 $82 $96.90 2011 $85 $97.14 2012 $89 $100.05 2013 $95 $104.95 2014 $99 $108.78 2015 $106 $115.40 2016 $110 $119.68 2017 $115 $121.78 2018 $122 $124.45 2019 $125 $126.85 2020 $125 $125.00 Part 11. Part 12. As years passed the gap between the price of admission and adjusjusted price of admission gradually diminis 1 2 $0 $20 $40 $60 $80 $100 $120 $140 Price Diseny Ticket Prices