110k views
3 votes
The excel file science and engineering jobs 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.

User Lee Oades
by
8.1k points

1 Answer

1 vote

Final answer:

To calculate the projected increase in jobs from 2000 to 2010, subtract the year 2000 job figures from the 2010 projections and calculate the percentage increase using the provided formula. Employment trends indicate higher growth rates for jobs requiring higher levels of education.

Step-by-step explanation:

To assess the projected increase in science and engineering jobs from a 2000 baseline to projections made for 2010, one would subtract the number of jobs in each occupational category in the year 2000 from the projected figures for 2010. To then calculate the percentage increase for each category, the formula (projected increase / number of jobs in 2000) × 100 should be used. It's important to note that growth rates and employment trends can vary widely by educational level, as higher levels of education are associated with higher growth rates in employment.

Data from the Employment Projections Program of the U.S. Bureau of Labor Statistics indicates a clear trend: jobs requiring more education anticipate greater growth. For example, jobs that require a professional degree or a master's degree are expected to grow by 20% and 22% respectively, while those requiring a high school diploma or less are expected to see much smaller increases in job growth.

User Tyese
by
8.2k points