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 Release date: 06-April-2025__________________Due date: 03-May-2025 Instructions for submission: Assignment must be submitted with properly filled cover sheet (Name, ID, CRN, Submission date) in word document, Pdf is not accepted. Length of the write-up should be 1 to 2 pages (500 -750 words). Text size 12-Times New Roman with double

Description

Description Guidelines: Cover sheet should be attached with assignment Use the excel sheet for your calculations to answer the assignment questions Complete student’s information on the first page of the document. Font should be 12 Times New Roman Line spacing should be 1.5 The text color should be “Black” Maximum

Description

Description Guidelines: Cover sheet should be attached with assignment Use the excel sheet for your calculations to answer the assignment questions Complete student’s information on the first page of the document. Font should be 12 Times New Roman Line spacing should be 1.5 The text color should be “Black” Maximum

Description

Description Guidelines: Cover sheet should be attached with assignment Use the excel sheet for your calculations to answer the assignment questions Complete student’s information on the first page of the document. Font should be 12 Times New Roman Line spacing should be 1.5 The text color should be “Black” Maximum

Description

Description Submission Guidelines: Write 1-2-page(s) essay not less than 200 words and maximum of 300 words excluding references with a font of Times New Roman and size of 12. The line spacing should be 1.5. Heading should be Bold and text color should be Black Avoid Plagiarism Assignments must be

Description

Description See College of Health Sciences Department of Health Informatics HCI-316 – Group Presentation In this group project, teams of 3–5 students will collaborate to explore and present exciting developments in digital health innovation within the Middle East, with a particular focus on Saudi Arabia (KSA). The goal is to

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment-3 MGT425-Spreadsheet Decision Modeling Due Date: 26/04/2025 @ 23:59 (End of Week 12) Course Name: Spreadsheet Decision Modeling Course Code: MGT425 Student’s Name: Semester: Second

Description

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

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 CT Digital Health Technologies in KSA (110 points) Evaluate the use of digital health technologies in Saudi Arabia that would support expanding patient access to medical care by researching a minimum of four peer-reviewed articles on this topic and then creating a brochure or infographic using appropriate templates available

Description

Description IMC campaign plan An IMC campaign plan involves the integration of different marketing communication tools such as advertising, public relations, direct marketing, sales promotion, and digital marketing to achieve marketing objectives. For this critical thinking assignment select one of the following scenarios to create an integrated marketing communications plan

Description

Description I want the answer without similarity at all, and Conceptual and professional, they’re important. I have a solution model ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment-3 MGT324-Public Management Due Date: 26/04/2025

Description

Description Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions. All answered must be typed

Description

Description I want the answer without similarity at all, and Conceptual and professional, they’re important. I have a solution model ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 3 Quality Management (MGT 424)

Description

Description Dis 1. one file. Efficiency and effectiveness are essential to controlling costs and quality in healthcare organizations. Research the global and national accreditation bodies working to accredit facilities in Saudi Arabia. Choose one of these agencies; evaluate the agency and its effect on healthcare organizations. Dis 2 Module 13:

Description

Description the title 68Ga-DOTA-TOC-injection (EP) in NETs arised from neuroendocrine cells the reference more than4 Vancouver style follow the rubric in the file Students Case Study Rubric Course: RNM 417 Student: ……………………………………………. Case study title: ………………………………..…… Criteria Needs Unsatisfactory (1) Satisfactory (3) Improvement Excellent (4) (2) 1. Patient’s Minimal Basic

Description

Description write case study about this title [18F]NaF is used in blood flow studies reference more than 4Vancouver follow the rubric in the file make sure 0% AI

Description

Description Action Items An e-mail is sent to Party B, in order to form a contract. Party A is the sender of the email. Party A’s identification is located at the top of the e-mail and is sufficient to show authentication. Will use of the individual’s initials or name at