The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 19942013 Develop a trend line and use it to predict the opening DJIA index value for years 2014, 2015, and 2016 YEAR DJIA 1994 3,754 1995 3,834 1996 5,117 1997 6,448 1998 7,908 1999 9,213 2000 11,502 2001 10,791 2002 10,022 2003 8,342 2004 10,453 2005 10,784 2006 10,718 2007 12,460 2008 13,262 2009 8,772 2010 10,431 2011 11,577 2012 12,392 2013 13,104 (b) Using the data from this problem (years 1994 2013), calculate 3 month average forecast and then calculate the MSE for this model The MSE is Question 6 options 1,532,843 1,601,226 1,497,394 1,568,511

Question: The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 19942013. Develop a trend line and

The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 1994–2013. Develop a trend line and use it to predict the opening DJIA index value for years

2014,
2015, and
2016.

YEAR	DJIA
1994	3,754
1995	3,834
1996	5,117
1997	6,448
1998	7,908
1999	9,213
2000	11,502
2001	10,791
2002	10,022
2003	8,342
2004	10,453
2005	10,784
2006	10,718
2007	12,460
2008	13,262
2009	8,772
2010	10,431
2011	11,577
2012	12,392
2013	13,104

(b): Using the data from this problem (years 1994-2013), calculate 3 month average forecast and then calculate the MSE for this model. The MSE is:

Question 6 options:

	1,532,843
	1,601,226
	1,497,394
	1,568,511

Step by Step Solution

★★★★★

3.31 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Step 1 of 14 A In forecasting moving averages are us... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Using the data from Problem 11.16, determine which means are different from one another using Î± = 0.05. In Problem Block Sample 1 Sample 2 Sample 3 13

Using the data from Problem 11.29, determine which means are different using Î± = 0.05, when warranted. In Problem Factor A Factor B LeveLevel 2 Level 3 Level 1 31 20 18 31 21 23 13 29...

Using the data from Problem 2 in Chapter 5 and/or the SAS output given here, answer the following questions about the separate straight-line regressions of SBP on QUET for smokers (SMK = 1) and...

Consider the following data: (a) Calculate the Solow residual for each year from 1995 to 2007. (b) Calculate percentage rates of growth in output, capital, employment, and total factor productivity...

Listed in the following table are two sets of figures: the total quantity of Mexican pesos (new pesos) in circulation (the total amount of Mexican money available) and the peso price of a U.S. dollar...

Xr03-32 The number of earned degrees (thousands) for males and females is listed below for the years 1987 to 2006. Graph both sets of data. What do the graphs tell you? Year Female Male 1987 941 882...

The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 1991-2010: Develop a trend line and use it to predict the opening DJIA index value...

Table E11-21 shows the population and the average count of wood storks sighted per sample period for South Carolina from 1991 to 2004. Fit a regression line with population as the response and the...

The high desert area of Southern California is 80 to 90 miles from Newport Beach, Disneyland, and the Staples Center, and perhaps more significantly, 3545 miles from jobs in the San Bernardino area....

8 The following chart shows health expenditures for the United States between 1960 and 2014. Using a spreadsheet program: (a) Calculate health expenditures per person for each year. (b) Calculate...

Kluber, Inc. had net income of $908,000 based on variable costing. Beginning and ending inventories were 55,800 units and 53,600 units, respectively. Assume the fixed overhead per unit was $1.65 for...

Strategic decision-making will determine the direction of any organisation. Some oorganisations make better strategic decisions than others. Various processes exist to make a strategic decision;...

Iqbal Corporation produces and sells a single product, has provided its contribution format income statement for March. Sales (17,000 units) Rs. 2,210,000 Variable Expenses 1,530,000 Contribution...

3.Fresh Foods wants to decrease the total cost of guava. Identify three costs areas - other than price - that Fresh Foods to focus on to decrease total cost. Explain why you choose those cost areas....

i.Suggest at least THREE (3) kinds of analytics and machine learning algorithms that Champo Carpets can use to solve their problems, and in general, for value creation. ii.Explain the data strategy...

While traveling on an assignment that is being paid for by your employer, you visit an area in which you would really like to live but can never find time to visit on your own. You have five days to...

For Xcode app Programming language: C 3.2 Task Two Since C passes arguments to functions by value, there is no direct way for the called functionto alter a variable in the calling function. For...

Identify Thank You mission, strategy and core competencies. Identify strategy changes that have taken place at Thank You since its founding in 2008. Your answer must in text references and must be...

Suppose I have two different possible routes for my commute to school. Because I never want to be late for class, I want to choose the route that provides a more consistent commute time. Being a...

The following data show the number of employees who called in sick to a chemical plant during the last 50 days. This data can be found in the Excel file sick days.xlsx. Using = 0.01, perform a...

A regional manager at Acme Markets would like to develop a model to predict the weekly sales of pet food based on the shelf space allotted to the food. The following table shows the results of data...

The Center on Budget and Policy Priorities (www. cbpp.org) reported that average out-of-pocket medical expenses for prescription drugs for privately insured adults with incomes over 200% of the...

The Jordeen Bottling Company recently did an extensive sampling of its soft-drink inventory in which 5,000 cans were sampled. Employees weighed each can and used these weights to determine the fluid...

For the following hypothesis test: H0: m 45 HA: m 45 a 0.02 with n 80, s 9, and 47.1, state a. the decision rule in terms of the critical value of the test statistic b. the calculated value of...