You move out into the country and you notice every Spring there are more and more Deer Fawns that appear. You decide to try and predict how many Fawns there will be for the up coming Spring.

You collect data to, to help estimate Fawn Count for the upcoming Spring season. You collect data on over the past 10 years.

x1 = Adult Deer Count

x2 = Annual Rain in Inches

x3 = Winter Severity

• Where Winter Severity Index:
  • 1 = Warm
  • 2 = Mild
  • 3 = Cold
  • 4 = Freeze
  • 5 = Severe

Find the estimated regression equation which can be used to estimate Fawn Count when using these 3 variables are predictor variables.

See Attached Excel for Data.

Deer data.xlsx

Fawn count	Adult Count	Annual Rain in Inches	Winter Severity		Winter Severity Index
2.9000001	9.19999981	13.19999981	2		1 = Warm
2.4000001	8.69999981	11.5	3		2 = Mild
2	7.19999981	10.80000019	4		3 = Cold
2.29999995	8.5	12.30000019	2		4 = Freeze
3.20000005	9.6	12.60000038	3		5 = Severe
1.89999998	6.80000019	10.60000038	5
3.4000001	9.69999981	14.10000038	1
2.09999991	7.9000001	11.19999981	3
2.99999995	8.7555559	12.34444319	4
3.49999995	10.6999998	14.20000038	1

A. Fawn Count = -6.4320 + 3.5626(Adult Count) + 4.3813(Annual Rain) + 4.3878(Winter Severity)

B. Fawn Count = 0.8643 + 0.0853(Adult Count) + 0.0908(Annual Rain) + 0.0568(Winter Severity)

C. Fawn Count = -5.5591 + 0.3071(Adult Count) + 0.3978(Annual Rain) + 0.2493(Winter Severity)

D. Fawn Count = 0.9661 + 0.9886(Adult Count) + 0.9774(Annual Rain) + 0.1105(Winter Severity)

along with explanation please provide A,B,C,D answer thank you.