The following table presents the orders of Samson Company for the last 36 months (3...

90.2K

Verified Solution

Question

Accounting

The following table presents the orders of Samson Company for the last 36 months (3 years).

Month

Order Year 1

Order Year 2

Order Year 3

January

450

600

612

February

418

575

668

March

490

580

680

April

451

534

653

May

466

555

674

June

511

604

702

July

522

624

724

August

500

612

716

September

502

633

712

October

523

634

724

November

533

643

735

December

534

676

755

  1. Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel work sheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient and coefficient determination and the forecast of orders for the next 12 months.
  2. Explain how you could make your forecasts results more reliable by incorporating a qualitative research to your quantitative results.

PreviousNext

Answer & Explanation Solved by verified expert
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