MTH216 assignment – Need by 11 am

  

ASSIGNMENT #1

• 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. This video can be accessed under Student      Materials on the right side of the screen.
• Watch      Lynda.com® Videos:  Creating Pie Charts, Histograms, &      Box-and-Whisker Plots. This video  can be accessed under Student      Materials on the right side of the  screen.
• Create at      least three visuals.
• One      visual must be a scatterplot with trend line, equation and R2 value.
• Two of      the remaining required visuals can be a histogram, box and whisker plot,      or pie chart.
• Please      note that the data sets include data that will not be needed  to      create your visuals. Quantitative reasoning requires critical       thinking to decide what data is necessary.  
• Create a      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:  
• A chart      title that is appropriate for the data
• A      descriptive x-axis label
• A      descriptive y-axis label
• For      your xy scatterplot, make at least one  prediction using the      trendline equation for some date into 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. 

ASSIGNMENT #2 POWERPOINT PRESENTATION

• The      purpose of this assignment is to use skills you have learned throughout      all five weeks of the course. You will apply what you have learned to      solve a real-world scenario that you could encounter in your future      career.
• Create a      5- to 7-slide Microsoft® PowerPoint® presentation including:
• Introduction      (approximately 1 minute and 1 slide)
• Which      topic and scenario did you choose?
• Why did      it interest you?
• Visuals/Evidence      (approximately 4 to 5 minutes and 3-4 slides)
• Show      your data table, scatterplot, other two visuals, calculations, and any      other evidence to support your conclusion.
• Explain      what information in the data tables is not needed for your analysis.      Explain why the unused information is not needed.
• Discuss      why you selected each visual and what you can conclude from the visuals.
• Conclusion      (approximately 1 minute and 1-2 slides)
• Restate      your topic and scenario and give your conclusion.
• Discuss      how your topic relates to a real-world scenario.
• Explain      how confident you are that your conclusion is sound.
• Explain      what work would need to be done to increase your confidence in your      conclusion.
• Discuss      what you learned from this project.
• Include detailed speaker notes for each slide.

Sheet1

Social Sciences Scenario Topic 4 Predicting

Teen Communication Preference

s Scenario 4 Review the data on communication preferences with teens. Predict how many high-school teens will prefer to use face-to-face communication in 201

8

.

Year

Communication Preference

Age School Level

Number of Teens

2000 Face to Face

Teen

HS 87 2001

Face to Face Teen HS

98 2002

Face to Face Teen HS

86 2003

Face to Face Teen HS

76 2004

Face to Face Teen HS

5

5 2005

Face to Face Teen HS

49 2006

Face to Face Teen HS

50 2007

Face to Face Teen HS

43 2008

Face to Face Teen HS

42 2009

Face to Face Teen HS

36 2010

Face to Face Teen HS

23 2011

Face to Face Teen HS

30 2012

Face to Face Teen HS

15 20

13

Face to Face Teen HS 13
2014

Face to Face Teen HS 8
2015

Face to Face Teen HS 5

Logarithmic Regression

Number of Teens

2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 87 98 86 76 55 49 50 43 42 36 23 30 15 13 8 5

Year

Number of Teens