Question 2The following data relates to Company 2's share prices and therelevant market indices.Period Company 2' share prices Market indicesDec-221.23234Nov-221.15225Oct-221.12222Sep-220.98216Aug-221.24226Jul-221.36230Jun-221.29228May-221.25217Apr-221.17206Mar-221.2207Feb-221.15217Jan-221.19213RequiredEstimate the beta for Company 2 using the data above.You may use the data provided and run an OLS regression onExcel. If you do this, you must explain the steps that you take toapply the data to the regression and provide the regressionoutput in your answer.Alternatively, you may use the covariance-variance method toestimate the beta value. If you do this, you must provide the fullworkings for each step.

PeriodCompany 2' share pricesMarket indicesDec - 221.23234Nov - 221.15225Oct - 221.12222Sep…

Answered: Question 2 The following data relates…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Provide an appropriate chart for the following data
Stock Market Listed on the top of the next page in order by row are the annual high values of the Dow Jones Industrial Average for each year beginning with 1990. Find the best model and then predict the value for the year 2014 (the last year listed). Is the predicted value close to the actual value of 18,054?
Table 1 displays data for money aggregates released by the Central Bank, Country A for the years 2019 - 2021. TABLE 1 2020 (Jan) $ Million 2021 (Jan) 2019 (Jan) $ Million Items $ Million Repurchase agreements Currency in circulation Demand deposits Fixed deposits with commercial banks, Islamic banks and central bank 50.8 105,091.5 344,140.6 0.0 53.5 101,254.1 326.976.9 1,130,449.7 123,007.5 412,203.8 1,158,924.1 1,120,366.7 Foreign currency deposits with commercial banks, Islamic banks and central bank Deposits placed with other banking institutions 145,887.1 155,502.5 159,817.5 9,698.1 10,556.70 2,558.7 Saving deposits with commercial banks Negotiable instruments of deposits 162,067.8 172,797.0 218,820.0 12,375.3 14,366.6 8,824.5 a) Based on the data in Table 1, answer the following questions: i) What is the value of quasi money in 2020? ii) Calculate the values of M2 for 2021
From the data in the table it shows the 2019 daily return data for the S&P 500 Index (stocks) and the US 30 year Bond (bonds). How do I test the hypothesis that mean daily return on stocks exceeds the mean daily return on bonds? Please show the steps. S&P500 dailt returns data: Date Price Daily Return 2019-12-31 3230.78 0.294602% 2019-12-30 3221.29 -0.578082% 2019-12-27 3240.02 0.003398% 2019-12-26 3239.91 0.512817% 2019-12-24 3223.38 -0.019545% 2019-12-23 3224.01 0.086614% 2019-12-20 3221.22 0.494478% 2019-12-19 3205.37 0.445929% 2019-12-18 3191.14 -0.043230% 2019-12-17 3192.52 0.033529% US 30 Year Bond Date Price Daily Return 31-Dec-19 2.389 2.32% 30-Dec-19 2.335 0.78% 29-Dec-19 2.317 -0.03% 27-Dec-19 2.318 -0.16% 26-Dec-19 2.321 -0.71% 25-Dec-19 2.338 0.15% 24-Dec-19 2.334 -0.83% 23-Dec-19 2.354 0.31% 22-Dec-19 2.346 0.12% 20-Dec-19 2.344 -0.43%
Quarterly Glass Container Demand Year 1990 1991 1992 First Qtr. 17,446. 17,748. 17,595. Second Qtr. 17,785. 19,360. 18,338. Third Qtr. 18,971. Fourth Qtr. 19140. 17,802. 19,413. 18,315. 18,083. Question: Quarterly sales (in thousands of units) of a product over the last two years have been 26, 29, 30, 27, 28, 32, 33, and 30. Plot the data and forecast for the next period using Winter's Seasonal Model. Now, assume sales for the ninth quarter turned out to be 32. Update your parameter estimates and forecast sales for period 10.
Data for a particular country on consumer debt (as a percentage of personal income) and mortgage debt (also as a percentage of personal income) for the 10 years from 2006 to 2015 are shown in the following table. Consumer Debt r = 6.72 7.07 6.97 6.69 6.19 5.58 5.15 4.95 4.74 4.59 Mortgage Debt 5.96 5.97 5.88 5.60 5.17 5.06 4.96 5.22 5.30 5.45 (a) What is the value of the correlation coefficient for this data set? (Round your answer to four decimal places.)
Use the data from the following four stocks to answer the questions below: Yields Year TLS DI PFE WMT 20x5 12.00% 4.50% 5.80% 11.30% 20x6 13.30% 5.30% 5.70% 9.00% 20x7 10.20% 3.10% 5.90% 13.90% 20x8 9.30% 2.70% 4.50% 14.80% 20x9 8.60% 1.90% 6.30% 15.00% a. Classify the correlations between each pair of stocks as positive correlation (PC), perfectly positive correlation (PPC), negative correlation (NC), perfectly negative correlation (PNC), and no correlation (NC): TLS – DI ___________ DI – PFE __________ TLS – PFE __________ DI – WMT _________ TLS – WMT _________ PFE – WMT _________
47. Given the following data : Weekly take-home pay (wages) Consumer price index Year 109.50 112.8 2012 2013 112.20 118.2 2014 116.40 127.4 2015 125.08 138.2 2016 135.40 143.5 2017 138.10 149.8 () What was the real average weekly wage for each year ? (i) In which year did the employees have the greatest buying power ? (ii) What percentage increase in the weekly wages for the year 2017 is required (if any) to provide the same buying power that the employees enjoyed in the year in which they had the highest real wages ?
Provide an appropriate chart for the given data
Use no. 16 in table 2 whenever necessary. Indicate the steps in doing it on excel file.
The following table shows the average monthly production of coal in tonnes for the year 2010-2019. Year Production (in tonnes) Year Production (in tonnes) 2010 50.0 2015 38.1 2011 36.5 2016 32.6 2012 43.0 2017 41.7 2013 44.5 2018 41.1 2014 38.9 2019 33.8 Compute the price indices from 2010 to 2019 by taking 2019 as the base year. Compare the price of 2014 and 2017. What is the percentage (%) change in the production from 2016 to 2019?

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS