1.In this question, you will work on a correlation problem. You will be using Excel to find the correlation ( r ) value.You will also be doing some research to identify values to see if there is a correlation between them.There will be three parts to this question (i.e., Part A, Part B, and Part C).

Part A) In this section, you will be doing some research and identify two data groups of 10.

Date Site 1:http://www2.stetson.edu/~jrasp/data.htm

or

Date Site 2:https://www.forbes.com/sites/bernardmarr/2016/02/12/big-data-35-brilliant-and-free-data-sources-for-2016/#52266d71b54d

Now, find and select the two data groups that you want to investigate further to see if there is a correlation between them.Use 10 data items for Data Group 1 and 10 data items for Data Group 2.Please use the table format below and insert your data in the below table:

Data Group 1

Data Group 2

Part B) Now, use the correlation function in Data Analysis within Excel and copy the output below.

Part C)List your correlation value that you found in Part B.List it below and answer these questions.

i)What is the correlation value that you found?

ii)Is this a strong or weak correlation?

iii)If you had a strong correlation, does this automatically mean that you can draw a conclusion that Data Group 1 causes Data Group 2.