Question: In this example we will fit a trend line to a time series data set given the value of the slope of the trend line

In this example we will fit a trend line to a time series data set given the value of the slope of the trend line and its intercept. Figure 9.17 illustrates the manual calculation of the trend line using basic Excel formulae.

1 Example 911 2 3 7 8 9 10 11 12 13 14 16 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Perod 1 2 3 4

1 Example 911 2 3 7 8 9 10 11 12 13 14 16 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Perod 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 NATHENSAR Series 1 8 25 15 22 15 30 27 20 27 32 30 36 39 35 55 38 43 55 54 56 49 46 58 60 59 62 65 60 58 62 la Trend 16 17 19 21 22 24 26 28 30 31 33 35 37 39 40 42 44 46 48 49 51 53 55 57 58 60 62 64 66 67 Formulae -SH$3+5H54*34 -SH$3+SH54 B33 F 165 br 13.306 1.802 Figure 9.17

Step by Step Solution

★★★★★

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Figure 917 indicates that we have put the value of the intercept in the cell ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!

Repeat Example 9.11, but this time use the Excel function INTERCEPT() and SLOPE() to calculate these values in Cells H3 and H4. Figure 9.19 illustrates the change to cells H3 and H4 in the Excel...

Use the Excel TREND() function to fit a trend line to the Example 8.1 data set, as illustrated in Figure 8.20. Data from Example 8.1 A large manufacturing firm with some 8000 employees has designed a...

In this example we will show how to use all the formulae listed in this chapter and we will demonstrate how to use the Data Analysis > Exponential Smoothing to undertake the analysis. Figures 9.40...

Question 1 The table below shows the mual expenditures of company LTD on salaries (in R100 00) for each semester of a four-year period. 2002 140.3 160.6 2003 139.6 158.2 2004 141.4 163.8 2004 141.4...

Consider the monthly sales data for the following questions. You may need to use Paste Special > text to copy properly into Excel. Time, t Price = Yt 1 5.80 2 5.87 3 5.79 4 5.96 5 5.96 6 6.51 7 6.41...

ANY STATUS ON THIS QUESTION. Professor Derek, also CEO of Body Gear, has decided that the appropriate forecasting model for the sales of the Signature Boxer Briefs is the Winters Model (with trend...

Professor Didia, also CEO of Brooklyn Bodygear, has decided that the appropriate forecasting model for the sales of the Signature Boxer Briefs is the Winter's Model ( with trend and seasonality ) ....

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

Complete the following Carolina Biological Lab: Kinematics. Please read the Distance Learning Lab Safety Agreement. By taking part in these labs, you agree to the terms in the Distance Learning...

1. What are at lest two diagnostic checks you should apply to a Box-Jenkins model to determine its reliability (excluding error measures such as MSE, RMSE, etc.)? (Points : 3) t-test of the...

An investment manager collected historical data of the market over the past 5 years and summarised the results in the table below. He is going to make some investment decision base on the following...

What is a limited liability company?

The result of a SELECT statement is a table form file report

Explain why the MAP classification is impractical to apply directly for any interesting real-world data mining application.

Annual maintenance costs for a particular section of highway pavement are $2000. The placement of a new surface would reduce the almual maintenance cost to $500 per year for the first 5 years and to...

An investor is considering buying a 20-year corporate bond. The bond has a face value of $1000 and pays 6% interest per year in two semiannual payments. Thus the purchaser of the bond will receive...

A road building contractor has received a major highway construction contract that will require 50,000 m3 of crushed stone each year for 5 years. The needed stone can be obtained from a quarry for...

Qu es un balance "clasificado"? Un balance que clasifique su cierre de ejercicio como 31/12. Un balance que solo muestra los activos totales. Un balance que separa activos y pasivos en secciones...

Ravsten Company uses a job-order costing system. On January 1, the beginning of the current year, the company's inventory balances were as follows The company applies overhead cost to jobs on the...

Which of the following is not normally viewed as an adjustment to the principal of an estate? Multiple Choice Insurance expenses. Debts incurred prior to death. Dividends declared prior to death....