QHA, Applied Statistics

Assignment Help:
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.
Data Analysis & Statistical Modeling for Business 6
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:- QHA

Multiple regression analysis, Complete the multiple regression model using ...

Complete the multiple regression model using Y and your combined X variables.  State the equation.  Next, make sure that you evaluate overall model performance with the Anova table

Canonical correlation analysis, Canonical correlation analysis (CC) allows ...

Canonical correlation analysis (CC) allows the investigation of the relationship between two ,sets of variables. For example, a sociologist may want to investigate the Relationship

Quota sampling, Quota sampling Under this method enumerators shall sele...

Quota sampling Under this method enumerators shall select the respondents in place of those not available, as per the quota fixed according  to guide lines   provided to them.

Interpolation and extrapolation, Meaning of Interpolation and Extrapolation...

Meaning of Interpolation and Extrapolation Interpolation is a method of estimating the most probable  missing figure on  the basis of given data under certain assumptions. On t

Measures of dispersion, Measures of Dispersion ...

Measures of Dispersion Box 3: Food vs. Oil Below are the figures for foodgrain procurement   and cr

Define the term multicollinearity, Question: (a) (i) Define the term ...

Question: (a) (i) Define the term multicollinearity. (ii) Explain why it is important to guard against multicollinearity. (b) (i) Sometimes we encounter missing values

Types of business forecasting , Types  of business forecasting  are genera...

Types  of business forecasting  are generally as follows: 1.      Sales  and Demand  forecasts 2.      Porduction  forecasts. 3.       Cost  Forecasts 4.       Financi

Show the hypothesis test, The file Midterm Data.xls has a tab labeled "Inc...

The file Midterm Data.xls has a tab labeled "Income Data 2009". This data is collected income data from a sample of 400 people in 2009. Use a hypothesis test to see whether the av

Inverse market demand, There are two types of drivers, high-risk drivers wi...

There are two types of drivers, high-risk drivers with an accident probability of 2=3 and low risk drivers with an accident probability of 1=3. In case of an accident the driver su

Pie diagram, Circles or Pie Diagram: Circles or pie diagrams are alter...

Circles or Pie Diagram: Circles or pie diagrams are alternative to squares. These are used  for the same purpose i.e. when  the values are differing  widely in their magnitude

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