menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

The Costello Music Company has been in business for five years. During that time, sales of pianos increased from 12 units in the first year to 76 units in the most recent year. Fred Costello, the firm's owner, wants to develop a forecast of piano sales for the coming year. The historical data follow. Year 1 2 3 4 5 Sales 12 28 34 50 76 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the linear trend equation for the time series. What is the average increase in sales that the firm has been realizing per year? c. Forecast sales for years 6 and 7.

BuyFindarrow_forward

STATISTICS F/BUSINESS+ECONOMICS-TE...

13th Edition
Anderson
Publisher: CENGAGE L
ISBN: 9781305881884

Solutions

Chapter
Section
BuyFindarrow_forward

STATISTICS F/BUSINESS+ECONOMICS-TE...

13th Edition
Anderson
Publisher: CENGAGE L
ISBN: 9781305881884
Chapter 17, Problem 48SE
Textbook Problem
6 views

The Costello Music Company has been in business for five years. During that time, sales of pianos increased from 12 units in the first year to 76 units in the most recent year. Fred Costello, the firm's owner, wants to develop a forecast of piano sales for the coming year. The historical data follow.

Year 1 2 3 4 5
Sales 12 28 34 50 76
  1. a. Construct a time series plot. What type of pattern exists in the data?
  2. b. Develop the linear trend equation for the time series. What is the average increase in sales that the firm has been realizing per year?
  3. c. Forecast sales for years 6 and 7.

a.

To determine

Construct the time series plot.

Explain the type of pattern.

Explanation of Solution

Calculation:

It is given that Costello Music Company is in business for five years. In that period, the sales of the piano increased from 12 units in the first year to 76 units in the latest year.

Software procedure:

Step-by-step procedure to draw the time series plot using the MINITAB software:

  • Choose Graph > Time Series Plot...

b.

To determine

Calculate the linear trend equation for data.

Find the average increase in sales per year.

c.

To determine

Calculate the forecast sales of years 6 and 7.

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 17 Solutions

STATISTICS F/BUSINESS+ECONOMICS-TEXT
Show all chapter solutions
add
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - The general fund budget for the state of Kentucky...Ch. 17.4 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Electric power consumption is measured in...Ch. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - The data contained in the DATAfile named CrudeCost...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...

Additional Math Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is inflation and what causes it?

Principles of Economics (MindTap Course List)

Describe marketing uses of branding

MKTG 12:STUDENT ED.-TEXT

PORTFOLIO REQUIRED RETURN Suppose you are the money manager of a 4 million investment fund. The fund consists o...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

What is driver analysis? What role does it play in process value analysis?

Cornerstones of Cost Management (Cornerstones Series)

Use the definition of the derivative to find the slope of the tangent line to the graph of the function f(x) = ...

Applied Calculus for the Managerial, Life, and Social Sciences: A Brief Approach

Evaluate ∫16t3 ln t dt. 4t4 + C 4t3 ln t − 16t3 + C 4t4 − t3 ln t + C 4t4 ln t − t4 + C

Study Guide for Stewart's Single Variable Calculus: Early Transcendentals, 8th

5.5 SKILL BUILDING EXERCISES Using the Quadratic formula In Exercises S-1 through S-6, use the quadratic formul...

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)

Find the slope of the line containing the two points. (2,5),(3,2)

Mathematical Excursions (MindTap Course List)

Find the midpoint of the segment PQ. P(0,5);Q(12,10)

College Algebra (MindTap Course List)

A normal vector to the plane 2x + 3y + 6z =–20 is:

Study Guide for Stewart's Multivariable Calculus, 8th

Fill in each blank: 1F=F

Elementary Technical Mathematics

Evaluate the integral. 69. 131+x2x2dx

Calculus: Early Transcendentals