--%>
Assignment Help - homework help

develop the most appropriate regression model

Predicting Courier Costs

The law firm of Adams, Babcock, and Connors is located in the Dallas-Fort metroplex.  Randall Adams is the senior and founding partner of the firm.  John Babcock has been a partner in the firm for the past eight years, and Blake Connors became a partner just last year.  The firm employs two paralegal assistants and three secretaries.  In addition, you, the newly hired office manager, are in charge of day-to-day operations and manage the financial affairs of the law firm. 

A major aspect of the law firm's business is the preparation of contracts and other legal documents for its clients.  A courier service is employed by the firm to deliver legal documents to its many clients as they are scattered throughout the metroplex.  The downtown centers of Dallas and Fort Worth are separated by a distance of approximately (30) miles.  With the large sizes of these cities and their associated heavy traffic, a trip by car from the southwest side of Fort Worth to the northeast side of Dallascan easily take longer than an hour which could impact courier costs.

In order to improve the firm's planned expenditures, you have been asked to derive a regression model that would be best in predicting courier costs.  The information provided in the Excel file E281 Project 2 Data, includes cost (charge for the delivery), pickup time (time in minutes from when the order is phoned in until a courier agent arrives), delivery time (time in minutes that it takes for the documents to be delivered), and mileage (distance in miles from the law firm to the destination).

(a).  Select only (1) of the (3) independent variables provided to use in your regression model.  Justify your selection by ONLY applying the p-value approach.

(b).  Using your results in (a), develop the most appropriate regression model using a linear model, quadratic model, and cubic regression model.  

(c).  Using your results in (a), develop the most appropriate model using a linear model, log-logmodel, logarithmic model, and exponential model.

(d).  Write a (1) page report that summarizes your results and methodology, and explain your perspective of the models you developed in (b) and (c).  In regards to your results in (b) and (c), which model would you choose.  Briefly explain.

   Related Questions in Basic Statistics

  • Q : Model Checking Approach Model Checking

    Model Checking Approach: • Specify program model and exhaustively evaluate that model against a speci?cation        –Check that properties hold   

  • Q : Compute two sample standard deviations

    Consider the following data for two independent random samples taken from two normal populations. Sample 1 14 26 20 16 14 18 Sample 2 18 16 8 12 16 14 a) Com

    		•
  • Q : Data Description 1. If the mean number

    1. If the mean number of hours of television watched by teenagers per week is 12 with a standard deviation of 2 hours, what proportion of teenagers watch 16 to 18 hours of TV a week? (Assume a normal distribution.) A. 2.1% B. 4.5% C. 0.3% D. 4.2% 2. The probability of an offender having a s

    		•
  • Q : Building Models Building Models • What

    Building Models • What do we need to know to build a model?– For model checking we need to specify behavior • Consider a simple vending machine – A custome rinserts coins, selects a beverage and receives a can of soda &bul

    		•
  • Q : Data Description 1. If the mean number

    1. If the mean number of hours of television watched by teenagers per week is 12 with a standard deviation of 2 hours, what proportion of teenagers watch 16 to 18 hours of TV a week? (Assume a normal distribution.) A. 2.1% B. 4.5% C. 0.3% D. 4.2% 2. The probability of an offender having a s

    		•
  • Q : Principles of data analysis For the

    For the data analysis project, you will address some questions that interest you with the statistical methodology we are learning in class. You choose the questions; you decide how to collect data; you do the analyses. The questions can address almost any topic,

    		•
  • Q : Derived quantities in Queuing system

    Derived quantities in Queuing system: • λ = A / T, Arrival rate • X = C / T, Throughput or completion rate • ρ =U= B / T, Utilization &bu

    		•
  • Q : Quantities in a queuing system

    Quantities in a queuing system: A: Count of

    		•
  • Q : Variance and standard error A hospital

    A hospital treated 412 skin cancer patients over a year. Of these, 197 were female. Give the point estimate of the proportion of females seeking treatment for skin cancer. Give estimates of the

    		•
  • Q : What is Inter-arrival times

    Inter-arrival times:A) Requests arrive randomly, often separated by small time intervals with few long separations among themB) The time until the next arrival is independent of when the last arrival occurredC) Coro

    		•