MSCI 212 Statistical Methods for Business

Custom Research Paper Writing Service 

2020-2021 COURSEWORK

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

PART II (Second, Third and Final Year)

MANAGEMENT SCIENCE

MSCI 212 Statistical Methods for Business

WRITTEN COURSEWORK ASSIGNMENT (DUE WEEK 12)

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

Q1]

  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 (e) by modelling monthly seasonality. Compare and contrast the resulting

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

 

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*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.
Testimonials
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.
Communications
Perfectly done. I would love to continue working with this writer thought out the 11-week course. Thank you.
Customer 452445, October 24th, 2021
Health Care
Great work, met all the requirements, and followed all instructions perfectly!
Customer 452445, December 20th, 2021
Business Studies
Great Work. Very Thorough
Customer 452445, January 12th, 2022
Nursing
Writer was cooperative and got me an A on my paper.
Customer 452445, December 23rd, 2021
Human Resources Management (HRM)
I am very pleased with your work and how it was completed in a timely manner. I will be requesting this writer for future assignments. Excellent work!
Customer 452445, June 10th, 2022
Human Resources Management (HRM)
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452445, June 6th, 2022
Criminal law
I got an A. I recommend homeworkstand.
Customer 452445, October 31st, 2021
Classic English Literature
Wonderful writer. Pay attention to detail. Does not plagiarize. Always completes work on time!
Customer 452445, March 3rd, 2022
Classic English Literature
The writer wrote a perfect paper in short amount of time.
Customer 452445, December 14th, 2021
Human Resources Management (HRM)
very professional work. on time, highly recommended thanks
Customer 452445, March 7th, 2022
Social Sciences
The write was very patient with my instructions and did their best to provide quality work according to my request.
Customer 452445, November 2nd, 2021
Business Studies
Amazing job on a tight deadline. Met all requirements and some. Will hire again if needed.
Customer 452445, March 3rd, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
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