Posted: July 25th, 2024

Portfolio of exercises.

PORTFOLIO OF EXERCISES

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

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

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.

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

Rubrics