To answer this question,use the data on bitcoinprices from the final exam's data file.

Use the data on Bitcoin prices for the first three quarters of 2017 to answer the following questions (assume the data points are daily, i.e., evenly spaced):

1. Using all the data, develop a 3-period moving average to forecast the Bitcoin price on October 1. Report the October 1 forecast, the MSE, and the MAPE.
2. Using only data for the 1^st of each month (again, assume the data points are evenly spaced), develop a 3-period moving average to forecast the Bitcoin price on October 1. Report the October 1 forecast, the MSE, and the MAPE.
3. The actual October 1 Bitcoin price was $4,404.30. How did each of your forecasts fare? Why is this the case?

Data is below:

Date Price 1/1/2017 998.99 d 1/2/2017 1,019.30 1/3/2017 1,037.50 1/4/2017 1,139.60 1/5/2017 1,003.20 1/6/2017 898 1/7/2017 908.84 1/8/2017 915.9 1/9/2017 903 1/10/2017 905.76 1/11/2017 778.58 1/12/2017 804.58 1/13/2017 828.12 1/14/2017 815.3 1/15/2017 820.74 1/16/2017 830.1 1/17/2017 903.99 1/18/2017 887.76 1/19/2017 900.29 1/20/2017 895.96 1/21/2017 924.02 1/22/2017 923.72 1/23/2017 910.03 1/24/2017 886.1 1/25/2017 893.35 1/26/2017 915.12 1/27/2017 916.7 1/28/2017 919.43 1/29/2017 912.56 1/30/2017 917.36 1/31/2017 966.19 2/1/2017 983.73 2/2/2017 1,005.70 2/3/2017 1,015.70 2/4/2017 1,031.10 2/5/2017 1,006.60 2/6/2017 1,022.60 2/7/2017 1,052.10 2/8/2017 1,048.80 2/9/2017 984.97 2/10/2017 992 2/11/2017 1,000.30 2/12/2017 996.01 2/13/2017 996.5 2/14/2017 1,013.70 2/15/2017 1,013.80

2/16/2017 1,038.40 2/17/2017 1,056.20 2/18/2017 1,059.80 2/19/2017 1,056.20 2/20/2017 1,091.20 2/21/2017 1,129.60 2/22/2017 1,125.30 2/23/2017 1,190.90 2/24/2017 1,185.10 2/25/2017 1,153.00 2/26/2017 1,178.30 2/27/2017 1,195.50 2/28/2017 1,189.10 3/1/2017 1,232.80 3/2/2017 1,262.30 3/3/2017 1,288.20 3/4/2017 1,267.80 3/5/2017 1,278.40 3/6/2017 1,279.30 3/7/2017 1,232.40 3/8/2017 1,149.30 3/9/2017 1,190.40 3/10/2017 1,113.60 3/11/2017 1,172.80 3/12/2017 1,225.20 3/13/2017 1,238.50 3/14/2017 1,245.00 3/15/2017 1,256.10 3/16/2017 1,169.00 3/17/2017 1,068.40 3/18/2017 971 3/19/2017 1,016.10 3/20/2017 1,039.00 3/21/2017 1,115.00 3/22/2017 1,039.10 3/23/2017 1,033.00 3/24/2017 943.1 3/25/2017 972.17 3/26/2017 969 3/27/2017 1,042.70 3/28/2017 1,044.70 3/29/2017 1,041.80 3/30/2017 1,041.00 3/31/2017 1,081.70 4/1/2017 1,093.20 4/2/2017 1,107.60 4/3/2017 1,150.20

4/4/2017 1,145.00 4/5/2017 1,140.60 4/6/2017 1,191.50 4/7/2017 1,196.60 4/8/2017 1,188.10 4/9/2017 1,215.90 4/10/2017 1,220.30 4/11/2017 1,235.60 4/12/2017 1,227.40 4/13/2017 1,187.00 4/14/2017 1,206.80 4/15/2017 1,193.30 4/16/2017 1,212.00 4/17/2017 1,240.00 4/18/2017 1,265.40 4/19/2017 1,260.50 4/20/2017 1,308.40 4/21/2017 1,325.60 4/22/2017 1,347.50 4/23/2017 1,355.20 4/24/2017 1,345.00 4/25/2017 1,370.30 4/26/2017 1,399.30 4/27/2017 1,440.30 4/28/2017 1,415.60 4/29/2017 1,423.60 4/30/2017 1,435.20 5/1/2017 1,533.10 5/2/2017 1,560.00 5/3/2017 1,617.80 5/4/2017 1,607.10 5/5/2017 1,545.10 5/6/2017 1,597.10 5/7/2017 1,619.90 5/8/2017 1,703.20 5/9/2017 1,760.00 5/10/2017 1,796.80 5/11/2017 1,853.90 5/12/2017 1,735.00 5/13/2017 1,820.40 5/14/2017 1,828.10 5/15/2017 1,772.50 5/16/2017 1,785.70 5/17/2017 1,870.00 5/18/2017 1,941.50 5/19/2017 1,966.50 5/20/2017 2,059.70

