Need an excel expert
Budget: $10 – $30 USD
To receive credit you must complete the Individual Project Part 1 quiz on CSePub and upload your Excel file to iCollege. You will get five attempts for each question. Your points will be reduced by 10% for each attempt. Using historic sales data create a monthly forecast using classical decomposition that is based on regression and seasonality. We are creating a monthly forecast not quarterly The data set is your historical sales Please set your Excel spreadsheet to show 4 decimal pointsThis will help when you are entering the data into the Csepub Quiz This part of the project is completed on the Excel Worksheet and Regression For help, review Module 4 Excel Exercise Please note that the Module 4 Exercise is based on quarterly data Kiana is creating a monthly forecast based on monthly data. You will create a seasonal Index for each month. Therefore, you will have seasonal indexes for Jan, FebMarch etc. Remember the total of the month's seasonal indexes for a year should add up to 12. You will still use a three-year average for your final seasonal index.