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

Approximately what percentage of the variation for Fawn Count is accounted for by these 3 variables in this model?

See Attached Excel for Data.

AutoSave OFF A FC ... Deer data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 A A = 2 7 V ab v General Insert x Delete v Paste BIUVV $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Filter Select Data F1 X V fx Winter Severity Index E F G H J K L M N O P Q R S |Fawn count Adult Count Annual Rain in Inches Winter Severity Winter Severity Index 2.9000001 9. 19999981 13. 19999981 1 = Warm 2.4000001 8.6999998 11.5 2 = Milo 7. 19999981 10.80000019 3 = Cold OWN AWN 2.29999995 8.5 12.30000019 4 = Freeze COCO VOS UI AWN 3.20000005 9.6 12.60000038 5 = Severe .89999998 6.80000019 10.60000038 3.4000001 9.69999981 4. 10000038 2.09999991 7.9000001 11.19999981 A C . 10 2.99999995 8.7555559 12.34444319 11 3.49999995 10.6999998 14.20000038 12 13 14 15 16 17 18 19 20 21 36 37 38 39 40 41 42 43 Data + Ready iJ + 100%