The Complete Excel Guide: Beginners to Advanced - Exercise 04

The video tutorial covers exercise four, focusing on multivariant linear regression using the LINEST function in Excel. It explains how to predict umbrella sales based on month and rainfall data, with a coefficient of determination of 0.87. The tutorial also provides tips on using array formulas effectively, ensuring that selecting a larger area than needed is not problematic.

What are the two independent variables used in the multivariant linear regression exercise?

• Rainfall and temperature

• Month and rainfall

• Month and temperature

• Temperature and humidity

Which function is used to predict the number of umbrellas sold?

• FORECAST

• TREND

• SLOPE

• LINEST

For which months are you required to predict umbrella sales?

• Months 10, 11, 12, 13, 14

• Months 11, 12, 13, 14, 15

• Months 12, 13, 14, 15, 16

• Months 13, 14, 15, 16, 17

What is the coefficient of determination achieved in the exercise?

• 0.87

• 0.97

• 0.67

• 0.77

What happens if you select an area too large for the LINEST array formula?

• It automatically adjusts the size

• It fills extra cells with N/A

• It fills extra cells with zeros

• It causes an error