ORDERS VS. SHIPMENTS CUSTOMERS IN PASTE MONTHS Customer # S Purchases MONTHLY SALES {a} 468 Size # Ordered 3 Received Extra Small 30 23 Small 50 54

1. Use the regression line formula to forecast how much a customer might spend on merchandise if that customer visited the store 13 times in a 6 month period. Consider the average monthly sales of 2014, $1310, as your base to:

• Calculate indices for each month for the next two years. 
• Graph a time series plot.

ORDERS VS. SHIPMENTS CUSTOMERS IN PASTE MONTHS Customer # S Purchases MONTHLY SALES {a} 468 Size # Ordered 3 ReceivedExtra Small 30 23Small 50 54Medium 85 92Large 95 91Extra Large 60 632X Large 45 42 Month 5 Sales Jan 1325Feb 1319Mar 1222Apr 1328M ay 1493.10 n 1492Jul 1489Aug 1354Sep 1530Oct 1483Nov 1450Dec 1495Jan 1545Feb 1454M ar 1322Apr 1492M ay 1528Jun 1545Jul 1580Aug 1493Sep 1219Oct 15?3N EN 1529Dec 1580 mmwwmwéwwewmmm