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
