How long did it take for the car to stop from the moment

Assignment Help Applied Statistics

Reference no: EM13767951

The following data shows the position (x), the speed (v), and the deceleration (v²) of a car from the moment that driver hit the break until the moment that the car came to a stop.

Required:

Please utilize an Excel spreadsheet to find the trend of deceleration versus distance, and the parameters involved. Show your Excel formulation (using Excel Statistics functions) to find the parameters and trend of this deceleration.
1. Hint: Please plot Deceleration versus Distance, i.e., v²-values [ on the y-axis] and x-values [on the x-axis] to find the best fit linear equation: and notice this is the deceleration equation between the driver hitting the break until the moment that the car comes to a stop. Note that 2a is the slope of deceleration line, which is called the deceleration rate. The v_i²in this equation is the y-axis intercept at x=0 that is given in your trend equation, when you fit a linear trend to your data in Excel.
How long did it take for the car to stop from the moment the driver hit the break?

Hint: Please notice the driver hit the break at an initial position assumed to be x=0.0 meter and with an initial speed ofv_i = unknown at that position (i.e., at x=0.0, v_i =?). The car then went through this deceleration process until it came to stop. The data is only given to you from the position of x=2 meters, and not from the initial position of x=0.0 meter. So, you can find these values through the trend and parameters that you will find in Excel. For example, you should be able to show the initial speed when the driver hit the break, the decelerating rate (slope), and etc.
To find the time it took from x=0 to x=10 meters for the car to stop: you need to think that at x=10 the deceleration is still the same as the slope of your trend line, which is also the same as distance travelled divided by the square of time it took to travel this distance. Therefore, by equating these two, the time it took from x=0 to x=10 meters can be calculated, i.e., 10/S²is = to the deceleration slope of the trend to find time, S.

Reference no: EM13767951

Questions Cloud

Research a case that involves alter-ego liability : Research a case that involves alter-ego liability. In 250 words, define the term "alter-ego" and list the elements the court considered when determining whether to pierce the corporate shield. Incorporate the material from the text and support y..

What is the size of the quality spread differential : Firm A and Firm B need to raise $100,000,000 of debt to pay for their projected capital expenditures. Firm A is a blue chip company with a high credit rating in the corporate debt market. It can borrow funds at either 10.75% fixed rate or at LIBOR + ..

Do you think socrates was an atheist : Do you think Socrates was an atheist, as he was charged in court? Why or why not? What is wrong with atheism anyway? Socrates gives several arguments about death not being something that he fears.

Pharmacological companies problem issues : Why don't they want to spend money on making sick people well?

How long did it take for the car to stop from the moment : The following data shows the position (x), the speed (v), and the deceleration (v2) of a car from the moment that driver hit the break until the moment that the car came to a stop. Required: Please utilize an Excel spreadsheet to find the trend of de..

Assume that the yield to maturity remains constant : A bond has a $1,000 par value, 7 years to maturity, and a 9% annual coupon and sells for $1,095. What is its yield to maturity (YTM)? Assume that the yield to maturity remains constant for the next 4 years. What will the price be 4 years from today? ..

Summary of the jurisdiction : A summary of the jurisdiction (i.e., city, county, or state) and the portion of the criminal justice system your proposal is designed to address

Annual dividend divided by the current stock price : Next year's annual dividend divided by the current stock price is called the:

Discuss how the philosophy of economist milton friedman : Discuss the legal and ethical issues surrounding Solyndra, the California based solar panel manufacturer. You will need to research the company through the University library.

User Account

All Pages