# Regression Model Results in Excel

#### GabbyA

Hi Guys!
Here is the regerssion model results I got from Excel. What are those numbers next to Occupation and Dance type Representative of? What would the formula be to predict the score of a 38 year old Actor dancing the cha cha ?
 Coefficients: Occupation Dance Type Intercept 21.12659 Actor 1.394297 ChaCha 3.911159 Age -0.03352 Athlete 2.061311 Paso Doble 4.625676 Game Show Host 1.844876 Ramba 4.021202 Model 8.414567 Samba 4.232011 Sum of Error: Other 0.457678 Waltz 4.338115 10766.6 Reality TV Star 5.0288 Singer 1.92674

#### chiro

MHF Helper
Hey GabbyA.

What was the regression model you fit and its details?

#### JeffM

Gabby

Chiro is great at this stuff, but he lives on the opposite side of the world so he is probably asleep about now.

I think what he wants to know is the form of the estimating equation. If you used the linear regression package and did not manipulate your variables it is of the form

$\displaystyle y = a_0 + \sum_{i=1}^n a_ix_i.$

Did you use dummy variables for the occupations and dance steps?