Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter2: Systems Of Linear Equations
Section2.4: Applications
Problem 28EQ
icon
Related questions
Question
100%

please show in excel

Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past
year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety
laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:
DEMAND (UNITS)
4,130
MONTH
January
February
4,230
March
3,930
4,330
4,930
4,630
5,230
4,830
5,330
5,630
6,230
5,930
Аpril
May
June
July
August
September
October
November
December
a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the
general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Month
Forecast
January
February
March
April
May
June
July
August
September
October
November
December
Transcribed Image Text:Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: DEMAND (UNITS) 4,130 MONTH January February 4,230 March 3,930 4,330 4,930 4,630 5,230 4,830 5,330 5,630 6,230 5,930 Аpril May June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December
b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional
units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest
whole number.)
Additional units
Transcribed Image Text:b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.) Additional units
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Knowledge Booster
Matrix Operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College