The following activity requires you to analyse the data given in relation to rail travellers in a country called Beeland, and the amount of ticket sales generated at each of the 30 stations on the main railway line to the capital city per month. You can download the spreadsheet below. When you download the spreadsheet, please enable it. In it you will see a table showing a railway network with data on the following X or independent variables relating to each station: Miles from capital city Population Spend on ticket barriers Predominant socioeconomic group. The furthest right column shows the Y or dependent variable which shows ticket sales at each station. Once you have opened the spreadsheet, you need to click on the data tab and then on the data analysis tab at the right hand side. Then select Regression from the drop down menu. You will then see a regression input table. All you need to do is select the Y variable cells (Ticket sales) then click on the Input X variables and select the X variables data in the four adjacent columns. Keep the confidence limit at the default of 95% and click the