Statistics Question

Ministry of Education Saudi Electronic University College of Science & Theoretical Studies ___________________________________________________________________ Quantitative Methods (STAT-201) Assignment 3: Excel QM (Social-Responsible) 2nd Semester, 1444-1445 (2023-2024) Due date: 06 May 2024 (Time: 11:00 PM) Student’s Name Student’s ID Section/CRN Location Marking Scheme Question Score Q-1 2 Q-2 2 Q-3 2 Q-4 2 Obtained Score Note: You are required to fill your full name, ID, and CRN. Message: Social responsibility is a framework of ethics in which an individual collaborates and works with other organizations and individuals for the betterment of the community. There are numerous ways in which an organization can exhibit social responsibility; for instance, by promoting volunteerism, facilitating donations, employing ethical employment practices, and implementing environmental improvements. It introduces the subjective obligation that entails maintaining a delicate equilibrium between one’s ecosystem and the economy, as well as the potential compromises that may be made between economic progress and societal and environmental wellbeing. This transcends business organizations and affects all individuals whose actions influence the environment. Restricted – ‫مقيد‬ Ministry of Education Saudi Electronic University College of Science & Theoretical Studies Solve the following questions using Excel QM. (2×4 = 8 marks) 1. Helping others through blood donation is a form of social solidarity or social responsibility. The blood donors cite a sense of social responsibility as their reason for donating blood, and as a result, the communities value and reward this activity. The following table shows the number of blood donors in a university from 2011–2023. Develop a 3-year moving average forecast and obtain the related statistical measures using excel QM. Solution: Restricted – ‫مقيد‬ year Blood Donors 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 116 105 146 159 108 194 227 219 234 224 248 253 265 311 Ministry of Education Saudi Electronic University College of Science & Theoretical Studies 2. University X has a unique on-campus dispensary that provides medical care. On a typical working day, patients arrive at the dispensary at an average rate of 2 patients per hour. There is one single nurse at the dispensary, and the average time required to give a consultation is 12 minutes. It is assumed that the service times can be described by the exponential distribution, and the arrival process by a Poisson distribution. You are requested to find: a. The average time in line, b. The average number of patients in line, c. The average time in the system, d. The average number of patients in the system, e. The probability that the dispensary is empty, f. The utilization factor of the system. Solution: Restricted – ‫مقيد‬ Ministry of Education Saudi Electronic University College of Science & Theoretical Studies 3. Assume that you are a statistical consultant and want to provide a volunteer consultation to a start-up company as a social responsibility consultation. The company is planning to purchase a uniform outfit for their employees, and they obtained the following quantity discount table with three discount options: DISCOUNT NUMBER DISCOUNT QUANTITY DISCOUNT COST (SAR) 1 0 to 49 100 2 50 to 99 90 3 100 and over 85 Annual demand is 400 outfits, ordering cost is 50, and holding cost is 25% of the cost of the outfit. Use Excel QM to find the discount option with the minimum total cost. Solution: Restricted – ‫مقيد‬ Ministry of Education Saudi Electronic University College of Science & Theoretical Studies 4. To help needy people through charity is a form of social responsibility. The act of doing charity to help others is recognized and rewarded by all communities of the society. The following table shows the amount collected through charity and the amount spent on social development (in million dollars) in the last 8 years. Find the correlation and coefficient of determination for the given data and obtain the related statistical measures using excel QM. Year 1 2 3 4 5 6 7 8 Solution: Restricted – ‫مقيد‬ Amount collected(y) 18 14 12 15 10 8 9 6 Amount spent(x) 15 10 9 12 5 4 6 3

Statistics Question

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.

GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.