Q3. Take the next 10 observation from the data generated in question 1 and put those in the table given below. (a). Fit a trend line to the following data by graphical method. 2.5 (b). Draw a trend line by the method of semi-averages. 2.5 (c). Calculate the trend value to the following data by the method of 3 years moving averages. (d). Also calculate the trend values by using the method of least square. Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Weights in gramsQ1. Take a random data using generaldata.com the link is https://www.generatedata.com/, In the field "Your Data Set Name" type your name then in "Data Set" "Column Title" type Weights in Grams "Data Type" select Number Range then in "Option" chose between 1 and 30 lastly in "Export Type" select excel. This will generate random data, you only select the first fifty observations, and all of you will have different data. Students should take the print out of the data and submit that in hard form with the hand written answer sheet