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:

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman