Question

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

Homework Answers

Answer #1

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
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...
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...
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...
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...
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 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...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • The college Physical Education Department offered an Advanced First Aid course last summer. The scores on...
    asked 10 minutes ago
  • Researchers hypothesized that increasing a woman's level of arousal would increase her perceptions of attractiveness of...
    asked 44 minutes ago
  • Equation 37-14b in the textbook gives the energy emitted by Hydrogen when electrons transition between states...
    asked 44 minutes ago
  • Theory of Computation Please provide explanation too on how it works a. Give an NFA recognizing...
    asked 44 minutes ago
  • Question 1 A sequential pattern detection circuit (state machine) has input A and output Y, which...
    asked 47 minutes ago
  • Natural Foods Inc. is planning to invest in new manufacturing equipment to make a new garden...
    asked 1 hour ago
  • Explain why a callable bond's price would be expected to decline less than an otherwise comparable...
    asked 1 hour ago
  • . What are the three types of pricing strategies services that services employ? Using a real...
    asked 1 hour ago
  • Given a search problem where some elements are searched more than others, it is more important...
    asked 2 hours ago
  • Suppose a consumer views two goods, X and Y, as perfect complements. Her utility function is...
    asked 2 hours ago
  • Describe how propinquity can perpetuate and increase perceived similarity in our friendships. Describe how similarity can...
    asked 2 hours ago
  • For explaining the pressure / stress phenomenon, analyze three cases given below: (also include a sketch...
    asked 2 hours ago