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.
•