[SOLVED] R Part Two: 50%

Part Two: 50%
A. You need to use R to complete the requirements of this part of the coursework and you
are required to submit two R files (R-Markdown document and R-Markdown file).
B. You need to download the data file titled: Coursework Data File, also you need to
watch week 4 lecture video titled Business Analytics Coursework The Answers Using Excel.
This video explains the data sample you are going to use for your coursework.
C. You are required to complete the following tasks (1000 words):
1. Observe the variables Loading Date, Year of Built, vessel type and cargo size
in the dataset. (5%)
i. Check the data type (format) of the following variables: year of built, vessel
type and cargo size. If necessary, modify the data type.ii. Check if these variables contain missing values. Exclude all observations where at
least one of these variables Loading Date, year of built and vessel type and
cargo size contain missing values and save it.
1
2. Create a weekly time series of vessels fixture (a count of number of weekly fixed ships)
and total cargo capacity
2
. (5%)
3. Plot a weekly time series showing total number of vessels fixtures and total cargo
capacity loaded onboard ships. You need to provide a table with the data used to plot
the time series
3
. (5%)
4. Identify the week that had the highest number of vessel fixtures and the most loaded
cargo in tonnes
4
. (5%)
5. Structure a table and provide a suitable illustration that categorises total fixtures and
cargo capacity by vessel type and year of built. (5%)
6. Forecasts are required to support decisions in the future. We need to provide the forecast
to support operational planning one week in advance. Use nave and simple moving
average to provide one-week ahead forecast. (5%)
7. Which approach do you recommend using for this forecasting task? Critically discuss
your answer and plot your forecasts. (5%)
8. Historical time series may contain useful information that are useful for decision
makers. Do you see any pattern in the weekly time series of vessels fixtures and total
cargo capacity? Use visualisations and critically discuss to justify your answer. (5%)