TechBuzz is an IT company that monitors the status of large data warehouses. According to TechBuzz, last year the majority of the data servers used by energy-based companies were over-utilized. A sample of 190 servers (all used by energy-based companies) showed that 142 were over-utilized, 12 were used efficiently, and 36 were underutilized. a. What is the point estimate of the proportion of the servers that were under-utilized? b. Determine the margin of error and provide a 95% confidence interval for the proportion of the servers that were over-utilized. c. What is the minimum sample size to ensure that the desired margin of error (in part b) is at most 0.04?
TechBuzz is an IT company that monitors the status of large data warehouses. According to TechBuzz, last year the majority of the data servers used by energy-based companies were over-utilized. A sample of 190 servers (all used by energy-based companies) showed that 142 were over-utilized, 12 were used efficiently, and 36 were underutilized.
a. What is the point estimate of the proportion of the servers that were under-utilized?
b. Determine the margin of error and provide a 95% confidence interval for the proportion of the servers that were over-utilized.
c. What is the minimum
Can this be solved using excel only please. thanks and shown step by step
Trending now
This is a popular solution!
Step by step
Solved in 4 steps