Purchase Solution

Linear Trend Forecasts in Excel

Not what you're looking for?

Ask Custom Question

The Dean of the business college at Strayer University wants to forecast the number of students who will enroll in business courses at the Charleston SC campus. Historically the enrollments have been:

Year Students
1 400
2 450
3 380
4 425
5 500
6 555
7 495
8 610

a. Compute a linear trend forecast for the next 5 years.
b. Is the trend seasonal or not?

Purchase this Solution
Solution Summary

This solution provides calculations for linear trend forecasts in Excel.

Purchase this Solution
Free BrainMass Quizzes
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.

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

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

View More Free Quizzes
Related BrainMass Solutions

  • Time Series Analysis of US Online Advertising Spending

    (c) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time-series. (d) Which trend model do you think is best to make forecasts for the next 3 years? Why?

  • Forecasting Corporate Triple A Bond

    Does a linear trend appear? b. Develop the equation for the linear trend component for the time series. c. Use the linear trend developed in part (b) to prepare a forecast for sales in year 8. Please help in excel format.

  • Exponential smoothing forecast

    Compare the three forecasts using MAD and average error (E) and indicate which forecast seems to be most accurate ** See the attached EXCEL file for more details. ** Thanks!!

  • Sales Records for Fastgro Fertilizer Company

    Compute the three forecasts, using MAD and average error, and indicate which seems to be most accurate. Hello Please find the solution in the attached excel file.

  • Forecasting

    If the exponential smoothing forecast model does not appear to be accurate, determine whether a linear trend model would provide a more accurate forecast. See attachments (Excel and Word) for explanations.

  • Forecasting problem:Cool-Man air conditioners

    116763 Forecasting problem using Excel modules addin 11-19 Sales of Cool-Man air conditioners have grown steadily during the past five years, as shown in the following table.

  • Management Science: Forecasting

    A step by step explanation of exponentially smoothed, adjusted exponentially smoothed, linear trend line, and moving average forecasts, using real examples.

  • Forecasting Personal Computers and Printers Sold

    Develop a linear trend line forecast to forecast printer demand in year 11. b. Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. c.

  • Regression and Linear Trend Equations

    Calculations are done in Excel. 1.

View More Related Solutions