Regression Analysis, Applied Statistics

Assignment Help:
Question 3
25 marks

Your employer, Quick Hit Agency (QHA), is a debt collections agency. The company specializes in collecting small accounts. QHA does not deal in large accounts and does not take on risky collections, such as those in which the debtor tends to be chronically late in payments or is known to be hostile.
To distinguish itself from competing collection agencies, the company wants to establish a reputation for collecting delinquent accounts fast. The marketing department has just suggested that QHA adopt the slogan:
“Under 60 days or your money back!“
At the last staff meeting in which this slogan was proposed, the marketing department was asked how they arrived at the number 60. You found the reply unsatisfactory at best: “Well, 60 sounded like a nice round number.”
Since you work as an accountant at QHA, you have access to account balances. You suspect that the number of days to collect the payment is related to the size of the bill. If this is the case, you may be able to estimate how quickly certain accounts are likely to be collected, which, in turn, may assist the marketing department in determining an appropriate level for the money-back guarantee.
To test this theory, you’ve taken a sample of accounts closed out during the months of January through June. The data set includes the initial size of the account and the total number of days to collect payment in full. QHA deals in both residential and commercial accounts and you’ve collected data from both groups. The first 48 observations in the data set are residential accounts and the second 48 are commercial accounts. QHA has approximately equal numbers of residential and commercial accounts so the samples are of the right size.
In the worksheet, the variable Late is the number of days the payment was overdue, and the variable Bill is the amount of the bill in dollars.
Your submission should be in the form of a report commencing with an Executive Summary which includes a recommendation on the feasibility of the 60- day money back guarantee. The next section should be titled Exploratory Analysis and provide an initial examination of the data. The final section titled Regression Analysis should decide whether the size of the bill a useful predictor of the number of days the payment is overdue.
You should make effective use of StatToolsTM output. Results should be reported using the appropriate templates.
Please DO NOT remove any data.
Page limit: Maximum 7 pages including all diagrams

Related Discussions:- Regression Analysis

Good measure of quality, Education seems to be a very difficult field in wh...

Education seems to be a very difficult field in which to use quality methods. One possible outcome measures for colleges is the graduation rate (the percentage of the students matr

Iterative convergence of the method, You are given the differential equatio...

You are given the differential equation dy/dx = y' = f(x, y) with initial condition y(0 ) 1 = . The following numerical method is also given: where  f n = f( x n , y n )

Asymmetric proximity matrices, Asymmetric proximity matrices Immediacy...

Asymmetric proximity matrices Immediacy matrices in which the off-diagonal elements which are, in the i th row and j th column and the j th row and i th column, are not essent

Ogive percentile, how do i determine the 40th percentile in an ogive graph

how do i determine the 40th percentile in an ogive graph

Calculate the normal loss and abnormal loss, Chemical processors manufactur...

Chemical processors manufacture wondercool using two processes- mixing and distillation. The following details relate to the distillation process for a period. No opening work i

Estimate the standard deviation of the process, Estimate the standard devia...

Estimate the standard deviation of the process: Draw the X (bar) and R charts for the data given and give your comments about the process under study. Estimate the standard de

Displacement of a simply supported beam, The displacement of a simply suppo...

The displacement of a simply supported beam subject to a uniform load is given by the solution of the following differential equation (for small displacements); and q is th

Association of attributes, In an examination 600 candidates appeared, boys ...

In an examination 600 candidates appeared, boys outnumbered girls by 16% of all candidates. number of passed candidates exceeded the number of failed candidates by 310. Boys failin

Latin Square design, what is the the Latin Square design? What is its appli...

what is the the Latin Square design? What is its application in research? please explain this term with very simple but with detailed explanation for effective understanding. I hav

Find probability of remaining paint free - ball duel, In a three-cornered p...

In a three-cornered paint ball duel, A, B, and C successively take shots at each other until only one of them remains paint free. Once hit, a player is out of the game and gets no

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd