diff_months: 17

How to represent the data using graphical tools, as well as numerical summaries

Download Solution Now
Added on: 2023-03-06 12:19:23
Order Code: CLT315526
Question Task Id: 0
  • Country :


Description of assessment task

This first milestone aims to give you a better understanding of the datasets, variables, and questions investigated by PwC. This exploratory data analysis seeks to get the necessary insights so that a development plan can be formulated to address the following key points of the distribution project:

(1) Correlation analysis: a cross-sectional analysis of correlation patterns between the profitability proxy variables and the local jurisdiction's key economic factors like GDP.

(2) Covid-19 effect analysis of cross-sectional patterns across the years may capture the effect of Covid on profitability (by country).

Approach to the assessment task

In week 1, we learnt how to represent the data using graphical tools, as well as numerical summaries. All these tools are meant to give us an idea of what the data is trying to tell us'. Can we make sense of the large numbers of observations and tell a simple story or pick up a trend? This is what you will do in this milestone: understand the data and what PwC is trying to find out from the data.

(A) Expected Tasks

(i) Attend the presentation session by PwC. This will give you important information about the importance of this analysis for PwC and will inform your formulation of the development plan for the analysis. You must understand the problem, PwC's expectations to inform your analysis.

(ii) Download your allocated data' spreadsheets. This is individual work, and you have been randomly assigned countries for Milestone 1 analysis. Please check the file 'Country Allocation' to find out which comp-anies you must analyse.

(iii) Data preparation. Please check the document,'Data Preparation and Data Cleaning' to prepare your data for analysis. The main data issue here is the missing points. These appear as 'n.a.' but sometimes also as '0'. In the latter case, you should double-check whether the variable in question can have a 'real' O value or whether '0', in fact, represents an 'n.a.' missing value. Some strategies for dealing with missing points appear in the document and will be discussed in your weekly SEM. You must explain any data manipulations you perform and provide a rationale for them.

(iv) Variables of interest. While preparing the data, think about (1) and (2) above and ask what information you need to be able to address these points. For instance, the columns in the data files have many variables that may proxy for profitability, like:

1) Operating Revenue (Turnover) US$
2) Gross Profits US$
3) Gross Profits Mark-up (%)
4) Gross Profit/ Total Operating Costs (%)
5) Gross Profit / Total Assets (%)

You must decide which variable(s) to address PwC profitability questions.

(v) Data structure. An essential aspect of the analysis is understanding the dataset's structure. The dataset provided by PwC has three dimensions: country, company and year. For each country, we have a panel dataset. Each panel is a cross-section of companies observed over six years. In this first milestone, we will fix the country dimension and analyse the profitability variation across companies and years.

(vi) You may not have all the information needed in the data file to address (1) and (2). For example, PwC is interested in understanding the effect of a country's key economic indicators (like GDP) on a company's profitability. At this point, you may want to ask how to use additional data to answer this question.

Get your How to represent the data using graphical tools, as well as numerical summaries assignment solved by Statistics Experts from Exam Question Bank . Our Assignment Writing Experts are efficient to provide a fresh solution to all 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Katthy Wills
  • Posted on : March 06th, 2023
  • Downloads : 0
  • Views : 264

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan


80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing


30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%


20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more