BCOBM122 APPLIED DATA ANALYTICS – Task brief & rubrics
Mid-term assignment
Task:
· Individual task in which you complete a portfolio of written assessments
· You must submit your assignment on the Moodle page of this course by 5th March 2023 at 23:59 Central European Time
· You must submit your work as a Word document
Portfolio of questions – each question is worth 10% of the marks for this assignment:
With reference your knowledge and relevant information and theories:
1. You run a business that sells coffee. Create a monthly distribution of your revenue per month for the last two years. Bear in mind you only work for 1 week out of 4 in August and only for 2 weeks in December.
2. Calculate the mean and standard deviation for the data in task 1. What does the standard deviation tell you about the data?
3. Convert the data in question 1 to quarterly (3-month period) revenue data. Then construct a histogram for this quarterly data in question. Explain/analyse the shape of the histogram. Are there any outliers?
4. Calculate the 5 points (the minimum, 25th percentile, 50th percentile, 75th percentile and maximum values) of the distribution. What do the values of Q1, Q2 and Q3 tell you? Answer this question using the monthly (and the not the quarterly) data! Thanks.
5. Graph a boxplot based on your answer to question 4.
6. Is the distribution of the monthly sales a normal one? Graph the frequency distribution curve by hand or with Excel.
7. Find the minimum level of sales that you are going to reach with 90% probability.
8. Now make a new monthly distribution of your number of customers for your coffee shop for the last 24 months.
9. Construct a scatterplot that relates sales to the number of customers per month in question 8 to the revenue per month that you produced in task 1.
10. Find the correlation equation and the index of correlation. Draw any conclusions that you think can be drawn from the data.
Formalities:
· You may want to include images/graphics etc. (for example from their website) to make your reasoning and argumention more visual and explicative
· Font: Arial. Size: 12,5pts. Line spacing: 1,5. Text align: Justified.
· Appendices and References, do not count towards the final wordcount but are strongly recommended (referencing websites, articles, books etc.)
Submission: of the assignment is due on Turnitin by 5th March 2023 at 23:59 Central European Time
Weight: This task is worth 40% of your overall grade for this subject.
Outcomes: This task assesses the following learning outcomes:
· Learning outcomes 1 to 4 in the course outline
Exceptional
90-100
Good
80-89
Fair
70-79
Marginal fail
60-69
Knowledge and Identification of the main Issues
20%
Identifies and demonstrates a sophisticated understanding of the main issues / problems in the case study
Identifies and demonstrates an accomplished understanding of most of the issues/problems.
Identifies and demonstrates acceptable understanding of some of the issues/problems in the case study
Does not identify or demonstrate an acceptable understanding of the issues/problems in the case study
Application
30%
Student applies fully relevant knowledge to the situation provided
Student applies mostly relevant knowledge to the situation provided
Student applies some relevant knowledge to the situation provided. Some minor misunderstandings may be evident.
Student applies little relevant knowledge to the situation provided. Misunderstandings are evident.
Evaluation
30%
Student assembles a coherent response to the question, providing a range of support and justification that leads to a well-reasoned conclusion
Student assembles a good response to the question, providing support and justification that lead to a well-reasoned conclusion
Student assembles a fair response to the question, providing some support and justification that lead to a well-reasoned conclusion. Minor misunderstandings may be evident
Student’s response to the question lacks coherence. Limited support and justification are provided that may or may not be well linked to the conclusion
Communication
20%
Student communicates ideas extremely clearly and concisely. Compliance with the guidelines on font, size, line spacing and text align will also be taken into account.
Student communicates ideas clearly and concisely. Compliance with the guidelines on font, size, line spacing and text align will also be taken into account.
Student communicates ideas fairly clearly and concisely. Compliance with the guidelines on font, size, line spacing and text align will also be taken into account.
Student attempts to communicate ideas clearly and concisely, with some problems. Student does not follow the guidelines on font, size, line spacing and text align.
Rubrics
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
