Question

In: Statistics and Probability

Use Excel The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes...

Use Excel

The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes information to assist companies in estimating the cost of building a temporary road for such activities as a timber sale. Such roads are generally built for one or two seasons of use for limited traffic and are designed with the goal of reestablishing vegetative cover on the roadway and adjacent disturbed area within ten years after the termination of the contract, permit, or lease. The timber sale contract requires out sloping, removal of culverts and ditches, and building water bars or cross ditches after the road is no longer needed. As part of this estimation process, the company needs to estimate haul costs. The USDA publishes variable costs in dollars per cubic-yard-mile of hauling dirt according to the speed with which the vehicle can drive. Speeds are mainly determined by the road width, the sight distance, the grade, the curves and the turnouts. Thus, on a steep, narrow, winding road, the speed is slow; and on a flat, straight, wide road, the speed is faster. Shown below are data on speed, cost per cubic yard for a 12 cubic yard end-dump vehicle, and cost per cubic yard for a 20 cubic yard bottom-dump vehicle. Use these data and simple regression analysis to develop models for predicting the haul cost by speed for each of these two vehicles. Discuss the strength of the models. Based on the models, predict the haul cost for 35 mph and for 45 mph for each of these vehicles.

SPEED (MPH) HAUL COST 12-CUBIC-YARD END-DUMP VEHICLE $ PER CUBIC YD. HAUL COST 20-CUBIC-YARD BOTTOM-DUMP VEHICLE $ PER CUBIC YD.
10 $2.46 $1.98
15 $1.64 $1.31
20 $1.24 $0.98
25 $0.98 $0.77
30 $0.82 $0.65
40 $0.62 $0.47
50 $0.48 $0.40

Solutions

Expert Solution

For HAUL COST 12-CUBIC-YARD END-DUMP VEHICLE $ PER CUBIC YD.:

The simple regression model is:

y = 2.3549 - 0.0434*x

For speed = 35, y = 0.83623

For speed = 45, y = 0.40234

The output is:

0.794
r   -0.891
Std. Error   0.341
n   7
k   1
Dep. Var. HAUL COST 12-CUBIC-YARD END-DUMP VEHICLE PER CUBIC YD.
ANOVA table
Source SS   df   MS F p-value
Regression 2.2457 1   2.2457 19.32 .0070
Residual 0.5810 5   0.1162
Total 2.8267 6  
Regression output confidence interval
variables coefficients std. error    t (df=5) p-value 95% lower 95% upper
Intercept 2.3549
SPEED (MPH) -0.0434 0.0099 -4.396 .0070 -0.0688 -0.0180
Predicted values for: HAUL COST 12-CUBIC-YARD END-DUMP VEHICLE PER CUBIC YD.
95% Confidence Intervals 95% Prediction Intervals
SPEED (MPH) Predicted lower upper lower upper Leverage
35 0.83623 0.44965 1.22280 -0.12155 1.79400 0.195
45 0.40234 -0.15889 0.96356 -0.63827 1.44294 0.410

For HAUL COST 20-CUBIC-YARD BOTTOM-DUMP VEHICLE $ PER CUBIC YD.:

The simple regression model is:

y = 1.8805 - 0.0348*x

For speed = 35, y = 0.66407

For speed = 45, y = 0.31653

The output is:

0.781
r   -0.884
Std. Error   0.285
n   7
k   1
Dep. Var. HAUL COST 20-CUBIC-YARD BOTTOM-DUMP VEHICLE PER CUBIC YD.
ANOVA table
Source SS   df   MS F p-value
Regression 1.4408 1   1.4408 17.80 .0083
Residual 0.4047 5   0.0809
Total 1.8455 6  
Regression output confidence interval
variables coefficients std. error    t (df=5) p-value 95% lower 95% upper
Intercept 1.8805
SPEED (MPH) -0.0348 0.0082 -4.219 .0083 -0.0559 -0.0136
Predicted values for: HAUL COST 20-CUBIC-YARD BOTTOM-DUMP VEHICLE PER CUBIC YD.
95% Confidence Intervals 95% Prediction Intervals
SPEED (MPH) Predicted lower upper lower upper Leverage
35 0.66407 0.34144 0.98670 -0.13528 1.46342 0.195
45 0.31653 -0.15187 0.78492 -0.55196 1.18501 0.410

