MANAGEMENT SCIENCE Statistical Methods for Business

Custom Research Paper Writing Service 

2020-2021 COURSEWORK

Don't use plagiarized sources. Get Your Custom Essay on
MANAGEMENT SCIENCE Statistical Methods for Business
Just from $13/Page
Order Essay

PART II (Second, Third and Final Year)


MSCI 212 Statistical Methods for Business


Please read the following instructions carefully.

  1. Your coursework must be submitted electronically to the MSCI212 Moodle site as a single document by 10:00am on Monday, 18th January 2021. The place to submit your file is in the Coursework section of the MSCI212 Moodle site.
  2. Your coursework will NOT be accepted unless you sign and return a declaration form (available from the Web Board) that includes the statement that you have read and understood the University regulations relating to plagiarism. Plagiarism includes:
    • Collusion, where a piece of work prepared by a group is represented as if it were the student’s own;
    • The purchase of a paper from a commercial service, including Internet sites, whether pre-written or specially prepared for the student concerned;
    • The submission of a paper written by any other person, including a friend, a fellow student or a person who is not a member of the university;
    • The submission of another student’s work, whether with or without that other student’s knowledge or consent.

Incidents of plagiarism are recorded on a student’s file. Penalties are in line with the institutional framework of the University.

  1. In accordance with University regulations, marks are deducted from any coursework which is not submitted by the deadline. This penalty will apply for 3 days after the deadline and then a mark of zero will be given to any work not submitted. However, if an extension is given then the rule applies from the date of the extension.
  2. This coursework has two questions and you must answer both questions in full.
  3. Both questions carry equal marks (50%) and you should be able to begin Question 1 immediately; for Question 2 some other important tools will still be covered later.
  4. Each of your answers should state clearly your reasoning. Please also state clearly any assumptions that you have made in addition to those given in the questions.
  5. You are allowed to submit handwritten answers but should include carefully selected extracts of your SPSS output to justify your answers. Also, please write neatly and if we cannot read your handwriting your answer will NOT be marked.

Question 1 [Worth 50% of the marks]

As at workshop 2, use <Transform><Random Number Generators> to set your unique starting point for the SPSS random number generator. For this coursework question use the last four digits of your library card PLUS 1, i.e. if your library card ends ‘4321’ type in ‘4322’, and if your library card ends ‘4329’ type in ‘4330’. Record these four digits at the top of your answer.

Accident and Emergency Departments (AEDs) in hospitals in England have to deal with highly variable workloads, providing high quality healthcare within a reasonable length of time. The government has set a target that 95% of patients should leave the AED within 4 hours. Data gathered on the 8781 patients who attended one such AED over a 4 week period is contained in the SPSS data file ‘AED4weeks.sav’ in the following variables:

  • Age – of patient in years;
  • Day – numbers the days 1 to 28 ;
  • DayofWeek – Monday … Sunday;
  • Period – patient’s time of arrival at AED, where ‘0’ means between midnight and 1am, ‘1’ means between 1am and 2am, etc.
  • LoS – Patient’s length of stay in the AED (in minutes);
  • Breachornot – patients who spend more than 4 hours in the AED have breached the NHS 4- hour performance target;
  • HRG – Health Related Group – this is a code that categorises the treatment that the patient received;
  • noofinvestigations – number of diagnostic tests and other investigations that were performed on the patient;
  • nooftreatments – number of treatments that the patient received;
  • noofpatients – the number of patients who were already in the AED when the patient arrived.

You have been asked by the AED management to use a sample of this data to help them describe to the hospital management the nature of the workload going through the AED, and the extent to which causes of patients breaching (or just staying in the AED a long time) can be identified.

Draw a random sample of 400 patients from this 4 week period and investigate your sample using SPSS.

  1. In no more than 6 pages describe the main features of your sample as if to the hospital management. You should include main features of individual variables and interesting relationships between them. You may include SPSS numerical and graphical output and/or you may quote values from your SPSS output. (The clarity and content of your report are both important). [Worth about 75% of the marks for


  1. Using your sample as evidence, explain what you believe may be causes of patients breaching (or just staying in the AED a long time). [No more than 2 pages. Worth about 25% of the marks for Q1]

Question 2 [Worth 50% of the marks]

You should include key parts of your SPSS output in your answer. You must explain your answer clearly and you are limited to a maximum of 6 pages plus 3 pages of Appendix.

Matching production with demand is essential in modern day manufacturing to avoid huge inventory costs. To achieve this a good prediction of sales is important so companies can avoid producing too much or too little. The BSW-Bens motorbike company is a major motorbike manufacturer in UK. Their only custom made model is also named after the company and has been produced since 1990. The task in this question is to build linear regression models to predict monthly sales using economic indicators of the UK as well as Google search queries. The data for this problem is contained in ‘BSW-Bens.csv’. Each observation in the file is a month, from January 2010 to February 2014. The variables are given in Table 1.

  1. Using descriptive and graphical methods conduct an exploratory analysis on the given data and generate some insights for conducting regression analysis. [Worth about 10% of the marks for Q2]
  2. Use linear regression to determine which, if any, of unemployment, Google queries, CPI.All and CPI.Energy show evidence of a significant linear relationship with sales? Justify your answer. [ Worth about 24% of the marks for Q2]
  3. Which of the four models do you think is best? Justify your answer. Carry out a common-sense based examination of the residuals for your chosen model and comment on your findings. [Worth about 6 % of the marks for Q2]
  4. Use your models from part (c) to estimate the value of sales for the following scenarios: (i) at unemployment rate 9, with 200 Google queries, with CPI.All 220 and CPI.Energy equal to 200; (ii) at unemployment rate 5, with 700 Google queries, with CPI.All 250 and CPI.Energy equal to 220;. Explain your beliefs about the accuracy of your estimates as if to a sales manager of the company. [ Worth about 10% of the marks for Q2]
  5. Investigate as far as you are able the possibility of a multiple linear regression model using unemployment, Google queries, CPI.All and CPI.Energy as explanatory variables. Explain clearly what you believe your results are telling you. [Worth about 20% of the marks for Q2]
  6. Modify your model in part (d) by modelling monthly seasonality. Compare and contrast the resulting

model with the model in part (d). [Worth about 30% of the marks for Q2]

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Home Work Stand
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
I am so pleased with your services Thank you so much for a well-done job with my papers!
Customer 452445, January 12th, 2022
Political science
The best Writer, always perfectly written papers!
Customer 452445, January 20th, 2022
Human Resources Management (HRM)
Always amazing work! Easy communication and made changes according to my needs!!
Customer 452445, January 5th, 2022
Great writer. I get a 100 on everything I turn in from here :)
Customer 452445, January 16th, 2022
Business Studies
Remarkable work!! Always helpful and amazing communication!!
Customer 452445, January 4th, 2022
Classic English Literature
Great work and delivered on time. thank you.
Customer 452445, October 30th, 2021
You have done a fantastic job ???? thank you.????
Customer 452445, January 14th, 2022
The writer has done an amazing job. I am very pleased!
Customer 452445, January 11th, 2022
Excellent work, thank you so much for doing this on such short notice! You're a lifesaver!
Customer 452445, January 21st, 2022
Criminal law
Great experience with this writer, my paper is always ready before my deadline and done professionally.
Customer 452445, January 28th, 2022
Biology (and other Life Sciences)
Customer 452445, October 30th, 2021
Social Sciences
The formatting was not okay but the paper was great.
Customer 452445, November 2nd, 2021
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Order your essay today and save 15% with the discount code ESSAYHELP