Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Programming Language Expert

ELECTRICITY MODELLING:
 
This section 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 ex, 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 ex 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 ex we turned the individual 48 data points into a numeric vector (as.numeric). 
 
problem 1: Examine the boxplot and briefly discuss the overall pattern of electricity usage for the households. 
 
problem 2: 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. 
 
problem 3: 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. 
 
problem 4: Discuss why these 2 outliers appear to be different from the overall general pattern of usage. 
 
problem 5: 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:
 
This section 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. 
 
problem 6: Visualise and discuss the different ROI and Risk associated with Stocks, Bonds and Cash.
 
Run the “invest.R” script. This script does a multi-objective criteria analysis to determine the best mix of stocks, bonds and cash over a range of tradeoffs. 
 
problem 7: Describe in words what the “invest.R” script is doing, what the objective functions are, and what each of the constraints represent. 

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

2017_brokerage house investment.jpg

Table: Major brokerage house investment blends (1996). From:

http://pages.stern.nyu.edu/~adamodar/New_Home_Page/invphillectures/port.html

problem 8: 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. Discuss, in relation to Table above, the level of risk that seems to be taken by the brokerage houses and whether the one year return performance is related to the associated risk of the brokerage house. 

problem 9: Produce a plot (such as that shown in Figure below) showing how the percentage of bonds, stocks and  cash varies as you move along the pareto front from the least to greatest risk. Discuss the patterns you observe and the relationship to Table above. Do the investment houses (Table above) that have the most risky blend receive the best ROI? Which investment house is the most risk adverse?

1483_investment blend.jpg

Figure: Plot of Risk versus investment blend as a percentage 
 
problem 10: Assume you only want to investigate the mix of solutions with the ROI between 8.0 and 12.0. State the constraint function that you would define to focus the search space between these ranges of ROI, and produce a plot of the pareto front using this additional constraint. NOTE that it may take several runs before you get the optimal front (the plot will be shown as BLUE DOTS if it has not found the optimal front).

Programming Language, Programming

  • Category:- Programming Language
  • Reference No.:- M91211

Have any Question? 


Related Questions in Programming Language

Assignmentthe fourth programming project involves writing a

Assignment The fourth programming project involves writing a program to manage a student database. The interface to the program should be a GUI that looks similar to the following: A combo box should allow the user to se ...

Programming logic and design questions1 given the

Programming Logic and Design Questions 1 given the following pseudocode module header: module calculate something (real x,real y, real z,) when the following call executes: call calculate something (21.6, 43.1, 15.2) sho ...

Assignmentindent code and insert comments to document your

Assignment Indent code and insert comments to document your program. Program must be implemented and run as instructed. Source file and executable are placed in a folder. Define the class with the name BankAccount to sto ...

Suppose a basic block is formed from the c assignment

Suppose a basic block is formed from the C assignment statements x = a + b + c + d + e + f; y = a + c + e; a) Give the three-address statements (only one addition per statement) for this block. b) Use the associative and ...

Write a function that returns a number given an uppercase

Write a function that returns a number, given an uppercase letter, as follows: def getNumber(uppercaseLetter): Write a test program that prompts the user to enter a phone number as a string. The input number may contain ...

Project instructionsinstructions complete the following two

Project Instructions Instructions: Complete the following two assignments as your final project. These two assignments review everything you learned from Chapters 1-8. Assignment 1 Write an application containing three p ...

1 write a program that reads input as a stream of

1. Write a program that reads input as a stream of characters until encountering EOF. Have the program report the number of uppercase characters, the number of lowercase characters, and the number of other characters rea ...

Object-oriented design for the ordering systemyou will

object-oriented design for the ordering system You will continue development of the object-oriented design for the ordering system. The new content this week will be the Sequence and Collaboration Diagram for the system. ...

Project final projectyour final project will be to analyze

Project: Final Project Your final project will be to analyze, design, and document a simple program that utilizes a good design process and incorporates sequential, selection and repetitive programming statements(i.e loo ...

Spreadsheet exercise1 run the spreadsheet program in your

Spreadsheet Exercise 1. Run the spreadsheet program in your computer and type the following:   A B C D E F 1 PAYROLL 2 XYZ COMPANY Employee Name Department Degree Salary Need Increase? 3 Nasser Mechanical Master 15000   ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro