The Excel file shows the number of jobs in thousands in the year 2000 and projections...

   

Transcribed Image Text:

The Excel file shows the number of jobs in thousands in the year 2000 and projections made for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and the percentage increase for each occupational category. In Cell E6, enter the formula to calculate the projected increase in the number of Mathematical/computer scientists from 2000 to 2010. Copy the formula here: Enter the result of the formula to compute the percentage increase for the number of Mathematical/computer scientists. The answer should be to 5 digits of precision. Example: .00000: 1 Science and Engineering Jobs 3 Total science and engineering jobs in thousands: 2000 and projected 2010 Occupation 6 Scientists 7 Life scientists 8 Mathematical/computer scientists 9 Computer specialists 10 Mathematical scientists 11 Physical scientists 12 Social scientists 13 Engineers 14 All occupations PROJECTED INCREASE 2000 3,241 2010 Nominal Percentage 5,301 184 218 2,408 4,308 2,318 4,213 89 95 239 283 410 492 1,465 1,603 145,571 167,754 The Excel file shows the number of jobs in thousands in the year 2000 and projections made for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and the percentage increase for each occupational category. In Cell E6, enter the formula to calculate the projected increase in the number of Mathematical/computer scientists from 2000 to 2010. Copy the formula here: Enter the result of the formula to compute the percentage increase for the number of Mathematical/computer scientists. The answer should be to 5 digits of precision. Example: .00000: 1 Science and Engineering Jobs 3 Total science and engineering jobs in thousands: 2000 and projected 2010 Occupation 6 Scientists 7 Life scientists 8 Mathematical/computer scientists 9 Computer specialists 10 Mathematical scientists 11 Physical scientists 12 Social scientists 13 Engineers 14 All occupations PROJECTED INCREASE 2000 3,241 2010 Nominal Percentage 5,301 184 218 2,408 4,308 2,318 4,213 89 95 239 283 410 492 1,465 1,603 145,571 167,754

Answer rating: 100% (QA)

The data in the Excel file is not directly accessible however based on the description provided I can instruct you on how to construct the formulas fo... View the full answer