Regression Model Results in Excel

Nov 2015
11
0
California
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:OccupationDance Type
Intercept21.12659Actor1.394297ChaCha3.911159
Age-0.03352Athlete2.061311Paso Doble4.625676
Game Show Host1.844876Ramba4.021202
Model8.414567Samba4.232011
Sum of Error:Other0.457678Waltz4.338115
10766.6Reality TV Star5.0288
Singer
1.92674
 

chiro

MHF Helper
Sep 2012
6,608
1,263
Australia
Hey GabbyA.

What was the regression model you fit and its details?
 
Feb 2014
1,748
651
United States
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?