ELECTRICITY MODELLING
It deals with electricity usage data for 241 households in New Zealand that was collected in 2009. The data is for a single 24 hour period, and has been sampled every 30 minutes. Hence there are 48 measures per household. The first entry is at 12:30am, the second at 1am, and so on. So, for example, the 14th sample is at 7am, and the 24th sample is at midday. Run the supplied R script power.R, which loads the electricity data and produces a boxplot and example plot for one household. Note that the data is in a data.frame (each row is labelled with each household identifier associated with this data), and that to plot an individual example we turned the individual 48 data points into a numeric vector (as.numeric).
Examine the boxplot and briefly discuss the overall pattern of electricity usage for the households.
The electricity company is interested in understanding some general patterns of usage so that they can identify different types of user and therefore target them with specific pricing structures. Your task is to identify 4 overall patterns of usage and to identify the outlier households.
Identify 2 outlier households and show their pattern of usage. HINT: Use either k-means clustering with about 16 cluster centres (this seems to work well), or a dendrogram with the tree cut into a groupsize of 16, and find those clusters with a single household.
Discuss why these 2 outliers appear to be different from the overall general pattern of usage.
Determine the general pattern of electricity usage by grouping behaviour into 4 groups, plot them by taking the mean of each group over time, and discuss how they differ. Include a written description of these types of behaviour and what this tells us about each groups typical power consumption usage.
INVESTMENT PORTOLIO MANAGEMENT
Deals with modelling the selection of stocks, bonds and cash to make up an investment portfolio. Load the data as follows:
invest <-read.table("invest.tab")
The ROI column is the percentage predicted return on investment, the Risk column is a measure of the risk associated with this particular investment, and the Type indicates the type of investment. Note that each row is labelled with the type of investment and a number, so that you can (if needed) refer to individual investments.
Visualise and discuss the different ROI and Risk associated with Stocks, Bonds and Cash.
The table below shows the recommended blend of stocks, bonds and cash for a number of different brokerage houses (i.e. businesses that take your money and invest it to give you a return).
Using the result of the nsga2 model, examine and present the blend of stocks, bonds and cash for a low risk, moderate risk and high risk investment blend.