statistics/excel

I am in an applied stat class and I need help making a predictive line in excel or by hand, I am not sure how to get it to come out so that I can answer

"what is the expected age of a person who is caught driving 86 mph?"
data is b0=102.33 and i am not sure what b1=.
data set= age 32, 41, 18, 69, 60,
speed = 89, 78, 93,68,71, respectively.
I have found the mean and mode, variance of age, Sx of speed, z-score to find the percentage of drivers who are caught speeding that will drive faster than 75mph. I have also found the covar of age and speed, and have done a t-test of correlation, this is my last part and i have worked on it for days and I know that I am missing something simple. It is due tomorrow so any help is appreciated. Thanks

1. 👍 0
2. 👎 0
3. 👁 80
1. I got 33.48 years. can anyone verify this is correct?

1. 👍 0
2. 👎 0
posted by amy

Similar Questions

1. Validity/Reliability

I have a test that accurately predicts who will learn statistics quickly. My test has a. predictive validity but not reliability b. content validity but not predictive ability c. predictive validity and reliability d. neither

asked by Melissa on October 17, 2007

Suppose that each student in stat. has a 9% chance of missing class on any given day and that student attendance is independent. In a stat. class of 20 students, find the probability that: 1) no student is absent =15.16 2) one

asked by Chris on April 8, 2013
3. Math Help

Suppose that each student in stat. has a 9% chance of missing class on any given day and that student attendance is independent. In a stat. class of 20 students, find the probability that: 1) no student is absent 2) one student is

asked by Chris on April 8, 2013
4. Health

Sometimes a patient needs additional care that his or her regular physician cannot provide. In this instance, the physician can make a referral for a patient to see another physician. What are the three types of referrals? (1

asked by Steve on December 1, 2016
5. Math

For a stat class the mean of the midterm is 75 with a standard deviation of 7. What percentage of students scored between 67 and 83

asked by Chris on December 21, 2015
6. resources for educating young children and diverse

a teacher asks all of the children in the class to watch a football game,and to write a report on the rules of the game.as some of the students in the class are recent immigrants from asia,europe,and africa,which principle of

asked by susue on September 14, 2011
7. Statistics

1. In a certain game, the probability of getting a red outcome is 0.03. Find the probability of getting an outcome that is not red? The answer must be in a decimal. I put 0.97 as the answer ( 1-0.03=0.97) 2. The instructor in a

asked by Lisa on September 29, 2013
8. Public Health

I am writing an essay on OSHA in construction industry and I am to include staffing mix & predictive factors on the Law. Am I right to say staffing mix is how many number of workers are staffed. Predictive factors - falls are

asked by Heather on September 3, 2011
9. Public Health

I am writing an essay on OSHA in construction industry and I am to include staffing mix & predictive factors on the Law. Am I right to say staffing mix is how many number of workers are staffed. Predictive factors - falls are

asked by Heather on September 4, 2011
10. statistics

survey revealed two percent of students did not select stat. for biz. suppose we select a sample of 10 students. -what is the probability that 3 students selected stat. for biz? -how many students would you expect to select

asked by nora on March 8, 2010

More Similar Questions