Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

IDBQM001 Quantitative Methods for Business

2022-2023

Coursework Assignment

This assignment is worth 25% of the total marks.

Task:

The data set consists of samples from 8 consecutive cohorts of students; they are all of size 200 and are stratified by major. The students are then further classified by gender, mode (FT or PT) and average.

You can:

    Represent the data according to the different categories, finding appropriate charts for

the data (pie charts, histograms, etc…).

    Compute some descriptive statistics on the samples, comparing values by year or

category.

   Analyse the data by doing some correlation analysis on the averages, first classifying

them by category.

    Do a time series analysis, perhaps by major or mode in order to make predictions on

future average marks. You should comment on the reliability of their predictions for higher marks.

You should submit a single Word document consisting of the following:

1.  A short research paper of no more than 1,000 words (plus appendices and references). You should use the template provided by your tutor.

2. An appendix containing any charts, graphs, tables and statistical measures.

 

<40

40-50

50-59

60-69

70+

1. a)

Research

paper

(~50%)

Major sections of the research paper are        missing .

No reference to context.

Does not refer to appendix.

No effort to      analyse results or make           suggestions for further study.

Appendix

disorganized

and not

commented.

Most sections of the research     paper are          present.

Little reference to context.

Describes parts of the appendix material, rather than the           information      displayed .

Appendix          referred to only sporadically.

All sections of the research  paper are      present.

Generally well written with   reference to   context.

Analysis

generally

correct.

Appendix         referred to in   text and           reasonable lay- out.

All sections of the research  paper are      present.

Well written   with reference to context.

Results mostly reasonable and sensible.

Some effort to look at            implications.

Written at a     level accessible to a non-         statistician.

Appendix           referred to in     text with a good lay-out.

Clearly structured,  signposted and well written with            continual reference to context

Results are sensible and clearly              interpreted and       explained.

Analysis goes         beyond context to  look at implications of information        and/or forecasting  (recommendations, further study, etc.)

Written at a level    accessible to a non- statistician.

Appendix referred to in text, clearly laid out and         commented.

1. b)

Data

presentation (~50%)

Graphs etc.       presented with  no attempt to    improve on       default settings.

 

Graphs

inappropriate

for goals.

Numerical

measures

inappropriate

and not

interpreted .

Some attempt to format         output, but      poorly labelled, some output    inappropriate   for goals, and  do not add       much insight    into the issues discussed .

Numerical

measures       inappropriate, or wrongly      calculated, or interpretation does not add  much to         understanding of data.

Most graphs      clearly labelled and appropriate for type of data and goals

All graphs         clearly labelled, formatted and  appropriate for type of data     and goals.

Graphs aid in    understanding  of arguments    made in memo .

Numerical

measures and  their                interpretations mostly correct  and add insight into data .

Evidence of      some more       sophisticated    use of Excel     Functions using conditions.

All graphs clearly  labelled and          appropriate for the type of data and   goals.

Creativity in          creating graphs to make the required points.

Graphs fully        support write-up.

Numerical

measures                interpreted well and contributed to         understanding

 

Evidence of             appropriate and      sophisticated use of Excel Functions to   analyse and present data.

Graphs

generally

understanding of arguments made in the   memo.

Numerical

measures and  their                 interpretations generally          correct and add some insight    into data .

Evidence of     some use of    basic Excel      Functions such as AVERAGE,

STDEV.