Question: Estimate a quadratic AVC function.Present the estimated equation and provide the regression results:

This is the data that I have in excel, but I am not sure which to use to come up with this function:

Column 1:

Monthly Production of finished product=Q

875

670

1675

1155

1845

1650

1955

2845

2265

3470

3665

3750

4595

4060

3575

4380

5575

7870

6750

Column 2:

TVC=Materials, Energy, and Wages

29170

20810

52285

35750

55300

50530

62750

90000

68995

108500

115540

129050

151900

132090

112000

137580

218500

325500

269350

Column 3:

AVC=TVC/Q

33.337

31.060

31.394

30.952

29.973

30.624

32.097

31.634

30.461

31.268

31.525

34.413

33.058

32.534

31.329

31.411

39.193

41.360

39.904