Business and Management

Data Analysis Tools with Application

(QHO430)

Feb 22 to May 22

Lecturers: Dr Hakim Mezali

Dr Ajmal Gharib

Emails: [email protected]

[email protected]

Programmes : BSc Business and Management

BSc Computer Science

FORMAT OF WRITTEN WORK

Students are required to adhere to the following instructions:

Front Page – Cover page with Student Name, Matric No, Module Code and Name

Page 2 – Table of Contents.

Last page – references.

Note:

Use Times New Roman, 12 normal fonts.

1.5 single spacing.

Numbered the pages (at the bottom centre) except for the Cover Page.

Appropriate Harvard referencing. Footnotes may be used to direct readers to appropriate appendices

Instructions:

1. Do this assignment individually. Students may collaborate, as a group, to find a particular dataset and brainstorm what analyses could be done on it. However, they then need to perform their individual analyses and based on those complete their reports.

2. Your work for this assessment should be submitted in a word document and must include all relevant output from Excel to avoid losing mark

3. You are required to explore, analyse and interpret the output.

4. Choose one or two of the models below that you have learned in this module:

5. Go through the weekly materials and based on those perform relevant analyses on your chosen dataset and include the results in your report.

6. You should demonstrate a good understanding of the key data analysis concepts, such as probability, correlation, regression, time series analysis, forecasting, box and whisker plot and importance of visualization.

Please bear the following points in mind:

a). If you use simple linear regression analysis with one independent variable, your answers should include the following in the context of the problem.

– graphical presentation (scatter diagram)

– regression equation,

– interpretation of correlation coefficient, coefficient of determination,

– interpretation of y-intercept, the slope (gradient)

– comment on the P-values test

– your conclusion of the regression model.

b) If you use multiple linear regression analysis with more than one independent variables, your answers should include the following in the context of the problem.

– graphical presentation (scatter diagram) of the dependent variables with each

independent variables

– regression equation,

– interpretation of correlation coefficient, coefficient of determination,

– interpretation of y-intercept, and all the slopes (gradients)

– comment on the P-values test

– your conclusion of the regression model.

For forecasting analysis, using time series data:

Construct a time-series plot for this data set.

Describe any trend and seasonal behavior that you can see in the plot.

Compute seasonal indices using moving (MA) average followed by a centre moving average (CMA).

Obtain forecast for the next three quarters.

If you use Dashboard Analysis to answer business key indicators performance, then fellow all the steps and the functionality that was introduce in the lecture (i.e., Excel Class Example)

Plagiarism

Plagiarism may occur in either oral or written presentation. It is passing someone else’s work or idea as one’s own. Plagiarism includes cutting and pasting text from websites and will be severely penalized. If you use someone else’s work, you should first read it to understand it then paraphrase it or write about it in your own words and finally reference it.

Examples of plagiarism include:

Copying sentences or paragraphs word for word from one or more sources, whether published or unpublished, which could include but is not limited to books, journals, reports, theses, websites, conference papers, course notes, etc. without proper citation,

Closely paraphrasing sentences, paragraphs, ideas, or themes without proper citation,

Piecing together text from one or more sources and adding only linking sentences,

Copying or submitting whole or parts of computer files without acknowledging their source,

Copying designs or works of art and submitting them as your original work,

Copying a whole or any part of another student’s work,

Submitting work as your own that someone else has done for you.

QA Higher Education strives to be a centre of academic excellence. As part of our Statement of Ethics, QAHE strives to preserve academic honour and integrity by repudiating all forms of academic and intellectual dishonesty, including cheating, plagiarism, and all other forms of academic dishonesty. Academic dishonesty is unacceptable and is subject to a disciplinary response.