5/21/2017 2,029.20 5/22/2017 2,085.50 5/23/2017 2,249.30 5/24/2017 2,394.80 5/25/2017 2,252.00 5/26/2017 2,127.30 5/27/2017 1,972.30 5/28/2017 2,056.60 5/29/2017 2,207.40 5/30/2017 2,146.70 5/31/2017 2,191.83 6/1/2017 2,311.60 6/2/2017 2,405.88 6/3/2017 2,461.00 6/4/2017 2,488.20 6/5/2017 2,636.20 6/6/2017 2,843.60 6/7/2017 2,642.63 6/8/2017 2,782.10 6/9/2017 2,809.00 6/10/2017 2,806.00 6/11/2017 2,936.30 6/12/2017 2,571.80 6/13/2017 2,676.40 6/14/2017 2,395.04 6/15/2017 2,377.40 6/16/2017 2,437.00 6/17/2017 2,610.00 6/18/2017 2,491.50 6/19/2017 2,580.80 6/20/2017 2,712.20 6/21/2017 2,621.20 6/22/2017 2,672.80 6/23/2017 2,674.90 6/24/2017 2,502.60 6/25/2017 2,477.70 6/26/2017 2,394.60 6/27/2017 2,521.20 6/28/2017 2,518.20 6/29/2017 2,470.10 6/30/2017 2,420.70 7/1/2017 2,349.50 7/2/2017 2,445.00 7/3/2017 2,524.00 7/4/2017 2,582.60 7/5/2017 2,598.50 7/6/2017 2,593.10

7/7/2017 2,479.30 7/8/2017 2,542.00 7/9/2017 2,478.00 7/10/2017 2,318.30 7/11/2017 2,282.10 7/12/2017 2,374.40 7/13/2017 2,329.00 7/14/2017 2,205.10 7/15/2017 1,978.60 7/16/2017 1,924.90 7/17/2017 2,219.00 7/18/2017 2,302.10 7/19/2017 2,253.10 7/20/2017 2,856.30 7/21/2017 2,664.00 7/22/2017 2,845.70 7/23/2017 2,747.50 7/24/2017 2,769.70 7/25/2017 2,560.90 7/26/2017 2,525.70 7/27/2017 2,664.90 7/28/2017 2,784.80 7/29/2017 2,714.10 7/30/2017 2,749.00 7/31/2017 2,856.00 8/1/2017 2,731.20 8/2/2017 2,702.00 8/3/2017 2,790.30 8/4/2017 2,860.00 8/5/2017 3,256.40 8/6/2017 3,227.90 8/7/2017 3,396.70 8/8/2017 3,415.00 8/9/2017 3,339.90 8/10/2017 3,407.90 8/11/2017 3,644.10 8/12/2017 3,865.50 8/13/2017 4,053.30 8/14/2017 4,319.50 8/15/2017 4,151.90 8/16/2017 4,386.30 8/17/2017 4,260.00 8/18/2017 4,090.20 8/19/2017 4,145.10 8/20/2017 4,064.30 8/21/2017 4,002.50 8/22/2017 4,074.00

8/23/2017 4,129.10 8/24/2017 4,325.20 8/25/2017 4,351.50 8/26/2017 4,341.70 8/27/2017 4,331.80 8/28/2017 4,383.80 8/29/2017 4,587.10 8/30/2017 4,569.00 8/31/2017 4,718.20 9/1/2017 4,904.90 9/2/2017 4,534.40 9/3/2017 4,595.00 9/4/2017 4,200.40 9/5/2017 4,374.90 9/6/2017 4,589.10 9/7/2017 4,613.50 9/8/2017 4,305.80 9/9/2017 4,317.90 9/10/2017 4,232.10 9/11/2017 4,203.00 9/12/2017 4,142.90 9/13/2017 3,849.70 9/14/2017 3,238.10 9/15/2017 3,698.00 9/16/2017 3,685.40 9/17/2017 3,666.30 9/18/2017 4,084.10 9/19/2017 3,900.00 9/20/2017 3,873.20 9/21/2017 3,603.40 9/22/2017 3,598.50 9/23/2017 3,779.60 9/24/2017 3,652.80 9/25/2017 3,930.00 9/26/2017 3,879.10 9/27/2017 4,205.40 9/28/2017 4,190.00 9/29/2017 4,169.90 9/30/2017 4,367.00