Marketing Research- Linear Regression-Standardized Regression-Excel Regression Analysis

Use the data listed below (car ratings and purchase decision) to perform a regression model and interpret the result.

 

Value Exterior Interior Comfort Performance Reliability Buy
3 3 3 3 5 4 0
1 2 2 2 2 2 0
3 5 4 4 4 5 1
1 4 5 5 1 3 0
3 5 5 3 5 1 0
5 5 5 5 5 5 1
4 4 3 4 5 4 1
4 2 2 5 3 5 0
1 1 3 4 4 1 0
4 1 4 4 4 4 1
3 2 4 3 4 4 0
4 4 4 5 2 3 1
4 5 5 4 5 4 1
3 4 5 2 4 3 0
4 5 5 3 4 4 1
5 3 5 5 4 5 1
4 2 4 3 3 3 1
3 4 2 4 4 4 0
1 4 3 3 3 5 0
5 4 5 2 2 3 1
2 2 2 2 3 3 0
4 3 5 4 5 4 1
5 5 5 5 5 4 1
5 5 5 5 4 5 1
1 2 3 1 1 1 0
5 5 4 5 5 5 1
4 4 5 4 4 3 1
5 5 5 3 3 4 1
3 3 5 3 5 3 1