
James S. answered 04/08/18
Tutor
5.0
(25)
SPSS, Statistics & Research Design - Former Faculty
"More than 10" complaints is 11 complaints.
z = (Score - Mean) / SD = (11 - 8.3) / 1.8 = 1.5
In Excel, enter this into a cell:
=normsdist(1.5)
and hit enter
The result is the area under the curve which falls below z=1.5
The result is 0.9332 .
You are looking for the area above z=1.5, so it is 1 minus that value.
1-.9332 = 0.0668