Briefly discuss why a 3D chart is not suitable to include in a report.

Resit Statistics Assignment

You must answer both Questions and Also Attempt the Online Statistics Test

Your answers should be produced in a single word processed document, with any charts produced being copied into this document, and a summary of any calculations that you have made being put into a suitable table where asked for. Do not include any calculations in the report, unless you are using them as an example in your explanations. Your spreadsheet should be submitted as a supporting document, and will be checked for the correct use of formulae.

Your answers are being presented to your manager, and whilst a formal report format is not required, you must take care with the presentation, spelling, and grammar.

Question 1 (10 Marks)

Critically evaluate this histogram (the drawing contains some errors).

Comment on the shape of the above histogram and explain what this infers about the mean and median.
(2 marks)

Briefly discuss why a 3D chart is not suitable to include in a report.
(2 marks)

What is generally the difference between the mean and the median (use your own words)? When should you be using each of the measures? Use fully worked examples to help demonstrate your answer.
(6 marks)

Question 2. (25 Marks)

You work for a travel company that runs holiday hotels throughout the Mediterranean. The general manager is worried that overall numbers of excursions purchased (a very profitable line for the hotel group) are falling. You have been asked to analyse data relating to the total number of excursions booked per quarter, and to provide forecasts for the numbers in 2021. Please note that the effect of reduced sales in 2020 has been ignored and so please do not take into account what the assumed real sales would be!

He has provided you with the following data since 2017.

Numbers of excursions sold (000’s)
Q1 Q2 Q3 Q4
2017 900 1555 2010 1065
2018 995 1600 2080 1074
2019 1000 1660 2200 1206
2020 1020 1680 2300 1110

The trend values have been calculated for you as follows – you do not need to check these:

Year  Quarter Data (000’s) Trend
2017 1 900
2 1555
3 2010 1394.375
4 1065 1411.875
2018 1 995 1426.25
2 1600 1436.125
3 2080 1437.875
4 1074 1446
2019 1 1000 1468.5
2 1660 1500
3 2200 1519
4 1206 1524
2020 1 1020 1539
2 1680 1539.5
3 2300
4 1110

Draw the appropriate graph using the above information given.
(5 marks)

Paste in a copy of your graph showing the fully annotated projected trend lines.
(3 marks)

Paste in a copy of your average seasonal variation (ASV) calculations with an explanation of the meaning of the final values for each quarter, using terms that your manager would understand.
(6 marks)

Put your final forecasts into a suitably headed table – showing the forecasted values for 2021 ONLY.
(4 marks)

Clearly explain to your manager your model choice (you must include a copy of your annotated graph to show this)
(4 marks)

General presentation, spelling and grammar including submitting your spreadsheet and correct use of formulae
(3 marks)