Thread: STATS (regression...)

Hello Guys. I live in non-english speaking country. it's pretty difficult for me to understand some things from this questions. to be honest, the most difficult thing for me was to solve these one with excel.

can you help me out there? helping will mean alot to me.

any amount of help will be appreciated.

here is the questions..

The following (hypothetical) data for a city shows the relationship between the number of days with
NO rain in a year and the number of trac accidents during that year.:

DAYS WITHOUT RAIN	NUMBER OF TRAFFIC ACCIDENTS
5	1008
15	943
30	902
40	804
50	798

In addition, the following (hypothetical) data shows the relationship between a driver's age and the
number of miles they have driven in the previous year:

DAYS WITHOUT RAIN	NUMBER OF TRAFFIC ACCIDENTS
25	35000
30	33000
40	20000
45	19000
55	16000

(a) Use EXCEL to find the equations of the regression lines for both sets of data. Your answer
should include a plot of each regression line AND the equation of each regression line in the form
y = ax + b for appropriate constants a and b.


(b) Find the correlation coefficient, r, for both sets of data and state which data set shows the
stronger correlation.


(c) For the first data set, use the equation of the regression line to predict how many days without
rain (rounded to the nearest whole number) there would be in a year in which there were 875
traffic accidents.


(d) Use EXCEL to fit the data in the second table to an exponential model. Show the graph of the
exponential fit and give the equation.


(e) Use the exponential equation from part (d) to predict how many miles a 50 year old person would
have driven in the previous year (rounded to the nearest mile). In addition, use the exponential
equation from part (d) to predict the age of someone who has driven 25 000 miles in the previous
year (give your answer rounded to one decimal place).

Hey Massacre.

For the regression, try and look at this:

Graphing With Excel - Linear Regression

It also has ways to calculate R^2 and some tips for calculating the exponential model.

Thanks for the link dude..

can you help me with the (e)?
this one

(e) Use the exponential equation from part (d) to predict how many miles a 50 year old person would
have driven in the previous year (rounded to the nearest mile). In addition, use the exponential
equation from part (d) to predict the age of someone who has driven 25 000 miles in the previous
year (give your answer rounded to one decimal place).