2 (b) Correlation and regression For this part of your portfolio, you are required to find some data from Statista.com (email address and password required off campus), a leading provider of market and consumer data. You should find some data broadly related to your degree title. (If you do not have access to Statista, your lecturer will advise you on where to find some data). For the correlation and regression analysis, you will need TWO columns of data so that you can have X and Y variables. You made need to download two different files and then combine them in Excel. You need two columns of the same length, with at least 10 pairs of (X, Y) data. Write down the titles of the data file(s) you have chosen to use: Write down which variable you have chosen as X and which as Y, and give a reason for your choice. Use Excel to create a fully-formatted scatter chart of your data, showing the linear regression line, R-squared value, and the equation of the regression line. What is the value of the correlation coefficient for your chosen data? What does it mean? Using the values in the regression equation, explain what your analysis shows. Explain the concepts of interpolation, extrapolation, validity and reliability when using a regression model for forecasting. INTERPOLATION: EXTRAPOLATION: VALIDITY: RELIABILITY: PLEASE I NEED THIS BY TOMORROW MAX. IT IS REALLY IMPORTANT THAT YOU FOLLOW EACH STEP BECAUSE THIS GREATLY CONTRIBUTES TO MY MARKS. THANK YOU AND I WILL PUT AN EXCELLENT RATING IF YOU DO IT PERFECTLY AND ON TIME.