Assignment:
Question 1
Butler Trucking company is an independent trucking company in southern California. A major portion of Butler's business involves deliveries thought its local are. To develop better work schedules, the mangers want to estimate the total daily trave time for their drivers. Thus a multiple linear regression model is estimated using th e numbers of miles traveled in marking the daily deliveries and number of deliveries as the independent variable (X). The dependent variable is the travel time (y). Part of the Excel output is given below.
1. Write down the estimated equation:
2. Briefly discuss which variable(s) is(are) associated with significant coefficient(s). Make sure you specify what criteria you used and your reasoning.
|
Regression Statistics
|
|
Multiple R
|
0.9507
|
|
R Square
|
0.904
|
|
Adjusted R Square
|
0.876
|
|
Standard Error
|
0.5731
|
|
Observations
|
10
|
|
|
Coefficients
|
Standard Error
|
t Stat
|
P-value
|
|
Intercept
|
-0.8687
|
0.9515
|
-0.91
|
0.392
|
|
Miles
|
0.061135
|
0.009888
|
6.18
|
0
|
|
Deliveries
|
0.9234
|
0.2211
|
4.18
|
0.004
|
Question 2
Discuss any two of the errors that are considered to be respondent error. Give brief explanation.
Question 3
List the pros and cons of using online questionnaire for surveys.
Question 4
Explain how to create dummy variables to include a categorical variable in regression analysis. Make sure you mention the omitted category. You can take the color of cars, blue, red, white and green, as an example.
Question 5
Briefly describe what exploratory research and descriptive research are and given an example of each.