Posted: September 8th, 2022

ETW2001 2022 S2 Assessment 2 Assignment

ETW2001 2022 S2 Assessment 2
Particular person Assignment (15%)
The principle job of the task is for college kids to carry out Assessment utilizing basic abilities of R programming. This task requires coding abilities from week 1 to week 6.
Deadline: Week 7, 9 September 2022 (Friday) by 11:55 PM in MYT
Submission: A report in pdf format and an R-script that information all codes for information preparation and output.
Word
• If you submit in Moodle, it would present an error saying, “You could add a supported file sort for this task. Accepted file sorts are; …”. You may ignore this message so long as you uploaded the R-script.
• Don’t take screenshots of your output. For plots, export it correctly. For tables, you may create tables utilizing the Microsoft phrase perform. There are some packages to create a desk in RStudio, however it requires an excessive amount of be just right for you. You may strive if you’d like.
• Since this task doesn’t require a lot writing for the report, you’ll spend most time looking out and writing codes. I encourage you to debate job 1 through the Discord channel.
• This task covers the Unit’s Studying outcomes 1 and 2.
• For 1.7 and 1.eight, you would possibly must discuss with Week 6 lecture materials.
• You don’t want to repeat and paste the codes into the report since it’s recorded in R-script. Your report ought to embrace plots and Assessment.
Context
Inhabitants information is effective because it impacts a number of elements of the sustainable development of nations. Assessment and estimation of inhabitants permit us to handle international challenges corresponding to poverty, hunger, distribution of commodities, vitality, atmosphere, and our well-being. This may be helpful for multinational companies in that observing demographic modifications gives an perception into future market measurement.
For this task, you’ll start with tidying up the information and give you some Assessment of a number of variables associated to the inhabitants. The info covers from the years 2001 to 2050, the place future values are estimated values by the World Financial institution.
Knowledge supply: https://databank.worldbank.org/supply/population-estimates-and-project ( help with nursing paper writing from experts with MSN & DNP degrees)ions
Process 1 – Knowledge preparation (33 marks)
The reply for this job must be written within the R-script.
1.1 Assign a brand new identify to the information body known as “df” by loading the datasheet from the excel file (Assessment 2 information) to R-Studio. Load the packages that you simply use within the task. Make sure the loaded sheet is “information” and set the primary row because the column identify. (2 marks)
1.2 Utilizing the dplyr capabilities, delete the “Sequence code” column from “df”. Save the output as “df1” (2m)
1.three Utilizing the dplyr capabilities, convert the “df1” information for columns from 2001 to 2050 as numeric. Save the output as “df2” (dim = 49747, 53). You would possibly see an error saying, “There have been 50 or extra warnings. Don’t worry about it. (2m)
1.four Utilizing the dplyr capabilities, convert the “df2” information for columns from 2001 to 2050 to take 2 decimal locations. Save the output as “df3”. (2m)
1.5 Change the format of column names as beneath:
Convert the “df3” column names from “2001 [YR2001]” to “2001”. Apply this to the remainder of the columns as much as 2050. Ensure you don’t repeat the codes 50 instances. You want two units of codes. One for the brand new set of column names and the opposite one to use as new column names. (5m)
1.6 Drop all NA values from “df3”. Save this output as “df4”. The dimension of df4 must be 33491 by 53. (2m)
1.7 There are too many columns for annually. Put all 12 months column names from “df4” beneath the “12 months” column and put their values beneath the “Values” column. Additionally, convert “12 months” as numerical values. Save this output as “df5”. The dimension of “df5” is 1674550 by 5. (4m)
1.eight There are too many rows for every nation. Put all “Sequence identify” from “df5” to separate columns following its identify. Save this output as “df6”; its dimension is 12950 by 156. (4m)
1.9 Since there are 156 columns, it could be tough to determine variables identify everytime you wish to carry out additional Assessment. Create an information body known as “index” to indicate the listing of variable names from “df6”. (2m)
1.10 Utilizing the index quantity, create “df7”, together with the followings: (2m)
• Nation Title
• Nation Code
• 12 months
• Age dependency ratio (% of working-age inhabitants)
• Inhabitants ages 65 and above, feminine (% of feminine inhabitants)
• Inhabitants ages 65 and above, male (% of male inhabitants)
• Inhabitants, feminine (% of the whole inhabitants)
• Inhabitants, complete
• Rural inhabitants (% of the whole inhabitants)
• City inhabitants (% of the whole inhabitants)
1.11 Rename the above variables from “df7” as beneath: (2m)
Unique Variable identify New identify
Nation Title Use as it’s
Nation Code Use as it’s
12 months Use as it’s
Age dependency ratio (% of working-age inhabitants) dep_ratio
Inhabitants ages 65 and above, feminine (% of feminine inhabitants) pop65f
Inhabitants ages 65 and above, male (% of male inhabitants) pop65m
Inhabitants, feminine (% of complete inhabitants) popf
Inhabitants, complete pop
Rural inhabitants (% of complete inhabitants) pop_rural
City inhabitants (% of complete inhabitants) pop_ruban
1.12 Utilizing the dplyr capabilities, calculate inhabitants development (popgr). It’s possible you’ll discuss with the system beneath: ?????????? =&( ??????! -??????!-#)**100
??????!-#
Create “df8” that features popgr and all of the variables from “df7”. You will need to group the information by nation, then to calculate popgr. (4m)
Process 2 – Inhabitants around the globe (43 marks) You’ll be utilizing “df8” for Process 2 and Process three.
2.1 Create a plot that reveals modifications in inhabitants development from 2002 to 2022. Your plot should embrace the next elements: (10m)
• Use information for five earnings classes (Low, Decrease center, Center, Higher center and Excessive earnings) which might be present in `Nation Title`
• Assign 5 completely different colors for these 5 classes.
• The road width is 1.2.
• Show the y-axis from zero to three and the breaks by zero.5.
• Show the x-axis from 2002 to 2022 and the breaks by 2.
• Add acceptable title, subtitle and axis labels.
• Find the legend on the backside of the plot. The legend gadgets ought to match properly.
• It’s possible you’ll add an additional theme to make your plot extra aesthetic (additional marks not granted)
2.2 Analyse the plot you created. Based mostly on plot 2.1, forecast (with none calculation) how the inhabitants development can be sooner or later. Your Assessment shouldn’t exceed 1 web page. (10m)
2.three Replicate the plot you created in 2.1 however overlaying a time span from 2022 to 2050. Make a crucial adjustment for the title and scale (the x-axis breaks by 5). (3m)
2.four Does the plot from 2.three match your forecast from 2.2? Talk about any noticed variations to your forecast. Present doable financial causes for any mismatch. Your Assessment shouldn’t exceed half a web page. (3m)
2.5 Create a plot that reveals modifications in dependency ratio from 2002 to 2022. Your plot should embrace the next elements: (3m)
• Use information for five earnings classes (Low, Decrease center, Center, Higher center and Excessive earnings).
• Assign 5 completely different colors for these 5 classes.
• The road width is 1.2.
• Show the y-axis from 40 to 100 and the breaks by 10.
• Show the x-axis from 2002 to 2022 and the breaks by 2.
• Add acceptable title, subtitle and axis labels.
• Find the legend on the backside of the plot. The legend gadgets ought to match properly.
• It’s possible you’ll add an additional theme to make your plot extra aesthetic (additional marks not granted)
2.6 Analyse the plot you created. Based mostly on plot 2.5, forecast (with none calculation) how the dependency ratio can be sooner or later. Your Assessment shouldn’t exceed 1 web page. (6m)
2.7 Replicate the plot you created in 2.5 however overlaying a time span from 2022 to 2050. Make a crucial adjustment for the title and scale (the x-axis breaks by 5). (3m)
2.eight Does the plot from 2.7 match your forecast from 2.6? Talk about any noticed variations to your forecast. Talk about why the anticipated information by the World Financial institution reveals such patterns for every earnings class. Your Assessment shouldn’t exceed 1 web page. (5m)
Process three – Mini analysis (24 marks)
Receive a random nation identify by utilizing your pupil ID as follows:
set.seed(“your pupil ID”) pattern(df8$`Nation Title`, measurement=1)
Utilizing the code above, you’ll receive a random nation’s identify from the ‘Nation Title’ variable. It’s okay in case your output reveals a area or group of nations.
three.1 Create a plot that features four line graphs inside. Embrace the next particulars (5m):
• A rustic or area that’s chosen by random sampling.
• four plots for Inhabitants, Inhabitants development price, Dependency Ratio, and City inhabitants.
• Because the inhabitants scale is simply too massive relative to the opposite variables, categorical the inhabitants in a unit of million. You’re allowed to make use of billion when you received area as an alternative of nation.
• Label every y-axis.
• The x-axis ought to point out years much less or equal to 2020.
• The principle title must be “Inhabitants in ‘nation’s identify’”.
Earlier than you filter the chosen nation, you need to ungroup “df8” first.
three.2 Analyse the plot you created in three.1. In the event you discover any uncommon modifications, seek for doable causes with correct quotation. Don’t write greater than a web page. (8m)
three.three Repeat three.1, embrace the randomly chosen nation/area and “Malaysia”. For every graph, two strains ought to point out the randomly chosen nation/area and Malaysia respectively. Set all different particulars the identical with a correct title and legend. (3m)
three.four Contemplating the financial growth stage, examine and analyse every graph. A superb Assessment ought to embrace perception with sound reasoning. Don’t write greater than a web page. (8m)

Order | Check Discount

Tags: ETW2001 2022 S2 Assessment 2 Assignment