Question
Hi, I just need you to answer these four questions below. Thank you! Question 2 Background The manager of the home loans department of a
Hi, I just need you to answer these four questions below. Thank you!
Question 2
Background
The manager of the home loans department of a suburban bank has been asked by an analyst at the head office of the bank to look at whether the so called problem customers of that bank have been experiencing more or less mortgage stress in the last year. The branch manager decides to look at a random sample of n = 100 problem customers. These are customers whose mortgage repayments are more than four weeks overdue. She finds the number of weeks overdue for each of these 100 customers and stores these values in cells A2:A101 in the Excel file Assignment 2 Data.
She refers to the number of weeks overdue a problem customer is with their loan as the X variable.
In her report she is required to comment on the average level, the variance and the distribution of the values of the X variable.
Currently the analyst at head office thinks that for the bank customers the average time overdue that problem loans should be is m = 15.5 weeks and the variance of these values should be s2 = 8.
For all of the following questions use a level of significance of a = 0.10
Answer the following questions
(a)As part of her preliminary analysis she obtains the descriptive statistics and the histogram for the X variable. For the histogram she uses the following 15 class intervals
5
15.5
Using these results discuss the type of distribution that the X variable has. .(5 marks)
(b)Obtain the 90% confidence interval for the mean of the X variable and interpret the result.
Briefly discuss how this interval estimate could be used to test the null hypothesis that the mean is equal to the value of 15.5 that the analyst at head office thinks it is.
What is the size of the error bound for this interval estimate. If she wants an error bound of B = 0.5 what size sample should she use.(6 marks)
(c)Using the standard 6 step procedure test whether the average X value is less than the average of 15.5 that the analyst at head office thinks it is. (5 marks)
(d)Find the p-value we would use when testing these hypotheses in part (c). Briefly describe how we interpret and use this value.(5 marks)
Weeks Overdue 5.9 15.5 12.4 17.6 15.6 14.8 13.8 18.8 17.8 17 12.2 18.2 16.7 15.1 13.5 8.5 11 14 11.9 12.1 21.8 14.6 11.5 7.2 7.9 14.1 15.2 15.5 15.8 15.8 12.1 16.3 14.6 13.9 10.3 15.8 17.4 17.6 15.1 13.4 18.5 16.8 20.1 19.3 15.3 11.8 14.7 12.8 18.3 12.6 17.3 18 23.2 25.3 15.8 14.2 13.1 13.4 18 9.1 14.1 11 16.4 10.2 7.9 19.2 13.2 13.2 15.7 16.5 18 16.8 14.9 12.5 17 14.8 14.7 19.9 17 11.3 15.8 14.1 16.9 15.8 15.5 13.9 11.9 12.7 14.4 17.6 15.1 22 17 13.8 12.1 16.2 14.9 10.4 16.6 15 Question 2 Background The manager of the home loans department of a suburban bank has been asked by an analyst at the head office of the bank to look at whether the so called problem customers of that bank have been experiencing more or less mortgage stress in the last year. The branch manager decides to look at a random sample of n = 100 problem customers. These are customers whose mortgage repayments are more than four weeks overdue. She finds the number of weeks overdue for each of these 100 customers and stores these values in cells A2:A101 in the Excel file Assignment 2 Data. She refers to the number of weeks overdue a problem customer is with their loan as the X variable. In her report she is required to comment on the average level, the variance and the distribution of the values of the X variable. Currently the analyst at head office thinks that for the bank customers the average time overdue that problem loans should be is = 15.5 weeks and the variance of these values 2 should be = 8. For all of the following questions use a level of significance of = 0.10 Answer the following questions (a) As part of her preliminary analysis she obtains the descriptive statistics and the histogram for the X variable. For the histogram she uses the following 15 class intervals 5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started