Reference no: EM132491902 , Length: word count:1500

The assignment consists of two parts: Analysis and Report. You are required to submit both your written report and your analysis.

Guidelines for Data Analysis

Read the case study and questions asked by Edmond carefully. Then spend some time reviewing the data to get a sense of the context. The analysis required for this assignment involves material covered in Module 1, with the corresponding tutorials being a useful guide.

The analysis should be submitted in the appropriate worksheets in the Excel file. Each question from the email should be analysed in a separate tab (e.g. Q1, Q2 ... or Q3.1, Q3.2 ...). You need to add these. Before submitting your analysis, make sure it is logically organised, and any incorrect or unnecessary output has been removed. Marks will be penalised for poor presentation or disorganised/incorrect results or any unnecessary output.

For all questions in the email, you can assume that:

• 95 % confidence level is appropriate for confidence intervals and;
• 5.0 % level of significance (i.e. α = 0.05) is appropriate for any hypothesis tests.

You can complete all data analysis using the Excel templates provided in the assignment data file. In choosing the technique to apply for a given question, keep the following in mind:

• Are we dealing with a numerical variable or categorical variable?
• Are we dealing with one sample, two samples or more than a two-sample situation?
• Are we dealing with independent samples or a paired-sample situation?
• Each question must be answered using the most appropriate technique and justify your decision where applicable.
• For relevant questions, please formulate your hypotheses, and state them clearly in both notation and words.
• Even though a question(s) may lead you to inferential techniques, consider conducting a descriptive analysis of the sample data first.

Guidelines for the Technical Report

Once you have completed your data analysis, you need to summarise the key findings for each question and write a response to Edmond in a report format. Your technical report consists of four sections: Introduction, Main Body, Conclusion, and Appendices. The report should be around 1,500 words.

Use proper headings (e.g. Q1, Q2 ... or Q3.1, Q3.2...) and titles in the main body of the report. Use sub-headings where necessary.

General instructions:

• Include relevant excel outputs including templates, tables, charts, and graphs inAppendices (appendices are not included in the word count).
• Make sure these outputs in the Appendix are visually appealing, have a consistent formatting style and proper titles (title, axes titles, etc.), and are numbered correctly. Where necessary, refer to these outputs in the main body of the report. If an output, graph or chart is not referred to in the body of the report then do not include it in your appendix.

• The introduction begins by highlighting the main purpose(s) of the analysis and concludes byexplaining the structure of the report (i.e., subsequent sections). The conclusion should highlight the key findings of the analyses and explain the main limitations (if any).

Attachment:- Case Study - Analysis and Report.rar