The following lists the answers to the problem solver questions for each chapter.
Create a query using the Query Wizard that shows what happens to the Natural Gas Futures contract 1 weekend 2 weeks later when the close price is up extra big and the day before it made a new 52-week low.
SHOW
t+1: percent_move from today to 1 week later of NG
t+2: percent_move from today to 2 weeks later of NG
WHEN
1 day ago
low of NG is less than 52 week lowest of low of NG 1 value ago
AND
1 value percent_move of NG is more than
(30 day average of 1 value percent_move of NG +
(3 * 30 day std_dev of 1 value percent_move of NG
)
)