+ Reply to Thread
Results 1 to 6 of 6

Coaching help - Calculating Slope Estimate , intercept estimate

  1. #1
    Registered User
    Join Date
    04-14-2020
    Location
    London, England
    MS-Off Ver
    Version : 18.2002.1101.0
    Posts
    3

    Question Coaching help - Calculating Slope Estimate , intercept estimate

    Hi. I am having trouble with a problem within my introductory statistics course.

    The question asks us when using the data set below to run a regression analysis using variables h_age(x) and w_age(y).
    Annotation 2020-04-14 120259.png

    As a result of running a regression, I see the following data set derived from the regression.
    Annotation 2020-04-14 120853.png

    Now in the question, I am asked to find the slope estimate of the regression and the intercept estimate. It then asks to find the predicted value of variable w_age when h_age = 34, it says you need to use the intercept and slope estimate in the calculation.
    -------------------------------------------------------------------------------------------
    -My question is how do I find the slope estimate and the intercept estimate? -
    -------------------------------------------------------------------------------------------
    Last edited by Pepe Le Mokko; 04-15-2020 at 02:59 AM. Reason: Title

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,640

    Re: Regression: Slope Estimate , intercept estimate and predicted y value based on x value

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

  3. #3
    Registered User
    Join Date
    04-14-2020
    Location
    London, England
    MS-Off Ver
    Version : 18.2002.1101.0
    Posts
    3

    Re: Regression: Slope Estimate , intercept estimate and predicted y value based on x value

    I understand I've updated my post, hopefully it meets standards more.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,479

    Re: Help!: Calculating Slope Estimate , intercept estimate

    Your screenshot indicates that you have already run the regression. The intercept (and various statistics related to the intercept) is directly indicated in the "coefficients" output block (row 17). The slope/coefficient (along with various statistics associated with this coefficient) associated with X variable 1 is also given in this block (row 18).

    The regression utility outputs a lot of different statistics and results. Was your question simply about where to find slope and intercept within the mass of other statistics the regression utility output, or is there something more to your question?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    04-14-2020
    Location
    London, England
    MS-Off Ver
    Version : 18.2002.1101.0
    Posts
    3

    Re: Help!: Calculating Slope Estimate , intercept estimate

    That helps a lot thanks, I think the issue is my understanding of the terminology.
    There was a second part to my question which I had removed :
    "I have to find the predicted value of a w_age when her h_age = 34 (using the rounded estimates of the intercept and slope estimate in my calculation), is there a formula that you know of which I should be using to find this"

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,479

    Re: Calculating Slope Estimate , intercept estimate

    Standard regression equation for linear regression is y=mx+b (w=mh+b). Assuming you are using this as your regression equation, that is how I would calculate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slope and Intercept Functions in Multiple Regression
    By costgeek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 02:22 PM
  2. [SOLVED] Estimate costs using linear regression statistics
    By wellous in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2014, 10:12 AM
  3. Point Estimate
    By smallexcel in forum Excel General
    Replies: 1
    Last Post: 08-12-2012, 03:48 PM
  4. Finding point estimate and interval estimate
    By Codedzero in forum Excel General
    Replies: 1
    Last Post: 10-11-2009, 02:46 PM
  5. Linear regression to estimate demand functions (HELP!)
    By Timmyh16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2006, 11:27 AM
  6. [SOLVED] Linear Regression by set Slope (not intercept)
    By Ben in forum Excel General
    Replies: 5
    Last Post: 05-21-2006, 05:55 AM
  7. Excel Linear Regression by set slope (not intercept)
    By Ben in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2006, 06:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1