Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
You have to submit a Word file with your solutions, findings, conclusions etc. S
You have to submit a Word file with your solutions, findings, conclusions etc. Since you will use Excel spreadsheets for finding results, you can paste these spreadsheets as well the graphs in the word file. If you did some calculations by hand, you can also scan and paste them to the work
Task:
You are managing a sales department and you need to make decisions related with you future strategy.
1) Create -invent- a monthly distribution of your sales for the last two years. Bear in mind you only work 1 week (out of 4 in August) and 2 weeks in December
2) Calculate average, standard deviation. How do you relate the accuracy of your results with this value of standard deviation
3) Make a histogram creating ranges of quarters (3 months). Explain the shape. Any outlier?
4) Calculate the 5 points of the distribution. What do the values of Q1, Q2 and Q3 mean?
5) Graph the Boxplot.
6) Let´s accept your distribution is a normal one. Give “name” to this distribution. Graph it 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 the last 24 months
9) Make a scatterplot relating sales and number of customers
10) Find the correlation equation and the index of correlation. Conclusions
Grading: 10 points per question
Documents expected (all to be submitted via Moodle):
Word file (with charts pasted) or Excel File
Font: Arial 11 pts.
Text alignment: Justified.
Harvard style in-text citations and bibliography
Submission: Via Moodle by Sunday 5th March, before 23:59hrs.
Weight: This task is worth 40% of your overall grade for this subject.
It assesses the following learning outcomes:
1. Outcome 1: Present data sets by summarizing the information, using tabular, numerical and graphical summary metrics
2. Outcome 2: Create data visualization using graphs and tables
Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
