Texas Health Harris Methodist measures average wait time for patients in the ER is 45 minutes. The average wait time for the ER is normally distributed. The hospital decided to check if thi
Excel Assignment
Texas Health Harris Methodist measures average wait time for patients in the ER is 45 minutes. The average wait time for the ER is normally distributed. The hospital decided to check if this is still true, the quality control staff recorded 45 observations of the wait time of ER patients. Using the observations below, is there evidence that the average wait time for ER patients is not 45 minutes? Use a level of significance of .05
Observation
|
Observations |
Time (in minutes) |
|
1 |
44.48 |
|
2 |
43.93 |
|
3 |
44.92 |
|
4 |
45.05 |
|
5 |
46.11 |
|
6 |
47.52 |
|
7 |
44.4 |
|
8 |
46.38 |
|
9 |
46.03 |
|
10 |
46.12 |
|
11 |
45.27 |
|
12 |
44.23 |
|
13 |
49.48 |
|
14 |
40.35 |
|
15 |
41.96 |
|
16 |
42.93 |
|
17 |
47.86 |
|
18 |
45.57 |
|
19 |
46.52 |
|
20 |
45.34 |
|
21 |
45.33 |
|
22 |
40.98 |
|
23 |
46.58 |
|
24 |
47.2 |
|
25 |
46.89 |
|
26 |
44.23 |
|
27 |
46.14 |
|
28 |
48.63 |
|
29 |
43.69 |
|
30 |
45.87 |
|
31 |
42.98 |
|
32 |
45.95 |
|
33 |
45 |
|
34 |
44.16 |
|
35 |
44.38 |
|
36 |
47.51 |
|
37 |
45.14 |
|
38 |
41.75 |
|
39 |
46.22 |
|
40 |
45.64 |
|
41 |
45.87 |
|
42 |
48.06 |
|
43 |
45.64 |
|
44 |
45.44 |
|
45 |
41.49 |
Answer the following question:
1. What is the null and alternative hypothesis to the case above?
2. Copy the data into excel and do an analysis to test the hypothesis
Upload the excel file with the your assignment submission
Hint: (watch the module 3 videos)
3. What is the conclusion of your analysis? (try to state it in terms of the original problem or question)
As a director of your HR department you want to see if there is a difference in salary based on gender in your industry. You take a sample of the salaries of males and females from different companies in your industry. Using the observations below, is there evidence that the average salary between males and female are different? Use a level of significance of .05
|
Company |
MALES ($ thousands) |
FEMALES ($ thousands) |
|
1 |
34.5 |
33.9 |
|
2 |
30.5 |
31.2 |
|
3 |
35.1 |
35 |
|
4 |
35.7 |
34.2 |
|
5 |
31.5 |
32.4 |
|
6 |
34.4 |
34.1 |
|
7 |
32.1 |
32.7 |
|
8 |
30.7 |
29.9 |
|
9 |
33.7 |
31.2 |
|
10 |
35.3 |
35.5 |
|
11 |
30.7 |
30.2 |
|
12 |
34.2 |
34.8 |
|
13 |
39.6 |
38.7 |
|
14 |
30.5 |
30 |
|
15 |
33.8 |
33.8 |
|
16 |
31.7 |
32.4 |
|
17 |
32.8 |
31.7 |
|
18 |
38.5 |
38.9 |
|
19 |
40.5 |
41.2 |
|
20 |
25.5 |
|
|
21 |
28 |
|
|
22 |
35.1 |
4. What is the null and alternative hypothesis to the case above?
5. Copy the data into excel and do an analysis to test the hypothesis
Upload the excel file with the your assignment submission
6. What is the conclusion of your analysis? (state it in terms of the original problem or question)
WinCo Foods, a large Discount grocery retailer in the western United States, promotes itself as the lowest priced grocery retailer. In newspaper ads WinCo Foods published a price comparison for products between WinCo and several competing grocery retailers. One of the retailers compared against WinCo was Walmart, also known as a low-price competitor. WinCo selected a variety of products, listed the price of the product charges at each retailer, and showed the sales receipt to prove the prices at WinCo were the lowest in the area. A sample of the products and their prices comparison at both WinCo and Walmart are shown in the following table:
|
Item |
WinCo |
Wal Mart |
|
Bananas |
0.42 |
0.56 |
|
Red Onions |
0.58 |
0.98 |
|
Mini Peeled Carrots |
0.98 |
1.48 |
|
Roma Tomatoes |
0.98 |
2.67 |
|
Deli Tater Wedges |
1.18 |
1.78 |
|
Beef Cube Steak |
3.83 |
4.118 |
|
Beef Top Round London Boil |
3.48 |
4.12 |
|
Pillsbury Devils Food Cake Mix |
0.88 |
0.88 |
|
Lipton Rice and Sauce Mix |
0.88 |
1.06 |
|
Sierra Nevada Pale Ale |
12.68 |
12.84 |
|
Gm Cheerios Oat Clusters |
1.98 |
2.74 |
|
Charmin Bathroom Tissues |
5.98 |
7.48 |
|
Bumble Bee Pink Salmon |
1.58 |
1.98 |
|
Pace Thick & Chunchy Salsa |
2.28 |
2.78 |
|
Nalley Chili |
0.78 |
0.78 |
|
Challenge Butter |
2.18 |
2.58 |
|
Kraft American Singles |
2.27 |
2.27 |
|
Yuban Coffee FAC |
5.98 |
7.56 |
|
Totinos Pizza Rolls |
2.38 |
2.42 |
|
Rosarita Refried Beans |
0.68 |
0.73 |
|
Barilla Spaghetti |
0.78 |
1.23 |
|
Sun-Maid Mini Raisins |
1.18 |
1.36 |
|
Jif Peanut Butter, Creamy |
2.54 |
2.72 |
|
Dole Fruit Bowl |
1.68 |
1.98 |
|
Progresso Chicken Noodle Soup |
1.28 |
1.38 |
|
Precious Mozzarella Ball |
3.28 |
4.23 |
|
Mrs. Cubbison Seasoned Crotons |
0.88 |
1.12 |
|
Kellogg's Raisin Bran |
1.98 |
2.5 |
|
Campbell's Soup at Hand |
1.18 |
1.26 |
7. What is the null and alternative hypothesis to the case above?
8. Copy the data into excel and do an analysis to test the hypothesis
Upload the excel file with the your assignment submission
9. What is the conclusion of your analysis? (State it in terms of the case or scenario)
10. At the bottom of the price list, the following statement appears: “ Though this list is not intended to represent a typical weekly grocery order or a random list of grocery items, WinCo continues to be the area’s low price leader” Why do you think WinCo added this statement?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
