1. You run a business that sells coffee. Create a monthly
2. 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.
3. Calculate the mean and standard deviation for the data in task 1. What does the standard deviation tell you about the data?
4. 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?
5. Calculate the 5 points (the minimum, 25th percentile, 50th percentile, 75th percentile and maximum values) of the distribution. What do the values of 01, Q2 and Q3 tell you? Answer this question using the monthly (and the not the quarterly) data! Thanks.
6. Graph a boxplot based on your answer to question 4
7. Is the distribution of the monthly sales a normal one? Graph the frequency distribution curve by hand or with Excel.
8. Find the minimum level of sales that you are going to reach with 90% probability.
9. Now make a new monthly distribution of your number of customers for your coffee shop for the last 24 months.
10. 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.
11. Find the correlation equation and the index of correlation. Draw any conclusions that you think can be drawn from the data.

Month

January 2018

Feb

March

April

May

June

July

August

September

October

November

December

January 2019

Feb

March

April

May

June

July

August

September

October

November

December

Revenue in Euros

62000

60000

65000

68000

70000

69000

66000

17000

73000

78000

66000

34000

63000

59000

64000

69000

72000

74000

70000

17000

72000

69000

72000

36000

Question 8

Month

January 2018

Feb

March

April

May

June

July

August

September

112 words

I

Revenue in Euros

63000

62000

66000

69000

71000

66000

69000

16000

74000

please answer me the details from the numbers on the bard with all the question include chart box plot but forget question 6 and 7

its urgent ???

\begin{tabular}{|l|l|} \hline Feb & 57000 \\ \hline March & 64000 \\ \hline April & 68000 \\ \hline May & 71000 \\ \hline June & 72000 \\ \hline July & 69000 \\ \hline August & 16000 \\ \hline September & 69000 \\ \hline October & 68000 \\ \hline November & 71000 \\ \hline December & 35000 \\ \hline \end{tabular}