it's due today. if someone can answer would be really helpful

ACTUAL DEMAND Month 2008 2009 2010 2011 712 701 732 437 605 722 893 613 984 812 1291 1162 1218 1088 901 829 992 1148 1552 927 1187 January February March April May June July August September October November December 1311 1430 1392 1481 1497 1781 1843 1284 839 1055 975 822 893 599 940 1118 737 994 807 1273 912 996 792 983 608 872 527 Tasks 1. Plot the data and describe what you see. What does it mean and how would you use the information from the plot to help you develop a forecast? 2. Use at least two different methodologies to develop as accurate a forecast as possible for the demand. Use each of those methods to project the next four months demand. 3. Which method from question 2 is "better"? How do you know that? market to improve the forecast? Please find Updated data sheet for use with Northcutt Bikes Case Submission for Winter 2022.This data sheet has demand data for an additional year i.e. 2015. If you have started working with the old data sheet you can add this data as well. However I expect the forecasting to be done with 5 years of data as the basis for calculation. Disclaimer: Data sheet is provided only as a courtesy to reduce the amount of time spent on entering data. Case Study 2 is Due by 11:59 PM Saturday March 12,2022 in the dropbox. Any emailed submissions will not be considered to avoid controversy and maintain transparency. The Case study has the same requirements as Case 1. 1. Individual component : You may choose to process the data using the provided excel sheet however you MUST submit a sample calculation of how you calculated using your chosen Model the following data Forecast/s Error Absolute Error O MAD 2. Group Component Forecasts using TWO models selected by you (Remember Forecast includes MAD) Answers to Questions 1,2 & 3 from the case study (This includes the forecast) 3. Please ensure the names of your group members are prominently displayed on a title / cover sheet I will deduct 25% marks if I have to waste time going through your emails looking for people to award the marks to. 4. Please provide forecast for first 4 months of year 2016 Attachment(s); G Month 2011 2012 2013 2014 2015 437 712 613 701 780 January February 605 732 984 1291 1573 March 722 829 812 1162 1533 893 992 1218 1088 1150 April May 901 1148 1187 1497 1765 June 1311 1552 1430 1781 1915 1055 927 1392 1843 2563 July August September 975 1284 1481 839 1125 822 1118 940 1273 1427 October 893 737 994 912 1024 Novemeber 599 983 807 996 1096 December 608 872 527 792 827