complete
The following data show a sample of Automatic Teller Machine (ATM) customers; time (seconds) to complete their transaction, estimated age, and gender (1= male, 0 = female).
Time |
76 |
70 |
76 |
42 |
66 |
57 |
53 |
67 |
81 |
76 |
70 |
75 |
73 |
72 |
Age |
47 |
42 |
46 |
38 |
22 |
34 |
31 |
69 |
43 |
67 |
50 |
29 |
40 |
51 |
Gender |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
1 |
Test 3 problem 3C data file.xlsx Download Test 3 problem 3C data file.xlsx
a. Determine the multiple regression equation for estimating transaction time based on age and gender of the customer.
Enter the regression coefficients in xx.xxx format. Round the value to three decimals and use leading and trailing zero to exactly match the format. Include the negative sign (minus sign) if the coefficient is negative. Do not include plus sign in your response. For example, if the coefficient is +6.1563 then enter 06.156 as your answer, if the coefficient is -0.54765 then enter -00.548 and if the answer is -1.6435 then enter -01.644
Ŷ=b0+b1X1+b2X2
Constant/intercept (b0) =
Coefficient/slope of Age (X1) (b1) =
Coefficient/slope of Gender (X2) (b2) =
b. Considering the regression coefficients (slope) for age and gender, which of the following statements is correct?
Enter the statement number 1, 2, or 3 corresponding to the correct statement in the answer text box below.
- Among the male customers, the younger customers on the average spend more time at the ATM machine.
- Among the customers with the same age, the male customers on the average spend less time at the ATM machine than the female customers.
- The male customers on the average spend less time at the ATM machine than the female customers.
Your answer (1/2/3) is:
c. What is the estimated time required by a female customer who is 35 years of age?
Enter your answer in xx.xx format. Round the value to two decimals and use leading and trailing zero to exactly match the format. Include the negative sign (minus sign) if the answer is negative. Do not include plus sign in your response. For example, if the answer is +6.1563 then enter 06.16, if the answer is -0.54765 then enter -00.55 and if the answer is 6.1 then enter 06.10
Your answer is =
d. Determine 90% prediction interval for the time required by the customer described in part (c).
Enter your answer in xx.xx format. Round the value to two decimals and use leading and trailing zero to exactly match the format. Include the negative sign (minus sign) if the answer is negative. Do not include plus sign in your response. For example, if the answer is +6.1563 then enter 06.16, if the answer is -0.54765 then enter -00.55 and if the answer is 6.1 then enter 06.10
The upper limit of the prediction interval is:
The lower limit of the prediction interval is:
e. Determine 90% confidence interval for the mean time required by customers similar to one described in part (c).
Enter your answer in xx.xx format. Round the value to two decimals and use leading and trailing zero to exactly match the format. Include the negative sign (minus sign) if the answer is negative. Do not include plus sign in your response. For example, if the answer is +6.1563 then enter 06.16, if the answer is -0.54765 then enter -00.55 and if the answer is 6.1 then enter 06.10
The upper limit of the confidence interval is:
The lower limit of the confidence interval is:
f. What is the coefficient of determination?
Enter your answer in percentage and round it to the nearest integer. Do not include % sign in your answer.
Your answer is:
g. With 90% confidence level (0.1 significance level), does the sample data suggest that the age of customer is a significant variable in explaining the time the customer spends at the ATM machine?
Enter “Y” if data suggests that the variable is significant and enter “N” if data does not suggest that the variable is significant.
Your answer (Y/N) is:
h. With 90% confidence level (0.1 significance level), does the sample data suggest that the customer gender is a significant variable in explaining the time the customer spends at the ATM machine?
Enter “Y” if data suggests that the variable is significant and enter “N” if data does not suggest that the variable is significant.
Your answer (Y/N) is:
Step by step
Solved in 2 steps