Ask Experts Questions for FREE Help !
Ask
    melissamebane's Avatar
    melissamebane Posts: 2, Reputation: 1
    New Member
     
    #1

    May 29, 2007, 03:02 PM
    Cubic Function/Algebra 2
    Find a cubic function to model the given data. Use 1940 = 0. Use the function to estimate the average monthly Social Security Benefit for a retired worker in 2005.

    Average Monthly Social Security Benefits, 1940-1999

    Year 1940 1950 1960 1970 1980 1990 2000

    Amt in
    dollars 23.71 29.03 81.73 123.82 321.10 550.50 757.71
    galactus's Avatar
    galactus Posts: 2,271, Reputation: 282
    Ultra Member
     
    #2

    May 29, 2007, 03:15 PM
    You can easily use Excel or a good calculator to do a cubic regression and solve this.

    If you have Excel:

    Enter your data into the columns, let column A be for the year and column B for the money.

    Click on INSERT, CHART, xy scatter plot, NEXT

    Highlight your columns and click NEXT. You can then name the chart, axes, etc. Click FINISH.

    Your chart will appear.

    Now, click CHART, ADD TRENDLINE, POLYNOMIAL, use 3 for cubic, click OPTIONS and check

    the boxes which say, DISPLAY EQUATION ON CHART and DISPLAY R^2 VALUE ON CHART.

    click OK and you should be set. Give it a go and let me know how it works out.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Erectile function [ 1 Answers ]

I've read warnings about when using drugs like Viagra that you should seek medical attention in the rare case of erections lasting 4 or more hours. My question is, is there any danger in erections lasting that long or longer, but just as a result of natural, prolonged stimulation and sexual...

Inverse function [ 1 Answers ]

find the inverse of Ln(2x+1)

TV Out Function On [ 0 Answers ]

I've got a DVD drive and the PowerDVD 5.0 player and every time I try to watch a newer DVD, I get the error message "TV out function error", I look at the details and it says I can't play copyright protected DVD's with the TVout function enabled. The weird thing is, ALL my graphics adapters just...


View more questions Search