Project 1:

Part 1

Section 1: Lookup + Text functions (match, index or V/H lookup functions, etc.), IfError, Validation etc.

Section2 - Pivot tables

Section3 - Chart (Frequency functions, etc.)

Part 2

Build 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.

Report:

The 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).

Assignment:

Assume these are financial data that have been extracted by your research assistant from prospectuses of New Zealand Non-bank Financial Institutions (NBFIs). The data are organized by alphabet in the blue sheet tabs A-G etc.

Attachment:- project1part1.xlsx