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

I have been taking help from Insta Research since 2015 and believe me, this place is incredible in giving the best help in assignments and essays. I also ask them to run plagiarism in my essays that I have written, and they always gave me accurate results. I am literally blessed to have a strong bonding with this site so that in any need of urgency, I contact them and find them always beside me. Thank you!
Reviews: 5

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

My writer did a small error in my work but it was fixed by him shortly. The work is admirable and I have submitted it. Now hoping for the best results. I would inform you soon.