CALCULATE BETA Assignment Help

UK Assignment Help

CALCULATE BETA Assignment Help



1. Go to https://au.finance.yahoo.com 

2. On the right-hand side, under “Quote Lookup”,

type in the name of your company allocated to your group. 

3. Make sure that you choose a company that is listed in the Australian Security Exchange.   This is usually shown as XYZ.AX if the company is XYZ. 

4. Select Historical Data 

5. Type in the time period.  e.g. Start Date: 8/9/2018, End Date: 8/9/2019. 

The date convention (Australia or US) will depend on the computer you are using. 

6. Under frequency, choose “weekly”   

7. Select “Apply”  8. Select “Download Data” 

9. Open with “Microsoft Excel” 

10. Save as - File Name: XYZ, and type : Excel Workbook 

11. Repeat Step 2 to Step 9 for ^AORD.  This index represents the price of the market portfolio.

12. Save as - File Name: AORD, and type: Excel Workbook 

13. For both files (10 and 12)

keep only the Date and the Adj Close columns.  Delete other columns.  14.

Copy the Adj Close data in AORD to the XYZ file.  Refer to the attached Excel example.  15. Label Y-Axis Security Return, and X-Axis Market Retu


1. Go to:   

• File/Options/Add-Ins/Analysis Toolpak/Go/OK 

 • Tick “Analysis Toolpak”  2. Click Data, and you should see “Data Analysis” on the top right-hand side of the screen.   


1. Select “Data Analysis”, then “Regression”.

  2. Input Y range-type in the cell references for all the data under Y-Axis.   e.g. $D$5:$D$52  3. Input X range-type in the cell references for all the data under X-Axis.  e.g. $E$5:$E$52  (For multiple regression, select the data under all the four ratios)

4. Choose Output Range.  e.g. $G$4 

5. Press OK, and the Regression Summary Output will show up from column G to O.  6. For TFIN 501 students, carry out multiple regression and correlation as well. 

7. Repeat the work from 2005 to 2019. 

8. Record Beta, R-square and p-value.  See green highlight in the Excel example.  rn.  16. Calculate Security Return and Market Return on a weekly basis.   

project management assignment helpbusiness management assignment helpbusiness management assignmentmanagement assignment help servicesstrategic management assignment helpmanagement accounting assignmentmanagement homework helpmarketing management assignment helphuman resource assignment helphuman resource management assignment helpmanagerial accounting assignment helpmanagement accounting assignment helpfinancial management assignment helpit management assignment helpproject management homework helphospitality management assignment helphr management assignment helpoperations management homework helpbrand management assignment helpdatabase management homework help 




Submit Works

Drop File To Upload Or
Assignment Help Australia

Our Top Experts

Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders