Description

Description

I want to stress some very important instructions to you

First, plagiarism must be zero, any percentage will cause the teacher to cancel my homework

You must focus on the solution and put the requirements correctly and without any error, a correct and complete solution to all questions

References must be placed and placed in style APA.

Put the solution inside the file

There is no possibility of error, you must make sure of the solution well

If you are sure that you will solve it correctly, accept the work

Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies

___________________________________________________________________
Quantitative Methods (STAT-201)
Assignment 3: Excel QM (Social-Responsible)
2nd Semester, 1446 (2024-2025)

Student’s Name
Student’s ID
Section/CRN
Branch

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

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Description

Description see College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name Maternal and Child Health Course number PHC 373 CRN – Branch name XXXXX Assignment title or task: ( write and questions) Discuss the methods, advantages, and criticisms of evidence-based practice in maternal and child health

Description

Description RISK MANAGEMENT IN MULTI-SECTOR PARTNERSHIPS IN SAUDI ARABIA: A GOVERNANCE PERSPECTIVE Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER OF BUSINESS ADMINISTRATION BY DINA MANSOUR ALSHEHRI Under Supervision Dr. Asra Inkesar COLLEGE OF ADMINISTRATIVE AND FINANCIAL SCIENCES SAUDI ELECTRONIC UNIVERSITY 2024-2025

Description

Description Comparison In terms of only 1/ The educational objective 2/ The teaching style 3/ The methodology and tools used no Plagiarism 5-6 pages no Plagiarism No AI INTERNATIONAL JOURNAL OF SPECIAL EDUCATION Vol.33, No.2, 2018 Twice-Exceptionality in the Kingdom of Saudi Arabia: Policy Recommendations for Advances in Special Education

Description

Description Hello, you can continue the research while I get the remaining of data from survey so we can get use of time.

Description

Description I do it but I am not sure. Please make short answer The Impact of Remote Work on Employee Productivity: A Study on Government Sector Employees in Saudi Arabia in the Post-Pandemic Era Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER

Description

Description please kindly no AI or Chat gbt. Write about 200-250 for each subject. I have 4 subjects which are: 1- Write a descriptive essay about the best holiday you greatly enjoyed in the past. 2- In your opinion what is the most important element of happiness ? 3- In

Description

Description see College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Advanced Epidemiology Course number: PHC 332 CRN: XXXX Assignment title or task: (You can write a question) Using Causal Criteria show that smoking causes lung cancer. Student Name: XXX Student ID: XXX Submission Date: XXX

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 01/03//2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 22/03//2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 3 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 26/04/2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description Revise the word file according to the instructor’s comments, and after making the necessary changes, organize it based on the requirements outlined in the attached PDF. 1 Digital Currencies Student’s Name University Course Title Professor’s Name Date 2 Digital Currencies 1. Research Approach The research design of this study

Description

Description The Impact of AI-Driven Workflow Optimization on Employee Satisfaction in Radiology: The Mediating Role of Job Stress Reduction Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER OF BUSINESS ADMINISTRATION BY Liyan Abdumohsen Almayouf Under Supervision Dr .Asra inkesar COLLEGE OF ADMINISTRATIVE

Description

Description the document with the required information on PRISMA and JBI. Both should come in the results section. In Methodology, you should mention them, but give the table/figure in the results section. Also, the total number of references is still less. You can try to cite more relevant articles in

Description

Description SEE College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Applied Biostatistics Course number: PHC321 CRN: 22884 Paper Assignment-1 Answer the following questions in a Word document using the provided datasheet (you may use SPSS or MS Excel for your analysis). The datasheet contains national

Description

Description Chapter 1: Description of the company This section should answer the following questions: What is the full title of the company/institution? Give a brief history of the company, full mailing address and relevant weblinks What is the type of ownership of the company/institution? State the main shareholders and their

Description

Description Revise the word file according to the instructor’s comments, and after making the necessary changes, organize it based on the requirements outlined in the attached PDF. Due 8th May 2025 by 11:59 pm. Research Methods and Quantitative Analysis 2nd Semester, 2025 EMBA – Section JA The proposal is worth

Description

Description see ASSIGNMENT COVER SHEET Course name: Health and Environmental Risk Assessment Course number: PHC 351 CRN: Assignment title or task: (You can write a question) Discuss the steps and methods of risk communication and community engagement and support your answer with examples. Student name: xxxx Student ID: xxxx Submission

Description

Description see College of Health Sciences Department of Public Health PAPER ASSIGNMENT Course name: Introduction to Mental Health Course number: PHC-273 Go through the research articles in the link below and answer any one of the following questions in at least 350 words. • • Assignment task Q1. Discuss about