Purchase Solution

Regression and Linear Trend Equations

Not what you're looking for?

Ask Custom Question

1. I would like to a use the regression equation: Y'= a + bX Please present the calculations and results and ANOVA
Graphs using a scatter diagram
Compute a moving average.
2. Determine a linear trend equation.
3. Compute a trend equation for a nonlinear trend.
4. Use a trend equation to forecast future time periods and to develop seasonally adjusted forecasts.
5. Make all possible observations and interpret the result
Prices Earning Billons
2.71 9.92
2.71 9.99
2.72 10
2.72 10.1
2.73 10.2
2.73 10.9
2.74 11.2
2.74 11.5
2.75 11.9
2.76 12.1
2.77 12.2
2.77 12.3
2.78 13.3
2.79 14.2
2.81 15.7
2.82 16.4
2.86 16.8
2.89 17.3
2.99 18.2
3.79 22

Purchase this Solution
Solution Summary

This solution discusses regression and linear trend equations. Calculations for results and ANOVA are determined.

Solution Preview

Please see the attachments.
Calculations are done in Excel.

1. I would like to a Use the regression equation: Y'= a + bX Please present the calculations and results and ANOVA
The general form of simple linear regression is Y= a + bX Where Y is the dependent variable and X is the independent variable. a and be are known as the regression coefficients .They are estimated by the method of least squares. The estimates of a and b are given by
,
The parameter b measures the impact of unit change in X on the dependent variable Y. It is the slope of the regression line. The parameter a is the value of Y when X=0. It is known as the Intercept term
The regression equation can be used to predict the value of Y for a given X. The predicted value of Y is given by

The correlation is given by the formula

The square of correlation between X and Y is known as the coefficient of determination (R2) . R2 gives the percentage of variation that can be predicated using the regression equation.
Time Prices: X Earning Billons ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Regression analysis for movie data set.

    Based on your interpretation of your trend line outcomes, do a data transformation of the variables and regression. ? Write out the regression equations for the linear and transformed models. ?

  • Regression Model to Predict Accounts Receivable

    Dear Student, I have created the charts, trend lines and regression equations for you and explained how you can create them in the future.

  • Linear Regression, Trends and Forecasting

    236408 Linear Regression, Trends and Forecasting The amounts spent in vending machines in the united states, in billions of dollars, for the years 1999 through 2003 are given below.

  • Excel Problem

    For this problem, I have to do all the steps but I have to do it not just for the linear trend but also estimate the quadratic, exponential and auto-regressive. There are specific equations for those equations.

  • Why is the trend commonly thought to be the most important c

    The linear trend method is related to linear regression because forecasting itself is linear regression with time as the predictor variable. Why are simple moving averages and weighted averages commonly used forms of forecasting?

  • Time Series Analysis of US Online Advertising Spending

    This solution provides calculations and graphs in Excel for regression analysis.

  • Linear long-term trend.

    If the long-term trend is linear, the least squares linear regression analysis will very closely follow the trend line. So the linear regression line can be used to extrapolate values to make future predictions just like the trend analysis line.

  • Three Statistics Questions: Radio Station, Mean Annual Temperature, and Seventh Grade Homeroom

    Find out the mean annual temperature, and do a linear regression for the years of 1900- 2000, and also for the years of 1945 to 1970. Do these equations show the same trend?

  • Advantages of Linear Regression in Complex Situations

    330240 Advantages of Linear Regression in Complex Situations How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations? Linear regression estimates the line of best fit for any given data.

View More Related Solutions