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.

File Home Insert Page Layout Formulas Data Review View Help A % Conditional Formatting * O Format as Table Clipboard Font Alignment Number Cells Editing Ideas Cell Styles Styles Ideas C16 X Y fx A B C D E F 1 Fawn count Adult Count Annual Rain in Inches Winter Severity Winter Severity Index 2 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 5 2.29999995 8.5 12.30000019 4 = Freeze 3.20000005 9.6 12.60000038 5 = Severe 1.89999998 6.80000019 10.60000038 CO 3.4000001 9.69999981 14. 10000038 9 2.09999991 7.9000001 11. 19999981 10 2.99999995 8.7555559 12.34444319 11 3.49999995 10.6999998 14.20000038 12