Activity 1 A Homework Aw Jan25th

docx

School

Roosevelt University *

*We aren’t endorsed by this school

Course

110

Subject

Mathematics

Date

Feb 20, 2024

Type

docx

Pages

5

Uploaded by DeaconFog9163

Report
Directions for all Activities: Type your answers in bold font in this document. Open excel files posted on Blackboard as needed. When finished, save this document and any excel files to your computer. You must save as a Word document and Excel file. To submit, click on the name of the Assignment (i.e. Activity 1) on the Blackboard page. In the Assignment Submission section, click Browse My Computer next to Attach Files. Open document from wherever you saved it. To also submit your excel file, click Browse My Computer again and attach. When finished, click Submit. Confirm that the submission has completed before closing the page. Math 110 Quantitative Literacy Activity 1-Absolute and Relative Quantities 1. For each of the following statements, identify the quantity in bold as an absolute quantity or a relative quantity. If it is a relative quantity, indicate which type (percent, fraction, rate, or ratio) a. There are 4127 students enrolled at Roosevelt University. ABSOLUTE QUANTITY b. Three fifths of Roosevelt students are full time. RELATIVE QUANTITY c. The total number of credit hours taken was 49,639 . ABSOLUTE QUANTITY d. The ratio of students to faculty is 10 to 1 RELATIVE QUANTITY e. The average wind speed in Chicago is 10.3 miles per hour . RELATIVE QUANTITY f. Roosevelt University, which was founded in 1945, is 78 years old. ABSOLUTE QUANTITY g. In 2021, 3.9% of Roosevelt students were international students. RELATIVE QUANTITY h. The number of students in the Heller College of Business is 1.8 times as large as the number in the Chicago College of Performing Arts. RELATIVE QUANTITY 2. Each year, the federal government sets a household income level threshold, below which a household is considered living in poverty and is eligible for assistance. This threshold is called the poverty level or poverty line . In 2023, the poverty level for a family of four was approximately $30,000. a. Assume that a family of four living at the poverty level listed above includes only one adult who is working full time (40 hours a week, 50 weeks a year ). Calculate the person's pay rate in dollars per hour ? Person’s pay rate per hour = Total Salary / weeks 30,000/2,000 (40x50) = 15.00/hr.
b. PREDICT Before examining the data in the file , briefly think about and answer the following questions. Make an educated guess . You will be answering these three questions with official Census Bureau data later in the activity. i. Approximately what percentage of the entire US population lives below the poverty line? According to 2019 poverty rate, approximately 10.5% US population lives below the poverty line ii. Which states do you think have the highest number of people living in poverty? Which states do you think have the lowest number of people living in poverty? I think the states with the highest poverty will be California, Texas, Florida, and Illinois. The states with the lowest poverty will be Alaska, South Carolina and Washington. iii. Which states do you think have the highest percentage of people living in poverty? Which states do you think have the lowest percentage of people living in poverty? I think California, Texas, and Florida has the highest percentage of people living in poverty. I think Vermont, Wyoming, and Alaska has the lowest percentage living in poverty. c . Open the file State Poverty 2019 . This file contains Census Bureau estimates for the number of persons below the poverty level and overall populations for the 50 states and DC in 2019. Sort the data to determine which states have the most people below the poverty line. For the three highest states , list the state names and their number of people living below poverty . Pay attention to how the numbers are measured. California 4,662, Texas 3943, and Florida 2,728 d. Explain why it would be misleading to compare states by only the number of people below poverty and to conclude that those with the highest number are the most affected by poverty. It does not account for differences in cost of living in different parts of the country . Also, because those with higher numbers are more likely to have a larger total population. Percentage is more accurate depiction of the number of persons affected. e. In column D, calculate the percentage of the population in each state that is below the poverty level. (Enter the correct formula using the appropriate cell references at the top of the column, then fill the column by double clicking on the bottom right corner of the cell with answer). Express your values in percentage form rounded to the nearest tenth (one decimal place). Now sort the data by percentage. Which three states had the highest percentage of persons below the poverty level and which three states had the lowest percentage ? List the names and percent below the poverty line for these states.
Mississippi, Louisiana, and New Mexico had the highest percentage of persons below the poverty level. New Hampshire, Utah, and Minnesota had the lowest percentage. f. REFLECT Compare the results of the answers to 2c and 2 e to your guesses in 2bii and 2biii . How well did you do? Were you surprised at all? Write a short response to this. I did not guess correct at all. In my mind Texas, Florida, and California has the largest population so I thought they would have the highest percentage of poverty. For the lowest percentages of persons below poverty level I honesty did not know. g. Using the map making site (link Blackboard or at https://cshcollege.is.depaul.edu/maptool/), make a map of the states and their percents. To copy and paste a map, right click over the bottom map and choose Copy Image, then click here and Paste. h. Examine the map. Write a paragraph in which you describe any geographic trends of poverty in the US. Do there seem to be any geographic similarities in the states with similar percents below poverty? In what areas of the country (north, east, south or west) are the percents generally high? In what areas are the percents low? Mention any outliers (states that don’t fit the trends you mentioned).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
The states with the highest percentages of people below poverty are all located in the South of the United States. Those that are 14 to 17 percent is located to the West. Those that are 10 to 14 percent are located to the North Ease and West of the United States. Those that are 7 to 10 percent are located mostly North East of the United States. i. Return to the data. To calculate the percentage of the entire country that is below the poverty level, what information would you need? I would need to know the Total Population Below Poverty and What the Total Population is. j. To add all the numbers in a column, use the AutoSum tool. Then use those totals to calculate the percent of the entire country that is below poverty . What is the percentage of the country's population that lives below the poverty level? Reflect and compare this result to your prediction in question 2bi . Part/Total (1000) Total below poverty (1000) Total Population Total below poverty 40521000/ Total Pop 328240000= 0.1234493053863027 X 100 = 12.34493053863027= Approximately 12.34% of the country’s population lives below poverty level. 3 . Open the file Sports Injuries 2015 , which contains data on the number of participants in some of the most common sports in the US and the number of injuries occurring in that sport that required a trip to the emergency room. a. Sort the data according to the number of injuries . Of all the sports listed, which has the highest number of injuries , and which has the lowest number of injuries ? Basketball has the highest number of injuries. Billiards/Pool had the lowest number of injuries. b. Can you conclude that a sport with a high number of injuries would also have a high risk of a participant getting injured ? Why or why not? No, we need to account for the number of participants who play one sport versus other sports, age, as well as the duration and frequency of play. c. In column D, calculate the injury rate in number of injuries per 10,000 participants . Sort the data by column D. Of all the sports, which is the most dangerous and which is the least dangerous sport according to injury rate ? Name the sport and the injury rate . Explain the meaning of the injury rate.
The most dangerous sports are Football 510.69, Skateboarding 221.26, Basketball 198.70, Soccer 161.37, and Bicycle riding 135.56. The Least dangerous sport is Billiards /Pool 1.54, Bowling 5.02 and Archery 5.39. d. According to a ratio of the rates, football is how many times more dangerous than skateboarding? Take football / skateboarding 0.0510693 / 0.0221260608=2.308106285236277 football is about 2.3 times more dangerous than skateboarding e. Let’s look at a specific sport and how it changes position when the data is sorted by absolute (number of injuries) versus relative (injury rate) . Look at swimming—what position from the top is swimming when the list is sorted largest to smallest by number of injuries? And what position from the top is swimming when the list is sorted largest to smallest by injury rate? What must be true about the number of participants in swimming if it has a large absolute quantity, but not a large relative quantity—is that total number of participants large or small? Swimming is 5th from the top if sorted by number of Injuries Largest to Smallest. Swimming would be 13 th from the top if I sort by Injury rate Largest to Smallest. In swimming total number of participants ranked 5th, that is large, however the rate of injury is smaller, ranked at 15th, so we can say although a lot of people do this sport, not as many receive injuries. REFLECT: Name at least one thing you learned about poverty in the US from examining this data. Name at least one thing you learned about sports injuries from examining this data. I’ve learned that you can’t equate states by only the number of people living below poverty and can’t conclude that those with the highest number are the most affected by poverty. This data does not account for differences in cost of living in different parts of the country. From sports Injuries I learned that you do not need to have to have a high number of participants to have a high number of injuries and vice versa.