xuebaunion@vip.163.com

3551 Trousdale Rkwy, University Park, Los Angeles, CA

留学生论文指导和课程辅导

无忧GPA：https://www.essaygpa.com

工作时间：全年无休-早上8点到凌晨3点

扫码添加客服微信

扫描添加客服微信

R代写 - ACTL1101 Introduction to Actuarial Studies

时间：2020-11-17

1

1. Part One: Australian Schools Data

1.1 Context

In this part of the assignment, you will revisit a dataset on Australian Schools, which you

encountered before in ‘R Questions on Week 4’. This dataset is available on Moodle under

the name school data2019.csv. On Moodle there is also a file ‘Decription of Variables’,

which briefly describes what each variable represents.

In this part of the assignment, you will create some visualisations to deepen your understanding

of this data. Note that, compared to the dataset encountered previously, school data2019.csv

contains:

• More variables, in particular it contains data about the average taxable income and tax

paid (from tax year 2017-2018) for people living within the postcode where each school

is located. Those additional income variables are called:

– Taxable.Income: average taxable income, within the postcode

– Net.Tax: average net tax paid, within the postcode

– Salary.or.Wages: average salary/wages, within the postcode

• A few schools have been removed (because the income data for the postcodes of

those schools was not available).

For your information, the school data is publicly available here, while the income data is

available here (with its license found here).1

1We must disclose that, compared to the original income/tax data found here, we have modified the income

data to obtain averages by individual (as opposed to the total amounts by postcode found in the original data).

2

ACTL1101 Introduction to Actuarial Studies 2020 Main Assignment

1.2 Your Tasks

1. (2pts) Produce a visualisation of the distribution of variable ICSEA across all schools.

Briefly describe this distribution.

Note: You may want to review the definition of ICSEA found here.

2. (2pts) Produce a visualisation that illustrates, by State, the proportion of schools with

their School.Sector equal to either ‘Government’, ‘Catholic’, or ‘Independent’. Briefly

discuss what you observe.

3. (2pts) Add a variable called Income.Bracket to this dataset. This new variable should

be based on variable Taxable.Income, and be equal to:

• ‘Low’ if Taxable.Income is below its 20% percentile.

• ‘Medium’ if Taxable.Income is equal or above its 20% and below its 90% percentile.

• ‘Rich’ if Taxable.Income is equal or above its 90% and below its 99% percentile.

• ‘Very Rich’ if Taxable.Income is equal or above its 99% percentile2.

What is the average Taxable.Income within each Income.Bracket?

4. (2pts) Produce a visualisation which illustrates the relationship between ICSEA and the

new variable Income.Bracket, and briefly discuss what you observe.

5. (2pts) Open Question: use any variable(s) you want in this dataset to tell a brief story

about the data. This can be anything you find relevant, but you must include at

least one visualisation to support your ‘story’. Example: an interesting/surprising link

between variables, an insight that could help public policy, a finding that is the starting

point for new research, etc.

2Hint: consider using function quantile().

3

2. Part Two: Utility of an Insurer

2.1 Context

In this second part of the assignment (which is totally unrelated to the first part), you will work

on an insurance problem that would be difficult to tackle without programming. Note that you

must use the numerical values of w0, n and r0, given in the file parameters by student on

Moodle (look for the values that correspond to your zID). The context is as follows.

An insurance company (insurer) has a current capital (initial wealth) of w0. It can choose

to insure a new group of n people. The individuals in this group are independent, and

they all have similar characteristics, so that each individual has a probability of incurring

a loss within the next year equal to q. The coverage offered is only for the next year. The

payout by the insurance company to each individual will be:

• 1 in the case of a loss.

• 0 otherwise.

We can model the total future payout made by the insurer by:

S = X1 +X2 + . . .+Xn,

where each Xi ∼ Bernoulli(q), i = (1, 2, . . . , n) is the individual payout on the policy of

individual i.

Based on its risk aversion policy, this insurer makes financial decisions using a utility

function given by:

v(w) = log(w), for w > 0,

where log() is the natural logarithm, i.e. such that log(e) = 1. The premium charged by

the insurance company to every individual is set to

Premium = c · q

where c > 0 is a ‘loading factor’: a bigger value of c implies a bigger margin for a profit.

Note: Be careful that the utility function v(w) is not defined for negative values of w. Hence,

in your R programming, be wary of not computing v(·) on amounts that are negative, which

could result in error messages.

4

ACTL1101 Introduction to Actuarial Studies 2020 Main Assignment

2.2 Your Tasks

1. (3pts) Assume that the insurer uses the Principle of Zero utility to fix c. Write a

function called find.c(), which returns the numerical value of c. Your function should

have q as an argument. Using this function, find the value of c for q = 0.01 and for

q = 0.10.

2. (2pts) Use your function find.c() from Q1 to create a graph which illustrates the

relationship between c and q. Analyse and interpret this relationship.

3. (3pts) Now assume that the insurer can choose to insure, or not, one specific individual

in that group. Further, assume that this individual has the exact same utility function

as the insurer and an initial wealth of r0. Then, we can show that, based on its utility

function, the individual will be willing to buy insurance if:

r0 > (r0 − 1)q · (r0)1−q + cq

On the other hand, the insurer will be willing to take on this risk (sell the insurance) if1

w0 < (w0 + cq − 1)q · (w0 + cq)1−q.

An interesting point is that there is a set of values of q and c such that both the individual

and the insurer would be willing to enter the insurance deal.

Your task: Produce a 13 × 13 table, where columns represent increasing values of c,

from 0.9 to 2.1 (left to right) by jumps of 0.1. Rows represent increasing values of q,

from q = 0.01 to q = 0.25 (from top to down) by increments of 0.02. Inside the table,

each cell displays a number, either:

• 1: if only the insurer is happy with that particular combination of {q, c}.

• 0: if both the insurer and individual are happy with that {q, c}.

• -1: if only the individual is happy with that {q, c}.

4. (2pts) Analyse and explain your results from Part 3. In particular, explain why it is

possible for two parties with the exact same utility function to happily stand on opposite

sides of a financial transaction (in this case, the exchange of an insurance risk).

1It is not required here, but for extra practice for the Final Exam: try to prove those inequalities. It is not too

hard :-).

5

3. Format Requirements

Here we explain the format requirements you must satisfy for this assignment. Heavy

penalties will be applied for non compliance, and in particular we will not mark any material

that exceeds the page limit.

• You must submit your assignment on Turnitin (under section ‘Main Assignment’ in

Moodle). The deadline is November 20th at 13:00.

• You must submit two files:

– a .pdf file: contains your answers to all questions.

– a .R file: contains all the R codes you used to produce your answers.

• About the .pdf file:

– It includes a title page with: student name, student zID.

– The page format is A4 (this is the standard Australian format).

– The minimum font size used is an equivalent of ‘Times New Roman’ size 11.

– The minimum line spacing used is 1.15.

– The margins should not be narrower than the ‘narrow’ option in Word (which is

0.5 inches every side).

– The answers (including sub-parts) are numbered in the same way they are numbered

in the statement of the questions.

– Your answers to Part One (including all plots) must fit on 2 pages.

– Your answers to Part Two (including the plot) must fit on 1 page.

– All R codes necessary to produce your results (i.e. the content of the .R file)

must also be placed in an Appendix to your .pdf file. There is no page limit on

this Appendix but the efficiency of your code will be graded (see Marking Criteria).

• About the .R file:

– Your R codes must run as they are (and produce exactly the results in your

assignment). If we cannot run your code, you will lose ALL marks associated

to R code (C1 and C2 in the Marking Criteria, see next page).

– Your R codes must contain ALL steps necessary to answer the questions in this

assignments. To be specific: you are NOT allowed to do any data manipulation in

Excel, or any other software.

6

4. Marking Criteria

Each individual Question gets attributed a fixed number of marks. To assess your answers,

we will use a series of criteria. Those criteria are stated below, with a brief description that

corresponds to a ‘HD mark’. Not all criteria are relevant to every sub-question: find a detailed

mapping below.

• C1: Code Correctness: Your R codes, functions and algorithms produce exactly the

desired results, and do not produce any irrelevant/superfluous results.

• C2: Code Efficiency: Your R codes are extremely efficient, without sacrificing readability.

Your R codes are extremely well organised and easy to follow.

• C3: Analysis: Your analysis is insightful and accurate. Your interpretation of your

results is correct, clear, precise and shows a great depth of understanding and critical

thinking. Your writing is concise, fluent and devoid of typos, grammatical and syntactical

mistakes.

• C4: Choice of Visualisation: Your choice of which visualisation to use is excellent: it

conveys all (and only) the appropriate information.

• C5: Presentation: The formatting and presentation of your results and/or visualisations

is impeccable: clear, readable and aesthetic.

4.1 Part One

For each sub question (Q1, Q2, Q3, Q4, Q5) in Part One, the relevant marking criteria are:

• Q1: C1, C3, C4, C5

• Q2: C1, C3, C4, C5

• Q3: C1, C2

• Q4: C1, C3, C4, C5

• Q5: C3, C4, C5

7

ACTL1101 Introduction to Actuarial Studies 2020 Main Assignment

4.2 Part Two

For each sub question (Q1, Q2, Q3, Q4) in Part Two, the relevant marking criteria are:

• Q1: C1, C2

• Q2: C1, C3, C4, C5

• Q3: C1, C2, C5

• Q4: C3

4.3 Plagiarism Awareness

This is an individual assignment. While we have no problem with students discussing

assignment problems if they wish, the material each student submits must be their own

individual work. Students should make sure they understand what plagiarism is.

In particular, any R code you present must be from your own computer, and developed by

you alone. While some small elements of code are likely to be similar with 265 students

performing the same task, big patches of identical code (even with different variable names,

layout, or comments) will be considered as plagiarism. Turnitin picks this up easily, so cases

of plagiarism have a very high probability of being discovered. The best strategy to avoid

any problem is to never share bits and pieces of code with other students.

8

5. Answering Students’ Questions

Any question or clarification about the assignment must be posted on the Ed Forum, under

category ‘Main Assignment’. We do not plan to give out many additional hints, but if we were

to do so, we want everyone to benefit from them.

Important Note: The deadline for submission of this assignment is Friday November 20th

at 13:00. However, we will stop answering any questions about the assignment on Monday

November 16th at 13:00. The rationale for this is twofold:

• we want to incentivise students to start the assignment early

• we want to be fair to assiduous students who decide to submit their assignment ahead

of time. Were we to give hints right before the deadline, those students would be

penalised for their earliness.

- 留学生代写
- Python代写
- Java代写
- c/c++代写
- 数据库代写
- 算法代写
- 机器学习代写
- 数据挖掘代写
- 数据分析代写
- Android代写
- html代写
- 计算机网络代写
- 操作系统代写
- 计算机体系结构代写
- R代写
- 数学代写
- 金融作业代写
- 微观经济学代写
- 会计代写
- 统计代写
- 生物代写
- 物理代写
- 机械代写
- Assignment代写
- sql数据库代写
- analysis代写
- Haskell代写
- Linux代写
- Shell代写
- Diode Ideality Factor代写
- 宏观经济学代写
- 经济代写
- 计量经济代写
- math代写
- 金融统计代写
- 经济统计代写
- 概率论代写
- 代数代写
- 工程作业代写
- Databases代写
- 逻辑代写
- JavaScript代写
- Matlab代写
- Unity代写
- BigDate大数据代写
- 汇编代写
- stat代写
- scala代写
- OpenGL代写
- CS代写
- 程序代写
- 简答代写
- Excel代写
- Logisim代写
- 代码代写
- 手写题代写
- 电子工程代写
- 判断代写
- 论文代写
- stata代写
- witness代写
- statscloud代写
- 证明代写
- 非欧几何代写
- 理论代写
- http代写
- MySQL代写
- PHP代写
- 计算代写
- 考试代写
- 博弈论代写
- 英语代写
- essay代写
- 不限代写
- lingo代写
- 线性代数代写
- 文本处理代写
- 商科代写
- visual studio代写
- 光谱分析代写
- report代写
- GCP代写
- 无代写
- 电力系统代写
- refinitiv eikon代写
- 运筹学代写
- simulink代写
- 单片机代写
- GAMS代写
- 人力资源代写
- 报告代写
- SQLAlchemy代写
- Stufio代写
- sklearn代写
- 计算机架构代写
- 贝叶斯代写
- 以太坊代写
- 计算证明代写
- prolog代写
- 交互设计代写
- mips代写
- css代写
- 云计算代写
- dafny代写
- quiz考试代写
- js代写
- 密码学代写
- ml代写
- 水利工程基础代写
- 经济管理代写
- Rmarkdown代写
- 电路代写
- 质量管理画图代写
- sas代写
- 金融数学代写
- processing代写
- 预测分析代写
- 机械力学代写
- vhdl代写
- solidworks代写
- 不涉及代写
- 计算分析代写
- Netlogo代写
- openbugs代写
- 土木代写
- 国际金融专题代写
- 离散数学代写
- openssl代写
- 化学材料代写
- eview代写
- nlp代写
- Assembly language代写
- gproms代写
- studio代写
- robot analyse代写
- pytorch代写
- 证明题代写
- latex代写
- coq代写
- 市场营销论文代写
- 人力资论文代写
- weka代写
- 英文代写
- Minitab代写
- 航空代写
- webots代写
- Advanced Management Accounting代写
- Lunix代写
- 云基础代写
- 有限状态过程代写
- aws代写
- AI代写
- 图灵机代写
- Sociology代写
- 分析代写
- 经济开发代写
- Data代写
- jupyter代写
- 通信考试代写
- 网络安全代写
- 固体力学代写
- spss代写
- 无编程代写
- react代写
- Ocaml代写
- 期货期权代写
- Scheme代写
- 数学统计代写
- 信息安全代写
- Bloomberg代写
- 残疾与创新设计代写
- 历史代写
- 理论题代写
- cpu代写
- 计量代写
- Xpress-IVE代写
- 微积分代写
- 材料学代写
- 代写
- 会计信息系统代写
- 凸优化代写
- 投资代写
- F#代写
- C#代写
- arm代写
- 伪代码代写
- 白话代写
- IC集成电路代写
- reasoning代写
- agents代写
- 精算代写
- opencl代写
- Perl代写
- 图像处理代写
- 工程电磁场代写
- 时间序列代写
- 数据结构算法代写
- 网络基础代写
- 画图代写
- Marie代写
- ASP代写
- EViews代写
- Interval Temporal Logic代写
- ccgarch代写
- rmgarch代写
- jmp代写
- 选择填空代写
- mathematics代写
- winbugs代写
- maya代写
- Directx代写
- PPT代写
- 可视化代写
- 工程材料代写
- 环境代写
- abaqus代写
- 投资组合代写
- 选择题代写
- openmp.c代写
- cuda.cu代写
- 传感器基础代写
- 区块链比特币代写
- 土壤固结代写
- 电气代写
- 电子设计代写
- 主观题代写
- 金融微积代写
- ajax代写
- Risk theory代写
- tcp代写
- tableau代写
- mylab代写
- research paper代写
- 手写代写
- 管理代写
- paper代写
- 毕设代写
- 衍生品代写
- 学术论文代写
- 计算画图代写
- SPIM汇编代写
- 演讲稿代写
- 金融实证代写
- 环境化学代写
- 通信代写
- 股权市场代写
- 计算机逻辑代写
- Microsoft Visio代写
- 业务流程管理代写
- Spark代写
- USYD代写
- 数值分析代写
- 有限元代写
- 抽代代写
- 不限定代写
- IOS代写
- scikit-learn代写
- ts angular代写
- sml代写
- 管理决策分析代写
- vba代写
- 墨大代写
- erlang代写
- Azure代写
- 粒子物理代写
- 编译器代写
- socket代写
- 商业分析代写
- 财务报表分析代写
- Machine Learning代写
- 国际贸易代写
- code代写
- 流体力学代写
- 辅导代写
- 设计代写
- marketing代写
- web代写
- 计算机代写
- verilog代写
- 心理学代写
- 线性回归代写
- 高级数据分析代写
- clingo代写
- Mplab代写
- coventorware代写
- creo代写
- nosql代写
- 供应链代写
- uml代写
- 数字业务技术代写
- 数字业务管理代写
- 结构分析代写
- tf-idf代写
- 地理代写
- financial modeling代写
- quantlib代写
- 电力电子元件代写
- atenda 2D代写
- 宏观代写
- 媒体代写
- 政治代写
- 化学代写
- 随机过程代写
- self attension算法代写
- arm assembly代写
- wireshark代写
- openCV代写
- Uncertainty Quantificatio代写
- prolong代写
- IPYthon代写
- Digital system design 代写
- julia代写
- Advanced Geotechnical Engineering代写
- 回答问题代写
- junit代写
- solidty代写
- maple代写
- 光电技术代写
- 网页代写
- 网络分析代写
- ENVI代写
- gimp代写
- sfml代写
- 社会学代写
- simulationX solidwork代写
- unity 3D代写
- ansys代写
- react native代写
- Alloy代写
- Applied Matrix代写
- JMP PRO代写
- 微观代写
- 人类健康代写
- 市场代写
- proposal代写
- 软件代写
- 信息检索代写
- 商法代写
- 信号代写
- pycharm代写
- 金融风险管理代写
- 数据可视化代写
- fashion代写
- 加拿大代写
- 经济学代写
- Behavioural Finance代写
- cytoscape代写
- 推荐代写
- 金融经济代写
- optimization代写
- alteryxy代写
- tabluea代写
- sas viya代写
- ads代写
- 实时系统代写
- 药剂学代写
- os代写
- Mathematica代写
- Xcode代写
- Swift代写
- rattle代写
- 人工智能代写
- 流体代写
- 结构力学代写
- Communications代写
- 动物学代写
- 问答代写
- MiKTEX代写
- 图论代写
- 数据科学代写
- 计算机安全代写
- 日本历史代写
- gis代写
- rs代写
- 语言代写
- 电学代写
- flutter代写
- drat代写
- 澳洲代写
- 医药代写
- ox代写
- 营销代写
- pddl代写
- 工程项目代写