Reference no: EM13922056 , Length:
Data on England and Wales conceptions wider 18.
Part 1
Produce a report on these figures including:
(1) A graph showing how these figures moved throughout the time period.
(2) From your graph in (1) give reasons as to whether you think a multiplicative or additive model is likely to be better here.
(3) A centred trend based on a method of moving averages on the figures in the published data.
(4) A set of adjusted seasonal variations based on your own analysis for the figures.
(5) A column showing the residuals from your model.
(6) A set of your own deseasonalised figures based on your analysis.
(7) A suitable graphical presentation of these series.
NB You should use excel for this question.
Part 2
Enter the figures into minitab and
(1) Use the Decomposition facility under stat menu to obtain seasonal variations, trend and deseasonalised figures using an additive model.
(2) Produce and comment the graphical representation showing trend and fitted model.
(3) Compare your pattern of residuals with that from the minitab model (hint: you might look at means and standard deviations and charts).
(4) Perform an analysis using autocorrelation and partial autocorrelation of the residuals in minitab. What do the autocorrelation and partial autocorrelation tell you about the residuals here?
Teenage conceptions England and Wales:
|
December
|
2003
|
10.749
|
|
March
|
2004
|
10.854
|
|
June
|
2004
|
10,570
|
|
September
|
2004
|
9.967
|
|
December
|
2004
|
10.807
|
|
March
|
2005
|
10,400
|
|
June
|
2005
|
10,464
|
|
September
|
2005
|
10.437
|
|
December
|
2005
|
11.024
|
|
March
|
2006
|
10,192
|
|
June
|
2006
|
10,550
|
|
September
|
2006
|
9.987
|
|
December
|
2006
|
11.039
|
|
March
|
2007
|
10.846
|
|
June
|
2007
|
10.932
|
|
September
|
2007
|
10.353
|
|
December
|
2007
|
10.857
|
|
March
|
2008
|
10.730
|
|
June
|
2008
|
10.576
|
|
September
|
2008
|
9,894
|
|
December
|
2008
|
10.161
|
|
March
|
2009
|
9.779
|
|
June
|
2009
|
10.046
|
|
September
|
2009
|
9,154
|
|
December
|
2009
|
9.280
|
|
March
|
2010
|
9.218
|
|
June
|
2010
|
9,098
|
|
September
|
2010
|
8,091
|
|
December
|
2010
|
8.226
|
|
March
|
2011
|
7.844
|
|
June
|
2011
|
8.347
|
|
September
|
2011
|
7,458
|
|
December
|
2011
|
7.402
|
|
March
|
2012
|
7.597
|
|
June
|
2012
|
7,083
|
|
September
|
2012
|
6,540
|
|
December
|
2012
|
6,614
|
|
March
|
2013
|
6.282
|
|
June
|
2013
|
6,279
|
|
September
|
2013
|
5.598
|
|
December
|
2013
|
6,147
|
|
March
|
2014
|
5,878
|
|
June
|
2014
|
5.740
|
Attachment:- Report Assignment in Time series.docx
|
Research a computer organization
: You are to research a computer organization/computer architecture topic and present your findings in a research paper. You should read various reference materials to gather information, which then should be presented in a logically organized and c..
|
|
What should market price be if the coupon were paid annually
: Dewey Cheetham & Howe accounting firm is considering the purchase of a $1000 New Haven Municipal Bond. The stated coupon rate is 5% paid quarterly. The bond will mature in 22 years. The YTM for similar bonds is 4%. What should the market price of the..
|
|
Prepare the entries for both the purchase and subsequent
: During 2013, TNL Systems reacquired shares of its common stock and later sold shares in two separate transactions. Prepare the entries for both the purchase and subsequent resale of the shares assuming the shares are (a) retired and (b) viewed as tre..
|
|
How much would a risk-neutral person be willing to pay
: What is the expected value and standard deviation of the investment? How much would a risk-neutral person be willing to pay for the investment? How much would a risk-averse person be willing to pay for the investment?
|
|
Graphical representation showing trend and fitted model
: Use the Decomposition facility under stat menu to obtain seasonal variations, trend and deseasonalised using an additive model - Produce and comment the graphical representation showing trend and fitted model.
|
|
Perform sensitivity analysis on project
: Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other..
|
|
Unix operating system
: The UNIX operating system (and its variants, of which Linux is one) includes quite a few useful utility programs. One of those is wc, which is short for Word Count. The purpose of wc is to give users an easy way to determine the size of a text fil..
|
|
Attractive to marketers around the world
: because it represents a collective approach to marketing in contrast to the traditional individualist approach used in the United States and other western cultures
|
|
Plot a budget line for a representative consumer
: Plot a budget line for a representative consumer both before and after the voucher program. Do you expect that current consumption of a typical consumer will increase by the full 100,000 yen of the voucher? Explain.
|