Excel and Correlation and Regression

A‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌SSIGNMENT INSTRUCTIONS Following the instructions in the video, enter your data set on an Excel worksheet. Be sure and use the labels provided in the data set. Then: Perform a correlation and regression on the data in Excel. Create a scatterplot with a regression line for your data using Excel In a separate Word document, discuss your findings (3-4 paragraphs) as if you were‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌ explaining to an individual the impact of soda consumption on weight. Is there a significant relationship between soda consumption and weight? Explain how you know this. Using your regression, predict how a person’s soda consumption will impact their weight (how much will drinking additional sodas increase an individual’s weight based upon your findings for this specific data set)‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌.