I am stuck on the question below. I have been able to figure out everything down to the last part. I am to use Excel in the assignment. I know that I will be using the excel formula norm.dist(x,mean,standarddeviation,true)but I am having issues with plugging in the data correctly in the formula .. please assist ensuring to show me what should be plugged into the excel formula sample data4.9goalsample sizesample mean0.75254.3725 or<10.53.27.70.18750.00750.08662.33.29.56.75.5standard error of the proportionWait times less than 518sample proportion0.720.52.3z score0.35Managers at a local phone service wireless retail center have a goal that 75% of the center's customers will have to wait less than five minutes for service. Thedata below shows the wait times of a random sample of 25 customers in minutes. Does this sample provide evidence that management's goal is being achieved?3.32.34.5

Test whether the population proportion of customers who wait for less than 5 minutes for service is…

Answered: sample data 4.9 goal sample size sample…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

I am stuck on the question below. I have been able to figure out everything down to the last part. I am to use Excel in the assignment.

I know that I will be using the excel formula norm.dist(x,mean,standarddeviation,true)

but I am having issues with plugging in the data correctly in the formula .. please assist ensuring to show me what should be plugged into the excel formula

sample data
4.9
goal
sample size
sample mean
0.75
25
4.372
5 or<
10.5
3.2
7.7
0.1875
0.0075
0.0866
2.3
3.2
9.5
6.7
5.5
standard error of the proportion
Wait times less than 5
18
sample proportion
0.72
0.5
2.3
z score
0.35
Managers at a local phone service wireless retail center have a goal that 75% of the center's customers will have to wait less than five minutes for service. The
data below shows the wait times of a random sample of 25 customers in minutes. Does this sample provide evidence that management's goal is being achieved?
3.3
2.3
4.5

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 7 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions