Topic of assignment should be in relation to healthcare and rising cost.
Please complete assignment as posted in the outline below.
Assignment 1:
The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools technology and skills of MTH/219. In the first week you must develop a question that can be answered with numerical data and that spans over at least ten years. For example How has the population of the world changed over the past 50 years and when will the population be unsustainable?
In a MicrosoftWord document write the topic/question you are addressing where you plan to find your data even if it is one of the below sources and why you chose this topic. Your paper should be 30 to 45 words long. You can either choose a topic from theStudent Topics and Questions Listor can create your own. If you chose to create your own you must get instructor approval.
Here is a list of possible data sources to find your data:
You may choose to find data elsewhere but you must get it approved by your instructor. It is very important the data you collect meet the following requirements:
Assignment 2:
The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools technology and skills of MTH/219. In Week 2 you will work with the data you collected to analyze the data to draw conclusions.
Reviewthe instructional video on how to use regression in MicrosoftExcel.
Inputyour data into MicrosoftExcel(data and years).
Createa scatterplot.
Inserta linear trendline. Make sure to show the equation and the R-square value. Also make sure you label each axis and give a title to your graph. If you need help creating your visual watchHow to create scatterplot with trendline in Excel.
In the same MicrosoftExcelworksheetanswerthe following questions. Each question should be 90 to 175 words.
Saveanduploadyour Excelfile including the graphic and your answer to each question.