Q1 Q2 a) Construct a time series plot and use one sentence to describe what type of paller exists in the data? Atower Year Expense (%) 2003 139 2004 12.2 2005 2006 2007 Period (0) 1 2 3 4 s 6 7 10,5 10,4 11.5 10,0 8.5 2008 2000 h)Use simple linear regression analysis to find the regression equation Intercepti OF Skob IF c) What is the forecasted percentage of administrative expenses for 2010 (year 3 OfSCF can maintain its current trend in reducing adminstrative expenses which year will SCF achieve a love of 5% or less! End of this signment Q1 Q2 Month ! 2 3 4 5 6 a) Construct a time series plot and use one sentence to describe what type of pattern exists in the data! Answer: Interest Rate 9,5 9,3 9,4 9,6 9,8 9,7 9,8 10,5 9,9 9,7 9,6 9,6 Interest Rate 7 X 9 10 11 30 12 20 10 0 10 20 30 b) develop three month and four month moving average for this time series And calculate the Mean Squred Error (MSE) for each Month Three month four month Interest Rate Moving Moving average average 9.5 ! 2 3 4 S 7 ellele 9,4 9,6 9,8 9.7 9,8 10,3 9,9 9,7 9,6 9,6 9 10 11 12 MSE of three month moving average MSE of four month moving average Based on the MSES, does three month or four month moving average model provide the better forcasts? c) What is the moving averape forecast for the next month? End of this tab. Please go the next tab for the 2nd problem Le Rate 1 95 a) Construct a time series plot and use one sentence to 3 93 describe what type of puttern exists in the data? 94 Arr: 9.6 9.8 9.7 Graph here: 9.8 10.5 9.9 10 9.7 11 9.6 9.6 ream b) develop three- month and four month moving average for this time series And calculate the Mean Squred Error (MS) for each Three Four month month Moving Moving Month Interest Rate average overore 3 93 2 9.4 9.6 9.8 97 IR 5 103 . 99 10 96 9.6 NSE of three month moving average SE of four month moving avera Based on the MSE, does three month of four month moving average mode provide the better forcasts? c) What is the moving average forecast for the next month? cofthitab peu the next to the notion They a) Construct a time series plot and use one secto describe what type of pattern ists in the data? The Senec Cid's Fund (SOF) is a local charity that runs mercamp for davantaged children. The fund's board of directors has been working very hard over recent years to decrease the amount of overhead expens, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that was spent on administrative and fundraising expenses over the past seven years Graph here Year 2003 2004 2005 2006 2007 2008 2009 Period (1) Expense (9) 139 2 122 3 103 4 10.4 113 6 100 83 b} Use simple inear regression analysis to find the repression equation Intercept_01 Sope 1) What is the forecasted percentage of administrative expenses for 2010 year 3? d) SCF can maintanits current trend in reducing intrative expenses which year WSCF Schevealeve of store of thigament Q1 Q2 a) Construct a time series plot and use one sentence to describe what type of paller exists in the data? Atower Year Expense (%) 2003 139 2004 12.2 2005 2006 2007 Period (0) 1 2 3 4 s 6 7 10,5 10,4 11.5 10,0 8.5 2008 2000 h)Use simple linear regression analysis to find the regression equation Intercepti OF Skob IF c) What is the forecasted percentage of administrative expenses for 2010 (year 3 OfSCF can maintain its current trend in reducing adminstrative expenses which year will SCF achieve a love of 5% or less! End of this signment Q1 Q2 Month ! 2 3 4 5 6 a) Construct a time series plot and use one sentence to describe what type of pattern exists in the data! Answer: Interest Rate 9,5 9,3 9,4 9,6 9,8 9,7 9,8 10,5 9,9 9,7 9,6 9,6 Interest Rate 7 X 9 10 11 30 12 20 10 0 10 20 30 b) develop three month and four month moving average for this time series And calculate the Mean Squred Error (MSE) for each Month Three month four month Interest Rate Moving Moving average average 9.5 ! 2 3 4 S 7 ellele 9,4 9,6 9,8 9.7 9,8 10,3 9,9 9,7 9,6 9,6 9 10 11 12 MSE of three month moving average MSE of four month moving average Based on the MSES, does three month or four month moving average model provide the better forcasts? c) What is the moving averape forecast for the next month? End of this tab. Please go the next tab for the 2nd problem Le Rate 1 95 a) Construct a time series plot and use one sentence to 3 93 describe what type of puttern exists in the data? 94 Arr: 9.6 9.8 9.7 Graph here: 9.8 10.5 9.9 10 9.7 11 9.6 9.6 ream b) develop three- month and four month moving average for this time series And calculate the Mean Squred Error (MS) for each Three Four month month Moving Moving Month Interest Rate average overore 3 93 2 9.4 9.6 9.8 97 IR 5 103 . 99 10 96 9.6 NSE of three month moving average SE of four month moving avera Based on the MSE, does three month of four month moving average mode provide the better forcasts? c) What is the moving average forecast for the next month? cofthitab peu the next to the notion They a) Construct a time series plot and use one secto describe what type of pattern ists in the data? The Senec Cid's Fund (SOF) is a local charity that runs mercamp for davantaged children. The fund's board of directors has been working very hard over recent years to decrease the amount of overhead expens, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that was spent on administrative and fundraising expenses over the past seven years Graph here Year 2003 2004 2005 2006 2007 2008 2009 Period (1) Expense (9) 139 2 122 3 103 4 10.4 113 6 100 83 b} Use simple inear regression analysis to find the repression equation Intercept_01 Sope 1) What is the forecasted percentage of administrative expenses for 2010 year 3? d) SCF can maintanits current trend in reducing intrative expenses which year WSCF Schevealeve of store of thigament