Application Exercises 3-21. EXCEL APPLICATION: Analyzing Growth in Computer Storage Capacities Since the computer hard drive was invented in 1956, a constantly increasing data storage capacity has been available at an ever-decreasing cost. Use the historical data of hard drive capacities and prices shown in Figure 3-29 (or download the Excel file named CH03Ex01). Modify the spreadsheet so that it includes a new column containing formulas that calculate a common measure of disk size (GB) and a second new column that computes the cost per GB for each year. (Recall 1 gigabyte = 1,024 megabytes; 1 terabyte = 1,024 gigabytes.) Now, create one line graph to show the cost per gigabyte from the period 1995 to 2016. Create a second line graph to show changes in the size of hard disks across the same period. (Tip: Use the Hide function to cover the columns you dont need for each graph.) Write a brief summary of the trends you found. What factors have contributed to these trends? What are the implications of these trends? 3-22. ACCESS

File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing x D1 X v A D E F G H - L M N 0 Q R S T LA 1 2 Year 1980 1981 1983 3 4 5 1984 1987 6 7 8 1989 1995 9 1996 1997 10 11 B Size 26 MB 63 MB 20 MB 20 MB 40 MB 20 MB 1.7 GB 3.2 GB 7.0 GB 8.4 GB 19.2 GB 27.3 GB 40 GB 100 GB 120 GB 250 GB 390 GB 1 TB 1.5 TB Price $5,000 $2,895 $3,495 $2,399 $1,799 $899 $1,499 $469 $670 $382 $512 $375 $238 $230 $168 $250 $106 $200 $220 12 13 1998 1999 2000 2001 2002 14 15 16 17 18 2003 2004 2006 19 2008 2010 20 21 22 23 24 25 26