four-seat hybrid Correlation
Size Significant?* Strength
*Yes = significantly different from zero at 95% level of confidence. Error means no
variance or some other data error.
3. Perform the proper analyses to identify the salient demographic, belief, and/or attitude
factors that are related to preferences for each of the five different hybrid models under
consideration. With each hybrid automobile model, prepare a summary that:
a. Lists the statistically significant independent variables (use 95% level of confidence).
b. Interprets the direction of the relationship of each statistically significant independent
variable with respect to the preference for the hybrid model concerned.
c. Assesses the strength of the statistically significant independent variables as they join
to predict the preferences for the hybrid model concerned.
The textbook notes that there are some variables that are recoded, and the new dataset is
“AAConcepts.Recoded.xlsm. Specifically, the following variables are recoded with
midpoints—size of hometown or city, age, education, and income. This procedure
Because of the constraint in Excel with regards to the maximum number of independent
variables, a recommended approach is to do the multiple regression analyses in blocks: