Stats Help for College-level Students

calculating a confidence interval using EXCEL

I need to know how to do this using microsoft excel. Do not address this unless you can do it in EXCEL. thank you Dunkin Donuts advertises that a dozen of their donuts weighs about 43 oz. A certain baker has figured out that she can stay out of trouble with her manager if each donut weighs about 3.6 oz. To test her donut-mak ...continues

confidence interval level

I have an opinion poll perfomed on 2 different population sizes, 900 and 10,000 with a 95% confidence level (Confidence Interval details have been computed) for each population. Opinion Poll Surveyed 900 Surveyed 10000 Invalid intelligence 52% 468 Invalid Intelligence 52% Proportion 0.52 Proportion 0.52 ...continues

Hypothesis Testing- 508

a. Attitude change is thought to result from the anxiety produced under conditions of cognitive dissonance. The data below represent the anxiety scores of subjects in a dissonance study. Assuming that anxiety is distributed with mean=10 and standard deviation=2 test whether this sample exhibited more anxiety than would be expect ...continues

distributions

1. Find the value of (a) in the following discrete probability distribution: X -2 0 2 P(x): a 0.35 0.25 2. A binomial distribution is based on n=25 and p=0.1. Find the probability that x =1. 3 A production process produces parts with weights that are normally distributed with a mean of 1.75 ounces and a standard devi ...continues

Working with conditional probability.

In an experiment, subjects are required to generate a "yes" or "no" decision. The probability of 'Yes' being correct is 50%. The observed probability of yes decisions is 70%. What is the probability that any "Yes"-outcome question will be answered correctly? Illustrate computational details of answer briefly.

Analyze data set for statistically significant change.

The specific questions I need help with are part of statistics homework. My progress so far is in an excel spreadsheet. The source data is labeled "case data", and the different responses are in different worksheets. Here are the questions: Produce a histogram for each data set. (DONE) Compute descriptive statistics ( ...continues

Correlation Coefficient, Hypothesis Testing with Confidence Interval

1. The manager of a movie rental store was interested in examining the relationship between the weekly take-home pay for a family and the amount that family spends weekly on recreational activites. The following output was generated using Minitab: Covariances takehome recreation takehome 4413.84 recreation 2419.64 1364.2 ...continues

Statistics - Confidence Interval

Please provide step by step instructions using actual numbers instead of formulas for solving the following 3 problems, thanks 3. Determine whether the average number of calories in a homemade cookie is more than a store-bought one. Estimate the difference in the mean calories between the two types using a 90% confidence int ...continues

Statistics - Correlation Coefficient and Hypothesis Testing

Please provide step by step instructions on how to solve the following problems using actual numbers provided. Thanks 1) A student representative claims that 60% of the students favor a move to division 1. A random sample of 250 students were selected and 140 of them indicated they favored a move to division 1. a. Perform ...continues

Statistic - Number of ways to select an object

3) Furnish 2 offices each with a desk, chair, and file cabinet and 2 bookcases. At a local store there are 6 models of desks, 8 models of chairs 4 models of file cabinets and 10 models of bookcases. How many choices do you have if you want to select two desks, two chairs, two file cabinets and four bookcases if you don't want t ...continues