1)Given the data in the table, calculate the four period moving average forecast for unemployment rate for October 2011. Express your result in percent, without the percent sign (e.g., 7.3 for 7.3%).
|
Unemployment |
||
|
Year |
Month |
Rate (%) |
|
2010 |
Oct |
6.8 |
|
Nov |
7.0 |
|
|
Dec |
7.5 |
|
|
2011 |
Jan |
8.0 |
|
Feb |
8.2 |
|
|
Mar |
8.5 |
|
|
Apr |
8.6 |
|
|
May |
8.6 |
|
|
Jun |
8.9 |
|
|
Jul |
9.1 |
|
|
Aug |
8.8 |
|
|
Sep |
8.7 |
|
|
Oct |

1)Given the data in the table, calculate the four period moving average forecast for unemployment...
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Last year 170 200 210 240 250 270 225 215 215 275 280 300 This year 205 210 140 255 245 220 Forecast...
The data contained in the file named StateUnemp show the unemployment rate in March 2011 and the unemployment rate in March 2012 for every state.† State Unemploy- ment Rate March 2011 Unemploy- ment Rate March 2012 Alabama 9.3 7.3 Alaska 7.6 7.0 Arizona 9.6 8.6 Arkansas 8.0 7.4 California 11.9 11.0 Colorado 8.5 7.8 Connecticut 9.1 7.7 Delaware 7.3 6.9 Florida 10.7 ...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
The human resources department needs to forecast the number of employees at a site. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 7 month moving average. Please round your forecast to the nearest whole number Nov 2019: 956 Oct 2019: 1014 Sep 2019: 1009 Aug 2019: 963 Jul 2019: 966 Jun 2019: 1024 May 2019: 1045||Apr 2019: 1047 Mar...
Date Gasoline Crude Oil
Jan 01, 2010 2.031 79.07
Jan 08, 2010 2.124 82.34
Jan 15, 2010 2.079 80.06
Jan 22, 2010 2.010 76.62
Jan 29, 2010 1.942 73.94
Feb 05, 2010 1.885 74.57
Feb 12, 2010 1.908 73.88
Feb 19, 2010 2.031 78.25
Feb 26, 2010 2.042 79.22
Mar 05, 2010 2.127 80.19
Mar 12, 2010 2.154 81.76
Mar 19, 2010 2.150 81.44
Mar 26, 2010 2.118 80.65
Apr 02, 2010 2.191 83.01
Apr 09, 2010 2.238 85.66
Apr...
1. The numbers below represent heights (in feet) of 3-year old elm trees. 5.1, 5.5, 5.8, 6.1, 6.2, 6.4, 6.7, 6.8, 6.9, 7.0, 7.2, 7.3, 7.3, 7.4, 7.5, 7.7, 7.9, 8.1, 8.1, 8.2, 8.3, 8.5, 8.6, 8.6, 8.7, 8.7, 8.9, 8.9, 9.0, 9.1, 9.3, 9.4, 9.6, 9.8, 10.0, 10.2, 10.2 Using the chi-square goodness-of-fit test, determine whether the heights of 3-year old elm trees are normally distributed, at the a = .05 significance level. Also, find the p- value.
Given the following data, what is the Mean Absolute Deviation (MAD): Month Demand Forecast Jan 100 110 Feb 100 100 Mar 120 100 Apr 110 90 May 100 110 Jun 90 100 Jul 80 90 Aug 90 80 Sep 100 110 Oct 110 100 Nov 110 110 Dec 120 110 A. 10 B. 20 C. 30 D. 133.33
Question 3: The following table shows the monthly minimum temperature (degree Celsius C)) of a city in Australia for 3 consequent years Mean of Minimum Temperature Month 2010 2011 2012 18 15.5 12.9 12.5 10 8.1 6.4 7.6 8.7 9 12.2 13.9 15.6 16 14.5 11.8 9.8 7.9 7.1 7.8 9.2 10.6 12.6 14.1 17.7 17.7 13.5 12.3 9.5 7.3 7.6 7.2 10.1 Jan Feb Mar Ma Jun Jul Aug Sep Oct Nov Dec 11.9 13.7 1. Propose a visualisation...
Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare Jan-10 -4.87 -0.15 Feb-10 1.8 0.53 Mar-10 2.26 1.41 Apr-10 3.03 -3.75 May-10 -11.5 -5.12 Jun-10 -5.67 -0.52 Jul-10 8.73 1.49 Aug-10 -5.99 -0.97 Sep-10 10.15 8.24 Oct-10 3.89 2.28 Nov-10 2.85 -2.52 Dec-10 5.55 1.4 Jan-11 6.6 1.55 Feb-11 5.7 3.04 Mar-11 1.32 1.22 Apr-11 1.64 5.89 May-11 -4.06 2.62 Jun-11 -2.08 -0.55 Jul-11 1.14 -2.64 Aug-11 -10.41 -2.8 Sep-11 -15.06 -4.17 Oct-11...
calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel. In a text box nearby, comment on whether investors’ trading decisions have created value. Month ADKSX Return (%) ADKSX Cash Flow ($) Nov-09 3.49 -$10,648,393 Dec-09 6.93 -$618,800 Jan-10 -2.05 $940,820 Feb-10 5.74 -$2,484,437 Mar-10 5.19 -$3,699,836 Apr-10 5.48 -$1,379,757 May-10 -4.68 $2,145,936 Jun-10 -6.31 -$2,953,884 Jul-10 5.9 -$4,160,472 Aug-10 -5.18 $1,096,304 Sep-10 8.61 -$5,571,657 Oct-10 4.5 -$669,464 Nov-10 2.77 -$3,145,367 Dec-10 9.16 -$6,162,018...