Using the sales data given below for ABC corporation, perform a regression to estimate the trend in this data. Write the regression coefficient that estimates the trend. Please attach your excel file with solution.

ABC Data:

Sales Year 1 Year 2 Year 3 Year 4 Year 5

JAN 2000 3000 2000 5000 5000

FEB 3000 4000 5000 4000 2000

MAR 3000 3000 5000 4000 3000

APR 3000 5000 3000 2000 2000

MAY 4000 5000 4000 5000 7000

JUN 6000 8000 6000 7000 6000

JUL 7000 3000 7000 10000 8000

AUG 6000 8000 10000 14000 10000

SEP 10000 12000 15000 16000 20000

OCT 12000 12000 15000 16000 20000

NOV 14000 16000 18000 20000 22000

DEC 8000 10000 8000 12000 8000

Total 78000 89000 98000 115000 113000