| 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...
Cypress Creek Data set for 1945 to 1984 for maximum annual flow. Year Flow (cfs) 1945 9840 1946 5170 1947 235 1948 15600 1949 4740 1950 427 1951 3310 1952 4400 1953 7760 1954 2520 1955 340 1956 5440 1957 3000 1958 3690 1959 10300 1960 6260 1961 1360 1962 1000 1963 2770 1964 1400 1965 3210 1966 1110 1967 5230 1968 4300 1969 2820 1970 1900 1971 3980 1972 6560 1973 4710 1974 3460 1975 3080 1976 2730 1977...
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...