Order Description
Data Analysis Report Coursework 2: 60% weighting o Assesses learning outcome 1 and 2 o This comprises the application of descriptive and inferential techniques within EXCEL to analyse business data
For CW2, the assignment, you are asked to calculate several statistics, such as the mean, the variance, or draw several graphs, such a stem and leaf diagram, a dot plot, etc.
For full marks it is not enough to simply give me the numbers EXCEL calculates for you or to simply give me the graph. You need to be able to explain what the mean is, what the variance is, and why we use them, etc. This has to be done for all calculations and graphs. Explain what they are and why we use them.
For example, let’s say you calculate the mean to be 50. If you simply write “Mean = 50” in the assignment you will not be awarded full marks. You need to be able to explain what the mean is, why we use it, what are its advantages and disadvantages, and then tell me the number “50”. You may also discuss what this “50” actually means.
The point I would like to make is that I would like to see that you understand, thoroughly, what each measure is and why we use it, and what kind of information it provides.
The reason you will not be awarded full marks for a simple “Mean=50” is that the calculations are being done by Excel so in essence, by simply relaying that information, you are not showing any signs of learning.
In short, write as much as you can. There is no word limit.
My apologies for this but a fellow student asked me how I would like to receive the results of CW2 since the work is in Excel.
Yes the work must be done in excel but you have to transfer everything over to word. Make sure you present your findings in Word in a nice format. The last page or two of the assessment brief explains this in detail.
In short do your calculations in Excel but present everything in a nice formatted way in Word. This is what expected by your future employers, a nice, readable, summary of your findings.
