Reference no: EM131199959

Activity a-Percentages

1. Open the fileState Population 2000-2010, which contains official decennial census population figures for all states in 2000 and 2010.

a. In column D,calculate the absolute change between the 2000and the 2010populations for each state. Now sort the data by column D. Which two states had the largest increase in population? Name the state and the increase (note how the numbers are measured). Did any states decrease in population between 2000 and 2010? If so, which states and by how much?

b. In column E, calculatethe percentagechange in population from 2000 to 2010 for each state. Express the percents with one decimal place. Which two states had the largest percent increase in population? Name the states and their percent increases.

c. Examine the list when sorted by the percent changes. You should notice that Wyoming and Washington had same percent increase in population but very different absolute changes. Explain: How is it possible that Washington's absolute increase is so much larger than Wyoming's while their percent increases are the same? What does it tell you about the original populations of the two states?

d. Using the MapMaking Tool, make a map of the states and the percent change in the population. Copy and paste map here.

e. Describe the geographical trends in population change. Mention any outliers.

2. According to the National Basketball Association, the average salary for a professional basketball player in 1997 was $2,200,000. By 2015, the average salary had increased to $5.235, 000. By what percentage did the average salary increase in this time period?

3. Chicago has the highest sales tax in the country. Stores charge 10.25% of the price. How much is paid in sales tax on a $800 couch?

4. In 2010, 269.3 million residents in the United States were born in the US, while 39.96 million US residents were born outside the country. What percentage of the total US population was foreign born?

5. Poverty: Good News or Bad News? According to Census Bureau figures, in 1959, 22.4% of the US population lived in poverty, while in 2011, 14.8% lived in poverty. The total population of the country in 1959 was 177.8 million people and in 2015, it was 321 million.

a. By how many percentage points did the percent below poverty change from 1959 to 2015?In other words, what is the absolute change in the percentages? Use correct units!

b. What was the percent change in the percentage below poverty from 1959 to 2015?

c. How many people lived below poverty in 1959? How many people lived in poverty in 2015? Did the actual number of people living in poverty increase or decrease between 1959 and 2015?

d. Explain:How is it possible that the percent below poverty decreased but the number below poverty increased?

6. In 2014, the population of China was approximately 1.39 billion, and the population of India was 1.27 billion.

a. China's population is what percent larger than India's population?

b. India's population is what percent smaller than China's population?

7. Obesity in American Kids: A study on obesity in American children appeared in the Journal of the American Medical Association in 2001. According to the study, the percentage of black and Hispanic children who were overweight more than doubled between 1986 and 1998 and the percentage of white children who were overweight increased by 50%. Specifically, in 1986 the percentage of 4-12-year olds who were overweight was 8%, 10%, and 8% for black, Hispanic, and white children, respectively. In 1998, the percentages had risen to 22%, 22%, and 12%, respectively. Among the reasons given for the increases were increased television watching, increased use of computers and video games, and more reliance on fast food.

a. The total number of white 4-12 year olds in 1986 was 19.66 million. By 1998 this number had grown 17 %. How many white 4-12 year olds were there in 1998?

b. Using what you found in part a. and info from the article, how many white children were overweight in 1986? How many white children were overweight in 1998?

c. Using what you found in part b, what was the percent increase in the number of overweightwhite children from 1986 to 1998?

d. Explain: How is it possible that the percent of overweight white children increased 50% but the number of overweight white children increased by more than 50%?

8. Successive Percent Change

Everyone shops, especially before the holidays! It is common for stores to offer items on sale at a certain percentage off. It is becoming increasingly popular for stores to offer items at an additional percentage off the sales price. This is a copy of an ad from Kohl's where many items in the store were 50% off the original price. Senior Citizens received an additional 15% off the sale price.

a. Suppose you (a non senior citizen) purchase an item from the Trim-A-Tree shop for $72.00 (original price). What is the sale price?

b. Senior citizens (age 62 and older) were eligible for a senior discount. Assume someone over age 62 purchased the same item on sale (originally $72.00) and received an additional 15% off the sale price. What price do senior citizens pay for the same item from the Trim-A Tree Shop?

c. How much do senior citizens save in total on this item? (absolute change)

d. What was the senior citizen's total percentage savings? (percentage change) Give one decimal place on the percent.

e. As store manager, you are asked to make a list of sales items including their original price, the sale price (50% off) and price after the senior citizen discount (an additional 15% off). You are trying to attract more senior citizens to your store. Open the file Sample of Savings. In cells B5, B6, B7, and B8 enter appropriate formulas and fill across the row by clicking on the corner of the cell with the formula and dragging sideways. Give one decimal place on the percents. Paste the completed table in your word document.

f. Does the absolute savings depend on the price? Does the overall percentage of savings depend on the price? Explain.

9.

a. Your boss says that the company is struggling and that he needs to cut your salary by 20%. He promises that in 6 months he will raise your new pay by 20%. Does this restore your original salary? Show your calculations.

b. If the salary was decreased by 20%, by what percent would it need to be increased in order to restore your original salary?

10. A politician promises, "If elected, I will cut your taxes by 20% for each of the first three years of my term, for a total of 60%." Evaluate this promise. Show whether or not the politician is being truthful by calculating the overall percent change in taxes in 3 years.

11. Solve for OriginalAt the local Video Station, you pay a total of $15.50 for a DVD, after tax had been added. Assuming a local sales tax of 7.5%, what is the retail price of the DVD before tax?

12. In 1994, Zaire's per capita GNP was $126, which is 70% lower than it was in 1958. What was Zaire's per capita GNP in 1958?

Reflect: Which of the types of the percentage problems was the most challenging for you? Was the challenge recognizing the type of problem? Or was it remembering the formula? Or was it knowing how to do the calculation? What can you do to improve on this type of problem?

Attachment:- StatePopulations.rar