year | price | 3 period moving average | error^2 |
1946 | 106.5058955 | ||
1947 | 109.3296707 | ||
1948 | 101.2225795 | ||
1949 | 100.0466076 | 105.6860486 | 31.80329 |
1950 | 105.8948393 | 103.5329526 | 5.578509 |
1951 | 103.8986687 | 102.3880088 | 2.282093 |
1952 | 103.9743275 | 103.2800385 | 0.482037 |
1953 | 114.7133093 | 104.5892785 | 102.496 |
1954 | 114.199126 | 107.5287685 | 44.49367 |
1955 | 115.4621261 | 110.9622543 | 20.24885 |
1956 | 115.3166155 | 114.7915205 | 0.275725 |
MSE | 25.95752 |
yt = (yt-1 + yt-2 + yt-3)/3
error = actual - predicted
MSE = 25.95752
=25.96
The table below is the data set of the Shiller Real Home Price Index for the years 1946-1956 Real Home Price Year 1946 Index 106.5058955 1947 109.3296707 1948 101.2225795 100.0466076 1950 105.894...
Table 12.1 (below)TABLE 12.1 Year-to-Year Total Returns: 1926–2019YearLarge-Company StocksLong-Term Government BondsU.S. Treasury BillsConsumer Price Index192611.62%7.77%3.27%–1.49%192737.498.933.12–2.08192843.61.103.56–.971929–8.423.424.75.201930–24.904.662.41–6.031931–43.34–5.311.07–9.521932–8.1916.84.96–10.30193353.99–.07.30.511934–1.4410.03.162.03193547.674.98.172.99193633.927.52.181.211937–35.03.23.313.10193831.125.53–.02–2.781939–.415.94.02–.481940–9.786.09.00.961941–11.59.93.069.72194220.343.22.279.29194325.902.08.353.16194419.752.81.332.11194536.4410.73.332.251946–8.07–.10.3518.1619475.71–2.62.509.0119485.503.40.812.71194918.796.451.10–1.80195031.71.061.205.79195124.02–3.931.495.87195218.371.161.66.881953–.993.641.82.62195452.627.19.86–.50195531.56–1.291.57.3719566.56–5.592.462.861957–10.787.463.143.02195843.36–6.091.541.76195911.96–2.262.951.501960.4713.782.661.48196126.89.972.13.671962–8.736.892.731.22196322.801.213.121.65196416.483.513.541.19196512.45.713.931.921966–10.063.654.763.35196723.98–9.184.213.04196811.06–.265.214.721969–8.50–5.076.586.1119703.8612.116.525.49197114.3013.234.393.36197219.005.693.843.411973–14.69–1.116.938.801974–26.474.358.0012.20197537.239.205.807.01197623.9316.755.084.811977–7.16–.695.126.7719786.57–1.187.189.03197918.61–1.2310.3813.31198032.50–3.9511.2412.401981–4.921.8614.718.94198221.5540.3610.543.87198322.56.658.803.8019846.2715.489.853.95198531.7330.977.723.77198618.6724.536.161.1319875.25–2.715.474.41198816.619.676.354.42198931.6918.118.374.651990–3.106.187.816.11199130.4719.305.603.0619927.628.053.512.90199310.0818.242.902.7519941.32–7.773.902.67199537.5831.675.602.54199622.96–.935.213.32199733.3615.855.261.70199828.5813.064.861.61199921.04–8.964.682.682000–9.1021.485.893.392001–11.893.703.831.552002–22.1017.841.652.38200328.681.451.021.88200410.888.511.203.2620054.917.812.983.42200615.791.194.802.5420075.499.884.664.082008–37.0025.871.60.09200926.46–14.90.102.72201015.0610.14.121.5020112.1127.10.042.96201216.003.43.061.74201332.39–12.78.021.51201413.6924.71.02.7620151.38–.65.02.73201611.961.75.202.07201721.836.24.802.112018–4.38–.571.811.91201931.4912.162.142.29Questions:a.Calculate the arithmetic average returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)b.Calculate the standard deviation of the returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)c-1.Calculate the observed risk premium...
Write MySQL query statements for the questions below including
the output that proves the accuracy of your solution. Your answers
should be stored in a text file that captures your interaction with
MySQL.
1. Find the movieID, title, year and DVDPrice of all movies
where the DVD-Price is equal to the discountPrice.
2. Find the actorID, lastName, firstName, middleName, and suffix
of all actors whose middleName is not NULL.
3. Suppose you remember a movie quote as “Play it again,...
write a SQL statements to perform the following: Select all years a World Series game was played Select all losing teams that played in a World Series game Select all winning and losing teams that played in a World Series game Select all cities of a winning or losing team that played in a World Series game Select all winning and losing teams that played in a World Series game, and provide aliases of "Winning Team" and "Losing Team" Select...