I am stuck on a few questions based on the attached data. (I have this data in a word doc for easy copy/paste also, but this program will not allow me to attach that version)

1. Run a regression and evaluate the results of your regression equation. Specifically discuss algebraic signs of parameters, statistical significance, and goodness of fit.

2.

a.How many modules should be produced (monthly) if world module prices are $62 per module?Forecast the Moore's Tech profit at this output level.

b. How many modules should be produced (monthly) if world module prices are $35 per module?Forecast the profit at this output level.

Cost Items for Moore's Tech. Month Monthly Business Insurance Building Materials Telephone Energy Wage Production Licenses Premiums Lease Expenses Expense Expense of & Fees Payment finished product Nov 16 875 0 3570 9690 945 723 12250 Dec 16 670 0 3570 6700 945 5115 8995 Jan 17 1675 6000 2200 3570 16295 945 12884 23106 Feb 17 1155 3570 11285 945 9240 15225 Mar 17 1845 0 3570 16550 945 14220 24530 Apr 17 1650 0 0 3570 6230 945 12700 21600 May 17 1955 0 0 3570 19626 945 15640 27484 June 17 2845 0 3570 27410 945 22760 39830 July 17 2265 0 2200 3570 20526 945 17244 31225 Aug 17 3470 0 3570 34176 830 25760 48564 Sep 17 3665 0 0 3570 36726 830 28720 50094 Oct 17 3750 0 3570 12576 830 32000 54474 Nov 17 4595 0 0 3570 48226 830 37260 66414 Dec 17 4060 0 3570 41095 830 33155 57840 Jan 18 3575 200 2450 4200 34550 830 27400 50050 Feb 18 4380 4200 41800 830 34460 61320 Mar 18 5575 0 4200 81750 830 54600 82150 Apr 18 7870 0 4200 92360 830 102960 130180 May 18 6750 0 0 4200 89576 830 70000 109774