Our Services

Get 15% Discount on your First Order

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

May 29, 2024

Description

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

Purchase answer to see full
attachment

Saudi Electronic University Homework Help

Share This Post

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

Related Questions

Week 2 Discussion 1 Evaluate and discuss clinical and business solutions for hospital improvement. Include in your discussion improvement of

Week 2 Discussion 1 Evaluate and discuss clinical and business solutions for hospital improvement. Include in your discussion improvement of outcomes, reduction in costs, optimization of payment, and improvement in the overall patient experience. – At least 1 page Week 2 Discussion 2 Discuss the nurse’s role in the policy

You are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for

You are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the southea

Diffusion models are one of the most influential generative modeling techniques for image generation and, across many benchmarks, they outperform

Diffusion models are one of the most influential generative modeling techniques for image generation and, across many benchmarks, they outperform state-of-the-art GANs. Explain your opinion on the reasons for the popularity of diffusion models. What is the real difference between diffusion models and GANs?

Option 1 Discuss the usage and creation of standard costs by your operation. How are these costs developed? How can they be used in the creation of a

Option 1 Discuss the usage and creation of standard costs by your operation. How are these costs developed? How can they be used in the creation of a forecast? How can these be used in an individual or organizational measurement system? – OR – Option 2 Discuss a current business

Using the report about the chemical refineries in Bergen County, NJ, from the reading and resources this week, respond to the discussion prompt below. The

Using the report about the chemical refineries in Bergen County, NJ, from the reading and resources this week, respond to the discussion prompt below. The location of chemical refineries in Bergen County, NJ, is considered the most dangerous two miles in America. If you were assigned to provide contextual descriptions

For this assignment, I want you to announce the medium in which you will present your Spark Grant Community Project ProposalLinks to an external site(I’ve

For this assignment, I want you to announce the medium in which you will present your Spark Grant Community Project ProposalLinks to an external site(I’ve attach the files).. The two most common options are essays and recorded screencasts. However, I am open to other format ideas such as magazine article, newsletter,

Guidance of Class Project Presentation (FIN 235 – A) Here is some guidance on the class project presentation. 1. Each group should have 3

Guidance of Class Project Presentation (FIN 235 – A) Here is some guidance on the class project presentation. 1. Each group should have 3 members. Please email me the names of your group members by April 29, 2024. 2. Each group will have 15 minutes for each team to present

In your response posts to at least two other peers’ initial posts, respond to the following: Compare and contrast your thoughts on the legal and

In your response posts to at least two other peers’ initial posts, respond to the following: Compare and contrast your thoughts on the legal and compliance implications identified by your peers. Explain one additional measure for preventing such actions that your peer did not discuss in their initial post. Why

Prompt: How do you define college writing? What do you think the expectations and requirements of college writing are? Directions: · Write a five par

Prompt: How do you define college writing? What do you think the expectations and requirements of college writing are? Directions: · Write a five paragraph essay that answers the above questions. · Start with an introduction that sets-up your definition. · Have your definition in the thesis. · Have three

PSYC 510 Homework: Big Picture Assignment Instructions Overview This final assignment allows you to demonstrate comprehension

PSYC 510 Homework: Big Picture Assignment Instructions Overview This final assignment allows you to demonstrate comprehension and mastery of topics covered throughout the course. It will require you to use techniques and concepts covered from the first day in an integrated manner, much like researchers do when conducting their own

see attachment Module 7: Lecture Content- Characteristics and Techniques to Develop Critical Thinking Definition

see attachment Module 7: Lecture Content- Characteristics and Techniques to Develop Critical Thinking Definition reached by a panel of leading critical thinking scholars and researchers and reported in the Delphi Report (Evans, 2020): “Purposeful, self-regulatory judgment which results in interpretation, analysis, evaluation, inference, and an explanation of the evidential, conceptual, methodological,

Review and identify relevant information on the linked PBS American Experience site, Reconstruction The Second Civil War White Southern Responses to

Review and identify relevant information on the linked PBS American Experience site, Reconstruction The Second Civil War White Southern Responses to Black Emancipation | American Experience | Official Site | PBS Milestone Documents | National Archives Consider the following statement: “The persistence of racism in both the North and the

15 to 20-sentence. Candlelight: A tribute to Adele The Coral Gables Congregational Church Focus: – Instrument: Identify the primary instrument(s)

15 to 20-sentence. Candlelight: A tribute to Adele The Coral Gables Congregational Church Focus: – Instrument: Identify the primary instrument(s) featured in the concert. – Era: Determine the historical era or period the music represents. – Genre: Categorize the music into a specific genre (e.g., baroque, classical, jazz, pop, rock).

Leadership Assignment Read the following article then answer the questions that below: 1. Think of two people

Leadership Assignment Read the following article then answer the questions that below: 1. Think of two people you have worked for and describe their style of leadership according to the descriptions in the attached article. Do not include any names or institutions. Person A Person B 2. Compare the positive

Case Study CASE INFORMATION: Gregor v. TD Bank, N.A. ANALYSIS REQUIREMENTS: Based on your readings,

Case Study CASE INFORMATION: Gregor v. TD Bank, N.A. ANALYSIS REQUIREMENTS: Based on your readings, literature, and/or the Fraud Examiners Manual analyze the cases and include the following in your discussion: · What type of fraud scheme took place in this case? · Analyze the internal controls of this company

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines Participate in the discussion by responding to the prompt below in an initial post, then by responding to the posts of your classmates. Your initial response post is due by Thursday at

Chronic illness is one of the most challenging and expensive of the medical challenges facing the world today. It is also at the root of a the

Chronic illness is one of the most challenging and expensive of the medical challenges facing the world today. It is also at the root of a the multi-trillion dollar international medical industry. What are chronic illnesses and how do they impact the individual?

Slot Frogs & Bugs adalah permainan yang cocok untuk para pemain yang mencari pengalaman bermain yang menyenangkan dan berpotensi menghasilkan kemenangan

Slot Frogs & Bugs adalah permainan yang cocok untuk para pemain yang mencari pengalaman bermain yang menyenangkan dan berpotensi menghasilkan kemenangan yang menguntungkan.