Extrapolate the time series in Table 9.8 three time periods in the future. Use the TREND function.

Question:

Extrapolate the time series in Table 9.8 three time periods in the future. Use the TREND function. Why do you think it would not make sense to extrapolate this time series 10 time periods in the future?

X Y Table 9.8 1 230 2 300 3 290 4 320 5 350 6 400 7 8 350 400 9 420 10 11 12

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For answer-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

See More Books

Question Posted: Nov 28, 2023 02:40 AM

See More Questions

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
It was 5:30 Friday afternoon, January 22, 2016. Bill Hall, the chairman and CEO of National Brands Inc. was clearing up the last of the papers on his desk and was looking forward to a relaxing...
Find the minimum value of the function: f(x) = x^4 - 6x^2 + 9 on the interval [-2,2].
On January 1, 2010, Housen Company issued 10-year bonds of $500,000 at 102. Interest is payable on January 1 and July 1 at 10%. On April 1, 2011, Housen Company reacquires and retires 50 of its own...
Develop an activity diagram based on the following narrative. Note any ambiguities or questions that you have as you develop the model. If you need to make assumptions, also note them. The purchasing...
Quilts R Us (QRU) is considering investing in a new patterning attachment with the cash flow profile shown in the table below. QRU's MARR is 13.5 percent/year. a. What is the internal rate of return...
John Adams Companys record of transactions for the month of April was as follows. Instructions (a) Assuming that perpetual inventory records are kept in units only, compute the inventory at April 30...
Suppose that farmers have a mandatory demand expansion program where all farmers pay a certain amount to fund a promotion program. You have estimated the following market supply and demand functions...
For what kind of time series would you use a multiplicative versus additive seasonal exponential smoothing model?
Does R 2 = 0.90 indicate a good fit? Why?
Use a calculator to evaluate the function f(x) = x 2 for x = 1, 0.1, 0.01, . . . . , 0.000 000 001. What do these calculations suggest about lim f(x)? x0+
Tim is building a toolshed 30 feet wide and 60 feet long. Heneeds a footer 15 inches wide and 10 inches deep. How many yards(yards means cubic yards) of concrete should he order?
After watching the Documentary film, We were Children by Tim Wolochatiuk, answer the following questions in the journal: Questions: 1. How long were the residential schools in existence? 2. Who ran...
The value of a Bobby Orr rookie card n years after its purchase is V(n)=520+28n. Determine the value of n when V(n)=744. a n=8 b n=10 c n=7 d n=6
8. GERMANY Company prepared a reconciliation between pretax financial income and taxable income at the end of 2022 as follows (see image below). The estimated litigation expense of P1,250,000 will be...
You are promoting media literacy (not any personal or political viewpoint)--you want to discuss the constant news flow that students are bombarded with every day (via social media, word-of-mouth,...
Kirk and Kirk, Ltd. began operations in July 2013 and reported the following results for each of its first 3 years of operations. 2013 ........ $20,000 net income 2014 ........ $640,000 net loss 2015...
As of January 1, 2018, Room Designs, Inc. had a balance of $9,900 in Cash, $3,500 in Common Stock, and $6,400 in Retained Earnings. These were the only accounts with balances in the ledger on January...
A group of 10 public-spirited citizens has agreed that they will support the local school hot lunch program. Each year one of the group is to pay the $15,000 cost that occurs continuously and...
A forklift truck costs $29,000. A company agrees to purchase such a truck with the understanding that it will make a single payment for the balance due in 3 years. The vendor agrees to the deal and...
PARC Company has money to invest in an employee benefit plan, and you have been chosen as the plan's trustee. As an employee yourself, you want to maximize the interest earned on this investment and...
Assume that the typical consumer basket consists of 5 bushels of peaches and 10 bushels of walnuts and that the base year is 2014. What is the consumer price index for 2014? Year peaches pecans 2014...
Airbnb is an online marketplace that allows people to rent out their homes or apartments on a short-term basis.In some areas, regulators have banned the use of Airbnb. What group would you expect to...
The table above shows the usefulness of pens and pencils. If pens and pencils cost $.25 each and the consumer has an income of $2.25, what is the consumer's equilibrium? number of pens Total Pen...

Extrapolate the time series in Table 9.8 three time periods in the future. Use the TREND function.

Question:

X Y Table 9.8 1 230 2 300 3 290 4 320 5 350 6 400 7 8 350 400 9 420 10 11 12

Step by Step Answer:

To extrapolate the time series in Table 98 three time periods into the future using the TREND function we need to use a tool like Microsoft Excel or G...View the full answer

Business Statistics Using Excel

Students also viewed these Business questions