Question

In: Statistics and Probability

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 14 288
5 235 10       267 15

313

Y = +  t
  Y16 =
  Y17 =
  Y18 =
  Y19 =
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 Stvalue 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.)

    

  Forecast for period 16 =

    

     

Solutions

Expert Solution

Solution:

a) Y = 192.82 + 7.31t

Y16= 192.82 + 7.31 * 16 = 309.78

Y17= 192.82 + 7.31 * 17 = 317.09

Y18= 192.82 + 7.31 * 18 = 324.4

Y19= 192.82 + 7.31 * 19 = 331.71

Solution B)

Compute the initial trend estimate (Tt) for Period 5 as follows: (Period 4 data – Period 1 data) / 3.

Solution : Forcast for period 16 is 291.08.

(Period 4 data – Period 1 data) / 3 = (222-200)/3 =7.333

Then compute the initial trend-adjusted forecast (TAFt) for Period 5 as follows:

Solution: Period 4 data + initial trend estimate for period 5 = 222 + 7.333 = 229.33

Forcast for period 16 = 312.92

  Y17

=

  Y18

=

  Y19

=


Related Solutions

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...
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...
9) Use the following data to estimate a linear regression equation between y and x. Interpret...
9) Use the following data to estimate a linear regression equation between y and x. Interpret the estimated slope coefficient. Predict y for an x value of 9. Calculate and interpret the model’s R-squared. x y 21 12 17 10 11 8 3 5 13 15
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.
Obtain the general solution of the following equation 4Uxx+12Uxy+9Uyy-9U = 9
Obtain the general solution of the following equation 4Uxx+12Uxy+9Uyy-9U = 9
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...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own initial values for the y-axis intercept (a) and slope parameter (b) before optimizing the model The data for this problem is shown in the table below. Note: changes from the original problem data are highlighted in yellow. DO NOT USE the "brute force" method shown in Example 8 on pages 120-121. DO NOT USE the linear regression function from Excel's ToolPak or the LINEST...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own initial values for the y-axis intercept (a) and slope parameter (b) before optimizing the model The data for this problem is shown in the table below. Note: changes from the original problem data are highlighted in yellow. DO NOT USE the "brute force" method shown in Example 8 on pages 120-121. DO NOT USE the linear regression function from Excel's ToolPak or the LINEST...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT