• Question 2 is about using regression to analyze a time series.

Please input how you created the graph. Please complete all yellow areas.

Thank you!!

• 

The Seneca Children's Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund's board of directors has been working very hard over recent years to decrease the amount of overhead expenses, 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 fund-raising expenses over the past seven years: a) Construct a time series plot and use one sentence to describe what type of pattern exists in the data? Answer: Graph here: b) Use simple linear regression analysis to find the regression equation Intercept (b_0)= Slope (b_1)= c) What is the forecasted percentage of administrative expenses for 2010 (year d) If SCF can maintain its current trend in readucing adminstrative expenses, which year will SCF achieve a leve of 5% or less? The Seneca Children's Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund's board of directors has been working very hard over recent years to decrease the amount of overhead expenses, 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 fund-raising expenses over the past seven years: a) Construct a time series plot and use one sentence to describe what type of pattern exists in the data? Answer: Graph here: b) Use simple linear regression analysis to find the regression equation Intercept (b_0)= Slope (b_1)= c) What is the forecasted percentage of administrative expenses for 2010 (year d) If SCF can maintain its current trend in readucing adminstrative expenses, which year will SCF achieve a leve of 5% or less