Complete and submit Assignment 7 – Linear Regression Working File. Provided is

Complete and submit Assignment 7 – Linear Regression Working File.
Provided is the Linear Regression Working File. Within, you will find four different tabs of data. You will be doing a couple of Linear Regression Analyses on these tabs, and answering questions based on your findings. Here are the steps to do so –
You will want to run the Linear Regression check against each data grouping. YOU WILL NEED THE ANALYTICS TOOLPAK ADD ON TO USE THIS. Follow the instructions within the lecture to run your initial output for each of the data files.
Once you have the Linear Regression Analysis for each tab, answer the following questions –
What is the overall relationship between the two variables in each tab? Is there a positive or negative relationship?
Based on the R squared for each run, do we have a strong linear relationship for each grouping? How do you know?