About The Dataset
Sheet 1 is the National Obesity Percentages by State. Explanation of Field Attributes:Obesity - The percent of the state population that is considered obese from the 2015 CDC BRFSS Survey.
Sheet 2 is average income for each state from 2021 and 2022.
Sheet 2 is average income for each state from 2021 and 2022.
Tasks
Do a VLookup to line up the data on to one sheet.
Use the PercentRank.Inc function to get a percentile for the Obesity dataset and the Average Income dataset.
Is it true that lower earning states have higher obesity rates. Support your answer with the data.
Calculate the correlation coefficient between the two data sets.
Use the PercentRank.Inc function to get a percentile for the Obesity dataset and the Average Income dataset.
Is it true that lower earning states have higher obesity rates. Support your answer with the data.
Calculate the correlation coefficient between the two data sets.