Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. the worldwide sales of cars from 1981-1990 are sho

The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α =...

Free

70.2K

Verified Solution

Question

Statistics

The worldwide sales of cars from 1981-1990 are shown in thetable below. Given: α = 0.2 and β = 0.15 (Hint: Use XLMiner) YearUnits sold in thousands 1981 888 1982 900 1983 1000 1984 1200 19851100 1986 1300 1987 1250 1988 1150 1989 1100 1990 1200 Using thedouble exponential smoothing, find the value of the root meansquare error for the given data.

Answer & Explanation Solved by verified expert
4.1 Ratings (646 Votes)

The value of the root mean square error is 159.2935.

Alpha 0.2
Beta 0.15
Data Forecasts and Error Analysis
Period Demand Smoothed Forecast, Ft Smoothed Trend, Tt Forecast Including Trend, FITt Error Absolute Squared Abs Pct Err
Period 1 888 888 888 0 0 0 00.00%
Period 2 900 888 1.71E-14 888 12 12 144 01.33%
Period 3 1000 890.4 109.6 109.6 12012.16 10.96%
Period 4 1200 912.32 287.68 287.68 82759.78 23.97%
Period 5 1100 969.856 130.144 130.144 16937.46 11.83%
Period 6 1300 995.8848 304.1152 304.1152 92486.05 23.39%
Period 7 1250 1056.708 193.2922 193.2922 37361.86 15.46%
Period 8 1150 1095.366 54.63373 54.63373 2984.844 04.75%
Period 9 1100 1106.293 -6.29302 6.293018 39.60207 00.57%
Period 10 1200 1105.034 94.96559 94.96559 9018.463 0.079138
Total 1180.138 1192.724 253744.2 100.19%
Average 118.0138 119.2724 25374.42 10.02%
Bias MAD MSE MAPE
SE 178.0956

Please give me a thumbs-up if this helps you out. Thank you!
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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Exercise 13-60 (LO13-2, LO13-3, LO13-5) Waterbury Insurance Company wants to study the relationship between the amount of...

Medical Sciences
1.2K views

Can I have a detailed explanation of the blood flow through the heart (left oxygenated blood)...

Accounting
1.2K views

Based on your understanding of how chains are managed, would you agree or disagree that an...

Biology
1.2K views

24 Volcanoes have a positive service function by a Replenishing soil with nutrients b Lava...

Physics
1.2K views

A 150W solar PV panel produces 15V and 7A when it is connected to a...

Geometry
1.2K views

10 8 6 4 2 9 6 5 3 6 9 y X 4 6...

Basic Math
1.2K views

A small airplane flies 1120 miles with an average speed of 280 miles per hour....

Accounting
1.2K views

Mastering Payroll 2020 - Section 7 - FEDERAL EMPLOYMENT REPORTING FORMS AND DUE DATES ...

Accounting
1.2K views

Horton Stores exchanged land and cash of $5,600 for similar land. The book value and...

Accounting
1.2K views

The information shown below relating to the ending inventory was taken at lower of cost...

Accounting
1.2K views

Entries for selected corporate transactions Nav-Go Enterprises Inc. produces aeronautical navigation equipment. Nav-Go Enterprises'...

Accounting
1.2K views

correct answer please Which of the following costs are...