Grading Guide for Week 5_Signature Assignment Presentation Quantitative Reasoning (60%) The speaker notes give a clear explanation of the following: Points Earned: x/9 Comments: Topic and Scenario Selection • Why the student chose their particular topic and scenario Visuals/Calculations • How the scatter plot and the other two visuals helped the student develop a conclusion • Which information from the initial data was not used for the analysis and why the unused information was not needed Final Analysis • How the topic relates to a real-world scenario • What the significance of predicting future results • How confident the student is that their conclusion is sound, and what could increase the student’s confidence in their conclusion • What the student learned from the project Presentation & Mechanics (40%) Length • The presentation is 5-7 slides long Clarity • The slides are easy to read and understand Grammar, Spelling, and Structure • The slides have proper grammar and spelling • The speaker notes have proper grammar, spelling, and sentence structure Total Points Earned: x/15 Points Earned: x/6 Comments: Comments: Quantitative Reasoning II Project_Final Presentation The purpose of this assignment is to use skills you have learned throughout all five weeks of the course. You will be able to apply what they have learned to solve a real world problem that you could use to in your future career. Create a 5- to 6-slide presentation that must include: • • • One slide on the Introduction o Introduce your topic and question that you chose in Week 2. o Why did it interest you? How does it relate to life? o What should the audience learn from your presentation? Three to four slides of your visuals o Show your tables, scatter plot, other 2 visuals, calculations, and any other evidence to support your conclusion(s) that you created in Week 3. o Explain what information in the data tables is not needed for your analysis. o Discuss what you can conclude from the visuals. How do these visuals support your conclusion? One slide for a conclusion o Restate your topic and question and give your answer to the scenario. o How confident are you that your conclusion is sound? o What work would need to be done to increase your confidence? o Discuss what you learned from this project. Include detailed speaker notes for each slide. Quantitative Reasoning II Project_ Calculations and Visuals In this stage you will do statistical reasoning and mathematical modeling to show central tendency and two variable analyses, including regression with equation and R squared value from the data set you chose in Week 2. The purpose of this assignment is to have you practice creating visuals using your own data. This shows you how you will be working with data in your own careers. The purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2. Use statistical reasoning and mathematical modeling to show central tendency and two-variable analyses, including regression with equation and R2 value. Watch How to Create Trendlines and Scatterplots in Excel®. Watch Lynda.com® Video: Adding Trendlines to Charts. Watch Lynda.com® Videos: Creating Pie Charts, Histograms, & Box-and-Whisker Plots. Create at least three visuals. • • • One visual must be a scatter plot with trend line, equation, R2 value, and prediction value. Two of the remaining required visuals can be of the following format: histogram, box and whisker plot, or pie chart. Please note that the data set that you chose in Week 2 includes data that will not be needed to create your visuals. Quantitative reasoning requires critical thinking to decide what data is necessary. Create a Microsoft® Word document that includes your three visuals and the following items: • • • • • • Title of your project and the scenario you are addressing Brief description of each visual (15 to 50 words) Consider including the following for each visual when applicable: o A chart title that is appropriate for the data o A descriptive x-axis label o A descriptive y-axis label For your xy scatter plot, make at least one prediction using the trend line equation for a date in the future. How confident are you in this prediction? State your prediction and provide justification (50 to 150 words). If you created a box and whisker plot, describe the central tendency of the values. What does this tell you about the data and about your project? Calculate the mean of the sample data. Your assignment will be graded using the Week 3 Quantitative Reasoning II Project Grading Guide. Health Services and Nursing Scenario Topic 1 Scenario 1 Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Predicting Expected Medicare Payers Review data of the expected payers that used Medicare between 2003 and 2014. Predict the percentage of expected payers that will use Medicare in 2018. County Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Humbolt Zip Code 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 Medicare payers 35612 37412 39841 40123 43122 44125 51229 59748 57008 56727 57985 63123 Security and Criminal Justice Scenario Predicting Total U.S. correctional population Review the data on persons supervised by U.S. adult correctional systems by correctional status. Scenario 2 Predict the number of the United States population that will be supervised by U.S. adult correctional system in 2018. Topic 2 Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Total U.S. correctional population 6,467,800 6,584,900 6,730,900 6,886,800 6,997,000 7,055,600 7,199,700 7,339,600 7,313,600 7,235,200 7,086,500 6,989,200 6,945,100 6,903,200 6,851,000 Probation 3,839,400 3,934,500 3,995,000 4,073,800 4,140,400 4,162,300 4,236,800 4,293,000 4,270,100 4,196,200 4,053,600 3,969,400 3,940,800 3,910,600 3,864,100 Parole 725,500 731,100 753,100 773,500 775,900 784,400 798,200 826,100 828,200 824,100 840,700 854,600 857,800 855,200 856,900 nario ms by correctional status. sed by U.S. adult Humanities and Sciences Scenario Topic 3 Scenario 3 Year Yearly Tuition 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 $29,450 $24,444 $20,288 $17,245 $16,412 $15,984 $8,618 $7,153 $5,937 $14,658 $13,549 $12,435 Predicted College Tuition and Fees Review college data of the yearly tuition and fees. Predict the cost of yearly tuition and fees in 2018. Books & Supplies $1,250 $1,038 $861 $732 $625 $600 $1,200 $996 $827 $703 $699 $612 Living Costs $12,400 $10,292 $8,542 $7,261 $6,532 $5,899 $15,682 $13,016 $10,803 $9,183 $5,771 $5,256 Yearly Tuition and Fees $44,190 $36,679 $30,442 $25,876 $24,112 $22,984 $25,770 $21,389 $17,753 $24,702 $20,142 $18,415 nario y tuition and fees in 2018. Social Sciences Scenario Predicting Teen Communication Preferences Review the data on communication preferences with teens. Predict how many high school teens will Scenario 4 prefer to use face-to-face communication in 2018. Topic 4 Communication Preference Age School Level 2000 2001 2002 Face to Face Face to Face Face to Face Teen Teen Teen HS HS HS 2003 Face to Face Teen HS 76 2004 Face to Face Teen HS 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Teen Teen Teen Teen Teen Teen Teen Teen Teen Teen Teen HS HS HS HS HS HS HS HS HS HS HS 55 49 50 43 42 36 23 30 15 13 8 5 Logarithmic Regression 120 Number of Teens 87 98 Year 86 120 y = -12105ln(x) + 92102 R² = 0.9473 Number of Teens 100 80 60 40 20 0 1998 -20 2000 2002 2004 2006 2008 Year 2010 2012 2014 2016 ario edict how many high school teens will Business Scenario Topic 5 Scenario 5 Year 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Predicting Tires Purchased Review the yearly data Tires Wheels Lugnuts Purchased Purchased Purchased 20,478 20,018 28,592 15,478 18,274 9,967 11,148 13,086 11,148 17,916 14,659 14,659 13,390 9,697 8,080 16,146 25,698 18,425 18,456 32,237 15,132 12,570 21,404 9,173 16,243 14,993 7,184 15,628 18,346 9,852 18,063 14,193 6,999 7,122 3,052 3,713 6,649 3,740 3,586 9,217 4,748 3,994 6,235 3,662 2,733 16,542 12,426 8,145 12,459 8,743 11,405 9,322 5,243 6,033 8,704 4,687 4,491 9,904 4,661 5,028 Business Scenario Topic 5 Scenario 5 Year 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Predicting Tires Purchased Review the yearly data Tires Wheels Lugnuts Purchased Purchased Purchased 20,478 20,018 28,592 15,478 18,274 9,967 11,148 13,086 11,148 17,916 14,659 14,659 13,390 9,697 8,080 16,146 25,698 18,425 18,456 32,237 15,132 12,570 21,404 9,173 16,243 14,993 7,184 15,628 18,346 9,852 18,063 14,193 6,999 7,122 3,052 3,713 6,649 3,740 3,586 9,217 4,748 3,994 6,235 3,662 2,733 16,542 12,426 8,145 12,459 8,743 11,405 9,322 5,243 6,033 8,704 4,687 4,491 9,904 4,661 5,028 Education Scenario Topic 6 Scenario 6 Predicting SAT Test Scores Review the data on the average SAT scores of college-bound seniors between 2002 and 2015. Pre seniors in 2018. Average SAT Mathematics of college-bound seniors Year 2002 2003 2004 All students Average White Black Mexican American Puerto Rican Other Hispanic Asian/Pacific Islander American Indian/Alaska Native 2005 2006 2007 2008 2009 540 530 426 460 566 467 529 531 426 458 451 465 530 533 427 457 451 464 522 534 426 457 453 464 531 531 427 458 452 465 523 536 431 463 457 469 525 536 429 465 456 463 530 534 429 466 454 463 565 566 569 575 577 580 578 578 481 479 483 482 488 493 494 494 ario een 2002 and 2015. Predict the average SAT scores of college-bound 2010 2011 2012 2013 2014 2015 525 537 426 463 453 461 520 536 426 463 450 461 519 536 428 467 452 462 516 535 427 466 452 462 518 536 428 465 452 461 514 534 429 464 453 461 581 587 591 595 595 597 491 493 492 488 489 486 1 Quantitative Reasoning II Project: Selecting a Topic Tracey Flowers Math / 216 June 5, 2018 Jeorge Hurtarte 2 Quantitative Reasoning II Project: Selecting a Topic I chose the Business Scenario, Predicting Tires Purchased. My major is Business Management; in 2016, I first received a Human Resources Certificate from the University of Phoenix as well. This math course, including Math 215 has allowed me to look at math in the real world. I can think about situations as they pertain to my every day life. Both professions require forecasting in some way. In Human Resources, forecasting is continuous to ensure that you are always well staffed. My current position is directly related to my Business Management degree. I work in the Executive Offices of a Fortune 500 company as an Analyst. In this role, we take on a lot of roles that effect the company. Forecasting is required for staff and products. The amount of product that we sell is probably on a greater scale than the tires; however, I think that it will fit my needs. My goal is to become more efficient with overall reporting.
Purchase answer to see full attachment