The billing department of a national cable service company is conducting a study of how customers pay their monthly cable bills. The cable company accepts payment in person at a local office, by mail, by credit card, or by electronic funds transfer from a bank account. The cable company randomly sampled 400 customers to determine if there is a relationship between the customer's age and the payment method used. The accompanying sample results were obtained. Based on the sample data, can the cable company conclude that there is a relationship between the age of the customer and the payment method used? Conduct the appropriate test at the α=0.01 level of significance.
Payment Method | 20-30 | 31-40 | 41-50 | Over 50 |
In person | 9 | 12 | 11 | 12 |
By mail | 29 | 66 | 71 | 56 |
By credit card | 25 | 19 | 5 | 6 |
By Funds Transfer | 23 | 34 | 16 | 6 |
A) Calculate the test statistic
B) Calculate the p-value
C) Conclusion
Solution:
Here, we have to use chi square test for independence of two categorical variables.
Null hypothesis: H0: There is no relationship between the age of the customer and the payment method used.
Alternative hypothesis: Ha: There is a relationship between the age of the customer and the payment method used.
We are given level of significance = α = 0.01
A) Calculate the test statistic
Test statistic formula is given as below:
Chi square = ∑[(O – E)^2/E]
Where, O is observed frequencies and E is expected frequencies.
E = row total * column total / Grand total
We are given
Number of rows = r = 4
Number of columns = c = 4
Degrees of freedom = df = (r – 1)*(c – 1) = 3*3 = 9
α = 0.01
Critical value = 21.66599
(by using Chi square table or excel)
Calculation tables for test statistic are given as below:
Observed Frequencies |
|||||
Column variable |
|||||
Row variable |
C1 |
C2 |
C3 |
C4 |
Total |
R1 |
9 |
12 |
11 |
12 |
44 |
R2 |
29 |
66 |
71 |
56 |
222 |
R3 |
25 |
19 |
5 |
6 |
55 |
R4 |
23 |
34 |
16 |
6 |
79 |
Total |
86 |
131 |
103 |
80 |
400 |
Expected Frequencies |
|||||
Column variable |
|||||
Row variable |
C1 |
C2 |
C3 |
C4 |
Total |
R1 |
9.46 |
14.41 |
11.33 |
8.8 |
44 |
R2 |
47.73 |
72.705 |
57.165 |
44.4 |
222 |
R3 |
11.825 |
18.0125 |
14.1625 |
11 |
55 |
R4 |
16.985 |
25.8725 |
20.3425 |
15.8 |
79 |
Total |
86 |
131 |
103 |
80 |
400 |
Calculations |
|||
(O - E) |
|||
-0.46 |
-2.41 |
-0.33 |
3.2 |
-18.73 |
-6.705 |
13.835 |
11.6 |
13.175 |
0.9875 |
-9.1625 |
-5 |
6.015 |
8.1275 |
-4.3425 |
-9.8 |
(O - E)^2/E |
|||
0.022368 |
0.40306 |
0.009612 |
1.163636 |
7.349946 |
0.618348 |
3.348329 |
3.030631 |
14.67912 |
0.054138 |
5.927725 |
2.272727 |
2.130128 |
2.553145 |
0.926991 |
6.078481 |
Chi square = ∑[(O – E)^2/E] = 50.56839
B) Calculate the p-value
P-value = 0.00
(By using Chi square table or excel)
P-value < α = 0.05
So, we reject the null hypothesis
C) Conclusion
There is sufficient evidence to conclude that there is a relationship between the age of the customer and the payment method used.
The billing department of a national cable service company is conducting a study of how customers...
The billing department of a national cable service company is conducting a study of how customers pay their monthly cable bills. The cable company accepts payment in person at a local office, by mail, by credit card, or by electronic funds transfer from a bank account. The cable company randomly sampled 400 customers to determine if there is a relationship between the customer's age and the payment method used. The accompanying sample results were obtained. Based on the sample data,...
Levine Company uses the perpetual inventory system and allows customers to use two credit cards in charging purchases. With the Suntrust Bank Card, Levine receives an immediate credit to its account when it deposits sales receipts. Suntrust assesses a 4% service charge for credit card sales. The second credit card that Levin accepts is Continental Card. Levin sends its accumulated receipts to Continental on a weekly basis and is paid by Continental a week later. Continental assesses a 2.5% charge...
A customer service department and is customers to sate their own the phone service on a scale of 1-20 immediately after their service has been completed. The department than matches each customers rating with the number of minutes the person walled on hold. The accompanying table shows the ratings and number of minutes on hold for 10 randomly selected customers. The regression line for the data is = 16.8427 -0.3701x47x30 and 50.9876 Complete parts a through below B Click the...
A National Bank issues MasterCard credit cards to its customers. A main factor in determining whether a credit card will be profitable to the bank is the average monthly balance that the customer will maintain on the card that will be subject to finance charges. Bank analysts wish to determine whether there is a relationship between the average monthly credit card balance and the income stated on the original credit card application form. The following sample data have been collected...
iti lance level of 411101ch A mann issues wedit cards to its customers. A main factor in determining whether a widit card will be profitable to re bann is te averase month 14 balance that the customer will maintain on the card that will be subullt to finance charges. Band analysts wish to be termine whether there is a relationship between te the average month14 Wedit card balance and the income stated on te original, Wedit card application form accompanying...
Using basic demographic information (age, household income, marital status, etc.), you collect a random sample size 181 customers who accepted a special balance transfer offer from a major credit card company six months ago. The company wants to determine if there is evidence that it would profit by offering the deal to the population of customers with those same demographic characteristics. The sample mean balance transfer amount is 1,690 with a sample standard deviation of 417. Based on the information...
Customer Service. A customer service department asks its customers to rate their over-the-phone service on a scale of 1-20 immediately after their service has been completed. The department then matches each customer’s rating with the number of minutes the person waited on hold. The file “Hold” on d2l contains data for the ratings and number of minutes on hold for 20 customers. As demonstrated in the lecture, please create a subset data of size 16 and perform your statistical analysis...
Question 3 (30%) White Company allows customers to make purchases on credit. The terms of all credit sales are 2/10, n/30, and all sales are recorded at the gross price. Other customers can use a bank credit card where the bank deducts a 4% service charge for credit card sales and credits the bank account of White immediately when credit card receipts are deposited. White uses the perpetual inventory method. Prepare journal entries to record the following selected transactions and...
For each of the problems below perform an hypothesis test. State the null and alternative hypothesis, the p-value and your conclusion in context of the problem. Perform each test at a .05 significance. 1. A manufacturer of a plasticised line used in home-assembly mobiles advertises that their product has an average tensile strength of 30 kilograms (this is a measure of how strong the product is). You took a sample of 144 sections of the line and tested them. The...
All work must be shown. If you use a calculator shortcut, please show what you used. 1. Exercise 4.16 on page 73. A beverage company makes weekly deliveries from its warehouse to a supermarket. The delivery time varies based on interstate traffic and scheduling factors, but is normally distributed with a mean of 17 hours and a standard deviation of 3 hours. What is the probability it will take between 12 and 15 hours to make this weeks delivery? 2....