Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the hand, T-84 and excel calculations and formula. Consider the question: A recent study found that the age of cars on road in
I need the hand, T-84 and excel calculations and formula.
Consider the question: A recent study found that the age of cars on road in 2013 is normally distributed with an average age of 8.3 years and a standard deviation of 2.4 years. Find the age that defines the top 2% of oldest cars on the road. 2% 8.3 By hand: To find the answer by hand we look in the field of our table for the proportion .98, or as close as we can get to it. Then find the z-score matching that proportion. Using our z- score formula we can solve for the requested value. By Hand:Using the TI - 84: To find the answer with the TI - 84 use the invNorm function found in distribution menu (DISTRJ. It should look like "invNorm(area left, mean,stdev)" TI - 84: With Excel: To find the answer with Excel we will use the "NORMINV" command. This tool asks for the probability on the left of the graph (.98), the mean (8.3), and the standard deviation (2.4). It should look like "=NORMINV(probability,mean, stdev)" ExcelStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started