BUS501 Business Analytics and Statistics

Data Analytics in SPSS, SPSS Assignment Help, SPSS Project Help

BUS501 - Business Analytics and Statistics

Research Report

Data from a small health food shop on the Sunshine Coast are provided. The business is divided into a number of areas including retail, wholesale a box delivery system (not included in the data) and Harvest Kitchen (http://www.goodharvest.com.au). The data is inclusive of a whole year of trading. This is the 2nd year of business and the business is still in a start-up phase. The reported high COGS is consistent with the Organic industry.

The main challenges in the business are revenue (i.e lead generation/new business), COGS (margins) and average sale.

The business has a 6 person team, 1 delivery van, a retail outlet and a cold store warehouse.

BUS501 - Business Analytics and Statistics

Illustration of Business Analytics applied to

Mutual Funds returns – Prof. W. Selen

  1. Introduction

Mutual Funds may exhibit different return profiles, pending on their objective and time horizon over which returns are measured. Returns may also be different across risk exposure of the fund. (your research report will have a slightly more elaborate introduction)

  1. Problem definition and business intelligence required

Mutual funds were sampled and we want to use descriptive and predictive analytics to gain insights about their return profile. In particular:

  • How much do best case and worst case returns differ, measured by best quarter and worst quarter performance?
  • Do average returns differ across risk exposure levels of the fund, and if so, how much?
  • How different are (average) returns for mutual funds that aim for value, as compared for those that aim for growth?
  • Do returns differ among funds that charge fees, as compared to those that do not?
  • Is the asset level a good predictor for a higher return? In other words, do larger

funds perform better overall?

  1. Selected analytics methods and technical analysis

We address each of the business problems in turn with an appropriate business analytics analysis:

First of all, we looked at the data set and ensured all relevant variables were appropriately scaled. Below is a screenshot of the part of the data set used for our analyses:

are ratio scaled.

(you may also want to discuss outlier analyses if relevant, using z-scores)

Analysis 1: How much do best case and worst case returns differ, measured by best

quarter and worst quarter performance?

spss-assignment-help-30-img1

The boxplot shows that median returns are vastly different and that the downside of worst case negative returns is limited to a loss not exceeding -30%, while the upside in best case yields returns up to +50%, with some outlier star performances up to 80%. The variation in returns is smaller (more contained) in worst case, as compared to best case.

Answer Detail

Get This Answer

Invite Tutor