Hi.

These are the questions. The datasheet is extensive so I couldn't paste it here as an image which is the only attachment allowed here. So, I need help with how to use/where do I go in Excel functions to solve hypotheses testing and make a Regression Model. Could you please provide me with a step by step Excel tutorial for:

• Hypothesis Tests to determine if the following lead to more Obesity (Column BM). Use alpha of 5%. For each, break the dataset into two sets (HIGH/LOW) at the mean.

a.Fast food restaurants per 1000 people (Column W)

b.Smoking (%smokers) (Column G)

• and a Regression Model for Obesity rate which should explain a lot of the variability but only identify the most important factors. For Independent Variables consider using those above and consider adding any that begin with a "%". Do not use Diabetes rate.