fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

BUS5SBF Statistics For Business And Finance

tag 0 Download2 Pages / 265 Words
  • Course Code: BUS5SBF
  • University: La Trobe University

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

Create the line charts for each of S&P, Yahoo and Google series using Close prices against time in Excel and comment on your observations (focusing time series features).
a. Calculate returns for these three series in Excel using the transformation: rt = 100 ln[Pt/Pt-1]
Hints:
• We performed a similar task in Tutorial 01.
• These numbers would represent percentages after multiplication with 100 in the formula above. However,you would not put a percentage sign in your data. For example, returns for two periods are 0.35% and 0.41% but we omit % sign in our excel worksheet and use 0.35 and 0.41.
b. Obtain the summary statistics for your sample and briefly discuss the risk and average return relationship in each stock. Which stock (Google or Yahoo) is relatively riskier than the other.
c. Perform the Jarque-Berra test of normally distributed returns for each of Yahoo, Google and S&P
 
Write down the sampling distribution of sample means for both stocks when a sample of 36 months is taken. Use the sampling distributions of part (a) above to answer the following parts.
b. What is the probability of observing average return of at least 4% in both stocks
c. What is the likelihood of loss in a sample of 36 periods for both stocks

Before investing in one of the two stocks based on higher risk-return relationship, you further want to determine
whether both stocks have same population average return. Perform an appropriate hypothesis test using information in your actual sample of 56 observations and report your findings. Also, which stock will you prefer and why.

Create two new columns in Excel for excess return on your preferred stock (yt) and excess market return (xt) by subtracting the 10-year T-Bill rate from both series as follows.
Excess return on your preferred stock: yt = rt - rf,t
Excess return on market: xt = rM,t - rf,t.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Statistics For Business And Finance. Retrieved from https://myassignmenthelp.com/free-samples/bus5sbf-statistics-for-business-and-finance/in-google-series.html.

My Assignment Help (2021) Statistics For Business And Finance [Online]. Available from: https://myassignmenthelp.com/free-samples/bus5sbf-statistics-for-business-and-finance/in-google-series.html
[Accessed 02 December 2021].

My Assignment Help. 'Statistics For Business And Finance' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/bus5sbf-statistics-for-business-and-finance/in-google-series.html> accessed 02 December 2021.

My Assignment Help. Statistics For Business And Finance [Internet]. My Assignment Help. 2021 [cited 02 December 2021]. Available from: https://myassignmenthelp.com/free-samples/bus5sbf-statistics-for-business-and-finance/in-google-series.html.


At MyAssignmenthelp.com, we are committed to deliver quality assignment assistance in the fastest way possible. To make our service delivery fast, we have hired subject matter experts to work on different subject specific assignments. We have hired experts who owe in-depth knowledge in their respective subjects. As per their expertise, they provide geography assignment help, Physics assignment help, Strategic assignment help, history assignment help, art architecture assignment help and assistance with other subjects as well.

Latest Statistics Samples

STAT 101 Introduction To Statistics

Download : 0 | Pages : 2
  • Course Code: STAT101
  • University: Coquitlam College

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Canada

Answer: T-tests T-tests are the most common statistical data analysis procedures used for testing hypothesis in statistics (Fagerland, 2012, pp.12-78). We have several types of t-tests, but the most commonly used t-test is the two sample t-test also called the student’s t-test. The two sample t-test normally tests whether two independent populations have some different mean values. In our case, we’ll compare the real mean weight o...

Read More arrow

PSM510 Problem Analysis And Statistics

Download : 0 | Pages : 3
  • Course Code: PSM510
  • University: University Of London

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: United Kingdom

Answer:      At the time of setting up of a chain of coaching centers, certain factors need to be taken into consideration. These factors have significant contribution towards the success of these coaching centers. Apart from this, the investors take into consideration at the time of making the investment decisions. In case of setting up the coaching center chain in two of the States of Victoria, these factors need to be considere...

Read More arrow Tags: Australia Eumemmerring Management Information systems for business University of New South Wales Masters in Business Administration 

STA101 Statistics For Business

Download : 0 | Page : 1
  • Course Code: STA101
  • University: Deakin University

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Answer: t-Test: Two-Sample Assuming Unequal Variances Mean 20.225 Variance 1.543 Observations 51 Hypothesized Mean Difference 0 df 93 t Stat -3.553 P(T<=t) one-tail 0.000 t Critical one-tail 1.661 P(T<=t) two-tail 0.001 t Critical two-tail 1.986 Mean 23 Standard Error 0.438261532 Median 22 Mode 22 Standard Deviation 2.80624304 Sample ...

Read More arrow Tags: Australia Lilyfield Management Humanities University of New South Wales 

BUS5SBF Statistics For Business And Finance

Download : 0 | Pages : 6
  • Course Code: BUS5SBF
  • University: La Trobe University

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Answers: Task 1 The given dataset contains information about 2000 households. A random sample of 200 households have been selected from the dataset using the technique of simple random sampling. Sampling has been done randomly as this is the most appropriate sampling technique that can be applied in this situation. There are certain advantages of this sampling technique for which this technique has been selected to be used for sampling. The...

Read More arrow Tags: Australia 34 Statistics for Business and Finance Other 

STA2300 Data Analysis

Download : 0 | Pages : 3

Answers 1a. The appropriate model to represent the variable of interest in the given case would be binomial distribution. The relevant parameters associated with the model are probability of success (p), number of trials (n) and number of successes (x) that are desired.  b. The conditions of binomial distribution are satisfied in the given case as indicated below. The given study consists of 20 trials being conducted. There are only tw...

Read More arrow Tags: Australia Bonnyrigg Management University of New South Wales Masters in Business Administration 
Next

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?