Question

Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population...

Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population mean.

The following is the data. Calculating Process should be shown by Excel (Formulas). What formulas in statistics are used?

7
21
23
24
18
16
2
19
11
6
3
13
17
9
5
12
13
17
4
14
15
25
12
24
22
14
14
20
15
11
26
17
21
11
4
13
16
14
13
14
25
23
9
15
14
12
19
11
18
9
12
13
17
6
19
17
13
23
16
17
11
15
11
23
8
16
10
26
19
16
23
15
20
30
21
21
14
1
13
14
21
3
26
18
6
17
18
15
10
14
9
17
10
16
13
9
14
6
19
4
8
4
7
8
2
21
6
14
20
7
18
11
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Solution:-

Steps

1) Paste the data points in the excel.

2) Click on data in the tool bar and then on data analysis.

3) Select "Descriptive statistics" from the options.

4) Paste the data set in input range and select the summary statistics.

5) Click on Ok.

Data
Mean 14.29464
Standard Error 0.589024
Median 14
Mode 14
Standard Deviation 6.233647
Sample Variance 38.85835
Kurtosis -0.45507
Skewness -0.00464
Range 29
Minimum 1
Maximum 30
Sum 1601
Count 112

95% confidence interval of the population mean is C.I = (13.127, 15.46).

C.I = 14.295 + 1.982 × 0.589

C.I = 14.295 + 1.1674

C.I = (13.127, 15.46)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Part A. In the past it has been found that the arrival time have a population...
Part A. In the past it has been found that the arrival time have a population mean value of μ = 13 and a population standard deviation of σ = 6.26. Using the given data, test whether this mean has changed. Use the critical value approach to test the hypothesis. The significance level alpha is set at 0.05 . The original data of time taken is given below. Show the process by using excel (Formulas). Part B. Test the hypothesis...
6. Using the class data (see Blackboard file - "Class Survey Data - PSS-10 and GAS")...
6. Using the class data (see Blackboard file - "Class Survey Data - PSS-10 and GAS") calculate the correlation between the GAS – Goal disengagement and the GAS – Goal reengagement scores. Write the results in a statistical statement. 7. Using the class data calculate the correlation between the GAS – Goal disengagement and the PSS-10 scores. Write the results in a statistical statement. 8. Using the class data calculate the correlation between the GAS – Goal reengagement scores and...
____________________________________________ The results of a sample of 372 subscribers to Wired magazine shows the time spent...
____________________________________________ The results of a sample of 372 subscribers to Wired magazine shows the time spent using the Internet during the week. Previous surveys have revealed that the population standard deviation is 10.95 hours. The sample data can be found in the Excel test data file. What is the probability that another sample of 372 subscribers spends less than 19.00 hours per week using the Internet? ____________________________________________ Develop a 95% confidence interval for the population mean ____________________________________________ If the editors...
The results of a sample of 372 subscribers toWiredmagazine shows the time spent using the Internet...
The results of a sample of 372 subscribers toWiredmagazine shows the time spent using the Internet during the week. Previous surveys have revealed that the population standard deviation is 10.95 hours. The sample data can be found in the Excel test data file. What is the probability that another sample of 372 subscribers spends less than 19.00 hours per week using the Internet? Develop a 95% confidence interval for the population mean If the editors of Wiredwanted to have the...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. If the variance of XYZ remains unchanged, what should be the variance of ABC in order...
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how...
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how I calculate the times. heres the data set and the questions. Calculate the probability that a flight will depart early or on time. Calculate the probability that a flight will arrive late. Calculate the probability that a flight departs late or arrives early. DEP_Delay ARR_Delay -4 0 -3 -3 0 -5 -7 -1 8 3 -1 -5 3 8 11 6 -6 0 -5...
A company has the following returns over the past 30 months: Month Ret.(%) Month Ret.(%) Month...
A company has the following returns over the past 30 months: Month Ret.(%) Month Ret.(%) Month Ret.(%) 1) 3 11   -3 21 -1 2) -16 12 -2 22 -24 3) 31 13 -8 23 -14 4) 33 14 2 24 -19 5) -23 15 35 25 -19 6) -17 16 11 26 33 7) 8 17 -20 27 -18    8) -19 18 15 28 23 9) -13 19 -12 29 6 10 -17 20 17 30 5 What is...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. Does the sample data indicate a statistically significant difference at the 5% level? Justify your answer....
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. Does the sample data indicate a statistically significant difference at the 5% level? Justify your answer....
Test, at the 1% level of significance, whether the average business has more than 15 employees....
Test, at the 1% level of significance, whether the average business has more than 15 employees. Answer using excel. Employees 14 17 17 6 8 17 21 16 6 17 11 17 15 16 20 19 6 12 17 22 20 17 11 11 9 22 17 18 21 20 26 7 16 19 18 11 21 17 25 16 22 14 14 16 18 20 21 11 19 13 6 11 19 14 18 31 13 15 17 21...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT