business statistic Excel案例 A short overview of this project. Be sure to read this carefully and ask questions about anything that you don’t understand.

Guidance on Business Statistics Portfolio

Guidance on Business Statistics Portfolio
A short overview of this project. Be sure to read this carefully and ask questions about anything that you don’t understand.


The whole portfolio is to be submitted at the end of the first week after the Winter vacation (12:00 noon on Friday 11th January 2019).


Requirements


Students will be required to submit a portfolio of written and computer-based exercises, which will include the following topics:



Topic 1:                     Sampling and Sampling Distributions

Topic 2:                     Estimation and Confidence Intervals

Topic 3:                     Hypothesis Testing

Topic 4:                     Parametric Tests (t and z tests)

Topic 5:                     Analysis of Variance

Topic 6:                     Non-Parametric Tests

Topic 7:                     Chi-squared Test (including Contingency Tables)

Topic 8:                     Control Charts

Topic 9:                     Statistical Replacement Methods



Topics 1-2 use calculations on paper and Microsoft Excel.

Topics 3-9 use a combination of Microsoft Excel and SPSS.


Students are expected to show their proficiency using a variety of tools and techniques.


The specific exercises will be issued on a weekly basis and displayed on Moodle.

Indicative exercises are attached. Some exercises use larger data sets which will be available on Moodle.

There will be an emphasis on presentation and interpretation of results as well as performing calculations correctly. A report must be submitted for each Topic (maximum 500 words per topic), this may include comments on individual questions and an overall summary. This should be included in Text Boxes in the Excel worksheets.



Please note: The Portfolio should be submitted electronically using Moodle.

SPSS output can be pasted into Excel worksheets.

If possible a single Excel spreadsheet should be submitted with one worksheet for each question clearly labelled (e.g. Topic 2 Q3). Comments should be included in Text Boxes in the Excel worksheets. Avoid zipped or RAR files.



Marking Scheme


The mark will be based on the best SIX topics. Some credit may also be given for additional exercises.

For each topic there will be a choice of questions each with marks allocated: students should answer questions or parts of questions with a total of 100 marks for each topic.

The whole portfolio is to be submitted at the end of the first week after the Winter vacation (12:00 noon on Friday 11th January 2019).



Feedback and Return of Work

All projects will be retained for external examiners.  All feedback will be provided via the feedback sheets on Moodle.  You should retain a copy for your own purposes and for security.


Plagiarism


You are reminded about the University’s rules regarding plagiarism.  Each piece of work should be original.  If you have collaborated with or given or received assistance from anyone such collaboration should be detailed.  If any evidence of plagiarism is detected, appropriate action will be taken in line with the University’s regulations.

Business Statistics Portfolio 2018-19






NOTE


In marking the portfolios, the examiner will take into account clarity of exposition and logic of arguments, effective arrangement and presentation and the use of concise and lucid English.



Candidates should ensure that all workings are clearly shown.


Indicative Marking Scheme

For each question which requires a Hypothesis Test (Topics 3-7):



Statement of hypotheses                                   10%



Choice of statistical test with reasons               10%



Correct formula and variables                           10%



Calculation of test statistic                                 30%



Determination of critical value                           10%



Conclusions                                                        10%



Explanation                                                         20%


TOTAL                                                                100%


For other questions (Topics 1, 2, 8 and 9):



Calculations                                                        50%



Description, conclusion and explanation          50%