Business and management statistics

Module learning outcomes being assessed:
LO2. Analyse realistic management problems based on analysis of data sets and case materials.
LO3. Apply the techniques studied to interpret and communicate findings on data analysis.
This assignment is an individual assignment.
Your coursework consists of the following three tasks with tasks 1 and 2 based on the results
of a survey. Some similar tasks will be performed in seminars with the tutors’ guidance.
However, some parts of these tasks will require independent study.
As well as submitting the coursework as a word report for all three tasks you MUST also
submit an excel spreadsheet containing the analysis which you have used in your word report.
[Continued o
This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
passed to third parties or posted on any website. Any infringements of this rule should be reported to [email protected]
Assignment Brief
Page 2 of 6
Task 1: [35 Marks]
The file “Survey_Data_Sem2.xls” contains the data of an anonymous survey.
Click on the red triangles, within the spreadsheet, to see details of each variable.
The purpose of this report is to:
? Describe the sample
? Investigate whether factors such as gender, type of student and age influence the
commuting time to University.
The report should contain quantitative information, summary statistics and appropriate charts
and tables.
The marking scheme is as follows:
? Report Structure and Presentation
o Introduction and summary [5 marks]
o Structure, layout, use of spell checker, charts and tables in text [5 marks]
o Conclusion [5 marks]
? Analysis
o Description of the data. [10 marks]
o Investigation of factors affecting the commuting time to University.
[10 marks]
[Continued on next page]
This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
passed to third parties or posted on any website. Any infringements of this rule should be reported to [email protected]
Assignment Brief
Page 3 of 6
Task 2 [35 Marks]
Use the survey data to conduct regression analysis to investigate the relationship between the
time taken from the student’s accommodation to Coventry University and the time spent doing
part time work.

1. Conduct linear regression analysis.
   ? Perform, using Excel, Data Analysis Pack, Regression function, the regression
   analysis
   [5 marks]
2. Produce the scatterplot including a fitted regression line.
   [5 marks]
3. Write the regression equation using the results of the excel table.
   [4 marks]
4. Determine and interpret the slope
   [3 marks]
5. Determine and interpre
   This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
   passed to third parties or posted on any website. Any infringements of this rule should be reported to [email protected]
   Assignment Brief
   Page 4 of 6
   Task 3: [30 Marks]
   The following table gives the key activities required for a product promotion campaign.
   Activity ID Description Proceeding Activity Duration
   (Weeks)
   A Approval of training
   budget

• 1
  B Training of service staff A 9
  C Training of sales staff A 3
  D Sales promotion to
  distributors
  C 4
  E Distribution to distributors D 2
  F Distribution to retailers E 4
  G Advertising brief A 2
  H Advertising contract G 1
  I Illustrations and text H 4
  J Printing I 4
  K Product launch B, F, J 1
  Using the above table determine:

1. Using the above table construct a network diagram for the project.
   [5 marks]
2. Now construct a precedence diagram for the project.
   [10 marks]
3. Determine and state the critical path
   [8 marks]
4. List and state the float associated with each activity
   [5 marks]
5. What is the complete duration of the project?
   [2 marks]
   [Continued on next page]
   This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
   passed to third parties or posted on any website. Any infringements of this rule should be reported to [email protected]
   Assignment Brief
   Page 5 of 6
   Guidelines for completing task:
   Follow the procedures, techniques and Excel-based techniques taught in seminars. Theories
   delivered in lectures will help you to answer descriptive questions. If you need further
   support please contact your seminar tutors.
   Word Count
   The section for which a word limit primarily applies is for Task 1. The word limit for this
   task is 750 words.
   It is recommended that you only use Appendices for supporting material and not for the
   substantive part of your work.
   There will be a penalty of a deduction of 10% of the mark (after internal moderation) for
   work exceeding the word limit by 10% or more.

Sample Solution