Purchase Order # PO# 10136 PO# 10153 PO# 10163 PO# 10167 PO# 10187 PO# 10219 PO# 10279 PO# 10306 PO# 10332 PO# 10346 PO# 10392 PO# 10471 PO# 10486

Please explain how you arrived at the answers. Also, what do you charge per hour for online tutoring?

Download this Hypothesis Testing Quiz Data Excel file to answer the following questions. Please note that there are three different sheets in the workbook.

1. The null hypothesis should NOT be accepted.

True

False

2. Use the data in the “Part 1” sheet of the spreadsheet above to answer this question:

Suppose that your company is concerned about two things: 1) having too much inventory, and 2) not having enough inventory. As the company looked into the problem, it discovered that a long lead time (amount of time it takes to receive an order from the supplier) on one of its most expensive parts was causing much of the inventory and stock-out problems.

During the last year, the average lead time for this particular part was 41.5 days. In an effort to shorten the lead time, the company decided to change to a different supplier. The attached spreadsheet shows a random sample of orders placed on the new supplier, along with the corresponding lead time for each order (in days).

What is the probability that a shorter lead time is simply due to “random chance” (therefore NOT the result of changing to a new supplier)?

(Enter your answer as a percentage rounded to the nearest tenth of a decimal. For example, 0.2585 would be entered as 25.8%.)

3. Use the data in the “Part 2” sheet of the spreadsheet above to answer this question:

Suppose that your relative wants to establish a new dealership for selling new cars. This dealership would be the first dealership to exist in the local community. Your relative is uncertain whether the company should sell domestic or foreign automobiles and, therefore, seeks your help.

You do some research and discover that in the past four years, 70.0% of all automobiles purchased by individuals living in the local community were domestic. However, there has been “talk” in the area that turmoil in the automotive industry may cause a change in the number of domestic automobiles individuals buy. You decide to conduct a survey by randomly selecting potential new car buyers in the area. The results of your survey are shown in the attached spreadsheet.

Your relative wants to know the probability that the difference between your survey results and the historical proportion of domestic cars sold is due to “random chance” (therefore NOT the result of the turmoil in the auto industry). What is your answer?

(Enter your answer as a percentage rounded to the nearest tenth of a decimal. For example, 0.2585 would be entered as 25.8%.)

4. Use the data in the “Part 3” sheet of the spreadsheet above to answer this question:

Suppose that a very large company is exploring different ways to improve the job satisfaction of its employees. Every year, the company has its employees complete a “job satisfaction” survey that ranges from a scale of 1 (lowest satisfaction) to 5 (highest satisfaction). The company decides to pilot an experiment to see if giving out company stock options to employees helps to increase the job satisfaction score.

The company randomly selects employees from two groups: those who received stock options and those who did not. The attached spreadsheet includes the job satisfaction scores for the sampled employees from each group.

What is the probability that the increase in the average satisfaction scores is due to “random chance” (therefore NOT the result of the paying out stock options)?

(Enter your answer as a percentage rounded to the nearest tenth of a decimal. For example, 0.2585 would be entered as 25.8%.)