Resit Assignment Hand-in Procedure & Statistics Questions

Hand-in Procedure

Please read this document carefully prior to proceeding with your resit question.

Your results indicate that you have not passed Assignment 1 (statistics) for the Introduction to Accounting & Finance module and as such you are required to re-sit it. Please ensure you have checked the work that you submitted online and that you fully understand the feedback provided.

All assignments must be submitted by the due date as indicated, via Blackboard. (Instructions below – same as for your first assignment).

Failure to comply by these rules is likely to result in your work not being marked.

Please note that the screenshots are for previous years so the dates will be different!

To submit your assignment click on Assignments – left hand side of the module page - here.

You will then see the assignments submission page.  For your resit statistics there is just one option

Once you have clicked on the link, you will see the following page:

You will need to add each of your submission files – should be a word processed document and a spreadsheet. You add them one at a time.

Make sure that your word processed document is saved as a .doc or .docx file, and your spreadsheet is saved as a .xls or .xlsx file.  

These are the standard MS Office types and your files will be saved in this format automatically if you are using MS Office.  If you are using a different word processor or spreadsheet, you will need to choose the “save as” option, and choose the MS options

See the screen shot below for how the screen should look with both files attached.

Once you are happy that the correct files have been selected, click the submit button, at the bottom of the page. Your assignment has now been submitted to the system and will be marked.

You will be able to view your submission files – see below (the file is NOT your assignment, so don’t try to read the file  ).

You must click on both submissions to view each file.  If you cannot see the detail in your files, then you probably do not have the correct file extensions.  Check that they are .doc(x) and .xls(x) (See above).  If you cannot see the detail you will need to resubmit in the correct file format!

Once you are happy that the correct files have been uploaded, you click OK at the bottom of the screen.  

Resit Statistics Assignment

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

a.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.

b.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.

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

Question 2.

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!

a.Draw the appropriate graph using the above information given.

b.Paste in a copy of your graph showing the fully annotated projected trend lines.

c.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.

d.Put your final forecasts into a suitably headed table – showing the forecasted values for 2021 ONLY.

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

F.General presentation, spelling and grammar including submitting your spreadsheet and correct use of formulae