Question

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 of Part A with p value approach. Show the calculation steps by Excel.

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 |

Answer #1

First we need to find the sample mean. Using excel formula "=average()" the mean of the sample is

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

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

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

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

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

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

Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14
14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18
11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18
18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...

Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14
14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18
11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18
18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 10 minutes ago

asked 44 minutes ago

asked 44 minutes ago

asked 44 minutes ago

asked 47 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago