statistics help?
How would I set up a problem like this?
Favorite Answer
A easy, no thought way to get the solution is to open up Excel and in the A column put in the year and in column B you have the population in millions. In some other cell use the FORECAST Function
=FORECAST( 2010, B2:B7, A2:A7)
this uses a linear regression model to predict future values based on know y and x values. the result is 59 million.
To do this by hand look up simple linear regression.
The easiest way to do this is list the values in a column in Excel, highlight all of them, and then drag the formula cross (in the bottom right corner of the cells you highlighted) down one more cell. You can only do this if the x values progress evenly (here, the years go by tens).
If you actually want to calculate the fitted line yourself, you can do that — it’s a little bit of a pain:
If x is the year, and y is population, the slope of the fitted line will be b = Cov(x,y)/Var(x) and the intercept can be calculated by taking y bar minus b*x bar (bar means the mean of the sample x’s or y’s). Then the equation is y=bx+a.
By the way, the answer is 59 million.
Charts in either Word or Excel would work fine
- Academic Writing
- Accounting
- Anthropology
- Article
- Blog
- Business
- Career
- Case Study
- Critical Thinking
- Culture
- Dissertation
- Education
- Education Questions
- Essay Tips
- Essay Writing
- Finance
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Health
- History
- Human Resources
- Law
- Literature
- Management
- Marketing
- Nursing
- other
- Politics
- Problem Solving
- Psychology
- Report
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles