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




(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.


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,, 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.

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).

About the Client

(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