Purchase Solution

Time series

Not what you're looking for?

Ask Custom Question

THE NASDAQ stock market includes small-and medium-sized companies, many of which are in high-tech industries. Because of the nature of these companies, the NASDAQ tends to be more volatile than the Dow Jones Industrial Average or the S&P 500. The weekly values for the NASDAQ during the first 20 weeks of 2006 are listed in the data file weeklyNASDAQ.xls(see attachment) extracted from finance.yahoo.com:
WEEK NASDAQ
3-JAN-06 2,305.62
9-JAN-06 2,317.04
17-JAN-06 2,247.70
23-JAN-06 2,304.23
30-JAN-06 2,262.58
6-FEB-06 2,261.88
13-FEB-06 2,282.36
21-FEB-06 2,287.04
27-FEB-06 2,302.60
6-MAR-06 2,262.04
13-MAR-06 2,306.48
20-MAR-06 2,312.82
27-MAR-06 2,339.79
3-APR-06 2,339.02
10-APR-06 2,326.11
17-APR-06 2,342.86
24-APR-06 2,322.57
1-MAY-06 2,342.57
8-MAY-06 2,243.78
15-MAY-06 2,193.88

a) plot the time series.
b) flt a three-period moving average to the data and plot the results.
c) using a smoothing coefficient of W=0.50, exponentially smooth the series and plot the results.
d) repeat (c), using W=0.25.
e) what conclusion can you reach concerning the presence or absence of trends during the first 20 weeks of 2006?

Use Excel or PhStat 2 (excel extension program). I need direction and explanation how to use Excel or PhStat 2.

Purchase this Solution

Solution Summary

The solution answers the question below.

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.