How much additional profit would be generated if $250,000 were spent on automated ticket barrier investment?

changes. Please save a copy to avoid losing your work. Save a Copy A1 X Y fx SUMMARY OUTPUT A B C D E SUMMARY OUTPUT F G H J K W N - Regression Statistics Multiple R 0,90 5 R Square 0,80 6 Adjusted R Square 0,77 7 Standard Error 16 698,85 8 Observations 30,00 9 10 ANOVA 11 SS MS Significance F 12 Regression 4,00 28 311 474 454,82 7 077 868 613,71 25,38 0,000000017 13 Residual 25,00 6 971 287 115,46 278 851 484,62 14 Total 29,00 35 282 761 570,28 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 17 Intercept 63 964,58 14 526,74 - 4,40 0,00 93 882,95 34 046,20 - 93 882,95 34 046,20 18 X Variable 1 234,96 39,17 6,00 0,00 154,29 315,63 154,29 315,63 19 X Variable 2 0,41 0, 12 3,40 0,00 0, 16 0,65 0, 16 0,65 20 X Variable 3 1,13 0,72 1,58 0, 13 0,34 2,61 0,34 2,61 21 X Variable 4 11 779,31 2 262,73 5,21 0,00 7 119, 13 16 439,49 7 119,13 16 439,49 22 23 D id. SCENARIO Beeland Network DATA RESULTS Q1 Q2 Q3 +A B C D E F G H K L M The following activity requires you to analyse the data given in relation to rail N O P 6 travellers in a country called Beeland, and the amount of ticket sales generated at 7 each of the 30 stations on the main railway line to the capital city per month. 8 You can download the spreadsheet below. 10 11 12 When you download the spreadsheet, please enable it. In it you will see a table 13 showing a railway network with data on the following X or independent variables 14 relating to each station: 15 16 . Miles from capital city 17 18 . Population 19 . Spend on ticket barriers 20 21 . Predominant socioeconomic group 22 23 The furthest right column shows the Y or dependent variable which shows tic WF-OVERSTAY STORAGE-30 AP. X Copy of DAM11 (1) - Excel 24 sales at each station. 25 26 27 Once you have opened the spreadsheet, you need to click on the data tab an CRINGEIGGEICCEIGG erdenein 18 62 SCENARIO Beeland Network DATA RESULTS | Q1 Q2 | Q3 + Ready Ex Accessibility: Investigate