Group Graded Assignment 3 Instructions
Complete the Assignment, name it as GroupXX_Assign3.xls (where XX is your Group
Number), and upload and submit to the instructor through Vista, using the link named “Group
Graded Assignment 3.” Do not enter anything in the spreadsheet cells that are black, labeled
“Grader”.
You must complete this assignment without the assistance of persons other than the members of
your GA (Graded Assignment) Group. You may use any other resources you deem necessary.
Answer the questions below by placing the appropriate graph and/or answers in the designated
cells of the spreadsheet.
DO NOT CHANGE THE APPEARANCE, FORMATTING, OR FUNCTIONALITY OF
THE SPREADSHEET UNLESS INSTRUCTED TO DO SO.
Information for Questions 1-3:
The Instant paper Clip Company sells and delivers office supplies to various companies, schools, and
agencies within a 30-mile radius of its warehouse. The office supply business is extremely competitive,
and the ability to deliver orders promptly is an important factor in customer relations. The manager of the
company wants to be certain that enough drivers and delivery vehicles are available so that orders can be
delivered promptly. Therefore, the manager wants to be able to forecast the number of orders that will
occur during the next month (i.e., to forecast the demand for deliveries).
From records of delivery orders the manager has accumulated data for the past 10 months. These
data are shown in the worksheets named MA and ES. The manager wants your help in fitting different
