P3
pdf
keyboard_arrow_up
School
University Of Arizona *
*We aren’t endorsed by this school
Course
107
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
Pages
3
Uploaded by BaronNightingaleMaster149
The following will then ask you to complete various tasks regarding your Excel project.
•
Most slides will require you to annotate the slides.
Make sure you show your math computations and answer
the questions in complete sentences.
•
One slide will require you to create a Zoom video recording of yourself working in Excel and interpreting your
result.
Make sure to
add the link to your Zoom cloud recording in assignment’s Student Work section in Teams
.
Task 1:
Probability Using the Filter
1.
Demonstrate in a Zoom video how you would use Excel to calculate the probability if you were to
randomly select a government contract that it was:
30 points
a.
Awarded to one of the Honeywell companies?
Include your answer below as well as in the video.
b.
NOT a contract given out to a company in Tempe?
Include your answer below as well as in the
video.
27195-2383/27195= 24812/27195= 0.9123735
There is a 91% chance of a contract not giving out to a company in tempe.
c.
Zoom link:
2.
https://arizona.zoom.us/rec/share/HaIg0Fw7w6f6Ead0FaHzK2bflkl7CM9a4bNAR2pYWK5FwHKgsggbBj_6uQ9dn81s.QL0j-
viYxyG6ZVnm03ClS
Task 2:
Two-Way Table
3.
Display the completed two-way table as shown in the second Excel sheet.
10 points
4.
Food/ Kitchen
Medical/ Hospital
Aircraft/ Repair
Housekeeping/ Transportation
Communication/ Software
Other
Total
12: USDA
10
4
101
110
4
326
555
14: DOI
2
7
63
104
78
512
766
15: DOJ
29
6
14
5
16
259
329
19: DOS
4
1
3
6
4
74
92
36: VA
4
481
23
38
11
96
653
47: GSA
8
1
80
2
2
104
197
Excel Project 3
Government Contracts
70:
14
2
100
21
13
141
291
75: HHS
5
188
23
56
69
224
565
80: NASA
0
0
18
2
2
108
130
97: DOD
1514
330 1868
152
305
19087
23256
Other
0
8
22
24
34
273
361
Total
1590
1028
2315
520
538
21204
27195
5.
Explain how you determined the value in the cell F12 in the two-way table.
10 points
U
6.
If you were to randomly select a government contract, what is the probability that it will be a contract
for the Department of Defense (DOD)?
Explain how you used the two-way table to find this
probability.
15 points
DOD:23256
Government contract: 27195
Probability: 85.5%
23256/
27195=0.8551572
7.
If you were to randomly select a government contract, what is the probability that it will be a contract
for the VA OR for aircraft/repair? Explain how you used the two-way table to find this probability.
15
points
About 1%
653+2293 / 653* 2293= 2946/1497329= 0.0019675
8.
Are the two events in #5 (VA and aircraft/repair) disjoint?
Explain your answer using the two-way
table.
10 points
The two events are not disjoint, because they happen at the same time and disjoint events do not
happen at same times.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help