30 Mar 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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.