STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 15E
a.
To determine
To draw: The graph of the given time series.
b.
To determine
To describe: The time series pattern.
c.
To determine
To explain: The reason that forecasting with a trend model is appropriate for the given time series.
d.
To determine
To calculate: A trend forecasting model using simple linear regression and the MAD.
e.
To determine
To state: The predicted annual change of industry sales.
f.
To determine
To calculate: The sales for the next three years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.
If a household has 3 members, and has an annual income of $100,000, predict this household’s monthly spending.
The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has
found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on
this information if the company contacts 900 potential donors to donate at the $100 level or below
E Click the icon to view the percentages of donors and gift levels.
C.....
3 Philanthropist
$5,000
11
=B3*C3
4 Producer's Circle
$1,000
25
=B4*C4
5 Director's Circle
$500
49
=B5 C5
6 Principal
$100
8%
=B6*C6*$B$9
7 Soloist
$50
14% =B7*C7*SB$9
8.
9 Solicitations
900
10 Total Donations
=SUM(D2:D7)
Enter the values in the model.
(Type integers or decimals. Do not round.)
B
D
Average Number
of Gifts
1 Gift Level
Amount
Donations
2 Benefactor
$10,000
3 Philanthropist
$5,000
11
4 Producer's Circle
$1,000
25
5 Director's Circle
$500
49
6 Principal
$100
8%
ns?
7 Soloist
$50
14%
8.
9…
Chapter 18 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
Knowledge Booster
Similar questions
- If you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forwardAccording to the Bureau of Labor Statistics, there were 27,900 computer and research information scientist jobs available in 2016. It is estimated that the number of jobs in this area will increase by 19% by the year 2026. This is much more than the national average. If this prediction is accurate, which of the following statements gives the exact description of the number of computer and research information scientist jobs available in 2026? A The number of computer and research information scientist jobs will increase by roughly 5,401 in 2026. B The number of computer and research information scientist jobs will be more than 27,900 in 2026. C There will be 33,201 computer and research information scientist jobs available in 2026. D There will be a lot of computer and research information scientist job opportunities in 2026.arrow_forwardBelow we list several variables. Which of these variables are quantitative, and which are qualitative?arrow_forward
- use the given data on the societal cost of crashes and the approximate U.S. population of 325 million to calculate the average social cost per person. U.S. Data (2016 estimates): Car Crash fatalities = 40,200; Car Crash injuries = 4.6 million; cost to society = $430 billion. (source: National Safety Council.) • Global Data (estimated); car crash fatalities = ≈ 50 million; car crash fatalities with victim's underage 45 ≈ 400,000. (Source: Association Safe International Road Travel.) About how often (once every x minutes or x seconds) on average is a person killed in a car crash in the United States? How often is a person injured in a car crash. The answer to this question is about once every 13 minutes; about once every 7 seconds. use the given data on the societal cost of crashes and the approximate U.S. population of 325 million to calculate the average social cost per person. The answer to this is about $1,320 per person. I forgot to put this so the answer can be solved. I…arrow_forwardMorning House is a mail-order firm which carries a wide range of rather expensive art objects for homes and offices. It operate problems would be greatly reduced. Since it takes approximately six weeks to receive 90% of the response to a given campaign, an accurate prediction of total sales made as late as the end of the first week of receiving orders would be useful. The first week’s sales and total sales of the last 12 campaigns of the firm are shown below. Can the first week’s sales be used to predict total sales? First week’s Total Campaign Sales Sales 1 32 167 2 20 91 3 114 560 4 66 335 5 18 70 6 125 650 7 83 401 8 65 320 9 94 470 10 5 15 11 39 210 12 50 265 --------------------------------------------arrow_forwardThe data represent the cost, return on investment, and graduation rate for a random sample of fifty colleges or universities in the United States. The data is from payscale.com. The variable "Cost" represents the four-year cost including tuition, supplies, room and board of attending the school. The variable "Annual ROI" represents the return on investment for graduates of the school. It essentially represents how much you would earn on the investment of attending the school. The variable "Grad Rate" represents the graduation rate of the school. Complete parts (a) and (b) below. Click here to view the school data. Click here to view the table of critical values of the correlation coefficient. (a) Describe the association between Cost and Graduation Rate graphically by drawing a scatter diagram, treating Cost as the explanatory variable. Describe the association between Cost and Graduation Rate by finding the linear correlation between the two variables. Is there a linear association…arrow_forward
- List one possible confounding variable for this analysis and explain what impact it might have on the variables of interest.arrow_forwardA high school guidance counselor analyzed data from a sample of 200 community colleges throughout the United States. One of his goals was to estimate the annual tuition costs of community colleges in the United States. Describe the population and variable of interest to the guidance counselor. Why?arrow_forwardAlthough Social Security is a problem, some projections indicate that there's a much bigger time bomb ticking in the federal budget, and that's Medicare. In 2000, the cost of Social Security was 5.48% of the gross domestic product, increasing by 0.04% of the GDP per year. In 2000, the cost of Medicare was 1.84% of the gross domestic product, increasing by 0.17% of the GDP per year. (Source: Congressional Budget Office) a. Write a function that models the cost of Social Security as a percentage of the GDP x years after 2000. b. Write a function that models the cost of Medicare as a percentage of the GDP x years after 2000. c. In which year will the cost of Medicare and Social Security be the same? For that year, what will be the cost of each program as a percentage of the GDP? Which program will have the greater cost after that year?arrow_forward
- Please solve all the questions belowarrow_forwardResearchers initiated a long-term study of the population of American black bears. One aspect of the study was to develop a model that could be used to predict a bear's weight (since it is not practical to weigh bears in the field). One variable thought to be related to weight is the length of the bear. The accompanying data represent the lengths and weights of 12 American black bears. Complete parts (a) through (d) below. Click the icon to view the data table. Click the icon to view the critical values table. ..... (a) Which variable is the explanatory variable based on the goals of the research? O A. The number of bears B. The weight of the bear O C. The length of the bear (b) Draw a scatter diagram of the data. Choose the correct graph below. O A. O B. O C. D. A Weight (kg) 180- AWeight (kg) 180- ALength (cm) 180- A Weight (kg) 180- 40- 100 40- 100 Length (cm) 40- 100 40- 100 200 200 200 200 Length (cm) Weight (kg) Length (cm) (c) Determine the linear correlation coefficient between…arrow_forwardWhat do the Forecast for each year add up to?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill