Results 1 to 3 of 3

Math Help - STATS (regression...)

  1. #1
    Newbie
    Joined
    Nov 2012
    From
    Georgia
    Posts
    3

    Post 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).
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    4,186
    Thanks
    772

    Re: STATS (regression...)

    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.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Nov 2012
    From
    Georgia
    Posts
    3

    Re: STATS (regression...)

    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).
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Ncaaf multiple regression/ stepwise regression
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: August 10th 2011, 07:21 AM
  2. Need help with stats (3)!
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: September 15th 2010, 03:11 PM
  3. Need Help With Stats (2)!
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: September 15th 2010, 06:20 AM
  4. Regression SS in multiple linear regression
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: June 20th 2009, 01:23 PM
  5. stats-
    Posted in the Statistics Forum
    Replies: 2
    Last Post: February 10th 2008, 04:14 PM

Search Tags


/mathhelpforum @mathhelpforum