Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- Individual task in which you complete a portfolio of written assessments - You must submit your assignment on the Moodle page of this course

image text in transcribed
- 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 mariks for this assignment: With reference your knowledge and relevant information and theories: 1. You fun 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 polnts (the minimum, 25 percentile, 50 percentle, 75th percentile and maximum values) of the distribution. What do the values of Q1. Q and Q3 tell you? Answer this question using the monthly (and the not the quarterly) datal 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 dlatribution 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 menth 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 webaite) to make your reasoning and argumention more visual and explicative - Font: Arial, Sire: 12,5pts, Une spacingri,5, Text align: Justified. - Appendices and References, do not count towards the final wordcount but are strongly recommended (referencing websites, articles, books ete.) Submission: of the assignment is due on Turniin by 5 - 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

a) Find the running time (RT) the code below: for(int i = 1;

Answered: 1 week ago

Question

7. Where Do We Begin?

Answered: 1 week ago

Question

a. What is the purpose of the team?

Answered: 1 week ago