Attachment # 00007179 - Project_1.pptx
Project_1.pptx (40.56 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Project 1FINA 415-15B Group of 5.Due by 18/09/2015.2 parts. Each worth 50% of total.Need to provide 1 excel workbook for part 1 and part 2.This project will help you to learn data management and interpreting regression results. Part 1Section 1: Lookup + Text functions (match, index or V/H lookup functions, etc.), IfError, Validation etc.Section2 – Pivot tablesSection3 – Chart (Frequency functions, etc.) Part 2Build Hypothesis.Organise data (Remove outliers, treat missing variables etc).Calculate relevant ratios, convert variables to log values, create categorical variables.Run multivariate regression.Interpreting regression with dummy variable. ReportThe Report should be divided in Part 1 and 2 and it should comprise at least the followings:- - Introduction- Literature review (only for Part 2)- Description of Analysis - Results - Conclusions and Recommendations - Appendices - References Part 1.Describe the functions used.If there is an alternative approach to get the same outputs, if yes, then the reason/s for choosing the function that you have used.Interpretation of summary statistics.Interpretation of histogram.A brief interpretation of the descriptive stat that you have obtained using Pivot Table and the frequency distribution.Part 2.Describe hypothesis.Treatment of data.Description of your data (i.e. the ratios calculated, reasons of using log values etc.)A literature review about interpreting dummy variables.Interpretation of regression with dummy variable (Please read materials provided).
FIN415 project1

FIN415 project1

Question # 00101493 Posted By: lyn689 Updated on: 09/08/2015 02:13 AM Due on: 09/15/2015
Subject Economics Topic Financial Markets Tutorials:
Question
Dot Image
You need to analyse given financial data using various Excel functions.

the PPTX in files will tell you the functions you should use in every section.  if you are good at excel, this will be easy for you. 
Dot Image
Attachments
Project_1_(Part_1).xlsx (541.85 KB)
Project_1_(Part_2).xlsx (338.54 KB)
Project_1.pptx (40.56 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00095833 Posted By: neil2103 Posted on: 09/08/2015 02:40 AM
    Puchased By: 3
    Tutorial Preview
    The solution of FIN415 project1...
      Get the Solution
    Attachments
    1-Project-1--Part-2-_(1).xlsx (1121.51 KB)
    _Part-2_(1).docx (57.09 KB)
    part_1_updated.xlsx (592.21 KB)
Whatsapp Lisa