ELLLLLLFELLLLE!Given the following data, answer the questions on the additional tabs. To receive credit, all work must be completed by using Excel functions and formulas. I will click on these cells to view your work. There are 103 total points on this assignment. Estimated Annual Sales for U.S. Electronic Shopping and Mail-Order Houses (NAICS 45411) - Total and E-commerce" Sales by Merchandise Line: 1999-2015 [Estimates are shown in millions of dollars and are based on data from the Annual Retail Trade Survey. Estimates have been adjusted using final results of the 2012 Economic Census.] Data Source: www.census.gov 2015 2014 2013 2012 2011 2010 Merchandise Line Total E-commerce Total E-commerce Total E-commerce Total E-commerce Total E-commerce Total E-commerce Total Total Electronic Shopping and Mail-Order Houses [NAICS 45411) . 433,692 294,809 386,065 256,269 350,487 221,587 328,655 195,477 294,697 168,919 263,488 143,000 235,625 7,569 Books and magazines ........ 12,583 11,648 11,879 10,828 11,444 10,249 10,991 9,778 10,160 8,773 8,860 7,428 Clothing and clothing accessories (includes footwear] ..... 58,188 52,128 53,751 DEB'90 46,681 40,198 40,451 33,614 35,137 28,196 31,388 23,480 27,300 Computer hardware .. 17,459 29,527 16,884 26,981 DEE'ST 25,640 14,240 24,948 ELGET 22,420 12,080 20,141 Computer software .. S 9.594 6,491 5ZE'S 5.425 8,093 5.425 6,854 4,493 5.834 3.676 5,432 Drugs, health aids, and beauty aids 21,469 985'86 19,112 41,001 17,456 90,714 14,612 82,424 11,845 75,318 10.952 69,164 Electronics and appliances ... 10,016 26,050 28,158 24,234 27,541 23, 727 26,573 22,580 24,622 20,975 ZEL'IZ 17,861 18.798 Food, beer, and wine .. 9,841 7,579 969'B 6,349 7,783 5,267 7,070 4,934 5,985 3,984 5,267 3,372 4,824 Furniture and home furnishings 32,369 ES8'87 26,599 23,311 22,856 19,588 19,420 15,917 16,900 13,536 14,518 11,150 12,759 Music and videos 11,263 10,325 9,914 8.964 8,225 7,241 6,107 Office equipment and supplies ... 10,613 9,236 9,042 8,579 6.869 8,136 6,432 7,822 6.009 7,730 Sporting Goods ... 13,104 11,681 10,910 9,347 9,914 7,927 8,506 6.356 6,982 5,103 6,437 4,408 6,058 Toys, hobby goods, and games - 12,110 10,682 10,623 8,997 9,125 S 7,801 6,091 6,794 5,260 6,022 4,470 5,384 Other merchandise" 68,378 $2,893 55, 104 41,543 47,981 34,491 44,679 30.045 39.998 25,491 35,221 20,851 568'QE Nonmerchandise receipts" 29,153 26,374 25,500 22,317 21,546 17,721 20,224 16 052 17,532 13,617 15,548 11,222 13,464 Additional Information NA . Not Available 5 . Estimate does not meet publication standards because of high sampling variability (coefficient of variation is greater than 30%%), poor response quality (total quantity response rate is less than 50%), or other concerns about the estimate's quality. Unpublished estimates derived from this table by subtraction are subject to these same limitations and should not be attributed to the U.5. Census Bureau. For a description of publication standards and the total quantity response rate, see http://www.census gowabout/policies/quality/standards/standardf1.html. Footnotes: "E commerce sales are sales of goods and services where the buyer places an order, or the price and terms of the sale are negotiated, over an Internet, mobile device (M-commerce), extranet, Electronic Data Interchange (EDI] network, electronic mail, or other comparable online system. Payment may or may not be made online. Includes other merchandise such as collectibles, souvenirs, auto parts and accessories, hardware, lawn and garden equipment and supplies, and jewelry. Includes nonmerchandise receipts such as auction commissions, customer training, customer support, advertising, and shipping and handling. Revised Data Note: Sales estimates are shown in milions of dollars, consequently industry group estimates may not be add the. Note: Estimates are not adjusted for price changes. Additional information on confidentiality protection, sampling error, nonsampling error, sample design, and definitions can be found at chitp:/www.census.gowretal/arts/how_surveys_are_collected.html>.TOTAL E-COMMERCE YEAR DOLLARS [in millions of Question 8 (1 point): dollars) From Question 1, copy the data and place it to the right. Question 9 (10 points): With a class (category) width of $50,000 (in millions of dollars), finish the frequency table with the remaining classes (categories) and the frequency of each category. Spending Categories Frequency $0 to