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.

Fawn countAdult CountAnnual Rain in InchesWinter SeverityWinter Severity Index2.90000019.1999998113.1999998121 = Warm2.40000018.6999998111.532 = Mild27.1999998110.8000001943 = Cold2.299999958.512.3000001924 = Freeze3.200000059.612.6000003835 = Severe1.899999986.8000001910.6000003853.40000019.6999998114.1000003812.099999917.900000111.1999998132.999999958.755555912.3444431943.4999999510.699999814.200000381