# (Answered) MATH399N Week Week 6 Assignment: Calculating Confidence Intervals with Technology – Excel

Question

The owner of a restaurant is reviewing customer complaints. In a random sample of 227 complaints, 57 complaints were about the slow speed of the service. Create a 95% confidence interval for the proportion of complaints that were about the slow speed of the service. Use Excel to create the confidence interval, rounding to four decimal places.

# Question

In a random sample of 350 attendees of a minor league baseball game, 184 said that they bought food from the concession stand. Create a 95% confidence interval for the proportion of fans who bought food from the concession stand. Use Excel to create the confidence interval, rounding to four decimal places.

# Question

In a city, 22 coffee shops are randomly selected, and the temperature of the coffee sold at each shop is noted. Use Excel to find the 90% confidence interval for the population mean temperature. Assume the temperatures are approximately normally distributed. Round your answers to two decimal places and use increasing order.

# Question

The yearly incomes, in thousands, for 24 random married couples living in a city are given below. Assume the yearly incomes are approximately normally distributed. Use Excel to find the 95% confidence interval for the true mean, in thousands. Round your answers to three decimal places and use increasing order.

# Question

Suppose the weights of tight ends in a football league are normally distributed such that σ2=1,369. A sample of 49 tight ends was randomly selected, and the weights are given below. Use Excel to calculate the 95% confidence interval for the mean weight of all tight ends in this league. Round your answers to two decimal places and use ascending order.

# Question

The amounts of time that customers stay in a certain restaurant for lunch is normally distributed with a standard deviation of 17 minutes. A random sample of 50 lunch customers was taken at this restaurant. Construct a 99% confidence interval for the true average amount of time customers spend in the restaurant for lunch. Round your answers to two decimal places and use ascending order.

# Question

The number of hours worked per year per adult in a state is normally distributed with a standard deviation of 37. A sample of 115 adults is selected at random, and the number of hours worked per year per adult is given below. Use Excel to calculate the 98% confidence interval for the mean hours worked per year for adults in this state. Round your answers to two decimal places and use ascending order.

# Question

Assume the distribution of commute times to a major city follows the normal probability distribution and the standard deviation is 4.5 minutes. A random sample of 38 commute times is given below in minutes. Use Excel to find the 98% confidence interval for the mean travel time in minutes. Round your answers to one decimal place and use ascending order.

# Question

A city is holding a referendum on increasing property taxes to pay for a new high school. In a survey of 458 likely voters, 254 said that they would vote “yes” on the referendum. Create a 95% confidence interval for the proportion of likely voters who will vote “yes” on the referendum. Use Excel to create the confidence interval, rounding to four decimal places.

# Question

The heart rates for a group of 21 students taking a final exam are given below. Assume the heart rates are normally distributed. Use Excel to find the 95% confidence interval for the true mean. Round your answers to two decimal places and use increasing order.

# Question

A sample of 22 test-tubes tested for number of times they can be heated on a Bunsen burner before they crack is given below. Assume the counts are normally distributed. Use Excel to construct a 99% confidence interval for μ. Round your answers to two decimal places and use increasing order.

# Question

A large company is concerned about the commute times of its employees. Of the 333 employees who were surveyed, 131 said that they had a daily commute longer than 30 minutes. Create a 95% confidence interval for the proportion of employees who have a daily commute longer than 30 minutes. Use Excel to create the confidence interval, rounding to four decimal places.

# Solution: ….Click link below to purchase full tutorial at \$5