Can you make business report from this information?

Among the many investmentchoices available today, superannuation funds, a market basket of a portfolio of securities, is a common choice for those thinking about their retirement. The recent productivity commission report on productivity of superannuation was critical on the competitive nature of the industry.

Assume that you work as investment analyst for clients who decided to purchase superannuation funds for their retirement account. How would you go about making a reasonable choice among the many funds available today? The objective of your report is to provide general guidelines for clients to select a superannuation fund based on different characteristics.

The data file SUPERFUNDS2018 contains information regarding 11 variables from a sample of 168 superannuation funds. Please note that names of funds are omitted from this database. The variables are:

REGUCLA -Regulatory classification of the fund by APRA: 1 for Public Offer and 2 for Non Public offer

TYPE -type of the fund - 1 for Corporate, 2 for Retail, 3 for public and 4 for Industry

LICOWNER -Licensee Ownership type; 1 for Financial, 2 for Employer, 3 for Nominating, 4 for Public sector and 5 for other

OBJECTIVE -Licensee profit status: For Profit is noted as 1 and Non Profit is noted as 2

BASE -Membership base of the fund: 1 for corporate, 2 for general, 3 for government and 4 for Industry

BOARDSTU -Licensee board structure: 1 for gender equal and 2 gender non equal.

ASSETS -in thousands of dollars

NET -Net members benefit outflow ratioINVESTEXPR -Investment expense ratio

OPEREXPRA -Operating expense ratio

ONERET -twelve-month return in 2018

THERET -three-year return - annualised return 2016 - 2018FIVERET -annualised return 2014 - 2018

As an analyst you can use descriptive analytics (visualisation, presentation and descriptive statistics) and inferential statistics (hypothesis testing) for your analysis. You should analyse the performance variables (Expense ratios, Three year return, Five year Return and return 2018) based on funds characteristics (regulatory classification, type of the fund, licence ownership type, objective, board structure and base).

Please provide results of your analysis as a management report. Please follow the format given in the Moodle site.

Assignment Tasks:

1. Visually present data for the rate of return at based on funds characterises of licensee ownership structure. Calculate descriptive statistics for the rate of return at based on funds characteristics of licensee ownership structure. Comments on the location, shape and variability of those distributions.
2. Visually present data for the rate of return at based on funds characteristics of type of the fund. Calculate descriptive statistics for the rate of return at based on funds characteristics of type of the fund. Comments on the location, shape and variability of those distributions.