# Chapter+2+Homework - Problem 1 Total science and...

• Homework Help
• 13
• 88% (109) 96 out of 109 people found this document helpful

This preview shows page 1 - 3 out of 13 pages.

Problem 1 Total science and engineering jobs in thousands: 2000 and projected 2010 PROJECTED INCREASE Occupation 2000 2010 Nominal Percentage Scientists 3,241 5,301 8.09011278 61.14% Life scientists 184 218 5.2833626 84.40% Mathematical/computer scientists 2,408 4,308 7.79400895 55.90% Computer specialists 2,318 4,213 7.7560219 55.02% Mathematical scientists 89 95 4.60808233 93.68% Physical scientists 239 283 5.53405279 84.45% Social scientists 410 492 6.05555625 83.33% Engineers 1,465 1,603 7.30689582 91.39% All occupations 145,571 167,754 11.8888474 86.78% PROBLEM: The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage increase for each occupational category. (Evans 49)
Problem 2 using SUM using SUMIF ID Item Description Unit Price Week Ending STORE NO TOTAL SALES REVENUE TOTAL SALES REVENUE 1 1 South 2005 24" Monitor \$229.00 28 October 1 2 1 South 2005 24" Monitor \$229.00 30 November 2 3 1 South 2005 24" Monitor \$229.00 9 December 3 4 1 South 3006 Wireless Keyboard \$19.95 30 October 4 5 1 South 3006 Wireless Keyboard \$19.95 35 November 5 6 1 South 3006 Wireless Keyboard \$19.95 39 December 6 7 1 South 6050 PC Mouse \$8.95 28 October 7 8 1 South 6050 PC Mouse \$8.95 3 November 8 9 1 South 6050 PC Mouse \$8.95 38 December 10 1 South 8500 Laptop \$849.95 25 October 11 1 South 8500 Laptop \$849.95 27 November using SUM using SUMIF 12 1 South 8500 Laptop \$849.95 33 December SALES REGION TOTAL SALES REVENUE TOTAL SALES REVENUE 13 2 South 2005 24" Monitor \$229.00 8 October South 14 2 South 2005 24" Monitor \$229.00 8 November North 15 2 South 2005 24" Monitor \$229.00 10 December East 16 2 South 3006 Wireless Keyboard \$19.95 8 October 17 2 South 3006 Wireless Keyboard \$19.95 8 November 18 2 South 3006 Wireless Keyboard \$19.95 8 December 19 2 South 6050 PC Mouse \$8.95 9 October Problem: 20 2 South 6050 PC Mouse \$8.95 9 November 21 2 South 6050 PC Mouse \$8.95 8 December 22 2 South 8500 Laptop \$849.95 18 October 23 2 South 8500 Laptop \$849.95 18 November 24 2 South 8500 Laptop \$849.95 20 December 25 3 South 2005 24" Monitor \$229.00 38 October 26 3 South 2005 24" Monitor \$229.00 30 November 27 3 South 2005 24" Monitor \$229.00 3 December 28 3 South 3006 Wireless Keyboard \$19.95 30 October 29 3 South 3006 Wireless Keyboard \$19.95 32 November 30 3 South 3006 Wireless Keyboard \$19.95 33 December 31 3 South 6050 PC Mouse \$8.95 25 October 32 3 South 6050 PC Mouse \$8.95 5 November 33 3 South 6050 PC Mouse \$8.95 26 December 34 3 South 8500 Laptop \$849.95 28 October 35 3 South 8500 Laptop \$849.95 27 November 36 3 South 8500 Laptop \$849.95 29 December 37 4 North 2005 24" Monitor \$229.00 18 October 38 4 North 2005 24" Monitor \$229.00 20 November 39 4 North 2005 24" Monitor \$229.00 4 December 40 4 North 3006 Wireless Keyboard \$19.95 12 October 41 4 North 3006 Wireless Keyboard \$19.95 24 November 42 4 North 3006 Wireless Keyboard \$19.95 36 December 43 4 North 6050 PC Mouse \$8.95 29 October 44 4 North 6050 PC Mouse \$8.95 11 November 45 4 North 6050 PC Mouse \$8.95 38 December 46 4 North 8500 Laptop \$849.95 21 October 47 4 North 8500 Laptop \$849.95 24 November 48 4 North 8500 Laptop \$849.95 30 December 49 5 North 2005 24" Monitor \$229.00 27 October 50 5 North 2005 24" Monitor \$229.00 25 November 51 5 North 2005 24" Monitor \$229.00 23 December 52 5 North 3006 Wireless Keyboard \$19.95 80 October 53 5 North 3006 Wireless Keyboard \$19.95 82 November 54 5 North 3006 Wireless Keyboard \$19.95 75 December Store No.