# Statistics Class: Excel Problem

Closed - This job posting has been filled and work has been completed.
IT & Networking Other - IT & Networking Posted 3 years ago

Fixed Price

Delivery by April 23, 2013

\$7

Budget

## Details

(Use Excel for all your work)

1.    The observations in the Excel data file SHEET 1 are the ages of a random sample of 8 men in a bar. It is known that the ages are normally distributed with a standard deviation of 10. Determine the 95% confidence interval estimate of the mean.
2.    It is known that the amount of time needed to change the oil in a car is normally distributed with a standard deviation of 5 minutes. The amount of time to complete a random sample of 10 oil changes was recorded and listed in the Excel data file SHEET 2. Compute the 99% confidence interval estimate of the mean of the population.

Notes:

Questions 1-2:

Step 1: Use AVERAGE function to find the sample mean from the data.
Step 2: Use the function CONFIDENCE.NORM  (Formulas -> More functions -> Statistical) to combine the mean and the population standard deviation (given in the problem) along with the given value of α using the formulation:

Sample mean ± CONFIDENCE.NORM(alpha, std. dev., sample size)

Question 3:

Use normdist function: normdist(x,mean, std.dev, cumulative), where cumulative = TRUE if computing P(X < k) and cumulative = FALSE if computing P(X = k). See the practice problems from Chapter 8 for more info, if desired.

Misc:
Clearly state the functions you are using along with the input arguments (if clicking on the answer displays the function at the top, that’s ok too).

(5.00) 5 reviews

United States
Santa Ana 12:06 AM

10 Jobs Posted
60% Hire Rate, 1 Open Job

\$112 Total Spent
10 Hires, 0 Active

\$2.82/hr Avg Hourly Rate Paid
24 Hours

Member Since Feb 14, 2013