Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Project 2 SU3 Math 131 Name: Stat Project 2 Total Points: 14 INSTRUCTIONS: First, download the Excel Project 2 Data file from Canvas. The data is also available in csv format in case you wish to use a...

1 answer below »
Project 2 SU3
Math 131                                   Name:
Stat Project 2                                   Total Points: 14

INSTRUCTIONS: First, download the Excel Project 2 Data file from Canvas. The data is also
available in csv format in case you wish to use a software other than Excel. All solutions must
e typed into the Word document. Please submit the Word doc with your solutions, not the
Excel sheet that you use to do the computations. Use Excel to give you the solutions to
numbers 1 & 2, only. No handwritten solutions accepted.

DATA SET: A random sample of marathon training times, in minutes, for 30 female marathon
unners.
1. Excel: Find a point estimate for the mean marathon training time of female runners. (1pt)

2. Excel: Find the standard deviation of the sample of marathon training times of female
unners. (1pt)

3. Construct a 90% confidence interval for the population mean training time for women. Be
sure to show the margin of e
or computation. (2pts)

4. Interpret your results from #3 above. (2pts)

5. Construct a 95% confidence interval for the population mean training time for women. Be
sure to show the margin of e
or computation. (2pts)

6. Interpret your results from #5 above. (2pts)

7. Which confidence interval is wider and why? (2pts)

8. Determine the minimum sample size needed to create a 95% confidence interval such that
the sample mean is within 1.5 minutes of the population mean. Assume the population
standard deviation is the same as the sample standard deviation you found in #2. (2pts)
Answered Same Day Aug 03, 2021

Solution

Pooja answered on Aug 03 2021
130 Votes
3)
critical value, t(a/2,n-1) = t(0.1/2,30-1) = 1.699
ME = t(a/2,n-1)*(sd/sqrt(n))        
ME = 1.699*(7.9002/sqrt(30)) = 2.451
CI = mean +- ME
lower    = 189 - 2.451 = 186.55
upper    = 189 + 2.451 = 191.45
4)
I am 90% confident that the estimated mean marathon training time for all female marathon...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here