For the past two years, a department store has carried a new type of electronic calculator. Sales of this calculator have generally been increasing over these two years. They attempt to ensure that their stores will have enough calculators to meet practically all of the demand. The data is provided in the following table. Month January February March April May June July August September October November December Year 1 197 211 203 247 239 269 308 262 258 256 261 288 Year 2 296 276 305 308 356 393 363 386 443 308 358 384 By using Excel or some other statistical package: (a) Find the initial values lo and bo, to fit a straight line to the first half of the data. (b) Set up a spreadsheet to perform Holt's trend corrected exponential smoothing. (c) Find the values of a and y that minimize the SSE (mention which software did you use) (d) Find point forecasts and 95% prediction intervals for January, February, and March of year 3. (e) Right a short report and present your findings with some interpretations. (f) Submit your spreadsheets along with the report.
For the past two years, a department store has carried a new type of electronic calculator. Sales of this calculator have generally been increasing over these two years. They attempt to ensure that their stores will have enough calculators to meet practically all of the demand. The data is provided in the following table. Month January February March April May June July August September October November December Year 1 197 211 203 247 239 269 308 262 258 256 261 288 Year 2 296 276 305 308 356 393 363 386 443 308 358 384 By using Excel or some other statistical package: (a) Find the initial values lo and bo, to fit a straight line to the first half of the data. (b) Set up a spreadsheet to perform Holt's trend corrected exponential smoothing. (c) Find the values of a and y that minimize the SSE (mention which software did you use) (d) Find point forecasts and 95% prediction intervals for January, February, and March of year 3. (e) Right a short report and present your findings with some interpretations. (f) Submit your spreadsheets along with the report.
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter12: Probability
Section12.3: Conditional Probability; Independent Events; Bayes' Theorem
Problem 82E
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1: Provide the given information.
VIEWStep 2: Determine the initial values l0 and b0 to fit a straight line to the first half of the data.
VIEWStep 3: Perform Holt's trend corrected exponential smoothing.
VIEWStep 4: Determine the values of alpha and gamma that minimize the SSE.
VIEWStep 5: Determine point forecasts and 95% prediction intervals for January, February, and March of year 3.
VIEWStep 6: Provide the short note and interpretation for the findings.
VIEWSolution
VIEWStep by step
Solved in 7 steps
Recommended textbooks for you
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning