Statistical Regression Analysis Excel

Conjoint Analysis,,,,,,,,,, ,,,,,,,,,, Conjoint Analysis is used by marketers to tell which product attributes of a product are most important to a consumer,,,,,,,,,, and to what degree is each important to the consumer.,,,,,,,,,, ,,,,,,,,,, ,,,,,,,,,, ,,,,,,,,,, ,,,,,,Conjoint,,,, ,,,Step 1 - Make a list of product attributes,,,Conjoint is an analysis that provides a marketer with a method to predict how much more or less a consumer will value ,,,, ,,,to be evaluated by consumer.,,,one combination of product attributes over another combination of product attributes.. ",,,, ,,4,0,0,1,0,0,8,,,,, ,,5,0,0,1,1,0,5,We will see below that this has no effect on the accuracy of the Regression output.,,,, ,,6,0,0,1,0,1,2,,,,, ,,7,1,0,0,0,0,7,,,,, ,,8,1,0,0,1,0,5,SUMMARY OUTPUT,,,, ,,9,1,0,0,0,1,3,,,,, ,,10,1,0,1,0,0,9,Regression Statistics,,,, ,,11,1,0,1,1,0,6,Multiple R,"0,933190299009789",,,, ,,12,1,0,1,0,1,5,R Square,"0,870844134165979",,,, ,,13,0,1,0,0,0,10,Adjusted R Square,"0,812136922423243",,,, ,,14,0,1,0,1,0,7,Standard Error,"1,14131916115056",,,, ,,15,0,1,0,0,1,5,Observations,17,,,, ,,16,0,1,1,0,0,9,,,,, ,,17,0,1,1,1,0,7,ANOVA,,,, ,,18,0,1,1,0,1,8,,df,SS,MS,F,Significance F,, ,,,,,,Regression,5,"96,6124727668845","19,3224945533769","14,8336824099591","0,000143010998941218",, ,,,,,,Residual,11,"14,3287037037037","1,30260942760943",,, ,,,,,,Total,16,"110,941176470588",,, ,,,,,,,,,, ,,,,,,Coefficients,Standard Error,t Stat,P-value,Lower 95 ,Upper 95 ,Lower 95.0 ,Upper 95.0 ,,,,,,Intercept,"5,91666666666667","0,807034518347706","7,33136753404333","0,0000148277390818504","4,14039566920714","7,6929376641262","4,14039566920714","7,6929376641262" ,,,,,,Brand B,"1,51388888888889","0,698912394620052","2,16606387373039","0,0531402239131163","-0,0244069189165876