HAUL COST 12-CUBIC-YARD END-DUMP VEHICLE $ PER CUBIC YD. is better because it is explaining more variation in the data.


Related Solutions

Use Excel The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes...
Use Excel The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes information to assist companies in estimating the cost of building a temporary road for such activities as a timber sale. Such roads are generally built for one or two seasons of use for limited traffic and are designed with the goal of reestablishing vegetative cover on the roadway and adjacent disturbed area within ten years after the termination of the contract, permit, or lease....
The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes information to...
The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes information to assist companies in estimating the cost of building a temporary road for such activities as a timber sale. Such roads are generally built for one or two seasons of use for limited traffic and are designed with the goal of reestablishing vegetative cover on the roadway and adjacent disturbed area within ten years after the termination of the contract, permit, or lease. The timber...
The United States Department of Agriculture (USDA) claims that the national average price for one gallon...
The United States Department of Agriculture (USDA) claims that the national average price for one gallon of whole milk is $3.49, and that the population standard deviation is $0.64. You believe that the USDA’s claim is not correct, so you select a simple random sample of 35 grocery stores nationwide and record the price of a gallon of whole milk. Your sample mean price for a gallon of whole milk was $3.27. Using a significance level of .05, does it...
13. (18 pts total) The U.S. Department of Agriculture (USDA) uses sample surveys to produce important...
13. (18 pts total) The U.S. Department of Agriculture (USDA) uses sample surveys to produce important economic estimates. One pilot study estimated wheat prices in July and in August using independent samples of wheat producers in the two months. Here are the summary statistics, in dollars per bushel. July: n1 = 35, x1 = $7:62, s1 = $0:28 and August: n2 = 25, x2 = $7:44, s2 = $0:35. Can we conclude that the national average price in July 1...
The U.S. Department of Agriculture (USDA) uses sample surveys to produce important economic estimates. One pilot...
The U.S. Department of Agriculture (USDA) uses sample surveys to produce important economic estimates. One pilot study estimated durum wheat prices in July and in January using independent samples of wheat producers in the two months. The data is given below. Price Month 6.2335 July 6.3215 July 6.4457 July 6.1488 July 6.3079 July 5.8976 January 6.2064 January 6.1278 January 6.0468 January 5.9692 January Although there is variation among prices within each month, the top four prices are all from July...
1.      The U.S. Department of Agriculture publishes data annually on various selected farm products. Shown here...
1.      The U.S. Department of Agriculture publishes data annually on various selected farm products. Shown here are the unit production figures (in millions of bushels) for three farm products for 10 years during a 20-year period. (leave 3 decimal places) Corn Soybeans Wheat 4152 1127 1352 6639 1798 2381 4175 1636 2420 7672 1861 2595 8876 2099 2424 8226 1940 2091 7131 1938 2108 4929 1549 1812 7525 1924 2037 7933 1922 2739 (1). If we want to predict the...
Consider the role of the United States Treasury Department, the Internal Revenue Service, in International Taxation....
Consider the role of the United States Treasury Department, the Internal Revenue Service, in International Taxation. What do you think are the major obstacles facing the Internal Revenue Service as our markets continue to become more international? As you continue to evolve in our international markets, how might the Internal Revenue Service’s role change?
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
The Economic Research Service of the U.S. Department of Agriculture has reported the results of a...
The Economic Research Service of the U.S. Department of Agriculture has reported the results of a study of the effects of the price of various types of oranges on the quantity demanded of the oranges. The oranges are sold in perfectly competitive markets. In particular, three types of oranges were studied: 1) Florida Valencia, 2) California Navel, and 3) California Blood Orange. In nine test stores in Grand Rapids, Michigan, the researchers varied the price of each of these types...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT