FC308: Statistical/Data Analysis Information technology - IT Assignment Help

What do you need to do for this assessment? 

Task:

Assume that you have been asked by an organisation to collect and analyse data.  You are required to submit a report detailing the statistical analysis of a dataset.  To avoid you having to collect real data the dataset for analysis will be provided by your tutor. Your report should assume that the reader has no technical knowledge of Python, the dataset or data analysis in general so technical terms and jargon should be defined and explained.  

The report needs to demonstrate the completion of the following tasks: 

Task 1: Introduction (15%) 

Describe the background of the organisation/company that the dataset belongs to and the purpose for why the data has been collected. Outline what you are going to do, why you are doing it and what you hope to achieve with your analysis.  

Task 2: The dataset (15%) 

Describe the size of the dataset, the datatypes within, the units of measurements used (where applicable) and an estimate of the memory required to store the data. The task should be accomplished using appropriate python commands using the pandas package. 

Task 3: Plot description (15%) 

Using appropriate pandas instructions generate a plot (chart) which displays the dataset. The plot should be appropriate labelled and coloured to make for easy reading. Ensure you include a screenshot of the chart in your report. To show your understanding of interpreting statistical results you should also explain the chart and the results it shows.  The reader should not have to make any assumptions regarding the diagrams.  

Pandas has many different types of plots and it is down to you to determine the most suitable one for the given dataset. 

Task 4: Further analysis (40%) 

For this task you need to perform further statistical analysis on the dataset using more complex pandas functions. For example, you should at a minimum calculate basic statistical information such as a the mean, median, mode, standard deviation and variance, on the dataset (where it is appropriate). You also need to explore more complex statistical analysis functions including but not limited to: percentage change, covariance, correlation and data ranking.  

For each function you use, you need to generate an appropriate plot, a written description explaining the interpretation of the data presented and the Python source code. Document the Python code assuming the reader has no technical knowledge. 

Task 5: Summary (15%) 

Having analysed the data you should state what business decisions could be made based on the results and what further data should be collected (and why 

Guidance:

For this assessment you should make use of the following formative activities that you have already completed.  These activities have been designed to support this summative assessment:

• Learning materials and activities from Cycle 2 Weeks 6 to 10 which includes the following topics:
  • Data types
  • Algorithms
  • Sequencing
  • Selection
  • Iteration
  • Input/Output
  • Functions

Please note:

This is an individual assessment so you should not work with any other student.

Your tutor will also ask for a draft copy of your work and provide feedback. 

Before you submit this assessment, you will have an opportunity to receive feedback from your peers (other students in the class).  Your tutor will arrange a time for you to share and discuss your progress with your classmates.  You do not have to act on their feedback, but you may find it useful to enhance your final submission.

Structure:

Your assignment should be divided into 7 sections and follow the format below: 

Your report must include: Title page, contents page, page numbers, name and student number. 

Section 1: Introduction - 200 words maximum. 

Section 2: The dataset – 200 words maximum. 

Section 3: Plot description – 300 words maximum. 

Section 4: Additional analysis – 500 words maximum. 

Section 5: Summary – 300 words maximum. 

Section 6: Reference list (not included in the word count) 

Section 7: Appendix (Python code) 

Theory and/or task resources required for the assessment:

You will need to use the Python programming language and install the following additional libraries: 

• Pandas 
• Numpy 
• Matplotlib 

Recommended choice of IDE: Visual Studio Community 2019 or PyCharm 

Depending on your choice of OS/IDE these can be installed via the IDE itself or can be downloaded separately and added to the program. 

To help install packages in Visual Studio: https://docs.microsoft.com/en-us/visualstudio/python/tutorial-working-with-python-in-visual-studio-step-05-installing-packages?view=vs-2019 

To help install packages in PyCharm: https://www.jetbrains.com/help/pycharm/installing-uninstalling-and-upgrading-packages.html 

Referencing style:

As well as any literary references you should include references to any Python script code used that is not sourced from the taught material (e.g. labs/lectures).  References should be in the Harvard style.  You do not need to include a bibliography. 

Expected word count:

Although there is no minimum word count you are expected to write no more than 1500 words in total. See section on structure for break down. Note that this is a limit, not a target.  Be succinct in your writing and avoid repetition. 

Learning Outcomes Assessed: