We're Open
+44 7340 9595 39
+44 20 3239 6980

Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket

  100% Pass and No Plagiarism Guaranteed

Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket employees

Probability & Statistics

Question 1

Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket employees:

- the number of months the employee has worked at the supermarket

- the employee’s age

- the number of hours worked per week

- the average number of items processed per minute during a two-hour test period

 

Task

The Supermarket Manager has asked you to investigate which factors are useful for predicting employee checkout speeds (measured by average number of items processed per minute in the sample data).

Carry out a detailed statistical analysis on behalf of the Supermarket Manager, ensuring that you make full use of all the available data.

As a minimum your professionally presented analysis and report should include:

 Appropriate charts

 Detailed calculations and interpretation at each stage of your analysis

 Commentary on the data used for this investigation

 

(12 marks)

 Model assumptions and detailed analysis (numerical and/or graphical) checking whether any of the assumptions have been violated (10 marks)

Comparison of a range of possible models (maximum of 15 marks)

 Selection of the most appropriate model and your reasoning for this choice (5 marks)

 Recommendations for improvements or further analyses (5 marks)

 Professional presentation (3 marks)

 

(Total 50 marks)

Question 2

A double glazing company decides to pay some of its sales representatives by the hour instead of on commission. The sales (in thousands of £) achieved during the test period by 45 hourly paid and 40 commission paid representatives is given in Sheet “Q2 Data” of the Excel file “P&S Data December2016.xls”.

Task

In order to select the ‘best’ payment method, the Finance Director has tasked you to test whether there is a difference between the mean sales figures of the two groups of representatives.

Required statistical analysis

It is crucial that you carry out a robust statistical analysis as your conclusion will play a major role in the way forward for this company.

As a minimum your professionally presented analysis and report to the Finance Director of the double glazing company should include:

 Appropriate descriptive statistics and charts

 Commentary on the data used for this investigation

 

(10 marks)

 A rationale for the statistical technique(s) selected

 An explanation of any statistical terms used in your analysis

 Any assumptions you have made, with detailed calculations and interpretation at each stage of your analysis

 

(30 marks)

 Recommendations for improvements or further analyses (5 marks)

 Professional presentation (5 marks)

 

(Total 50 marks)


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket employees
  • Price: £ 99
  • Post Date: 2018-11-10T13:00:12+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket employees Sheet “Q1 Data” of the Excel file “P&S Data December2016.xls” contains the following data from a sample of 50 supermarket employees
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The support team is quite friendly and gives you the best solutions. I literally came here crying and went smiling like an idiot. My HR assignment is written beautifully with all the specifications I wanted. This is the best platform to get helped in assignments for me. All the people are supportive. Keep it up you all!
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The rates are a bit expensive for me of the essay writing service but the overall look is amazing. The references and formatting are done beautifully. So, I feel that the high rates are worth all these qualities. I want to thank you for great help.