Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Excel Application:
Excel Application: Analyzing Growth in Computer Storage Capacities
Use the historical data of hard drive capacities and prices shown in Figure 3-26 to create an Excel spreadsheet that includes formulas to calculate a common measure of disk size (GB) and the cost per GB for each year. You can also download the Excel file that contains this data, named Ch03Ex01. Recall 1 gigabyte = 1024 megabytes; 1 terabyte = 1024 gigabytes. Create two line charts to present trends in the cost of data storage, using the data for years 1980–1999 for one chart and the data for years 2000–2010 for the second chart. Write a brief summary of the trends you found. What factors have contributed to these trends? What are the implications of these trends?
