User Account

All Pages

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

Calculate the ratio of the sample standard deviation, The Case Study includ...

The Case Study included information about the price for a full meal before and after the law change (in dollars).  Of interest is whether the differences in price for a full meal b

Use event rule ot estimates the claim, Make a decision about the given clai...

Make a decision about the given claim. Use only the rare event rule, and make subjective estimates to determine whether events are likely. For example, if the claim is that a coi

Estimation of seasonal variation, how can i calculate seasonal index?

how can i calculate seasonal index?

Correlation matrix table, A.    Do the correlation matrix table. B.    W...

A.    Do the correlation matrix table. B.    Which variable (s) has the largest correlation coeffieient which is not a perfect correlation? C.    Which variable (s) has the s

Perform a simple linear regression analysis, In New Jersey, banks have been...

In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, data is presented in the table below conc

the npv of the book , Bill Clinton reportedly was paid $10 million to writ...

Bill Clinton reportedly was paid $10 million to write his book My Way. The book took three years to write. In the time he spent writing, Clinton could have been paid to make speech

Multiple regressions, A sample of 43 houses that were purchased in the Sout...

A sample of 43 houses that were purchased in the Southern California town Monrovia within a month was collected. We are interested in the study of the relationships between Price a

Harmonic mean, The Harmonic Mean is based on the reciprocals of numbers ave...

The Harmonic Mean is based on the reciprocals of numbers averaged. It is defined as the reciprocal of the arithmetic mean of the reciprocal of the given individual observations. Th

Logistic regression model, A marketing research firm was engaged by an auto...

A marketing research firm was engaged by an automobile manufacturer to conduct a pilot study to examine the feasibility of using logistic regression for ascertaining the likelihood

Postneonatal mortality rate, Mid year population 440000 Late fatal death...

Mid year population 440000 Late fatal death          29 No. of live birth           5200 No. of infant death      423 No. of maternal death 89 No. of infant deaths i

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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