Opportunity to Apply the Data Manipulation Skills - Accounting and Finance Assignment Help

Download Solution Order New Solution
Assignment Task:

You must have R Studio experience and the tool needs to be downloaded in your machine.

This individual assignment provides an opportunity to apply data manipulation skills. The assignment would help you appreciate how you can prepare the data based on the business decision and what business insights can be drawn from the given data. Please complete this assignment on your own. Before attempting to complete this assignment, please do the following:

Readings and Files: Read the assigned case (Attached separately to learn the business context) and familiarize yourself with the " Mod3_LiveSession_Assignment.Rmd" and “ Mod3_LiveSession_Assignment.csv”. 

Assignment detail

You will have to write/fill some code in the attached "Mod3_LiveSession_Assignment.RMD" to prepare a few datasets.

Deliverables: Please follow this naming convention "NetID_Mod_3.Rmd" and "NetID_Mod_3.pdf" and

  1. submit an RMD file with code chunks. The codes must be commented to specify what is each line of code doing.

  2. submit a PDF of the above Rmd. It can be created through the preview option and converting the HTML file into PDF.

The PDF must include:

  • The code for data preparation. The codes must be commented to specify what is each line of code doing.

  • The first five rows (using “head” function) of each created dataset and the structure (using “str” function)

  •  Any other output of the code below the respective chunk.

Please prepare the data from the following level of analysis:

  • Customer Level Data with the following variables: 

    • TotalItemsCount - Number of total items bought

    • AvgItemCount – Avg number of items bought

    • Recency – difference between the last date in the data and the last date on which the customer made a transaction 

    • Frequency – Total number of transactions by a customer

    • Monetary – Average amount of purchase

    • Profitability – Total profitability

    • Discounts – Total discount

    • UniqueItems – Number of unique items bought (indicating broad taste vs narrow taste)

    • Items – the list of unique items bought by a given customer 

This Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.