   # Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P13_33.xlsx. a. Create a scatterplot for these data. Comment on the observed behavior of monthly sales at this store over time. b. Estimate an appropriate regression equation to explain the variation of monthly sales over the given time period. Interpret the estimated regression coefficients. c. Analyze the estimated equation’s residuals. Do they suggest that the regression equation is adequate? If not, return to part b and revise your equation. Continue to revise the equation until the results are satisfactory. ### Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

#### Solutions

Chapter
Section ### Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
Chapter 13, Problem 33P
Textbook Problem
5 views

## Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P13_33.xlsx. a. Create a scatterplot for these data. Comment on the observed behavior of monthly sales at this store over time. b. Estimate an appropriate regression equation to explain the variation of monthly sales over the given time period. Interpret the estimated regression coefficients. c. Analyze the estimated equation’s residuals. Do they suggest that the regression equation is adequate? If not, return to part b and revise your equation. Continue to revise the equation until the results are satisfactory.

a)

Summary Introduction

To create: A scatterplot for the data.

Introduction: Forecasting is a technique of predicting future events based on historical data and projecting them into the future with a mathematical model. Forecasting may be an intuitive or subjective prediction.

### Explanation of Solution

Data:

Formulae to determine the data:

Scatterplot using StatTools:

Summary graph from the StatTools should be used. Then, the scatterplot should be chosen. The below image shows the scatterplot parameter table from StatTools:

b)

Summary Introduction

To estimate: The regression equation to predict the peak power load.

Introduction: Forecasting is a technique of predicting future events based on historical data and projecting them into the future with a mathematical model. Forecasting may be an intuitive or subjective prediction.

c)

Summary Introduction

To determine: Whether the estimated equation is adequate.

Introduction: Forecasting is a technique of predicting future events based on historical data and projecting them into the future with a mathematical model. Forecasting may be an intuitive or subjective prediction.

### 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 