Question
2.2 New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly indexes
2.2 New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly indexes (seasonal relatives), which are supplied to the dealer by the regional distributor. Month Units sold Jan 640 Feb 648 Mar 630 Apr 761 May 735 Jun 850 Jul 765 Aug 805 Sep 840 Oct 828 Nov 840 Dec 800 a) Capture this data in excel and plot the data. You should take a snapshot of the graph you created and paste it into your assignment. b) Does there seem to be a pattern? Explain. c) What forecasting technique will you suggest for the above data? Justify your answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started