Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. 11-14 highland automotive wishes to forecast the n

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next...

90.2K

Verified Solution

Question

Statistics

11-14 Highland Automotive wishes to forecast the number

of new cars that will be sold next week. The following

table summarizes the number of new cars sold

during each of the past 12 weeks: (PLEASE ANSWER BY USINGEXCEL)

weeknumber sold
122
226
323
427
521
625
728
826
929
1029
1127
1231

(a) Provide a forecast by using a 3-week weighted

moving average technique with weights 5, 3, and

1 (5 = most recent).

(b) Forecast sales by using an exponential smoothing

model with a = 0.45.

(c) Highland would like to forecast sales by using

linear trend analysis. What is the linear equation

that best fits the data?

(d) Which of the methods analyzed here would you

use? Explain your answer.

Answer & Explanation Solved by verified expert
3.6 Ratings (343 Votes)
aFormula under each cellbFormula of the above excel calcc Performed the regression    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Propose a nucleophilic aromatic substitution mechanisms for the reactions of a) 2,4-dinitrochlorobenzene + sodium methoxide b) 2,4-dimethylchlorobenzene +...

Chemistry
Q

QUESTIONS TO ANSWER: 1-What is the role of the silica gel beads in the reaction setup? 2-What is...

Chemistry
Q

1.Explain what kind of temperament you had as an infant? 2.How did it effect your relationship...

Psychology
Q

2 An unpolarised beam of light is incident on a group of four polarising sheets...

Physics
Q

Ajob order cost sheet for Ryan Company is...

Accounting
Q

Sam, Dean, Bobby and Cass are the shareholders of a C-corporation named Winchester 4'Ever, Inc....

Accounting
Q

I cant figure out the Applied Overhead please help thank you! ...

Accounting
Q

According to these data, what will be the present value (TV) of alternative B? ...

Accounting
Q

FULL YEARS / PARTIAL YEARS AMT. TO COMPLETE RECOVERY IN NET YEAR, INITIAL INVESTMENT, RESIDUAL...

Accounting
Q

A skilled carpenter installed a roof on a new administrative building for a private not-for-profit...

Accounting
Q

Required information Skip to question [The following information applies to the questions displayed...

Accounting
Q

Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company...

Accounting