1week5assignment Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ Cut Calibri (Body) * 11 A- A = = = Wrap Text General AutoSum Copy Fill Paste B I U V V V A .00 Conditional Format Cell Format Sort & Format Merge & Center $ % > Insert Delete Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D3 X V fx describe what type of pattern exists in the data? A B H M O P Q R T U V W X 1 Month Interest Rate 9.5 a) Construct a time series plot and use one sentence to The yellow area or cells are for you to 9.3 describe what type of pattern exists in the data? complete. Only work in these areas will be W N 94 graded. Answer: 96 9.8 Graph here: 97 98 Interest Rate GUFWRESO VOUAWN 10.5 10.6 9.9 10 9.7 10.4 11 9.6 10.2 12 9.6 10 9.8 9 .6 9.4 9.2 b) develop three-month and four month moving average for this time series 10 12 14 And calculate the Mean Squred Error (MSE) for each Three month Four month Moving Moving Month Interest Rate average average 9.5 UN 9.3 3 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 9.7 CEb 9 .6 36 9.6 37 01 Q2 + Ready + 100%1week5assignment Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ Cut Calibri (Body) * 11 A- A = = = Wrap Text General AutoSum Copy Fill Paste B I U VYA Merge & Center $ % > .00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D3 X v fx describe what type of pattern exists in the data? A G H K L M N P Q R T U V W 23 Three month Four month Moving Moving 24 Month Interest Rate average average 1 95 26 2 9.3 27 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 10 9.7 11 9.6 9.6 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 average forecast for the next month? End of this tab. Please go the next tab for the 2nd problem. Q1 Q2 + Ready + 100%1week5assignment Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ Cut Calibri (Body) * 11 A- A Wrap Text General AutoSum Copy Fill Paste B I UV V. A . Merge & Center $ ~ % > .00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates L51 X V fx G H K M 0 P Q R T U V W The Seneca Children's Fund (SCF) is a local charity that runs a summer camp for disadvantaged a) Construct a time series plot and use one sentence to The yellow area or cells are for you to children. The fund's board of directors has been describe what type of pattern exists in the data? complete. Only work in these areas will be working very hard over recent years to decrease the Answer: amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the mone Graph here: SCF has raised that was spent on administrative and fund-raising expenses over the past seven years: Year Period (t) Expense (%) 2003 13.9 2004 12.2 2005 10.5 2006 10.4 2007 11.5 2008 10.0 2009 8.5 b) Use simple linear regression analysis to find the regression equation Intercept (b_0)= 24 Slope (b_1)= 25 26 c) What is the forecasted percentage of administrative expenses for 2010 (year 8)? 27 28 29 30 d) if SCF can maintain its current trend in readucing adminstrative expenses, which year will SCF achieve a leve of 5% or less? 35 36 End of this assignment 37 38 39 40 Q1 Q2 + Ready + 100%