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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Write Semi-block format 3 paragraph 100-120 words to Mrs. Lauren Peter, Headmaster of Lane Primary School, London, 1 United...

Advance Math
Q

Suppose you are using a multimeter (one designed to measure a range of voltages, currents, and...

Physics
Q

what phylum do the organisms that made these tests belong Apicomplexa Dinoflagellata Bacillariophyta

Biology
Q

Listen Green algae differ from land plants in that many green algae A have plastids...

Biology
Q

219 Charge Q is uniformly distributed on a dielectric rod AB of length 21 The...

Physics
Q

find the domain of each logarithmic function.f(x) = log5 (x+4)f(x) = log5 (x+6)f(x) = log...

Basic Math
Q

Return on Investment, Margin, Turnover Data follow...

Accounting
Q

perpetual inventory using FIFO ...

Accounting
Q

Can someone explain the subparts to understand, Thank you. Your cousin purchased a refrigerator at...

Accounting
Q

The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for...

Accounting
Q

Using activity based costume results in a different total amount of overhead allocated than the...

Accounting
Q

Trial balance and income statement please Prepare journal entries to record...

Accounting