Purchase Solution

MAPE and MAD

Not what you're looking for?

Ask Custom Question

Senior Management at Esil University believes that decreases in the number of undergraduate applications that they have experienced are directly related to tuition increases. They have collected the following enrollment and tuition fees data for the past decade:
Year: Undergraduate Applications: Annual Tuition Fees(GBP)
1 6,050 3,600
2 4,060 3,600
3 5,200 4,000
4 4,410 4,400
5 4,380 4,500
6 4,160 5,700
7 3,560 6,000
8 2,970 6,000
9 3,280 7,500
10 3,430 8,000
Problem:
a)Develop a linear regression model for these data and forecast the number of applications for Esil University if tuition fees increase to 9000 gbp per year and if tuition fees are lowered to 7000 gbp per year.
b)Determine the strength of the linear relationship between undergraduate applications ad tuition fees by using correlation.
c)Describe the various decisions for Esil University that would be affected by the forecast for undergraduate applications.
d)Develop an exponential smoothing model with a=0.20 for these data to forecast undergraduate applications in year 11 and compare its accuracy to the forecast developed in part a).

Purchase this Solution
Solution Summary

The regression equation is clearly utilized. A linear regression model for MAPE and MAD.

Solution Preview

PART A

The regression equation is
apps = 6542 - 0.449 fees
The prediction you want can be found by plugging 9000 in where the word fees is in the equation. However, regression models are not used to predict trends outside of the data range in most cases...just an FYI.

PART B
Based on the p values below and the R^2 value we can see that this is not a very good model. Usually the p value should be lower and .05 and R^2 should be above 90 (some people say above ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Business Forecasting



    In the Mean Absolute Percent Error (MAPE), we express the absolute magnitude of each forecast error as a percentage of the actual demand and then average the percentages.

  • Forecast Analysis

    Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search.) 2.

  • Measuring Forecast Accuracy

    Lastly, the lower the values of MAD, MSE and MAPE, the more accurate the forecast is. This solution provides a list of the three primary ways of measuring forecast accuracy and explains the differences between them.

  • Forecasting & Inventory Model

    MAPE and MAD are easy to interpret. Mean Squared Error (MSE) MSE = ∑ (At - Ft)2 / T MSE measures error variance.

  • Demand Forecasting: Measuring forecast accuracy and comparing different techniques/algorithms

    In excel, it demonstrates forecast and forecasting error calculations. Two forecasting error/accuracy measures are used, 1) Mean absolute percentage error (MAPE) and 2) Mean absolute deviation (MAD).

  • Exponential Smoothing Forecast, MSE, MAE and MAPE

    What are the results if MAPE is used? Hi there, I've included my explanation in the excel file. Thanks. Tony The solution provides detailed explanation how to calculate MSE, MAD and MAPE.

  • Price Club

    I need assistance in writing a memo SUMMARIZING the findings mentioned above (forecast, mad, sme, mape, mpe).

  • BUSINESS FORECASTING

    I ALSO NEED ASSISTANCE IN EVALUATING THE FORECASTING METHOD USING MAD, MSE, MAPE, MPE AND LASTLY, I NEED TO KNOW HOW TO FORECAST THE MUTUAL FUND FOR JANUARY 2001.

  • Stocks

    Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search). Please refer to the attachment.

View More Related Solutions