(ANSWER) MATH 225N -Week 6 Assignment Understanding Confidence Intervals - Excel - Essay Prowess
Do You Have an online Class? Email us [email protected]

# (ANSWER) MATH 225N -Week 6 Assignment Understanding Confidence Intervals – Excel

$5.99 Kindly ADD to CART and Purchase the FULL answer at$5 ONLY!

Categories: , Tags: ,

## Question 1

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 2

A study was conducted to estimate the mean age when people buy their first new car. The ages of purchase for 22 randomly selected people are given below. Assume the ages are approximately normally distributed. Use Excel to determine the 99% confidence interval for the mean. Round your answers to two decimal places and use increasing order.

## Question 3

A company wants to determine a confidence interval for the average CPU time of its teleprocessing transactions. A sample of 70 random transactions in milliseconds is given below. Assume that the transaction times follow a normal distribution with a standard deviation of 600 milliseconds. Use Excel to determine a 98% confidence interval for the average CPU time in milliseconds. Round your answers to the nearest integer and use ascending order.

## Question 4

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 5

Gary is studying the prevalence of regional dialects. He surveyed 351 people in a region and asked what words they used for certain things. 292 of the respondents referred to soft drinks as “pop,” as opposed to “soda” or “cola.” Create a 90% confidence interval for the proportion of people in this region who refer to soft drinks as “pop.” Use Excel to create the confidence interval, rounding to four decimal places.

## Question 6

Suppose that the scores of bowlers in a particular league follow a normal distribution such that the standard deviation of the population is 12. Find the 95% confidence interval of the mean score for all bowlers in this league using the accompanying data set of 40 random scores. Round your answers to two decimal places and use ascending order.

## Question 7

In a survey of 603 adults, 98 said that they regularly lie to people conducting surveys. Create a 99% confidence interval for the proportion of adults who regularly lie to people conducting surveys. Use Excel to create the confidence interval, rounding to four decimal places.

## Question 8

In a survey of 1,000 adults in a country, 722 said that they had eaten fast food at least once in the past month. Create a 95% confidence interval for the population proportion of adults who ate fast food at least once in the past month. Use Excel to create the confidence interval, rounding to four decimal places.

## Question 9

Weights, in pounds, of ten-year-old girls are collected from a neighborhood. A sample of 26 is given below. Assuming normality, use Excel to find the 98% confidence interval for the population mean weight μ. Round your answers to three decimal places and use increasing order.

## Question 10

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.

59.015,58.962, 58.935, 58.989 ,58.997 ,58.970, 59.000, 59.014 ,59.001, 59.003, 58.992, 58.926 ,59.032, 58.958 ,59.093, 58.955, 59.003 ,58.952, 59.057, 59.056, 59.074 ,59.128, 59.001, 59.007

## Question 11

The monthly incomes from a random sample of 20 workers in a factory is given below in dollars. Assume the population has a normal distribution and has standard deviation \$518. Compute a 98% confidence interval for the mean of the population. Round your answers to the nearest dollar and use ascending order.

## Question 12

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.

error: Content is protected !!