(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