please help me this question!!! Thank you.
P S T w X 22567 - Week 9 - Online Homework Question - Multiple Regression Retail Traders operates in a fast growing and competitive market. For the purpose of forecasting operating profit, the two predominant drivers, namely Operating Revenue and Total Assets, have been identified. The following table contains information on the operating profit and profit drivers for the period 2011 to 2009 Operating Year 2011 2012 Operating Profit 294 Total Assets 151 2,391 11.42 2.924 342 361 2013 2014 11 15.5 2.102 3,564 2015 473 4.084 4702 2016 494 2017 550 614 2018 18.45 20.019 20.935 24,473 26,321 4,817 5.63 5,724 887 742 2019 2020 Retail Traders wants to develop reliable forecasting functions for the prediction of the level of business activity and the estimation of Operating Professed you to develop a model to facilitate this requirement Required 1. Using three month fractionally weighted mine applied to the Growth Rate of Operating Reve, with wes of 0.02 forecast for Operating Revenue for 2071 whole Compute the Mean Absolute Deviation Mother forecast Growth rate of Operating Revenue Using Exponent Sing forced to me with state of Assets with develop a forecast for Total 2021 whole stars Compute the Mean A Devon Mthe forecast Growth rate of Total Assets using multiple repression acha forecast of Operating thased on the forecast of Operating evene dved in and the forecast of Total developed in Gestion Using the forecast den uestion by the pro will exceed 900 7. Using the forecast depen by the Operating pront ered 900 Management has decided that the 2021 will be $25.500 and the Forecast of Total As for 2021 expected Operating for 2011 Using the forecast developed the baby that 10 Styles Cells Number Editing to the AR AB M N 0 P R MAD 22567. Week 9 - Online Homework Question. (Multiple Regree Retal Traders operates in a fast growing competitive market. For the purpose of forecasting operating profit the two predavvers, namely Operating Revenue and Total Assets, have been identified. The following alle conformation on the operatione profit and profit der for the period 2011 to 2009 Operating R$ Operating Revenue 11.43 12,789 2011 Total Assets 2,291 2.924 2012 2013 342 361 00 2,100 3,564 2014 2015 2016 2017 473 494 4.703 13.90 15.574 16,841 16.465 20,015 20.915 24,473 26,321 4812 2018 054 742 2019 5.083 5.734 5.17 2020 365 1 1 Rotell Traders wants to develop reliable forecasting functions for the prediction of the level of business activity and the estimation of Operating Profit and has bed you to develop model to Facilitate the requirement Required: Unga three month fractionally weighted moving average applied to the Growth rate of Operating wine with weights of 0.0.2.0.1.. develop a forecast for Operating Revenue for 2021 whole dollars only) 2. Compute the Mean Absolut Deviation (MAD) of the forecast Growth rate of Operating Revue Using Exponential Smoothing forecasting techniques applied to the Growth Rate of Ausets with 4 develop a forecast for Toral Assets for 2021 (whole dollars only) Compute the Mean Absolute Devision (MA) of the forecast Growth rate of total nuts 5. Using multiple regression techniques, develop a forecast of Operating profit based on the forecast of Operating Revenue developed in Question 1 and the forecast of Total Assets developed in Question 6. Ung the forecast developed in astion 5, what is the probability that Operating profit exceed 7. using the forecast developed in Questions, what is the probability that Operating profit will Management has decided that the forecast for Sale in 2021 will be $29,500 and the Forecast of Total Assets for 2021 will be $4,700. What is the expected Operating profit for 2021 Using the force developed in Question what is the probability that Operating profit will exceed $1,000? 10 Using the forecast developed in Question I, what is the probably that Operating profit will aceed? Taskbar Taskbar O P R S T V w 22567 - Week 9 - Online Homework Question - (Multiple Regression) Retail Traders operates in a fast growing and competitive market. For the purpose of forecasting operating profit, the two predominant drivers, namely Operating Revenue and Total Assets, have been identified. The following table contains information on the operating profit and profit drivers for the period 2011 to 2009: Year 2011 Operating Profit (5) 294 Operating Revenue (5) 11,482 Total Assets (S) 2,391 2,924 2012 342 12.789 2013 361 13,986 15.574 2014 408 3,102 3,564 4,084 473 2015 2016 2017 494 16,841 18,465 20,019 594 2018 694 4,702 4,817 5,083 5,724 5,887 742 20,915 24,473 26,321 2019 2020 865 Retail Traders wants to develop reliable forecasting functions for the prediction of the level of business activity and the estimation of Operating Profit and has asked you to develop a model to facilitate this requirement Required: 1. Using a three month fractionally weighted moving average applied to the Growth Rate of Operating Revenue with weights of 0.7.0.0.2.3.0.112. develop a forecast for Operating Revenue for 2021 (whole dollars only) Compute the Mean Absolute Deviation (MAD) of the forecast Growth rate of Operating Revenue. 3. Using Exponential Smoothing forecasting techniques applied to the Growth Rate of Assets with a = .4 develop a forecast for Total Assets for 2021 (whole dollars only) 4. Compute the Mean Absolute Deviation (MAD) of the forecast Growth rate of Total Assets Using multiple regression techniques, develop a forecast of Operating Profit based on the forecast of Operating Revenue developed in Question i and the forecast of Total Assets developed in Question 3. Using the forecast developed in Questions, what is the probability that Operating profit will exceed $900? Using the forecast developed in Question 5, what is the probability that Operating profit will exceed $980? Management has decided that the forecast for Sales in 2021 will be $29,500 and the Forecast of Total Assets for 2021 will be $6,700. What is the expected Operating profit for 2021? Using the forecast developed in Question 8, what is the probability that Operating profit will exceed $1,000? Using the forecast developed in Question 8, what is the probability that Operating profit will exceed $950? 5. 7. 8. 9. 10