In 2005 Stanley Ahlon and three financial partners formed Dy

In 2005, Stanley Ahlon and three financial partners formed Dynamic Scales, Inc. The company was based on an idea Stanley had for developing a scale to weigh trucks in motion and thus eliminate the need for every truck to stop at weigh stations along highways. This dynamic scale would be placed in the highway approximately one-quarter mile from the regular weigh station. The scale would have a minicomputer that would automatically record truck speed, axle weights, and climate variables, including temperature, wind, and moisture. Stanley Ahlon and his partners believed that state transportation departments in the United States would be the primary market for such a scale. As with many technological advances, developing the dynamic scale has been difficult. When the scale finally proved accurate for trucks traveling 40 miles per hour, it would not perform for trucks traveling at higher speeds. However, eight months ago, Stanley announced that the dynamic scale was ready to be field-tested by the Nebraska State Department of Transportation under a grant from the federal government. Stanley explained to his financial partners, and to Nebraska transportation officials, that the dynamic weight would not exactly equal the static weight (truck weight on a static scale). However, he was sure a statistical relationship between dynamic weight and static weight could be determined, which would make the dynamic scale useful. Nebraska officials, along with people from Dynamic Scales, installed a dynamic scale on a major highway in Nebraska. Each month for six months data were collected for a random sample of trucks weighed on both the dynamic scale and a static scale. Excel sheet presents these data. Once the data were collected, the next step was to determine whether, based on this test, the dynamic scale measurements could be used to predict static weights. A complete report will be submitted to the U.S. government and to Dynamic Scales.

Now, when sketching the relationship between y and all the x’s you will find that the relation is a linear relationship. Then when attempt to do the multiregression analysis, the perfect model will relay only on x₁(Front - Axle Dynamic Weight (lb)). But Stanley Ahlon and the three financial partners inc. believed that the value of y (Front - Axle Static Weight (lb)) depends on more than that but the data could not be enough to detect that.

1) Is there any other way to find a better model that makes y relies on more than one x, if there is can you write the equation of that model?

2) For the chosen model is there an evidence of multicolinearity? What can make it appear?

3) Also for the chosen model, analysis the residuals and comment on the results? If you (cannot draw the histogram analysis what you can).

4) Again for the chosen model, calculate the Axle Statistics weight for a truck with a dynamic weight of 1800 lb traveling 38 miles per hour in a temperature of 21^O with a 4% moister.

Solution

Chegg\'s policy allow me to answer only 1 question, I can gladly help with all your questions but you should post it in a new question

I will help you with the first

1) Is there any other way to find a better model that makes y relies on more than one x, if there is can you write the equation of that model?

There is no way to find a better model for this regression because \"y\" only depends that the x\'s and you need to use a tool of excel to solve a multiple regression thats the only way for a good model