Category: Statistics

I have wrote my discussion part but AI is high, please proffreading or editing make it no AI. But don’t change my content. 

hello please just write the data report that extracted from attached excel sheet .
please take a look to project sample PDF in attached files before writing the report .
please follow the instructions of assinment.

the Unit is 
Quantitative Methods for
Business and Management. it is mix between economics and  staticitics.  Please answer all the questions and also see thexcel sheet. 
no need for references 

in the document i uploaded, i already started on the data from the 2022 season. Follow the format that i have used so far to finish the data on the 2022 season, 2021 and 2023 seasons, also inclue weather and temperature. (note that there will be no odds data for the 2021 season, only for the 2022 and 2023 seasons)
use the following website to collect the odds for the games : https://oddspedia.com/american-football/europe/elf/odds.
the rest of the information(date and time of games, conferences, attendance, stadium…) can be found on Wipedia. weather and temperature can be found at the bottom of
the 1st page on the reference link(pdf file) for each game : https://en.wikipedia.org/wiki/2022_European_League_of_Football_season

___________________________________________________________________
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
Obtained Score
Q-1
2
Q-2
2
Q-3
2
Q-4
2
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.
Solve the following questions using Excel QM. (2×4 = 8 marks)
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. 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.
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:
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
Blood Donors
2011
116
2012
105
2013
146
2014
159
2015
108
2016
194
2017
227
2018
219
2019
234
2020
224
2021
248
2022
253
2023
265
2024
311
Solution:
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:
The average time in line,
The average number of patients in line,
The average time in the system,
The average number of patients in the system,
The probability that the dispensary is empty, The utilization factor of the system.
Solution:
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: Year
Amount collected(y)
Amount spent(x)
1
18
15
2
14
10
3
12
9
4
15
12
5
10
5
6
8
4
7
9
6
8
6
3
Solution:

The telecommunication company aims to build a modular glass fiber network across 13 regions. Each region will have its own local network, and these will be interconnected via a main network. Local networks are designed using modular nodes, with various layouts containing 3, 4, 5, or 6 nodes. The main network, comprising star, circle, double circle, triple circle, or quadruple circle shapes, links these local networks. The project requires calculating system reliability for different network configurations and optimizing costs to achieve an overall reliability of 0.98 using Excel’s built-in functions.
There is 9 question needs to be answered

All the intructions are attached please follow each step given by the instructor. Thank you very much in advance. 

calculate the 90% confidence interval the proportion of students in this school
who were born in this state, 
will interpret confidence intervals and 
will determine the effects of changing conditions on the confidence interval.

I need someone to finish my inferential stats project for me. Report must be made in a Word Document format, while the graphs and information must be copy and pasted from SPSS. I need someone who has access to SPSS. I need someone to finish this before midnight tonight. I can pay extra.

Please provide an answer that is 100% original and do not copy the answer to this question from any other website since I am already well aware of this. I will be sure to check this.
Please be sure that the answer comes up with way less than 18% on Studypool’s internal plagiarism checker since anything above this is not acceptable according to Studypool’s standards. I will not accept answers that are above this standard.
No AI or Chatbot! I will be sure to check this.
FINAL PROJECT STEP V
The Final Project is a stepwise process, and its goal is to leave you well-prepared by the end of this course to execute on your qualitative research study plan.
In Week 10, you will complete Step V of the Final Project. Step V allows you to develop your skills in selecting the right coding strategy for your study approach and in reporting the appropriate codes and categories for your study. In this Assignment, you will complete Step V.
BY DAY 6
Submit the following:
A draft Analysis Plan (which you will continue to revise later in the week)
A summary of the codes and categories you identified in your transcribed documents
A 2 to 3 full page paper comparing your hand-coding experience with what you researched on QDA software
A final analysis plan, with feedback from your peer debriefer integrated into the document
You will need to have completed all 4 tasks in order to be eligible for full credit on this Assignment. Be sure to allow adequate time for each task as you structure your week. A suggested schedule is included here:
Draft your analysis plan, including steps based on the research question, chosen approach, and sampling criteria.
Note: You’ll be posting this to your Workshop thread in order to receive peer feedback.
By Day 5: Summarize the codes and categories you identified in your transcribed documents.
By Day 5: Draft a 2 to 3 full page paper comparing your hand-coding experience with what you researched on QDA software.
By Day 6: Integrate the feedback you received from your peer debriefer.
Requirements: 2-3 Full Pages Times New Roman Size 12 Font Double-Spaced APA Format Excluding the Title and Reference Pages
Please provide an answer that is 100% original and do not copy the answer to this question from any other website since I am already well aware of this. I will be sure to check this.
Please be sure that the answer comes up with way less than 18% on Studypool’s internal plagiarism checker since anything above this is not acceptable according to Studypool’s standards. I will not accept answers that are above this standard.
No AI or Chatbot! I will be sure to check this.
Please be sure to carefully follow the instructions.
No plagiarism & No Course Hero & No Chegg. The assignment will be checked for originality via the Turnitin plagiarism tool.
Please be sure to include at least one in-text citation in each body paragraph.
Please be sure to use credible or scholarly sources published within the last 5 years.