data analytics

Now, read the following and write a 2 - 3 paragraph report on the following: (Don't forget to provide visuals!)

The Gallup-Healthways Well-Being Index provides an assessment measure of health and well-being of U.S. residents.  The overall composite score is calculated on a scale of 0 to 100 , where 100 represents fully realized well-being.  In 2017, the overall well-being of American residents was reported as 61.5 - a decline from 62.1 in 2016.  The accompanying data shows the overall well-being score for a random sample of 35 residents from South Dakota - the state with the highest level of well-being.  In a report, use the sample information to:

• Determine whether the well-being score of South Dakotans is more than the national average of 61.5 at the 5% significance level.
• Comment on the well-being of South Dakotans given your results. 
• Click HERE to see the Excel File and go to the Well-Being work sheet!