Using Excel, create scatter graph diagram of the share price history of each company (separate graphs). Forecast the share price for the next 3 months using the linear regression analysis method. Please note, graphs should also include trend line and formula.

ASX Code Company Name Date Close Volume Market Capitalisation($m) Shares on Issue FLT Flight Centre Travel Group Limited 30/1 1/2020 17.11 103,604, 166.00 3,407.12 199, 130,550.00 FLT Flight Centre Travel Group Limited 30/10/2020 1.26 71,087,470.00 2,241.87 199, 100,447.00 FLT Flight Centre Travel Group Limited 30/09/2020 13.77 77,605,378.00 2,741.11 199,064, 133.00 FLT Flight Centre Travel Group Limited 31/08/2020 13.23 70,822,308.00 2,632.99 199,016,638.00 FLT Flight Centre Travel Group Limited 31/07/2020 10.59 64,722, 125.00 2, 107.08 198,968,557.00 FLT Flight Centre Travel Group Limited 30/06/2020 11.12 121,781, 136.00 2,212.18 198,937,079.00 FLT Flight Centre Travel Group Limited 29/05/2020 13.08 96,629,474.00 2,601.68 198,904,945.00 FLT Flight Centre Travel Group Limited 30/04/2020 10.99 83,894,754.00 ,974.48 179,661,679.00 FLT Flight Centre Travel Group Limited 31/03/2020 3.921 21,787,390.00 902.26 101, 139,424.00 FLT Flight Centre Travel Group Limited 28/02/2020 29.364 11,856,545.00 2,969.79 101, 135,513.00 FLT Flight Centre Travel Group Limited 31/01/2020 35.387 7,733,669.00 3,578.76 101, 132,380.00 FLT Flight Centre Travel Group Limited 31/12/2019 39.663 4,868,091.00 4,011.08 101, 129,431.00 FLT Flight Centre Travel Group Limited 29/11/2019 39.636 7,932,874.00 4,008.22 101, 126,299.00 FLT Flight Centre Travel Group Limited 31/10/2019 38.34 8,716,861.00 3,877.01 101, 123, 142.00 FLT Flight Centre Travel Group Limited 30/09/2019 42.849 8,206,099.00 4,332.91 101,119,334.00 FLT Flight Centre Travel Group Limited 30/08/2019 41.868 10,689,621.00 4,233.56 101,116, 176.00 FLT Flight Centre Travel Group Limited 31/07/2019 41.49 8,445,276 4, 195.20 101, 112,932.00 FLT Flight Centre Travel Group Limited 28/06/2019 37.403 9,131,936.00 3,781.68 101, 105,594.00 FLT Flight Centre Travel Group Limited 31/05/2019 39.24 10,246,255.00 3,967.21 101, 101,852.00 FLT Flight Centre Travel Group Limited 30/04/2019 34.568 11,441,684.00 3,494.71 101,097,484.00 FLT Flight Centre Travel Group Limited 29/03/2019 37.853 11,919,654.00 3,826.76 101,094,350.00 FLT Flight Centre Travel Group Limited 28/02/2019 41.202 12,777,482.00 4, 165.18 101,091, 166.00 FLT Flight Centre Travel Group Limited 31/01/2019 38.736 6,617,785.00 3,915.72 101,088,296.00 FLT Flight Centre Travel Group Limited 31/12/2018 38.637 6,262,795.00 3,905.60 101,085,430.00 FLT Flight Centre Travel Group Limited 30/1 1/2018 43.975 7,890,961.00 4,445.07 101,082, 134.00 FLT Flight Centre Travel Group Limited 31/10/2018 41.769 10,896,029.00 4,222.02 101,079,515.00 FLT Flight Centre Travel Group Limited 28/09/2018 47.855 8,455,028.00 4,837.12 101,079,515.00 FLT Flight Centre Travel Group Limited 31/08/2018 52.59 10,611,526.00 5,315.51 101,075, 192.00 FLT Flight Centre Travel Group Limited 31/07/2018 61.223 7,349,094.00 6,187.99 101,073,651.00 FLT Flight Centre Travel Group Limited 29/06/2018 57.298 6,924,589.00 5,791.19 101,071,891.00 FLT Flight Centre Travel Group Limited 31/05/2018 55.47 8,620,290.00 5,606.39 101,070,091.00 FLT Flight Centre Travel Group Limited 30/04/2018 50.321 6,684,871.00 5,085.85 101,067,746.00 FLT Flight Centre Travel Group Limited 29/03/2018 51.302 14,394,603.00 5, 184.92 101,065,895.00 FLT Flight Centre Travel Group Limited 28/02/2018 $2.023 11,803,404.00 5,257.60 101,063,678.00 FLT Flight Centre Travel Group Limited 31/01/2018 45.937 6,972,680.00 4,642.50 101,061,979.00 FLT Flight Centre Travel Group Limited 29/12/2017 39.82 6,224,973.00 4,024.69 101,059,840.00 FLT Flight Centre Travel Group Limited 30/1 1/2017 40.293 8,259,230.00 4,071.90 101,057,252.00 FLT Flight Centre Travel Group Limited 31/10/2017 42. 129 6,948,725.00 4,257.39 101,055, 161.00 FLT Flight Centre Travel Group Limited 29/09/2017 40.518 8,515,354.00 4,094.46 101,052,906.00 FLT Flight Centre Travel Group Limited 31/08/2017 43.525 11,993,944.00 4,398.21 101,050,914.00 FLT Flight Centre Travel Group Limited 31/07/2017 39.159 13,051, 123.00 3,956.94 101,048,815.00 FLT Flight Centre Travel Group Limited 30/06/2017 34.478 9,458,643.00 3,483.85 101,046,347.00 FLT Flight Centre Travel Group Limited 31/05/2017 32. 191 13, 132,458.00 3,252.69 101,042,829.00 FLT Flight Centre Travel Group Limited 28/04/2017 28.311 7,161,411.00 2,860.58 101,040, 163.00 FLT Flight Centre Travel Group Limited 31/03/2017 25.998 8,535,307.00 2,626.73 101,036,704.00 FLT Flight Centre Travel Group Limited 28/02/2017 25.962 10,717,527.00 2,622.21 101,002,495.00 FLT Flight Centre Travel Group Limited 31/01/2017 26.952 5,478,555.00 2,721.70 100,983,383.00 FLT Flight Centre Travel Group Limited 30/12/2016 28. 176 6,911,716.00 2,845.08 100,974,390.00 FLT Flight Centre Travel Group Limited 30/1 1/2016 30.067 9,795,439.00 3,035.67 100,964,584.00 FLT Flight Centre Travel Group Limited 31/10/2016 30.49 8,601,596.00 3,078. 14 100,956,371.00ASX Code Company Name Date Close Volume Market Capitalisation($m) Shares on Issue SGR The Star Entertainment Group Limit 30/1 1/2020 3.78 94,332,801.00 3,598.61 952,014,210.00 SGR The Star Entertainment Group Limit 30/10/2020 3.28 111,780, 194.00 3, 122.61 952,014,210.00 SGR The Star Entertainment Group Limit 30/09/2020 3.06 93,665,596.00 2,913.16 952,014,210.00 SGR The Star Entertainment Group Limit 31/08/2020 2.95 100,064,730.00 2,796.76 948,053,728.00 SGR The Star Entertainment Group Limit 31/07/2020 2.55 113,579,919.00 2,417.54 948,053,728.00 SGR The Star Entertainment Group Limit 30/06/2020 2.84 168, 130,683.00 2.605.20 917,322,730.00 SGR The Star Entertainment Group Limit 29/05/2020 2.95 91,721,012.00 2,706.10 917,322,730.00 SGR The Star Entertainment Group Limit 30/04/2020 3.03 143,756,827.00 2,779.49 917,322,730.00 SGR The Star Entertainment Group Limit 31/03/2020 2.15 143,959,206.00 1,972.24 917,322,730.00 SGR The Star Entertainment Group Limit 28/02/202 3.65 12,745.00 3,348.23 917,322,730.00 SGR The Star Entertainment Group Limit 31/01/2020 4.18 65,553,967.00 3,834.41 917,322,730.00 SGR The Star Entertainment Group Limit 31/12/2019 4.60 79,471,733.00 4,219.68 917,322,730.00 SGR The Star Entertainment Group Limit 29/1 1/2019 4.76 62,953,686.0 4,366.46 917,322,730.00 SGR The Star Entertainment Group Limit 31/10/2019 4.70 76,775,646.00 4,311.42 917,322,730.00 SGR The Star Entertainment Group Limit 30/09/2019 4.36 84,763,736.00 3,999.53 917,322,730.00 SGR The Star Entertainment Group Limit 30/08/2019 4.11 ,846,348.00 3,770.20 917,322,730.00 SGR The Star Entertainment Group Limit 31/07/2019 4.14 93,794, 124.00 3,797.72 917,322,730.00 SGR The Star Entertainment Group Limit 28/06/2019 4.12 124,447,454.00 3,779.37 917,322,730.00 SGR The Star Entertainment Group Limit 31/05/2019 4.47 91,607,356.00 4, 100.43 917,322,730.00 SGR The Star Entertainment Group Limit 30/04/2019 4.54 61,730,684.00 4, 164.65 917,322,730.00 SGR The Star Entertainment Group Limit 29/03/2019 4.18 69,229,916.00 3,834.41 917,322,730.00 SGR The Star Entertainment Group Limit 28/02/2019 4.43 62,254,207.00 4,063.74 917,322,730.00 SGR The Star Entertainment Group Limit 31/01/2019 4.44 52, 164,357.00 4,072.91 917,322,730.00 SGR The Star Entertainment Group Limit 31/12/2018 4.56 47,915,210.00 4,182.99 917,322,730.00 SGR The Star Entertainment Group Limit 30/1 1/2018 4.38 87,801,741.00 4,017.87 917,322,730.00 SGR The Star Entertainment Group Limit 31/10/2018 4.74 57,911, 107.00 4,348.11 917,322,730.00 SGR The Star Entertainment Group Limit 28/09/2018 5.19 72,018,249.00 4,760.90 917,322,730.00 SGR The Star Entertainment Group Limit 31/08/2018 5.39 85,058,955.00 1,944.37 917,322,730.00 SGR The Star Entertainment Group Limit 31/07/2018 4.96 66,593, 167.00 4,549.92 917,322,730.00 SGR The Star Entertainment Group Limit 29/06/2018 4.93 84,532, 144.00 4,522.40 917,322,730.00 SGR The Star Entertainment Group Limit 31/05/2018 4.96 56,075, 193.00 4,549.92 917,322,730.00 SGR The Star Entertainment Group Limit 30/04/2018 5.28 54,720,696.00 4,843.46 917,322,730.00 SGR The Star Entertainment Group Limit 29/03/2018 5.29 74,212,612.00 4,367.81 825,672,730.00 SGR The Star Entertainment Group Limit 28/02/2018 5.32 83,622,911.00 4,392.58 825,672,730.00 SGR The Star Entertainment Group Limit 31/01/2018 6.06 46,224,019.00 5,003.58 825,672,730.00 SGR The Star Entertainment Group Limit 29/12/2017 6.08 47,846,697.00 5,020.09 825,672,730.00 SGR The Star Entertainment Group Limit 30/1 1/2017 5.92 69, 178,811.00 4,887.98 825,672,730.00 SGR The Star Entertainment Group Limit 31/10/2017 5.75 48,711,522.00 4,747.62 825,672,730.00 SGR The Star Entertainment Group Limit 29/09/2017 5.24 43,005,998.0 4,326.53 825,672,730.00 SGR The Star Entertainment Group Limit 31/08/2017 5.20 67, 135,379.00 4,293.50 825,672,730.00 SGR The Star Entertainment Group Limit 31/07/2017 5.04 120,853,946.00 4, 161.39 825,672,730.00 SGR The Star Entertainment Group Limit 30/06/2017 5.05 70,347,505.00 4,169.65 825,672,730.00 SGR The Star Entertainment Group Limit 31/05/2017 5.18 68,059,208.00 4,276.98 825,672,730.00 SGR The Star Entertainment Group Limit 28/04/2017 5.57 60,519,789.00 4,599.00 825,672,730.00 SGR The Star Entertainment Group Limit 31/03/2017 5.47 75,310,880.00 4,516.43 825,672,730.00 SGR The Star Entertainment Group Limit 28/02/2017 4.88 93,790,788.00 4,029.28 825,672,730.00 SGR The Star Entertainment Group Limit 31/01/2017 4.77 54,875,769.00 3,938.46 825,672,730.00 SGR The Star Entertainment Group Limit 30/12/2016 5.17 61,914,882.00 4,268.73 825,672,730.00 SGR The Star Entertainment Group Limit 30/1 1/2016 5.28 116,863,627.00 1,359.55 825,672,730.00 SGR The Star Entertainment Group Limit 31/10/2016 4.99 120,392,729.00 4, 120.11 825,672,730.00