please answer questions on the 2nd page

2. This file shows the approximate file sizes for different kinds of media, along with estimated download times. 3. Look at the partially completed Excel spreadsheet below that should have been downloaded. Media 3 minute song 3 minute video 9-hour audiobook 45-minute TV show 45-minute HDTV show 2-hour movie 2-hour HD movie Download time Download time in seconds with for slower File Size in fast broadband broadband (1 MB 15 Mbit/s) Mbit/sec) 3 3 .51 18 2 1 108 110 120 600 2651 3 181 600 1250 4000 750 1260 900 3 120 6300 18900 3 2-32. 1. Add a column called Speed Advantage and enter the formula that shows how many times faster the download will be if one uses fast broadband (+d2/+c2). 2. Copy the formula to the remaining rows, and then add a row at the bottom called "AVERAGE. 3. On average, how much faster is it to download media files using fast broadband compared to regular broadband? 2-33. 1. Add two more columns called Download Time per MB (Fast Broadband) and Download Time per MB (Regular Broadband). 2. Compute these values by dividing the appropriate download time by the file size in MB, and add the average at the bottom. a. What is the average download time per MB for fast broadband? b. For regular broadband? shows how many times faster the download will be if one uses fast broadband (+d2/+c2). 2. Copy the formula to the remaining rows, and then add a row at the bottom called "AVERAGE". 3. On average, how much faster is it to download media files using fast broadband compared to regular broadband? 2-33. 1. Add two more columns called Download Time per MB (Fast Broadband) and Download Time per MB (Regular Broadband). 2. Compute these values by dividing the appropriate download time by the file size in MB, and add the average at the bottom. a. What is the average download time per MB for fast broadband? b. For regular broadband? 2-34. 1. Download the video file called CSC112_CHO2_Test Video and time how long it takes. a. What is the file's size in MB? If the file size is represented in gigabytes (GB), multiply that number by 1,000 to convert to megabytes (MB). b. Using the average download times you computed, what should be the download time using fast broadband? What would it be for regular broadband? c. How does your download time compare to these estimates? Do you have fast broadband, regular broadband, or something else? Media Downloads Sheet2 Sheet3 Media File Size in MB Download time in seconds with fast broadband (5 Mbit/s) Download time for slower broadband (1 Mbit/sec) 3.5 3 minute song 3 minute video 9-hour audiobook 18 21 110 120 108 600 1390 45-minute TV show 265 318 45-minute HDTV show 600 750 3120 2-hour movie 2-hour HD movie 1250 4000 1260 3900 6300 18900 Media Downloads Sheet2 Sheet3 Length and Approximate 1 Mbits 20-30 seconds About us Dial 56K modem About 10 minutes About how to mi MB 30-40 se 110B About us About how 200 MB About how 15 ml About 45 minutes About 15-2 hou nia2 OTVO 10-1.5GB 2. ve 30458 Pare 10 GOMBA 16 minutes 54-72 300 us About 3 12 Length and type of Approximate Broadband SM 's MOS 20-30 seconds About Dial 56K modem About Us thout me MB 10 wonde 9 hour audiobook HOB About me 200 ME 35 minutes About how minutes 15 HOTY BOMB 10-15 About 45 ? 2 04508 10-60 MB About 15-2 hours About us About us Pod Game About 30-70 seconds About 1-2 Hours Sed Download Downlo Download time is wronds t with broadband Mbit/s) File Sire in MB o time for stomer breathand Mb ) time per Pani Breadband tage for time per MB Regular 180 11262 5.14 1.16666667 5.00 1.0909091 5.454545 To 200 240 1050 500 750 3120 1260 6100 1953 1.005 3.0 0.975 4.77 4000 3900 18900 4,85 270 1.10 for now File Size In MB Download time in seconds Download time for with fast broadband 15 stomer br a nd ( Mbit/s) Speed Advanter for Download Sored Advantage for time per MB (F) (Rear time per lower radhand M 1.125 6 110 600 5.00 1.0909091 S.454545 265 318 1390 750 1130 1360 6300 1250 4000 4.16 5.00 4.85 1995 1.00 SC 0.975 4.72 2 HD movie 3900 18900 4-minute song 4-5 seconds 20-30 seconds About 10 minutes 4 MB 30 MB 5-minute video 30-40 seconds About 3 minutes About 1 hour 10 minutes 9-hour audiobook 110 MB About 10 minutes About 4 hours, 15 minute 200 MB 45-minute TV show 45-minute HDTV 15-20 minutes 3-5 minutes About 7 hours 45 minute 600 MB About 45 minutes-th About 1.5-2 hours hour movie 10-1.5 GB na2 10-15 minutes 18-24 minutes 54-72 minutes3 About 30-70 seconds 2-hour HD movie iPod Game 3,0-4,5 GB 10-60 MB About 4.5-6 hours About 3-6 minutes Media File Size in MB Download time in seconds Download time for with fast broadband (5 slower broadband (1 Mbit/s) Mbit/sec) Download Speed Advantage for Download time per Fast Broadband time per MB MB (Fast) (Regular) 5.56 1.125 6.25 5.14 1.1666667 5.00 1.0909091 5.4545455 3 minute song 25 5-minute video 45 35 120 180 9-hour audiobook 110 600 200 240 1050 438 1.2 45-minute TV show 45-minute HDTV show 2-hour movie 750 1260 3900 1250 4000 3120 6300 18900 4.16 5.00 4.85 5.25 5.2 5.04 4.725 1.25 1.008 0.975 2-hour HD movie Test Video iPod Game SO 50 270 5.40 4.93 1 1.10 5 .41 Download Download Media File Size in MB Download time in seconds Download time for with fast broadband (5 slower broadband (1 Mbit/s) Mbit/sec) Speed Advantage for time per Fast Broadband time per MB MB (Fast) (Regular) 5.43 1.125 6.25 5.14 1.1666667 5.00 1.0909091 5.4545455 3 minute song 3 minute video 3.5 108 6 9-hour audiobook 110 120 600 265 1390 1.2 45-minute TV show 45-minute HDTV show 2-hour movie 750 600 1250 4000 3120 6300 4.37 4.16 5.00 4.85 1.25 1.008 0.975 5.25 5.2 5.04 4.725 2-hour HD movie 3900 18900