Question

In: Economics

a. Obtain the linear trend equation for the following data on new checking accounts at Fair...

a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.)

Period New Accounts Period New Accounts Period New Accounts
1 200 6 239 11 281
2 215 7 246 12 275
3 211 8 250 13 283
4 229 9 256 14 288
5 235 10 267 15 319



b.Use trend-adjusted smoothing with α = .2 and β = .1 to smooth the new account data in part a. What is the forecast for period 16? Compute the initial trend estimate (Tt) for Period 5 as follows: (Period 4 data – Period 1 data) / 3. Then compute the initial trend-adjusted forecast (TAFt) for Period 5 as follows: Period 4 data + Initial trend estimate for Period 5. Then compute all remaining values (including the St value for Period 5) using the textbook formulas or Excel template. (Round the "Trend"values (Tt) to 3 decimal places and all other intermediate forecast values (TAFt and St) to 2 decimal places. Round your final answer to 2 decimal places.)


Solutions

Expert Solution

a.

Linear trendline equation:

y = a+bx

where, a is the intercept, x = time period, b is the slope and y is the new period

Hence, the linear trendline equation :

y = 195.25 + 7.21x

The expected values are :

For, y =

16 == 310.62

17 == 317.83

18 == 325.04

19 == 332.25

b.

Initial trend(Tt) = (Period 4 data - Period 1 data)/3

=(229-200)/3 = 9.667

Initial trena adjusted forecast (TAFt) = Period 4 data + Initial trend estimate for Period 5(St)

TAFt = Tt +St

Calculate all values using:

St = TAFt + 0.2(A-TAFt)

Tt = Tt-1 + 0.1(TAFt - TAFt-1 - Tt-1

Therefore, forecast for period 16 is 361.21


Related Solutions

Problem 3-9 a. Obtain the linear trend equation for the following data on new checking accounts...
Problem 3-9 a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) Period New Accounts Period New Accounts Period New Accounts 1 200 6       231 11 281 2 213 7       244 12 275 3 211 8       250 13 286 4 222 9       254...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
1. Obtain a linear regression equation for the data to predict the mean temperature values for...
1. Obtain a linear regression equation for the data to predict the mean temperature values for any given CO2 level. How good is the linear fit for this data? Explain using residual plot and R-square value. To draw residual plot, compute the estimated temperatures for every value of the CO2 level using the regression equation. Then compute the difference between observed (y) and estimated temperature values (called residual; ). Plot the residuals versus CO2 level (called a residual plot). 320.09...
The monthly linear trend equation for the Hoopes ABC Beverage Store is:
The monthly linear trend equation for the Hoopes ABC Beverage Store is: ŷ = 5.50 + 1.25t The equation is based on 4 years of monthly data and is reported in thousands of dollars. The index for January is 105.0 and for February it is 98.3. Determine the seasonally adjusted forecast for January and February of the fifth year.
Estimate a linear time trend for the Netflix data using data for the period 2000Q1 ......
Estimate a linear time trend for the Netflix data using data for the period 2000Q1 ... Estimate a linear time trend for the Netflix data using data for the period 2000Q1 to 2008Q4. a. Carry out a preliminary analysis of the data including a line fit plot and interpret your results. b. Test whether the slope is significantly different from zero, using alpha = 0.05. c. Compute S and R2 and interpret the results. d. Compute point forecasts for sales...
Curve-fitting Project - Linear Model Instructions For this assignment, collect data exhibiting a relatively linear trend,...
Curve-fitting Project - Linear Model Instructions For this assignment, collect data exhibiting a relatively linear trend, find the line of best fit, plot the data and the line, interpret the slope, and use the linear equation to make a prediction. Also, find r2 (coefficient of determination) and r (correlation coefficient). Discuss your findings. Your topic may be that is related to sports, your work, a hobby, or something you find interesting. If you choose, you may use the suggestions described...
1) a) Establish schrodinger equation,for a linear harmonic oscillator and solve it to obtain its eigen...
1) a) Establish schrodinger equation,for a linear harmonic oscillator and solve it to obtain its eigen values and eigen functions. b) calculate the probability of finding a simple harmonic oscillator within the classical limits if the oscillator in its normal state.
collect data exhibiting a relatively linear trend, find the line of best fit, plot the data...
collect data exhibiting a relatively linear trend, find the line of best fit, plot the data and the line, interpret the slope, and use the linear equation to make a prediction. Also find r2 (coefficient of determination) and r (correlation coefficient). Discuss your findings. Your topic may be that is related to sports, your work, a hobby, or something you find interesting.
.  Draw a plot of the following set of data and determine the linear regression equation.  What is...
.  Draw a plot of the following set of data and determine the linear regression equation.  What is the      value of the slope and intercept?   What is r and R2?  Are there any outlier values?   (15 points)                                 Age (X):     20  25  36  29  41  35  56  43  66  50  59  67  51  75  75  81  54  66  52  48            Total Body Water (Y):     61  57  52  59  53  58  48  51  37  44  42  41  48  38  41  39  47  42  51  50  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT