Questions:
1.Home Mail Corporation sells products by mail. The company's management wants to find out if the number of orders received on each of the five days of the week is the same. The company took a sample of 400 orders received during a four-week period. The following table lists the frequency distribution for these orders by the day of the week. Conduct a goodness of fit test to determine if the distribution of orders is equally distributed by day of the week.
Day of week Mon Tue Wed Thur Fri
Number of orders 92 68 65 86 89
2 One hundred auto drivers, who were stopped by police for some violation, were also checked to see if they were wearing their seat belts. The following table shows the results of this survey. Conduct a test of independence to determine if seat belt usage differs by gender
Wearing Not Wearing
seatbelt seatbelt
Male 34 21
Female 30 15
3 Two drugs were administered to two groups of patients to cure the same disease. One group of 60 patients and another group of 40 patients were selected. The following table gives information about the number of patents who were cured and not cured by drug. Conduct a test of independence to determine if each drug is as equally effective in curing the patients.
Cured Not cured
Drug 1 46 14
Drug 2 18 22
4 A large company buys thousands of light bulbs every year. The company is currently considering four brands of light bulbs to choose from. Before the company decides which light bulbs to buy, it wants to investigate if the mean life of the four types of light bulbs is the same. The company's facilities department randomly selected a few bulbs of each type and tested them. The following table lists the number of hours (in thousands) at each of the bulbs by brand survived before burning out. Conduct an A in EXCEL to determine if mean life of these four brands are the same or different. If you have time also try to do by hand.
Brand 1 Brand 2 Brand 3 Brand 4
23 9 23 26
24 23 27 24
19 18 25 21
26 24 26 29
22 20 23 28
23 21 21 24
25 19 27 28
Attachment:- Assignment.rar