This discussion allows you to discuss and apply the linear trend model for forecasting total house sales in the United States.
This discussion allows you to discuss and apply the linear trend model for forecasting total house sales in the United States.
Instructions
Download Download Downloadthe data on annual historical total houses sold (THS) in the U.S. and its regions. Select a region you are interested in and get the last 20 years of data.
To prepare for the discussion, undertake the analysis on the given points:
By using a bivariate regression trend line model, forecast total houses sold for the next five years.
Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years.
Post the results of your statistical analysis and the graph with your response to the following:
Do you think the model looks as though it will provide reasonably accurate forecasts for a five-year horizon? Explain your answer.
HINTS:
The data set in the discussion includes multiple spreadsheets. You will need to use the data on the first spreadsheet (Sol Ann). Choose a region from this spreadsheet and extract 20 years of house sales data (1996-2016). Next, use a linear trend model to forecast the next five years.
I have also created a video demonstrating the use of a linear trend model with Texas population data. Please watch the video, and if you have any questions, please let me know.
Linear Trend Model with Texas Population DataLinks to an external site.
Refer to the given video if you do not know how to estimate data with a trend line in Excel.
Corman, L. (2010, September 28). Trend lines and regression analysis in excel
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
