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 : Decision Variables Determine Decision

    Determine Decision Variables: Let X1 be the number of private homes to be inspectedLet X2 be the number of office buildings to be inspect

  • Q : Homework help on Human memory & SPSS

    Effect of Scopolamine on Human Memory: A Completely Randomized Three Treamtent Design (N = 28) Scopolamine is a sedative used to induce sle

  • 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 : Statistics basic question This week you

    This week you will analyze if women drink more sodas than men.  For the purposes of this Question, assume that in the past there has been no difference.  However, you have seen lots of women drinking sodas the past few months.  You will perform a hypothesis test to determine if women now drink more

  • Q : Regression Analysis 1. A planning

    1. A planning official in the Texas Department of Community Affairs, which works in the office next to you, has a problem. He has been handed a data set from his boss that includes the costs involved in developing local land use plans for communities wi

  • Q : Designing a system What are the

    What are the questions that comes into mind when designing a system?

  • Q : FIN512 Entrepreneurial Finance Chapter

      Chapter 6: Discussion Question: #4 p. 223  It is usually easier to forecast sales for a seasoned firm contrast to an early-stage venture because an early-stage venture has limited access to bank credit lines, sho

  • Q : Help An experiment is conducted in

    An experiment is conducted in which 60 participants each fill out a personality test, but not according to the way they see themselves. Instead, 20 are randomly assigned to fill it out according to the way they think a parent sees them (i.e. how a parent would fill it out to describe the participant

  • Q : Spss in Business and Management Please

    Please tell me the cost of this current assignment. Note : I do not want the Solutions but please tell me the price as the assignment is .. Is the cost 3 euro? Do you sell those questions?

  • Q : Probability how can i calculate

    how can i calculate cumulative probabilities of survival

©TutorsGlobe All rights reserved 2022-2023.