Using Excel

1. List the 5 steps in Hypothesis testing

2 A tire company makes 5000 tires an hour on average with a known standard deviation of 50 A sample is taken last hour and 5100 tires were made Spell out the null and alternate hypotheses that the mean is different than 5000 Evaluate the hypothesis (Accept or Reject) at the following significance levels: a. 0.01 b. 0.05

3 Samples of a car company's output is taken and 490 cars are made in a day with a known standard deviation of 16 cars Spell out the null and alternate hypotheses that the average production of the car company is less than 475 cars Evaluate the hypothesis (Accept or Reject) at the following significance levels a. 0.001 b. 0.1

List the 5 steps in Hypothesis testing Answer N A tire company makes 5000 tires an hour on average with a known standard deviation of 50 A sample Is taken last hour and 5100 tires were made Spell out the null and alternate hypotheses that the mean is different than 5000 Evaluate the hypothesis (Accept or Reject) at the following significance levels: 0.01 Answer 0.05 Answer Samples of a car company's output is taken and 490 cars are made in a day with a known standard deviation of 16 cars Spell out the null and alternate hypotheses that the average production of the car company is less than 475 cars Evaluate the hypothesis (Accept or Reject) at the following significance levels utoring 0.001 Answer 0.1