\$20 Bonus + 25% OFF

# ECON 1095 Quantitative Methods In Finance

0 Download6 Pages / 1,455 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
• Course Code: ECON 1095
• University: Royal Melbourne Institute Of Technology
• Country: Australia

## Questions:

Question 1

(a)If you roll a dice 12 times what is the probability that you will roll two 6s? Work out both by hand and using the EXCEL function for the Binomial distribution.
(b)If you roll a dice 12 times what is the probability that you will roll more than two 6s? Work out using the EXCEL function for the Binomial distribution only (that is, don’t worry about doing this calculation by hand).
(c)If you roll a dice 12 times what is the mean and the variance of the number of 6s you will throw? Please use the Binomial formulas (Mean = n.p, Variance = n.p.(1 - p)) to work these out and then check using EXCEL and the general formulas for the mean and variance of any probability distribution:
??= i P(X i) and ?? = (Xi - ?)2P(Xi)
(d)If you roll a dice 12 times what is the skewness and kurtosis of the number of 6s you will throw? Please just use EXCEL to work this out.

Question 2

It is often thought that the Australian share market takes its lead from America. To look at this you examine the monthly returns from the Australian and US share markets from 2007 to 2017. The data to be used for this question is in the Excel file ECON1095 Data Sem 1 2018.xls on Canvas.
(a)Using all of the available data for Share prices: Australia: S&P/ASX 200 (AUS) and the Share prices: United States: United States: S&P 500 (USA), examine the relationship between these two variables. To do this, graph the two variables against each other. You may do a number of graphs; that is, both as levels and as returns[ Do this as continuous returns.] and as XY graphs and as line (time series) graphs. Does it look as though the variables are dependent or independent?
(b)As a further test calculate the correlation coefficient between the AUS and USA (tools, data analysis, correlation). Again, do this both for the levels and the returns. Please interpret this coefficient and offer a brief explanation for the result.
(c)Using the same data fill in the following table for the number of rises and falls[ You will find the IF function in EXCEL very useful when filling in this table.].

AUS

USA

Rise No change Fall Total
Rise
No change
Fall
Total

(d)Calculate the joint probability distribution and the marginal probability distributions for the data.
(e)Using your previous answers as a guide, make a decision regarding whether the AUS and USA are dependent or independent?
(f)Due to the potential trade war between the US and China you expect the US share returns market to fall in the near future. Calculate the conditional probability distribution for AUS given that USA has decreased. Explain how this calculation could be used to guide your Australian investment decisions.

Question 3

You are considering moving additional funds into the Australian share market. To assist with this decision you analysis AUS from 2007 to 2017 in more detail (from the QUESTION 2 data set). I suggest using Excel’s Tools/Data Analysis/Descriptive Statistics on the continuous returns to answer these questions.
(a)Calculate the 95 % confidence interval for the AUS returns over this period. Please interpret this confidence interval.
(b)You decide that you are only prepared to put more money into Australian shares if you can confidently rule out negative returns. Therefore, the decision is to invest only if you believe that monthly returns will not go below zero. Average monthly returns for the sample period are below zero, therefore you would clearly not invest using this rule. However, you know that the early part of the sample period includes the Global Financial Crisis (GFC) and as you do not anticipate another GFC in the immediate future you decide to start the sample in 2009 (use a sample from 2009 to 2017 to answer the rest of this question). Using this smaller sample the average monthly returns should be just above zero. Therefore the question is, have monthly returns on the AUS been far enough above zero for you to be convinced that they will not go negative in the near future?’ Test to see whether the returns are less than or equal to zero using a level of significance of ??????????Would you invest?
(c)Test to see whether the AUS has a normal distribution using the Jarque-Bera test. This must be done in Excel, by calculating the Jarque-Bera statistic using the formulas from the notes and Excel’s Tools/Data Analysis/Descriptive Statistics.[ Note that when Excel calculates kurtosis it subtracts 3 from the value.] Using the results of this test, comment on the accuracy of the probabilities you calculated in parts (a) and (b) of this question.
(d)The AUS monthly returns over the sample period are negatively skewed. Explain why this is the case, and then explain the implications of this for your investment decision.
(e)Using the continuous returns on AUS, determine whether the rises and falls are independent using a runs test. What are the implications of your findings?

Question 4

An individual's utility function is represented by:
Their budget constraint is:
That is, their total budget is \$10,000 and the price of X1 is \$2 and the price of X2 is \$5. Use the Lagrangian function to find the optimal values of X1 and X2 that maximises utility subject to the budget constraint[ There is no need to check the second order conditions.]. What is the value of ? and what is its interpretation?

Check your answer using EXCEL. To do this open a new spread sheet and insert names for X1 and X2 in cells B2 and C2 and the starting values for these variables of 1 in both cells B3 and C3. Use the Insert, Name, Define commands to name cells B3 and C3. In cell B6 type the formula for the utility function, = (Xone^0.9)*(Xtwo^0.1) and name this UU. In cell B9 type the formula for the budget, =2*Xone+5*Xtwo and name this BB. Next, go to the solver and set target cell UU equal to maximum by changing Xone and Xtwo. Then add the constraint that BB = 10,000, then solve. When given the solver results ask for the sensitivity report as this gives ?.
(2 marks)

Question 5

Using the following matrices:

(a)State the dimensions of A, B and C.
(b)Find A.B
(c)Find B.C
(d)Find A.C’
(e)Using excel find C-1, then multiply C-1 by C to find I.
Do (b), (c), (d) and (e) using excel.

Question 6 (Please Use Excel For This Question).
You are trying to diversify your investments across different share markets around the world and so want to construct an efficient frontier. Follow the instructions presented below to construct the efficient frontier for the proportions of your funds that need to be allocated to the various markets (there are additional instructions in the Mathematical Programming notes).

Using the file ECON1095 Data Sem 1 2018.xls and the entire sample from 2007 to 2018 as a guide, an investor would like to allocate their funds across the shares markets of USA, Japan, Euro area, UK, New Zealand, Hong Kong, Taiwan, Korea, China and Australia in an optimal way by finding the various efficient allocations. An efficient allocation of funds is one in which expected risk is minimised for a given level of expected return. A graph of the possible optimal values of the returns and risk is called the efficient frontier.

Calculate the average continuous monthly returns, then convert the average monthly returns to yearly returns by multiplying each by 12. Transpose this block of cells and name the average returns Ret. Use the covariance command from EXCEL’s Data Analysis Tools to find the variance-covariance matrix for these monthly returns. This matrix is symmetrical, so the missing elements can be easily filled in. Name this matrix Mvac. Convert Mvac into the variance-covariance matrix for yearly returns by highlighting the cells and entering =12*Mvac [Ctrl]+[Shft]+[Enter]. Name this block Vac. Enter the initial guesses for the optimal weights for the shares and name this block of cells Wts. Transpose these weights and name this block Twts. Find the expected return for the portfolio using =MMULT (Wts, Ret) [Ctrl]+[Shft]+[Enter]. Call this cell Pret. Finding the variance of portfolio returns requires three stages. First, highlight the appropriate cells and enter =MMULT (Wts,Vac) [Ctrl]+[Shft]+[Enter]. Name this block Tvac. Second, highlight a single cell and enter =MMULT (Tvac, Twts) [Ctrl]+[Shft]+[Enter]. Call this cell Pvar. Next, find the portfolio risk, or square root of the portfolio variance and name this cell Prsk. To ensure that the portfolio weights sum to one, enter ten 1’s and name this block Unit. To find the expression for the sum of the weights by entering =MMULT (Unit, Twts) [Ctrl]+[Shft]+[Enter]. Name this cell Wtcn.

Using this work sheet and the EXCEL Solver Tool find the minimum risk for the funds allocations for the various expected returns (I suggest performing the exercise for about ten different expected returns, chosen to ensure a solution can be found). In each case you must constrain the weights so they are non-negative and sum to one. Use these values to graph the Efficient Frontier with risk on the horizontal axis and returns on the vertical axis.

Write a brief report explaining how your portfolio changes as you try different expected returns.

Question 7

The data to be used for this question is in the Excel file ECON1095 Data Sem 1 2018.xlsx on Canvas. Using all of the available data for returns on Share prices: Australia: S&P/ASX 200 (RAUSt) and the returns for Share prices: United States: S&P 500 (RUSAt); examine the relationship between these two variables via regression. That is, use regression analysis to estimate RAUSt = ?0 + ?1RUSAt. This should be done using the three approaches used in the example on the Canvas (sample regression example.xlsx). All three approaches should yield the same answer. That is:
(a)Use the solver to find the values of ?0 and ?1 that minimize ei2.
(b)Ensure that the values of ?0 and ?1 satisfy the normal equations.
(c)Use Excel’s regression function to confirm your results in parts (a) and (b).
(d)Next, it is often thought that the Australian economy is driven by what happens in both America (US) and China. Test this by estimating a multiple regression where returns on Australian shares are a function of returns on both the US and Chinese share (China: Shanghai A), but do this using excel and the matrix formula = (XX)-1Xy , then check your results using the regression function in excel. Interpret your results.

### Cite This Work

My Assignment Help (2020) Quantitative Methods In Finance [Online]. Available from: https://myassignmenthelp.com/free-samples/econ-1095-quantitative-methods-in-finance/conditional-probability.html
[Accessed 06 December 2020].

My Assignment Help. 'Quantitative Methods In Finance' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/econ-1095-quantitative-methods-in-finance/conditional-probability.html> accessed 06 December 2020.

My Assignment Help. Quantitative Methods In Finance [Internet]. My Assignment Help. 2020 [cited 06 December 2020]. Available from: https://myassignmenthelp.com/free-samples/econ-1095-quantitative-methods-in-finance/conditional-probability.html.

### Latest Management Samples

#### MN603 Wireless Networks And Security

Answers: 1. Strengths and Weaknesses of Yagi, Horn Cellular and New Digital Antennas i) Yagi Antennas: Yagi antenna is a bidirectional antenna that is composed of parallel elements within one specific line or even the half wave dipole. This type of dipole is composed of metal rod (Lei et al., 2013). Yagi uda antenna is eventually linked with transmitter and thus it is being utilized as the high gain antenna over the ultra high frequency band...

• Course Code: BPD1100
• University: Victoria University
• Country: Australia

Answers: Introduction The main motive of this paper is to outline the significance and role of culture in Disney. Disney is one of the biggest and leading providers and producers of information and entertainment. The culture of Bangkok also has been discussed in the task. Cultural considerations important to business in general It is stated that cultural considerations are significant to the effectiveness and efficiency of any counseling ap...

#### MNG81001 Management Communication

• Course Code: MNG81001
• University: Southern Cross University
• Country: Australia

Answer: The effective communication is essential in an organization because it helps to perform the basic functions of management starting with planning, organizing, controlling and leading. The managers of the organization be facilitated to accomplish the organizational goals and manage the workforce. There are many skills that are used to communicate well in the organization.  The personal and interpersonal skills are important for comm...

#### MGMT5904 Organisational Change Management

Answer: Annotated bibliography of two articles Millar, C., Hind, P., & Magala, S. (2012). Sustainability and the need for change: organisational change and transformational vision. Journal of Organizational Change Management, 25(4), 489-500. Synopsis of the article The article “Sustainability and the need for change: organisational change and transformational vision” by Millar, Hind and Magala  (2012) focused ...

#### ECON1020 Introductory Macroeconomics

• Course Code: ECON1020
• University: The University Of Queensland
• Country: Australia

Answers: What is monetary policy? The role of the reserve bank of Australia is to maintain a stable economic environment within the country. The bank formulates monetary and fiscal policies aimed at maintaining stability and fostering a stable financial system. Monetary policies consist of decisions and actions that ensure that money supply in the economy match growth and price goals of the government (Parliament of Australia, 2017). The majo...

Read More Tags: Australia Doncaster Management nursing University of New South Wales
Next

### Save Time & improve Grade

Just share requirement and get customized Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

416 Order Completed

95% Response Time

### Tyler Moore

#### Washington, United States

5/5

2109 Order Completed

99% Response Time

### Emma Zhong

#### Singapore, Singapore

5/5

134 Order Completed

95% Response Time

### Thomas Nelson

#### New Jersey, United States

5/5

529 Order Completed

95% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

The expert completed the task within a few hours wow . It was a very good job done. Very nicely written . Overall well articulated with APA style references.

#### User Id: 394056 - 05 Dec 2020

Australia

It is a effective and satisfactory work which is done within 2 hour after the order.

#### User Id: 561904 - 05 Dec 2020

Australia

dadasdadasdak askd asd asd asd asd asd as asdasd asd as asda sda das dasd asd asd asd asd asd asd asd as das das da sdas asd as das daa sda dasd asd asd asd asd asd asd asd asd a

#### User Id: 161623 - 03 Dec 2020

Australia

Thank you very much for your assistance. The proposals were well written, and beyond my expectations. Thank you again.

Australia