IDBQM001 Quantitative Methods for Business 2022-2023
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. |
2023-03-25