MKTG 3P98 Project 2
Yiming Sun, Hamish Nobel, Mathias Castelhano
2024-11-08
Set up working directory
getwd()## [1] "D:/34884/Documents"setwd("D:/34884/Documents")Load packages
library(ggplot2)
library(readxl)
library(stringr)
library(dplyr)##
## 载入程序包：'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(car)## 载入需要的程序包：carData##
## 载入程序包：'car'## The following object is masked from 'package:dplyr':
##
## recodelibrary(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ forcats 1.0.0 ✔ readr 2.1.5
## ✔ lubridate 1.9.3 ✔ tibble 3.2.1
## ✔ purrr 1.0.2 ✔ tidyr 1.3.1## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ✖ car::recode() masks dplyr::recode()
## ✖ purrr::some() masks car::some()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(visreg)Read data file Car_Total
upload data file
Car_Total<-read.csv("Car_Total.csv")see the variable names in the data file
names(Car_Total) ## [1] "Resp" "Att_1"
## [3] "Att_2" "Enj_1"
## [5] "Enj_2" "Perform_1"
## [7] "Perform_2" "Perform_3"
## [9] "WOM_1" "WOM_2"
## [11] "Futu_Pur_1" "Futu_Pur_2"
## [13] "Valu_Percp_1" "Valu_Percp_2"
## [15] "Pur_Proces_1" "Pur_Proces_2"
## [17] "Residence" "Pay_Meth"
## [19] "Insur_Type" "Gender"
## [21] "Age" "Education"
## [23] "Region" "Model"
## [25] "MPG" "Cyl"
## [27] "acc1" "C_cost."
## [29] "H_Cost" "Post.Satis"
## [31] "Make" "Model_v1"
## [33] "Attitude" "Parent"
## [35] "Enjoyment" "Perform"
## [37] "Word_of_Mouth" "Future_Purchase_Intention"
## [39] "Value_Perception" "Purchase_Process"assign the data file into a new dataframe
ct <- Car_Totalsee the new dataframe
head(ct, 50)## Resp Att_1 Att_2 Enj_1 Enj_2 Perform_1 Perform_2 Perform_3 WOM_1 WOM_2
## 1 Res1 6 6 6 6 5 6 3 3 3
## 2 Res10 6 6 4 4 4 4 1 5 6
## 3 Res100 6 7 7 3 5 6 6 3 5
## 4 Res1000 6 6 7 6 6 6 6 6 6
## 5 Res1001 6 6 7 6 6 6 6 4 4
## 6 Res1002 3 1 4 3 5 6 6 2 6
## 7 Res1003 2 2 1 2 2 2 1 6 7
## 8 Res1004 7 7 7 6 5 6 5 6 6
## 9 Res1005 2 1 2 1 2 2 2 7 7
## 10 Res1006 6 6 6 5 5 5 5 3 3
## 11 Res1007 4 4 4 2 3 5 3 7 7
## 12 Res1008 5 5 5 3 3 5 5 5 5
## 13 Res1009 4 4 7 7 7 7 7 7 7
## 14 Res101 6 6 7 6 5 6 3 5 6
## 15 Res1010 7 7 7 4 7 4 4 5 5
## 16 Res1011 7 7 7 2 6 2 5 6 6
## 17 Res1012 6 6 6 6 5 3 4 5 5
## 18 Res1013 4 4 5 1 1 3 4 7 6
## 19 Res1014 5 5 5 4 3 5 5 5 5
## 20 Res1015 4 5 5 5 4 7 5 7 7
## 21 Res1016 6 6 7 7 6 7 6 7 7
## 22 Res1017 6 6 7 5 5 6 5 7 7
## 23 Res1018 4 3 4 2 3 5 4 7 6
## 24 Res1019 6 6 6 5 5 4 4 4 4
## 25 Res102 7 7 7 6 6 6 1 7 7
## 26 Res1020 6 7 6 6 6 5 5 7 7
## 27 Res1021 6 6 6 3 5 6 5 6 6
## 28 Res1022 6 6 6 4 4 7 7 5 5
## 29 Res1023 7 7 6 6 6 5 5 6 6
## 30 Res1024 6 5 4 5 4 6 5 6 7
## 31 Res1025 7 7 7 6 6 6 6 7 7
## 32 Res1026 6 7 7 7 7 6 6 7 7
## 33 Res1027 7 7 7 6 6 7 7 7 7
## 34 Res1028 4 7 7 6 7 6 7 7 6
## 35 Res1029 7 7 7 7 7 7 7 7 7
## 36 Res103 7 7 7 6 6 7 2 6 6
## 37 Res1030 7 7 7 7 7 7 7 7 7
## 38 Res1031 6 6 6 5 5 4 4 6 6
## 39 Res1032 7 6 6 5 6 6 6 7 7
## 40 Res1033 7 6 5 6 6 6 6 7 7
## 41 Res1034 7 7 7 7 7 6 5 7 6
## 42 Res1035 7 7 7 7 7 7 7 7 7
## 43 Res1036 6 5 6 5 5 6 6 7 7
## 44 Res1037 6 7 6 6 7 5 5 5 5
## 45 Res1038 6 5 5 5 5 5 5 5 5
## 46 Res1039 6 6 7 5 5 4 5 5 5
## 47 Res104 7 7 7 7 7 6 6 3 4
## 48 Res1040 5 6 5 6 6 4 4 7 7
## 49 Res1041 4 4 4 3 5 6 6 2 6
## 50 Res1042 5 5 1 2 2 2 1 6 7
## Futu_Pur_1 Futu_Pur_2 Valu_Percp_1 Valu_Percp_2 Pur_Proces_1 Pur_Proces_2
## 1 3 3 5 2 6 4
## 2 6 6 6 6 6 6
## 3 6 6 7 6 5 5
## 4 6 6 4 6 6 3
## 5 4 6 5 6 6 7
## 6 6 6 5 4 5 5
## 7 6 5 4 4 4 5
## 8 6 7 6 5 5 5
## 9 7 7 4 6 6 7
## 10 6 6 5 6 6 5
## 11 5 6 6 2 2 5
## 12 6 6 6 5 6 6
## 13 5 5 5 4 4 3
## 14 4 3 3 2 2 2
## 15 6 5 6 6 6 6
## 16 6 5 5 6 7 7
## 17 4 4 4 4 4 4
## 18 6 6 6 5 4 4
## 19 5 5 4 6 6 6
## 20 5 5 5 3 3 6
## 21 6 5 5 4 5 6
## 22 5 5 5 4 4 4
## 23 6 7 6 6 6 6
## 24 6 6 6 4 5 5
## 25 6 6 6 7 7 7
## 26 7 7 7 3 3 7
## 27 5 6 6 5 5 6
## 28 6 6 6 5 5 6
## 29 5 5 5 5 5 5
## 30 9 5 4 3 3 6
## 31 3 4 6 6 6 6
## 32 6 6 5 4 6 6
## 33 3 2 6 4 3 6
## 34 7 6 6 4 5 4
## 35 6 5 6 6 6 6
## 36 6 7 6 5 6 5
## 37 6 6 6 5 5 6
## 38 7 6 4 6 6 5
## 39 5 5 5 5 5 4
## 40 6 6 4 6 4 5
## 41 4 5 4 5 5 6
## 42 6 3 5 5 5 6
## 43 6 5 5 6 6 6
## 44 5 6 3 7 6 6
## 45 5 6 3 5 6 4
## 46 6 6 6 6 6 6
## 47 4 4 4 2 3 2
## 48 7 7 7 5 6 6
## 49 6 7 4 6 6 3
## 50 6 6 4 4 4 4
## Residence Pay_Meth Insur_Type Gender Age Education Region
## 1 2 2 Collision Male 18 2 European
## 2 1 2 Collision Male 21 2 European
## 3 2 1 Collision Female 32 1 American
## 4 2 3 Liability Female 24 2 Asian
## 5 1 3 Liability Female 24 2 Asian
## 6 1 3 Liability Female 25 2 Asian
## 7 1 3 Liability Female 26 2 Asian
## 8 2 3 Liability Female 26 2 Asian
## 9 1 3 Liability Female 27 2 Asian
## 10 2 3 Liability Female 27 2 Asian
## 11 2 3 Liability Male 27 1 Asian
## 12 2 3 Liability Female 29 2 Asian
## 13 1 3 Collision Female 32 2 Asian
## 14 2 2 Collision Female 32 2 American
## 15 1 1 Collision Female 32 2 American
## 16 2 1 Collision Female 32 2 American
## 17 2 1 Collision Female 32 2 American
## 18 2 1 Collision Female 34 2 American
## 19 1 1 Collision Female 34 2 American
## 20 2 3 Collision Female 34 2 American
## 21 2 1 Collision Female 34 3 American
## 22 2 1 Collision Female 35 3 American
## 23 2 1 Collision Female 35 1 American
## 24 1 1 Collision Male 36 3 American
## 25 2 2 Liability Female 32 3 American
## 26 1 3 Collision Female 36 2 American
## 27 2 1 Collision Female 36 1 American
## 28 1 1 Collision Female 36 2 American
## 29 1 2 Collision Female 36 3 American
## 30 2 3 Collision Female 37 2 American
## 31 1 3 Collision Female 38 3 American
## 32 2 1 Collision Female 39 2 American
## 33 1 3 Collision Female 42 1 American
## 34 2 3 Collision Female 45 2 American
## 35 2 1 Collision Female 45 2 American
## 36 2 2 Liability Female 34 1 American
## 37 1 1 Collision Female 46 2 American
## 38 2 3 Collision Male 48 3 American
## 39 2 3 Collision Male 49 1 American
## 40 2 2 Collision Female 49 2 European
## 41 2 2 Collision Male 50 2 European
## 42 2 2 Comprehensive Female 52 2 European
## 43 2 2 Comprehensive Male 53 2 European
## 44 2 2 Comprehensive Female 53 2 European
## 45 1 2 Comprehensive Male 53 3 European
## 46 1 2 Comprehensive Female 54 2 European
## 47 2 2 Liability Female 34 2 American
## 48 2 2 Comprehensive Female 55 2 European
## 49 2 3 Collision Male 18 2 European
## 50 2 3 Collision Female 18 1 European
## Model MPG Cyl acc1 C_cost. H_Cost Post.Satis Make Model_v1
## 1 Ford Expedition 15 8 5.5 16 14 4 Ford Expedition
## 2 Ford Expedition 15 8 5.5 16 14 5 Ford Expedition
## 3 Toyota Rav4 24 4 8.2 10 8 4 Toyota Rav4
## 4 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 5 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 6 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 7 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 8 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 9 Toyota Corolla 26 4 8.0 7 6 7 Toyota Corolla
## 10 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 11 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 12 Honda Pilot 20 6 6.5 12 10 5 Honda Pilot
## 13 Honda Pilot 20 6 6.5 12 10 4 Honda Pilot
## 14 Toyota Rav4 24 4 8.2 10 8 5 Toyota Rav4
## 15 Honda Pilot 20 6 6.5 12 10 4 Honda Pilot
## 16 Honda Pilot 20 6 6.5 12 10 6 Honda Pilot
## 17 Honda Pilot 20 6 6.5 12 10 4 Honda Pilot
## 18 Honda Pilot 20 6 6.5 12 10 5 Honda Pilot
## 19 Honda Pilot 20 6 6.5 12 10 5 Honda Pilot
## 20 Honda Pilot 20 6 6.5 12 10 5 Honda Pilot
## 21 Honda Pilot 20 6 6.5 12 10 4 Honda Pilot
## 22 Honda Pilot 20 6 6.5 12 10 6 Honda Pilot
## 23 Honda Pilot 20 6 6.5 12 10 6 Honda Pilot
## 24 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 25 Toyota Rav4 24 4 8.2 10 8 7 Toyota Rav4
## 26 Toyota Corolla 26 4 8.0 7 6 7 Toyota Corolla
## 27 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 28 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 29 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 30 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 31 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 32 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 33 Toyota Corolla 26 4 8.0 7 6 5 Toyota Corolla
## 34 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 35 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 36 Toyota Rav4 24 4 8.2 10 8 6 Toyota Rav4
## 37 Toyota Corolla 26 4 8.0 7 6 7 Toyota Corolla
## 38 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 39 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 40 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 41 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 42 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 43 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 44 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 45 Toyota Corolla 26 4 8.0 7 6 6 Toyota Corolla
## 46 Toyota Corolla 26 4 8.0 7 6 7 Toyota Corolla
## 47 Toyota Rav4 24 4 8.2 10 8 6 Toyota Rav4
## 48 Toyota Corolla 26 4 8.0 7 6 7 Toyota Corolla
## 49 Fiat 500x 22 4 8.0 8 6 7 Fiat 500x
## 50 Fiat 500x 22 4 8.0 8 6 6 Fiat 500x
## Attitude Parent Enjoyment Perform Word_of_Mouth Future_Purchase_Intention
## 1 6.0 Ford 6.0 4.666667 3.0 3.0
## 2 6.0 Ford 4.0 3.000000 5.5 6.0
## 3 6.5 Toyota 5.0 5.666667 4.0 6.0
## 4 6.0 Toyota 6.5 6.000000 6.0 6.0
## 5 6.0 Toyota 6.5 6.000000 4.0 5.0
## 6 2.0 Toyota 3.5 5.666667 4.0 6.0
## 7 2.0 Toyota 1.5 1.666667 6.5 5.5
## 8 7.0 Toyota 6.5 5.333333 6.0 6.5
## 9 1.5 Toyota 1.5 2.000000 7.0 7.0
## 10 6.0 Toyota 5.5 5.000000 3.0 6.0
## 11 4.0 Toyota 3.0 3.666667 7.0 5.5
## 12 5.0 Honda 4.0 4.333333 5.0 6.0
## 13 4.0 Honda 7.0 7.000000 7.0 5.0
## 14 6.0 Toyota 6.5 4.666667 5.5 3.5
## 15 7.0 Honda 5.5 5.000000 5.0 5.5
## 16 7.0 Honda 4.5 4.333333 6.0 5.5
## 17 6.0 Honda 6.0 4.000000 5.0 4.0
## 18 4.0 Honda 3.0 2.666667 6.5 6.0
## 19 5.0 Honda 4.5 4.333333 5.0 5.0
## 20 4.5 Honda 5.0 5.333333 7.0 5.0
## 21 6.0 Honda 7.0 6.333333 7.0 5.5
## 22 6.0 Honda 6.0 5.333333 7.0 5.0
## 23 3.5 Honda 3.0 4.000000 6.5 6.5
## 24 6.0 Toyota 5.5 4.333333 4.0 6.0
## 25 7.0 Toyota 6.5 4.333333 7.0 6.0
## 26 6.5 Toyota 6.0 5.333333 7.0 7.0
## 27 6.0 Toyota 4.5 5.333333 6.0 5.5
## 28 6.0 Toyota 5.0 6.000000 5.0 6.0
## 29 7.0 Toyota 6.0 5.333333 6.0 5.0
## 30 5.5 Toyota 4.5 5.000000 6.5 7.0
## 31 7.0 Toyota 6.5 6.000000 7.0 3.5
## 32 6.5 Toyota 7.0 6.333333 7.0 6.0
## 33 7.0 Toyota 6.5 6.666667 7.0 2.5
## 34 5.5 Toyota 6.5 6.666667 6.5 6.5
## 35 7.0 Toyota 7.0 7.000000 7.0 5.5
## 36 7.0 Toyota 6.5 5.000000 6.0 6.5
## 37 7.0 Toyota 7.0 7.000000 7.0 6.0
## 38 6.0 Toyota 5.5 4.333333 6.0 6.5
## 39 6.5 Toyota 5.5 6.000000 7.0 5.0
## 40 6.5 Toyota 5.5 6.000000 7.0 6.0
## 41 7.0 Toyota 7.0 6.000000 6.5 4.5
## 42 7.0 Toyota 7.0 7.000000 7.0 4.5
## 43 5.5 Toyota 5.5 5.666667 7.0 5.5
## 44 6.5 Toyota 6.0 5.666667 5.0 5.5
## 45 5.5 Toyota 5.0 5.000000 5.0 5.5
## 46 6.0 Toyota 6.0 4.666667 5.0 6.0
## 47 7.0 Toyota 7.0 6.333333 3.5 4.0
## 48 5.5 Toyota 5.5 4.666667 7.0 7.0
## 49 4.0 Chrysler 3.5 5.666667 4.0 6.5
## 50 5.0 Chrysler 1.5 1.666667 6.5 6.0
## Value_Perception Purchase_Process
## 1 3.5 5.0
## 2 6.0 6.0
## 3 6.5 5.0
## 4 5.0 4.5
## 5 5.5 6.5
## 6 4.5 5.0
## 7 4.0 4.5
## 8 5.5 5.0
## 9 5.0 6.5
## 10 5.5 5.5
## 11 4.0 3.5
## 12 5.5 6.0
## 13 4.5 3.5
## 14 2.5 2.0
## 15 6.0 6.0
## 16 5.5 7.0
## 17 4.0 4.0
## 18 5.5 4.0
## 19 5.0 6.0
## 20 4.0 4.5
## 21 4.5 5.5
## 22 4.5 4.0
## 23 6.0 6.0
## 24 5.0 5.0
## 25 6.5 7.0
## 26 5.0 5.0
## 27 5.5 5.5
## 28 5.5 5.5
## 29 5.0 5.0
## 30 3.5 4.5
## 31 6.0 6.0
## 32 4.5 6.0
## 33 5.0 4.5
## 34 5.0 4.5
## 35 6.0 6.0
## 36 5.5 5.5
## 37 5.5 5.5
## 38 5.0 5.5
## 39 5.0 4.5
## 40 5.0 4.5
## 41 4.5 5.5
## 42 5.0 5.5
## 43 5.5 6.0
## 44 5.0 6.0
## 45 4.0 5.0
## 46 6.0 6.0
## 47 3.0 2.5
## 48 6.0 6.0
## 49 5.0 4.5
## 50 4.0 4.0The number of cars sold per brand in different Region
ggplot(ct,aes(x=Make,fill=Make))+
geom_bar(position = "dodge")+
geom_text(stat="count", aes(label=..count..), vjust=0, size=5, color="blue")+
facet_wrap(~ Region)+
labs(title = "Sales volume of various types of brand", x = "Brand", y = "Number of car sale",)+
theme_minimal()## Warning: The dot-dot notation (`..count..`) was deprecated in ggplot2 3.4.0.
## ℹ Please use `after_stat(count)` instead.
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
New dataset with selected variables
honda_vs_competitors <- ct %>%
select(Region, Parent, Make, MPG, Attitude, Enjoyment, Perform, Future_Purchase_Intention, Post.Satis, Word_of_Mouth, Value_Perception, Purchase_Process) %>%
na.omit()assign the data file into a new dataframe with the Average value of each variable
honda_vs_competitors_summary <- honda_vs_competitors %>% group_by(Region, Parent, Make, MPG) %>% summarise(Avg_Attitude = mean(Attitude, na.rm = TRUE),
Avg_Enjoyment = mean(Enjoyment, na.rm = TRUE),
Avg_Perform = mean(Perform, na.rm = TRUE),
Avg_WOM = mean(Word_of_Mouth, na.rm = TRUE),
Avg_Future_Purchase = mean(Future_Purchase_Intention, na.rm = TRUE),
Avg_Value_Perception = mean(Value_Perception, na.rm = TRUE),
Avg_Post_Satis = mean(Post.Satis, na.rm = TRUE))## `summarise()` has grouped output by 'Region', 'Parent', 'Make'. You can
## override using the `.groups` argument.rounded to 2 decimal places
Define the coulumes to round
colums_to_round <- c("Avg_Attitude", "Avg_Enjoyment", "Avg_Perform", "Avg_WOM", "Avg_Future_Purchase", "Avg_Value_Perception", "Avg_Post_Satis")Round the specified columns to two decimal places
honda_vs_competitors_summary <- honda_vs_competitors_summary %>%
mutate(across(all_of(colums_to_round), \(x) round(x, 2)))Plot 1: Attitude by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_Attitude, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Attitude by Region and Brand", x = "Make", y = "Average Attitude") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_attitude <- honda_vs_competitors_summary %>%
group_by(Region, Make) %>%
summarize(Avg_Attitude = round(mean(Avg_Attitude, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_attitude, n = Inf)## # A tibble: 29 × 3
## Region Make Avg_Attitude
## <chr> <chr> <dbl>
## 1 American Buick 5.41
## 2 American Chevrolet 5.16
## 3 American Chrysler 5
## 4 American Dodge 4.73
## 5 American Fiat 4.78
## 6 American Ford 4.76
## 7 American Honda 5.72
## 8 American Kia 4.4
## 9 American Toyota 5.39
## 10 Asian Chrysler 5.42
## 11 Asian Ford 4.72
## 12 Asian Honda 5.4
## 13 Asian Toyota 5.06
## 14 European Buick 5.1
## 15 European Chevrolet 4.86
## 16 European Chrysler 5.19
## 17 European Fiat 3.83
## 18 European Ford 5.14
## 19 European Honda 5.47
## 20 European Kia 4.47
## 21 European Toyota 5.46
## 22 Middle Eastern Buick 6
## 23 Middle Eastern Chevrolet 5.83
## 24 Middle Eastern Chrysler 4.6
## 25 Middle Eastern Dodge 4.42
## 26 Middle Eastern Ford 4.87
## 27 Middle Eastern Honda 5.54
## 28 Middle Eastern Lincoln 5.47
## 29 Middle Eastern Toyota 5.5Plot 2: Enjoyment by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_Enjoyment, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Enjoyment by Region and Brand", x = "Make", y = "Average Enjoyment") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_enjoyment <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_Enjoyment = round(mean(Avg_Enjoyment, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_enjoyment, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_Enjoyment
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 4.15
## 2 American Chevrolet General Motors 4.73
## 3 American Chrysler Chrysler 4.84
## 4 American Dodge Chrysler 4.25
## 5 American Fiat Chrysler 4.44
## 6 American Ford Ford 4.86
## 7 American Honda Honda 5.44
## 8 American Kia Kia 5.63
## 9 American Toyota Toyota 5.25
## 10 Asian Chrysler Chrysler 5.17
## 11 Asian Ford Ford 4.9
## 12 Asian Honda Honda 5.04
## 13 Asian Toyota Toyota 4.95
## 14 European Buick General Motors 4.85
## 15 European Chevrolet General Motors 4.31
## 16 European Chrysler Chrysler 4.77
## 17 European Fiat Chrysler 3.56
## 18 European Ford Ford 4.59
## 19 European Honda Honda 5.22
## 20 European Kia Kia 5.21
## 21 European Toyota Toyota 5.55
## 22 Middle Eastern Buick General Motors 5.12
## 23 Middle Eastern Chevrolet General Motors 5.31
## 24 Middle Eastern Chrysler Chrysler 5.04
## 25 Middle Eastern Dodge Chrysler 3.92
## 26 Middle Eastern Ford Ford 5.16
## 27 Middle Eastern Honda Honda 4.69
## 28 Middle Eastern Lincoln Ford 4.83
## 29 Middle Eastern Toyota Toyota 4.81Plot 3: Performance by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_Perform, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Performance by Region and Brand", x = "Make", y = "Average Performance") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_performance <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_Perform = round(mean(Avg_Perform, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_performance, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_Perform
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 4.24
## 2 American Chevrolet General Motors 4.42
## 3 American Chrysler Chrysler 4.75
## 4 American Dodge Chrysler 3.82
## 5 American Fiat Chrysler 4.26
## 6 American Ford Ford 4.53
## 7 American Honda Honda 4.77
## 8 American Kia Kia 4.98
## 9 American Toyota Toyota 4.77
## 10 Asian Chrysler Chrysler 5.1
## 11 Asian Ford Ford 4.69
## 12 Asian Honda Honda 4.85
## 13 Asian Toyota Toyota 4.86
## 14 European Buick General Motors 4.37
## 15 European Chevrolet General Motors 3.95
## 16 European Chrysler Chrysler 4.33
## 17 European Fiat Chrysler 3.81
## 18 European Ford Ford 4.04
## 19 European Honda Honda 4.56
## 20 European Kia Kia 4.7
## 21 European Toyota Toyota 5.23
## 22 Middle Eastern Buick General Motors 4.58
## 23 Middle Eastern Chevrolet General Motors 5.22
## 24 Middle Eastern Chrysler Chrysler 4.76
## 25 Middle Eastern Dodge Chrysler 3.51
## 26 Middle Eastern Ford Ford 4.79
## 27 Middle Eastern Honda Honda 4.57
## 28 Middle Eastern Lincoln Ford 4.22
## 29 Middle Eastern Toyota Toyota 4.58Plot 4: Word of Mouth by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_WOM, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Word of Mouth by Region and Brand", x = "Make", y = "Average Word of Mouth") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_WOM <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_WOM = round(mean(Avg_WOM, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_WOM, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_WOM
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 4.15
## 2 American Chevrolet General Motors 5.27
## 3 American Chrysler Chrysler 5.48
## 4 American Dodge Chrysler 4.5
## 5 American Fiat Chrysler 4.28
## 6 American Ford Ford 5.3
## 7 American Honda Honda 5.54
## 8 American Kia Kia 5.1
## 9 American Toyota Toyota 5.68
## 10 Asian Chrysler Chrysler 5.58
## 11 Asian Ford Ford 5.26
## 12 Asian Honda Honda 5.12
## 13 Asian Toyota Toyota 5.56
## 14 European Buick General Motors 4.35
## 15 European Chevrolet General Motors 4.26
## 16 European Chrysler Chrysler 4.65
## 17 European Fiat Chrysler 5.11
## 18 European Ford Ford 5.27
## 19 European Honda Honda 4.93
## 20 European Kia Kia 5.05
## 21 European Toyota Toyota 5.87
## 22 Middle Eastern Buick General Motors 6.25
## 23 Middle Eastern Chevrolet General Motors 5.9
## 24 Middle Eastern Chrysler Chrysler 5.21
## 25 Middle Eastern Dodge Chrysler 4.37
## 26 Middle Eastern Ford Ford 5.51
## 27 Middle Eastern Honda Honda 5.81
## 28 Middle Eastern Lincoln Ford 4.78
## 29 Middle Eastern Toyota Toyota 5.38Plot 5: Future Purchase Intention by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_Future_Purchase, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Future Purchase Intent by Region and Brand", x = "Make", y = "Average Future Purchase Intention") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_Future_Purcahse <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_Future_Purchase = round(mean(Avg_Future_Purchase, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_Future_Purcahse, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_Future_Purchase
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 5.5
## 2 American Chevrolet General Motors 5.02
## 3 American Chrysler Chrysler 5.47
## 4 American Dodge Chrysler 3.73
## 5 American Fiat Chrysler 4.83
## 6 American Ford Ford 5.52
## 7 American Honda Honda 5.36
## 8 American Kia Kia 5.97
## 9 American Toyota Toyota 5.27
## 10 Asian Chrysler Chrysler 5.25
## 11 Asian Ford Ford 5.23
## 12 Asian Honda Honda 5.21
## 13 Asian Toyota Toyota 5.38
## 14 European Buick General Motors 4.65
## 15 European Chevrolet General Motors 4.45
## 16 European Chrysler Chrysler 5.54
## 17 European Fiat Chrysler 5.89
## 18 European Ford Ford 5.66
## 19 European Honda Honda 5.65
## 20 European Kia Kia 5.5
## 21 European Toyota Toyota 5.42
## 22 Middle Eastern Buick General Motors 4.12
## 23 Middle Eastern Chevrolet General Motors 5.69
## 24 Middle Eastern Chrysler Chrysler 5.34
## 25 Middle Eastern Dodge Chrysler 5.34
## 26 Middle Eastern Ford Ford 5.54
## 27 Middle Eastern Honda Honda 5.47
## 28 Middle Eastern Lincoln Ford 5.68
## 29 Middle Eastern Toyota Toyota 5.12Plot 6: Value Perception by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Parent, y = Avg_Value_Perception, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Value Perception by Region and Brand", x = "Make", y = "Average Value Perception") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_Value_Perception <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_Value_Perception = round(mean(Avg_Value_Perception, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_Value_Perception, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_Value_Perception
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 6
## 2 American Chevrolet General Motors 4.82
## 3 American Chrysler Chrysler 5.5
## 4 American Dodge Chrysler 4.57
## 5 American Fiat Chrysler 4.39
## 6 American Ford Ford 5.2
## 7 American Honda Honda 5.08
## 8 American Kia Kia 5.67
## 9 American Toyota Toyota 5.11
## 10 Asian Chrysler Chrysler 4.79
## 11 Asian Ford Ford 5.06
## 12 Asian Honda Honda 5.43
## 13 Asian Toyota Toyota 5.13
## 14 European Buick General Motors 5.3
## 15 European Chevrolet General Motors 4.64
## 16 European Chrysler Chrysler 5.38
## 17 European Fiat Chrysler 5.28
## 18 European Ford Ford 5.56
## 19 European Honda Honda 5.48
## 20 European Kia Kia 5.42
## 21 European Toyota Toyota 5.29
## 22 Middle Eastern Buick General Motors 5.38
## 23 Middle Eastern Chevrolet General Motors 5.07
## 24 Middle Eastern Chrysler Chrysler 5.46
## 25 Middle Eastern Dodge Chrysler 5.63
## 26 Middle Eastern Ford Ford 5.64
## 27 Middle Eastern Honda Honda 5.46
## 28 Middle Eastern Lincoln Ford 5.13
## 29 Middle Eastern Toyota Toyota 5.75Plot 7: Post-Purchase Satisfaction by Region and Brand
ggplot(honda_vs_competitors_summary, aes(x = Make, y = Avg_Post_Satis, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Post-Purchase Satisfaction by Region and Brand", x = "Make", y = "Average Post-Purchase Satisfaction") +
facet_wrap(~ Region) +
theme_minimal()
New Dateset of summary
summary_avg_Post_Satis <- honda_vs_competitors_summary %>%
group_by(Region, Make, Parent) %>%
summarize(Avg_Post_Satis = round(mean(Avg_Post_Satis, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_Post_Satis, n = Inf)## # A tibble: 29 × 4
## Region Make Parent Avg_Post_Satis
## <chr> <chr> <chr> <dbl>
## 1 American Buick General Motors 5.65
## 2 American Chevrolet General Motors 4.68
## 3 American Chrysler Chrysler 5.39
## 4 American Dodge Chrysler 4.55
## 5 American Fiat Chrysler 4.44
## 6 American Ford Ford 4.8
## 7 American Honda Honda 5.12
## 8 American Kia Kia 5.93
## 9 American Toyota Toyota 5.57
## 10 Asian Chrysler Chrysler 4.92
## 11 Asian Ford Ford 4.88
## 12 Asian Honda Honda 5.29
## 13 Asian Toyota Toyota 5.56
## 14 European Buick General Motors 4.8
## 15 European Chevrolet General Motors 4.57
## 16 European Chrysler Chrysler 5.31
## 17 European Fiat Chrysler 5
## 18 European Ford Ford 4.56
## 19 European Honda Honda 5.63
## 20 European Kia Kia 5.79
## 21 European Toyota Toyota 5.72
## 22 Middle Eastern Buick General Motors 4.75
## 23 Middle Eastern Chevrolet General Motors 5.19
## 24 Middle Eastern Chrysler Chrysler 5.32
## 25 Middle Eastern Dodge Chrysler 4.74
## 26 Middle Eastern Ford Ford 5.19
## 27 Middle Eastern Honda Honda 5.59
## 28 Middle Eastern Lincoln Ford 5.74
## 29 Middle Eastern Toyota Toyota 5.5Plot 8: Post Purchase satisfaction by mile per gallon
ggplot(honda_vs_competitors_summary, aes(x = MPG, y = Avg_Post_Satis, fill = Make)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Post Purchase Satisfaction by Miles Per Gallon", x = "Miles Per Gallon", y = "Post Purchase Satisfaction") +
facet_wrap(~ Make) +
theme_minimal()
New Dateset of summary
summary_avg_Post_Sat <- honda_vs_competitors_summary %>%
group_by(Make, MPG) %>%
summarize(Avg_Post_Satis = round(mean(Avg_Post_Satis, na.rm = TRUE), 2), .groups = "drop")Display the summarized data
print(summary_avg_Post_Sat, n = Inf)## # A tibble: 14 × 3
## Make MPG Avg_Post_Satis
## <chr> <int> <dbl>
## 1 Buick 17 5.07
## 2 Chevrolet 14 4.81
## 3 Chrysler 18 5.23
## 4 Dodge 16 4.64
## 5 Fiat 22 4.72
## 6 Ford 15 4.44
## 7 Ford 19 5.28
## 8 Honda 20 5.28
## 9 Honda 26 5.52
## 10 Kia 22 5.86
## 11 Lincoln 15 5.74
## 12 Toyota 20 5.34
## 13 Toyota 24 5.48
## 14 Toyota 26 6.07select the text values with “Honda”
stringr::str_detect(ct$Model, "Honda")## [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [13] TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [25] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [37] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [49] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [61] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [73] FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [85] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [121] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [133] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [145] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [157] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [181] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [217] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [241] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [253] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [265] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [325] FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [337] TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [385] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [397] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [409] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [421] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [433] FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE
## [445] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [457] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [469] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [481] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE
## [493] TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [505] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [517] TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [541] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [553] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [565] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [577] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [589] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [601] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [613] FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE
## [625] TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [637] TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE
## [649] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [661] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [673] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [685] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [697] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [709] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [721] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [733] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [745] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [757] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [769] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [781] FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE
## [793] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [805] TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [817] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [829] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [841] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [853] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [865] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [877] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [889] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
## [901] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [913] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [925] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE
## [937] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [949] TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [961] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [973] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [985] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [997] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1009] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1021] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1033] TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE FALSE FALSE
## [1045] FALSE FALSE FALSE FALSE FALSEjust see the dataframe
ct[str_detect(ct$Model,"Honda"),]## Resp Att_1 Att_2 Enj_1 Enj_2 Perform_1 Perform_2 Perform_3 WOM_1
## 12 Res1008 5 5 5.00000 3.00000 3.000000 5.000000 5 5
## 13 Res1009 4 4 7.00000 7.00000 7.000000 7.000000 7 7
## 15 Res1010 7 7 7.00000 4.00000 7.000000 4.000000 4 5
## 16 Res1011 7 7 7.00000 2.00000 6.000000 2.000000 5 6
## 17 Res1012 6 6 6.00000 6.00000 5.000000 3.000000 4 5
## 18 Res1013 4 4 5.00000 1.00000 1.000000 3.000000 4 7
## 19 Res1014 5 5 5.00000 4.00000 3.000000 5.000000 5 5
## 20 Res1015 4 5 5.00000 5.00000 4.000000 7.000000 5 7
## 21 Res1016 6 6 7.00000 7.00000 6.000000 7.000000 6 7
## 22 Res1017 6 6 7.00000 5.00000 5.000000 6.000000 5 7
## 23 Res1018 4 3 4.00000 2.00000 3.000000 5.000000 4 7
## 76 Res121 7 7 7.00000 6.00000 6.000000 6.000000 1 7
## 77 Res122 6 7 6.00000 3.00000 5.000000 5.000000 3 5
## 78 Res123 7 7 7.00000 7.00000 7.000000 7.000000 5 4
## 79 Res124 7 7 7.00000 7.00000 7.000000 7.000000 3 6
## 80 Res125 6 6 5.00000 4.00000 4.000000 5.000000 6 6
## 81 Res126 6 6 6.00000 5.00000 5.000000 4.000000 3 7
## 82 Res127 6 6 6.00000 5.00000 5.000000 5.000000 3 6
## 83 Res128 7 5 6.00000 2.00000 2.000000 7.000000 6 6
## 84 Res129 7 7 7.00000 7.00000 7.000000 5.000000 4 6
## 86 Res130 5 5 5.00000 3.00000 2.000000 5.000000 5 5
## 328 Res349 6 7 7.00000 6.00000 6.000000 5.000000 5 4
## 330 Res350 2 6 6.00000 6.00000 6.000000 7.000000 3 5
## 331 Res351 3 5 5.00000 4.00000 6.000000 5.000000 4 5
## 332 Res352 6 4 5.00000 4.00000 6.000000 6.000000 5 6
## 333 Res353 5 6 7.00000 6.00000 7.000000 6.000000 5 2
## 334 Res354 6 7 7.00000 7.00000 7.000000 5.000000 3 6
## 335 Res355 4 3 4.00000 4.00000 7.000000 5.000000 2 6
## 336 Res356 2 6 6.00000 5.00000 4.000000 4.000000 4 6
## 337 Res357 2 6 6.00000 6.00000 6.000000 6.000000 3 5
## 338 Res358 1 7 7.00000 7.00000 7.000000 7.000000 7 5
## 339 Res359 3 6 6.00000 5.00000 6.000000 5.000000 3 6
## 341 Res360 1 6 6.00000 5.00000 4.000000 6.000000 1 7
## 342 Res361 2 6 6.00000 4.00000 7.000000 5.000000 1 7
## 343 Res362 1 7 7.00000 7.00000 7.000000 3.000000 4 5
## 344 Res363 2 5 6.00000 6.00000 5.000000 4.000000 5 4
## 345 Res364 3 6 6.00000 5.00000 6.000000 5.000000 5 3
## 346 Res365 5 3 3.00000 4.00000 4.000000 3.000000 3 3
## 347 Res366 1 7 7.00000 7.00000 6.000000 5.000000 5 7
## 437 Res447 6 4 4.00000 3.00000 7.000000 6.000000 4 4
## 438 Res448 5 6 6.00000 5.00000 6.000000 3.000000 5 5
## 439 Res449 6 5 5.00000 5.00000 6.000000 5.000000 5 7
## 441 Res450 5 3 3.00000 4.00000 4.000000 4.000000 6 6
## 442 Res451 4 5 5.00000 5.00000 7.000000 4.000000 5 5
## 443 Res452 1 7 7.00000 7.00000 6.000000 7.000000 6 5
## 489 Res494 6 6 7.00000 5.00000 5.000000 5.000000 5 4
## 490 Res495 6 6 6.00000 6.00000 6.000000 6.000000 5 4
## 491 Res496 5 5 4.00000 2.00000 2.000000 4.000000 4 5
## 492 Res497 7 6 7.00000 6.00000 6.000000 5.000000 5 6
## 493 Res498 7 7 7.00000 7.00000 7.000000 6.000000 6 6
## 494 Res499 6 6 5.00000 5.00000 5.000000 5.000000 5 3
## 497 Res500 6 1 6.00000 3.00000 5.000000 4.000000 3 4
## 498 Res501 7 7 7.00000 6.00000 7.000000 7.000000 6 7
## 499 Res502 5 5 7.00000 1.00000 4.000000 5.000000 5 5
## 500 Res503 6 6 7.00000 5.00000 5.000000 5.000000 5 5
## 501 Res504 7 6 7.00000 5.00000 5.000000 4.000000 5 5
## 502 Res505 7 7 7.00000 6.00000 6.000000 2.000000 4 5
## 503 Res506 7 7 7.00000 7.00000 6.000000 3.000000 6 4
## 504 Res507 6 6 5.00000 5.00000 5.000000 6.000000 6 6
## 505 Res508 6 5 5.00000 6.00000 5.000000 4.000000 2 5
## 506 Res509 6 5 5.00000 5.00000 4.000000 5.000000 5 5
## 508 Res510 7 7 7.00000 7.00000 7.000000 5.000000 6 5
## 509 Res511 7 7 7.00000 6.00000 6.000000 3.000000 4 5
## 510 Res512 6 6 5.00000 4.00000 4.000000 5.000000 5 6
## 511 Res513 6 6 6.00000 5.00000 5.000000 2.000000 2 2
## 512 Res514 6 6 7.00000 7.00000 5.000000 6.000000 7 7
## 513 Res515 6 6 7.00000 5.00000 6.000000 5.000000 6 5
## 514 Res516 6 6 5.00000 5.00000 5.000000 4.000000 4 5
## 515 Res517 7 7 7.00000 7.00000 6.000000 7.000000 7 7
## 516 Res518 7 6 1.00000 1.00000 6.000000 1.000000 1 1
## 517 Res519 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 519 Res520 6 5 4.00000 2.00000 2.000000 3.000000 2 3
## 619 Res610 5 5 5.00000 2.00000 2.000000 3.000000 2 5
## 620 Res611 7 6 6.00000 3.00000 2.000000 6.000000 6 7
## 621 Res612 4 6 7.00000 6.00000 6.000000 5.000000 5 6
## 622 Res613 7 6 7.00000 6.00000 7.000000 7.000000 6 6
## 623 Res614 7 6 6.00000 6.00000 5.000000 3.000000 4 6
## 624 Res615 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 625 Res616 6 6 6.00000 6.00000 5.000000 6.000000 6 6
## 626 Res617 6 7 7.00000 4.00000 5.000000 4.000000 5 6
## 627 Res618 7 1 7.00000 3.00000 6.000000 6.000000 7 7
## 628 Res619 4 5 1.00000 3.00000 3.000000 5.000000 5 7
## 630 Res620 5 4 4.00000 2.00000 3.000000 4.000000 4 4
## 631 Res621 6 6 5.00000 5.00000 6.000000 5.000000 6 6
## 632 Res622 6 6 6.00000 5.00000 5.000000 4.000000 4 6
## 633 Res623 6 5 5.00000 2.00000 3.000000 5.000000 4 6
## 634 Res624 7 1 7.00000 7.00000 7.000000 7.000000 7 7
## 635 Res625 6 6 6.00000 6.00000 6.000000 4.000000 6 6
## 636 Res626 6 5 5.00000 2.00000 5.000000 5.000000 5 7
## 637 Res627 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 638 Res628 6 6 6.00000 6.00000 5.000000 5.000000 5 6
## 639 Res629 5 6 6.00000 5.00000 5.000000 6.000000 6 7
## 641 Res630 7 6 7.00000 5.00000 5.000000 5.000000 5 6
## 642 Res631 6 5 5.00000 4.00000 5.000000 2.000000 4 5
## 643 Res632 4 5 6.00000 4.00000 5.000000 4.000000 4 5
## 644 Res633 7 6 6.00000 7.00000 6.000000 4.000000 4 7
## 762 Res74 3 4 3.00000 3.00000 4.000000 4.000000 2 5
## 773 Res75 3 2 2.00000 2.00000 2.000000 5.000000 5 4
## 784 Res76 4 4 4.00000 2.00000 2.000000 6.000000 5 4
## 788 Res763 7 7 7.00000 7.00000 7.000000 6.000000 6 7
## 789 Res764 5 5 3.00000 1.00000 1.000000 2.000000 3 3
## 790 Res765 6 6 4.00000 3.00000 4.000000 4.000000 4 4
## 791 Res766 5 4 4.00000 3.00000 3.000000 5.000000 5 5
## 792 Res767 6 5 6.00000 6.00000 5.000000 5.000000 5 6
## 793 Res768 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 794 Res769 6 5 6.00000 4.00000 5.000000 5.000000 5 7
## 795 Res77 6 6 6.00000 6.00000 5.000000 4.000000 6 3
## 796 Res770 7 6 7.00000 3.00000 4.000000 5.000000 5 6
## 797 Res771 6 6 6.00000 1.00000 4.000000 5.000000 4 6
## 798 Res772 5 5 5.00000 5.00000 5.000000 4.000000 2 3
## 799 Res773 7 7 7.00000 4.00000 6.000000 7.000000 6 7
## 800 Res774 7 7 6.00000 5.00000 6.000000 5.000000 6 7
## 801 Res775 4 6 1.00000 1.00000 1.000000 4.000000 2 3
## 802 Res776 4 5 5.00000 2.00000 5.000000 4.000000 2 5
## 803 Res777 6 6 6.00000 3.00000 5.000000 7.000000 6 7
## 804 Res778 6 6 5.00000 5.00000 5.000000 6.000000 6 7
## 805 Res779 4 3 4.00000 3.00000 3.000000 2.000000 1 5
## 806 Res78 7 6 7.00000 7.00000 7.000000 7.000000 5 3
## 807 Res780 6 6 7.00000 6.00000 5.000000 7.000000 6 7
## 817 Res79 5 5 5.00000 4.00000 4.000000 6.000000 3 5
## 829 Res80 6 6 6.00000 5.00000 5.000000 5.000000 5 5
## 840 Res81 6 6 5.00000 3.00000 4.000000 6.000000 2 5
## 851 Res82 6 6 7.00000 6.00000 7.000000 6.000000 1 6
## 862 Res83 6 6 7.00000 6.00000 6.000000 4.000000 6 3
## 873 Res84 6 6 6.00000 6.00000 4.946514 4.830622 5 5
## 884 Res85 7 6 7.00000 7.00000 6.000000 6.000000 5 3
## 895 Res86 7 7 7.00000 7.00000 6.000000 6.000000 2 5
## 906 Res87 4 4 4.00000 3.00000 4.000000 4.000000 6 2
## 917 Res88 7 7 5.37799 4.57512 7.000000 7.000000 5 7
## 928 Res89 7 7 6.00000 7.00000 6.000000 6.000000 1 7
## 934 Res895 6 5 5.00000 4.00000 3.000000 5.000000 5 7
## 935 Res896 4 4 4.00000 1.00000 2.000000 2.000000 2 7
## 936 Res897 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 937 Res898 3 4 4.00000 4.00000 6.000000 7.000000 6 7
## 938 Res899 6 6 6.00000 6.00000 6.000000 4.000000 4 4
## 940 Res90 6 6 6.00000 7.00000 7.000000 6.000000 5 3
## 941 Res900 6 5 5.00000 2.00000 4.000000 3.000000 5 7
## 942 Res901 5 5 4.00000 3.00000 2.000000 5.000000 5 5
## 943 Res902 3 4 4.00000 2.00000 3.000000 2.000000 4 6
## 944 Res903 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 945 Res904 6 6 6.00000 5.00000 5.000000 5.000000 5 6
## 946 Res905 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 947 Res906 4 6 7.00000 4.00000 5.000000 4.000000 4 6
## 948 Res907 6 6 6.00000 4.00000 4.000000 5.000000 5 7
## 949 Res908 6 6 5.00000 1.00000 4.000000 1.000000 1 7
## 950 Res909 6 7 7.00000 5.00000 4.000000 6.000000 5 7
## 951 Res91 7 7 7.00000 6.00000 6.000000 6.000000 5 4
## 952 Res910 7 7 7.00000 6.00000 6.000000 5.000000 5 7
## 962 Res92 6 6 6.00000 5.00000 5.000000 6.000000 2 6
## 973 Res93 6 6 6.00000 6.00000 5.000000 5.000000 2 6
## 984 Res94 6 6 5.00000 3.00000 4.000000 5.000000 1 6
## 995 Res95 6 7 7.00000 6.00000 5.000000 6.000000 2 6
## 1033 Res984 6 6 7.00000 6.00000 6.000000 4.000000 6 6
## 1034 Res985 4 3 1.00000 1.00000 1.000000 4.000000 1 4
## 1035 Res986 4 5 4.00000 4.00000 4.000000 3.000000 4 4
## 1036 Res987 6 6 7.00000 5.00000 5.000000 5.000000 5 3
## 1037 Res988 6 6 7.00000 6.00000 5.000000 6.000000 6 6
## 1038 Res989 4 4 4.00000 1.00000 2.000000 4.000000 2 3
## 1040 Res990 6 6 7.00000 4.00000 5.000000 2.000000 4 3
## WOM_2 Futu_Pur_1 Futu_Pur_2 Valu_Percp_1 Valu_Percp_2 Pur_Proces_1
## 12 5.000000 6.000000 6 6 5 6.000000
## 13 7.000000 5.000000 5 5 4 4.000000
## 15 5.000000 6.000000 5 6 6 6.000000
## 16 6.000000 6.000000 5 5 6 7.000000
## 17 5.000000 4.000000 4 4 4 4.000000
## 18 6.000000 6.000000 6 6 5 4.000000
## 19 5.000000 5.000000 5 4 6 6.000000
## 20 7.000000 5.000000 5 5 3 3.000000
## 21 7.000000 6.000000 5 5 4 5.000000
## 22 7.000000 5.000000 5 5 4 4.000000
## 23 6.000000 6.000000 7 6 6 6.000000
## 76 7.000000 2.000000 2 1 5 4.000000
## 77 6.000000 7.000000 7 6 5 6.000000
## 78 4.000000 5.000000 6 5 5 5.000000
## 79 5.000000 5.000000 5 5 4 5.000000
## 80 6.000000 4.000000 5 4 4 4.000000
## 81 7.000000 6.000000 6 6 5 5.000000
## 82 5.000000 4.000000 4 4 4 4.000000
## 83 6.000000 4.000000 5 5 6 7.000000
## 84 6.000000 7.000000 7 6 6 6.000000
## 86 5.000000 6.000000 6 5 6 6.000000
## 328 3.000000 7.000000 7 7 6 6.000000
## 330 5.000000 7.000000 7 7 7 7.000000
## 331 5.000000 5.000000 3 2 5 6.000000
## 332 5.000000 6.000000 6 6 7 7.000000
## 333 2.000000 6.000000 7 7 7 7.000000
## 334 6.000000 3.000000 3 3 3 4.000000
## 335 6.000000 7.000000 7 7 6 6.000000
## 336 6.000000 2.000000 2 1 1 3.000000
## 337 5.000000 5.000000 6 4 6 6.000000
## 338 5.000000 7.000000 6 6 6 2.000000
## 339 6.000000 5.000000 6 5 5 6.000000
## 341 7.000000 6.000000 5 6 6 6.000000
## 342 7.000000 7.000000 7 6 6 7.000000
## 343 5.000000 4.000000 6 4 4 4.000000
## 344 6.000000 7.000000 6 6 5 4.000000
## 345 4.000000 6.000000 6 6 4 5.000000
## 346 3.000000 7.000000 6 5 7 7.000000
## 347 7.000000 6.000000 7 6 7 5.000000
## 437 6.000000 1.000000 5 5 5 4.000000
## 438 5.000000 3.000000 3 7 5 6.000000
## 439 5.000000 4.000000 4 4 3 5.000000
## 441 5.000000 6.000000 7 6 6 6.000000
## 442 5.000000 7.000000 6 6 7 7.000000
## 443 4.000000 7.000000 7 7 7 5.000000
## 489 4.000000 7.000000 6 6 7 6.000000
## 490 4.000000 7.000000 7 5 6 6.000000
## 491 5.000000 4.000000 4 4 6 5.000000
## 492 6.000000 4.000000 4 4 6 6.000000
## 493 7.000000 2.000000 2 7 7 7.000000
## 494 3.000000 7.000000 6 5 6 6.000000
## 497 6.000000 6.000000 7 6 7 6.000000
## 498 7.000000 7.000000 7 7 5 6.000000
## 499 5.000000 4.000000 3 3 4 5.000000
## 500 6.000000 5.000000 4 5 5 5.000000
## 501 5.000000 6.000000 5 6 6 6.000000
## 502 5.000000 4.000000 6 6 5 6.000000
## 503 4.000000 6.000000 7 7 7 6.000000
## 504 6.000000 4.000000 4 2 4 4.000000
## 505 5.000000 4.000000 4 6 6 6.000000
## 506 5.000000 4.000000 4 4 4 5.000000
## 508 5.000000 5.000000 6 5 6 6.000000
## 509 6.000000 6.000000 6 6 6 6.000000
## 510 6.000000 6.000000 7 7 6 7.000000
## 511 2.000000 6.000000 6 6 5 5.000000
## 512 7.000000 7.000000 6 6 6 6.000000
## 513 6.000000 4.000000 3 4 4 6.000000
## 514 5.000000 6.000000 6 6 6 7.000000
## 515 7.000000 6.000000 6 5 6 6.000000
## 516 1.000000 4.000000 4 6 6 6.000000
## 517 4.000000 6.000000 6 5 5 5.000000
## 519 1.000000 7.000000 7 6 7 6.000000
## 619 4.000000 6.000000 6 6 6 6.000000
## 620 6.000000 6.000000 6 6 6 6.000000
## 621 6.000000 3.000000 3 7 7 7.000000
## 622 5.000000 5.000000 5 5 4 5.000000
## 623 6.000000 6.000000 6 5 6 5.000000
## 624 4.000000 6.000000 6 6 6 6.000000
## 625 4.000000 6.000000 4 6 4 6.000000
## 626 4.000000 5.000000 3 4 4 5.000000
## 627 7.000000 3.000000 3 3 3 5.000000
## 628 7.000000 4.000000 4 4 5 6.000000
## 630 4.000000 6.000000 6 6 6 6.000000
## 631 6.000000 5.000000 6 6 1 2.000000
## 632 5.000000 1.000000 1 2 1 2.000000
## 633 5.000000 7.000000 6 5 6 6.000000
## 634 7.000000 4.000000 3 5 6 5.000000
## 635 6.000000 4.000000 4 4 5 5.000000
## 636 5.000000 6.000000 7 6 5 6.000000
## 637 4.000000 5.000000 6 7 6 6.000000
## 638 6.000000 4.000000 4 4 4 4.000000
## 639 5.000000 5.000000 6 5 6 5.000000
## 641 5.000000 6.000000 7 7 6 5.000000
## 642 5.000000 6.000000 6 6 7 6.000000
## 643 4.000000 6.000000 6 6 7 7.000000
## 644 7.000000 4.000000 4 5 3 4.000000
## 762 5.000000 5.000000 7 7 6 6.000000
## 773 4.000000 6.000000 7 6 7 7.000000
## 784 4.000000 6.000000 7 7 7 7.000000
## 788 6.000000 5.000000 6 5 5 4.000000
## 789 3.000000 4.000000 4 7 6 7.000000
## 790 5.000000 6.000000 6 6 7 6.000000
## 791 5.000000 5.000000 5 6 5 5.000000
## 792 7.000000 6.000000 6 6 6 6.000000
## 793 4.000000 5.000000 4 5 6 5.000000
## 794 7.000000 6.000000 6 7 6 5.000000
## 795 4.000000 5.000000 5 5 4 5.000000
## 796 6.000000 6.000000 7 6 6 7.000000
## 797 6.000000 6.000000 6 6 6 6.000000
## 798 5.000000 6.000000 7 7 7 6.000000
## 799 7.000000 6.000000 5 5 6 5.000000
## 800 7.000000 5.000000 6 5 7 6.000000
## 801 1.000000 7.000000 7 6 6 6.000000
## 802 3.000000 5.000000 5 5 4 4.000000
## 803 7.000000 7.000000 7 7 7 7.000000
## 804 7.000000 4.000000 4 4 4 5.000000
## 805 7.000000 5.000000 6 5 3 4.000000
## 806 4.000000 6.000000 7 6 7 5.256214
## 807 7.000000 5.000000 4 5 5 5.000000
## 817 3.000000 7.000000 7 6 6 6.000000
## 829 5.000000 6.000000 6 6 5 5.000000
## 840 5.000000 4.000000 6 5 4 1.000000
## 851 6.000000 6.000000 7 4 4 7.000000
## 862 4.000000 6.000000 7 6 6 6.000000
## 873 5.349904 5.320881 6 6 5 5.000000
## 884 4.000000 5.000000 7 5 7 7.000000
## 895 5.000000 3.000000 4 4 2 3.000000
## 906 3.000000 5.000000 5 5 6 4.000000
## 917 6.000000 5.320881 5 5 4 5.000000
## 928 7.000000 6.000000 7 3 6 7.000000
## 934 7.000000 6.000000 6 6 6 6.000000
## 935 7.000000 3.000000 3 4 2 6.000000
## 936 7.000000 7.000000 7 7 5 5.000000
## 937 6.000000 3.000000 3 7 3 6.000000
## 938 6.000000 4.000000 4 6 6 6.000000
## 940 3.000000 4.000000 5 4 5 3.000000
## 941 5.000000 6.000000 6 6 6 6.000000
## 942 5.000000 5.000000 4 6 6 6.000000
## 943 7.000000 6.000000 7 6 6 6.000000
## 944 7.000000 6.000000 6 6 6 6.000000
## 945 6.000000 6.000000 6 6 6 6.000000
## 946 7.000000 6.000000 6 4 5 6.000000
## 947 5.000000 4.000000 4 7 2 5.000000
## 948 6.000000 2.000000 6 6 6 6.000000
## 949 7.000000 7.000000 7 7 3 6.000000
## 950 7.000000 6.000000 6 6 6 6.000000
## 951 4.000000 6.000000 6 6 7 7.000000
## 952 5.000000 6.000000 2 2 3 6.000000
## 962 6.000000 6.000000 6 4 6 6.000000
## 973 7.000000 6.000000 7 6 7 7.000000
## 984 6.000000 5.000000 7 3 6 6.000000
## 995 7.000000 5.000000 5 4 3 3.000000
## 1033 6.000000 6.000000 6 6 5 5.000000
## 1034 4.000000 5.000000 6 6 6 7.000000
## 1035 3.000000 6.000000 6 6 3 3.000000
## 1036 3.000000 5.000000 5 5 6 4.000000
## 1037 6.000000 6.000000 6 5 7 4.000000
## 1038 3.000000 6.000000 5 7 5 5.000000
## 1040 4.000000 4.000000 4 5 5 6.000000
## Pur_Proces_2 Residence Pay_Meth Insur_Type Gender Age Education
## 12 6 2 3 Liability Female 29 2
## 13 3 1 3 Collision Female 32 2
## 15 6 1 1 Collision Female 32 2
## 16 7 2 1 Collision Female 32 2
## 17 4 2 1 Collision Female 32 2
## 18 4 2 1 Collision Female 34 2
## 19 6 1 1 Collision Female 34 2
## 20 6 2 3 Collision Female 34 2
## 21 6 2 1 Collision Female 34 3
## 22 4 2 1 Collision Female 35 3
## 23 6 2 1 Collision Female 35 1
## 76 1 2 3 Liability Male 48 2
## 77 5 1 3 Liability Male 49 3
## 78 4 2 3 Liability Female 49 2
## 79 3 1 3 Liability Male 50 2
## 80 2 2 2 Liability Female 52 2
## 81 2 1 2 Liability Male 53 1
## 82 4 1 2 Liability Female 53 2
## 83 2 2 2 Liability Male 53 2
## 84 5 2 1 Liability Female 54 2
## 86 6 1 1 Collision Female 55 2
## 328 6 2 2 Liability Female 60 2
## 330 2 2 2 Liability Female 18 1
## 331 3 1 2 Liability Female 18 2
## 332 2 1 2 Liability Female 18 2
## 333 2 1 2 Liability Female 19 1
## 334 2 1 3 Liability Female 19 2
## 335 5 1 2 Liability Female 19 2
## 336 1 1 2 Liability Female 19 3
## 337 4 2 2 Liability Male 19 1
## 338 6 1 2 Liability Female 21 2
## 339 2 1 2 Liability Female 21 2
## 341 2 1 2 Collision Female 21 1
## 342 2 1 2 Collision Female 21 2
## 343 2 1 2 Collision Female 21 1
## 344 2 1 2 Collision Female 22 2
## 345 5 1 2 Collision Female 23 1
## 346 2 1 2 Collision Female 23 1
## 347 6 2 2 Collision Female 23 2
## 437 5 1 3 Comprehensive Male 27 2
## 438 6 1 3 Comprehensive Male 29 2
## 439 5 1 3 Comprehensive Female 32 2
## 441 5 1 3 Comprehensive Male 32 2
## 442 7 2 3 Comprehensive Male 32 2
## 443 7 1 3 Comprehensive Female 32 1
## 489 7 1 2 Collision Female 19 2
## 490 7 1 2 Collision Female 19 2
## 491 5 2 2 Collision Female 19 2
## 492 6 1 2 Collision Female 19 2
## 493 7 2 2 Collision Female 21 2
## 494 6 1 2 Liability Male 21 2
## 497 6 1 2 Liability Female 21 2
## 498 7 2 2 Liability Female 21 2
## 499 5 2 2 Liability Female 21 1
## 500 5 1 2 Liability Female 22 3
## 501 6 1 1 Liability Female 23 2
## 502 6 1 1 Liability Female 23 2
## 503 6 1 1 Liability Female 23 2
## 504 2 2 1 Collision Female 23 2
## 505 6 2 2 Collision Female 24 2
## 506 2 1 2 Collision Female 24 2
## 508 6 2 2 Collision Female 24 2
## 509 6 1 2 Collision Male 24 2
## 510 6 1 2 Collision Male 25 2
## 511 6 1 2 Collision Female 26 3
## 512 6 2 2 Collision Male 26 2
## 513 6 2 2 Collision Female 27 2
## 514 5 1 2 Collision Male 27 1
## 515 7 2 2 Collision Female 27 2
## 516 7 2 2 Collision Male 29 2
## 517 5 1 1 Collision Female 32 2
## 519 6 1 1 Collision Female 32 2
## 619 6 1 3 Liability Female 46 2
## 620 6 1 3 Liability Female 48 3
## 621 2 1 3 Liability Female 49 3
## 622 2 2 3 Liability Female 49 2
## 623 2 2 3 Liability Female 50 1
## 624 2 2 3 Liability Female 52 3
## 625 2 2 3 Liability Female 53 3
## 626 2 1 3 Liability Male 53 3
## 627 2 1 3 Liability Female 53 1
## 628 2 1 3 Liability Female 54 1
## 630 6 1 3 Liability Female 55 1
## 631 2 2 3 Collision Female 55 2
## 632 2 1 3 Collision Female 55 1
## 633 1 2 3 Collision Female 56 3
## 634 5 1 3 Collision Female 57 3
## 635 5 1 3 Collision Female 57 3
## 636 5 1 3 Collision Female 57 3
## 637 6 1 3 Collision Female 57 1
## 638 4 1 3 Collision Female 60 2
## 639 5 1 3 Collision Male 60 3
## 641 6 1 1 Collision Female 18 3
## 642 6 1 1 Collision Female 18 2
## 643 6 2 1 Collision Female 18 3
## 644 5 1 2 Collision Female 19 1
## 762 7 2 2 Liability Male 19 2
## 773 3 2 2 Female 19 1
## 784 7 2 3 Liability Female 19 2
## 788 4 1 2 Collision Female 56 3
## 789 6 2 2 Collision Female 57 3
## 790 6 2 2 Collision Female 57 3
## 791 5 1 2 Collision Female 57 3
## 792 7 1 2 Collision Female 57 3
## 793 7 1 2 Collision Female 60 3
## 794 5 1 1 Collision Female 60 3
## 795 5 1 3 Liability Male 19 2
## 796 5 1 1 Collision Female 18 3
## 797 5 2 1 Collision Male 18 3
## 798 6 1 1 Collision Male 18 3
## 799 6 1 1 Collision Female 19 3
## 800 7 1 1 Collision Male 19 3
## 801 7 1 1 Collision Female 19 3
## 802 4 2 1 Collision Male 19 3
## 803 6 1 1 Collision Female 19 3
## 804 5 2 3 Collision Male 21 3
## 805 5 1 3 Collision Female 21 3
## 806 7 2 3 Liability Male 21 2
## 807 5 1 3 Collision Female 21 3
## 817 6 2 3 Liability Female 21 2
## 829 6 1 3 Collision Female 21 2
## 840 3 1 3 Collision Male 21 2
## 851 5 2 3 Collision Female 21 3
## 862 4 2 2 Collision Male 22 2
## 873 6 2 1 Collision Male 23 2
## 884 2 2 1 Collision Female 23 1
## 895 4 2 1 Collision Male 23 1
## 906 4 1 1 Collision Female 23 3
## 917 5 1 2 Collision Female 24 1
## 928 6 1 2 Collision Female 24 2
## 934 6 1 3 Liability Female 52 3
## 935 6 1 3 Liability Female 53 1
## 936 7 2 3 Liability Female 53 3
## 937 5 1 3 Liability Female 53 2
## 938 6 1 3 Liability Female 54 1
## 940 5 1 2 Collision Female 24 2
## 941 6 1 3 Liability Female 55 3
## 942 5 1 3 Liability Male 55 3
## 943 6 2 1 Liability Male 55 3
## 944 6 1 1 Liability Female 56 1
## 945 6 2 1 Liability Male 57 1
## 946 5 2 1 Liability Female 57 2
## 947 6 1 1 Collision Male 57 1
## 948 4 1 1 Collision Female 57 2
## 949 6 1 1 Collision Male 60 1
## 950 6 1 1 Collision Female 60 1
## 951 3 1 2 Collision Female 24 1
## 952 4 1 1 Collision Female 18 1
## 962 3 1 2 Collision Female 25 2
## 973 6 2 1 Collision Female 26 1
## 984 6 2 1 Collision Female 26 2
## 995 4 2 1 Collision Female 27 2
## 1033 5 1 3 Collision Male 19 2
## 1034 6 1 3 Collision Female 19 1
## 1035 6 2 3 Collision Female 19 1
## 1036 6 2 3 Collision Male 19 1
## 1037 7 2 1 Collision Male 21 2
## 1038 6 2 1 Collision Female 21 2
## 1040 6 2 3 Collision Female 21 2
## Region Model MPG Cyl acc1 C_cost. H_Cost Post.Satis Make
## 12 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 13 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 15 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 16 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 17 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 18 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 19 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 20 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 21 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 22 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 23 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 76 American Honda CRV 26 4 8.5 8 7 5 Honda
## 77 American Honda CRV 26 4 8.5 8 7 7 Honda
## 78 American Honda CRV 26 4 8.5 8 7 6 Honda
## 79 American Honda CRV 26 4 8.5 8 7 6 Honda
## 80 American Honda CRV 26 4 8.5 8 7 5 Honda
## 81 European Honda CRV 26 4 8.5 8 7 6 Honda
## 82 European Honda CRV 26 4 8.5 8 7 5 Honda
## 83 European Honda CRV 26 4 8.5 8 7 5 Honda
## 84 European Honda CRV 26 4 8.5 8 7 5 Honda
## 86 European Honda CRV 26 4 8.5 8 7 6 Honda
## 328 American Honda CRV 26 4 8.5 8 7 7 Honda
## 330 American Honda CRV 26 4 8.5 8 7 6 Honda
## 331 American Honda CRV 26 4 8.5 8 7 6 Honda
## 332 American Honda CRV 26 4 8.5 8 7 6 Honda
## 333 American Honda CRV 26 4 8.5 8 7 6 Honda
## 334 American Honda CRV 26 4 8.5 8 7 5 Honda
## 335 American Honda CRV 26 4 8.5 8 7 6 Honda
## 336 American Honda CRV 26 4 8.5 8 7 4 Honda
## 337 European Honda CRV 26 4 8.5 8 7 5 Honda
## 338 European Honda CRV 26 4 8.5 8 7 6 Honda
## 339 European Honda CRV 26 4 8.5 8 7 6 Honda
## 341 European Honda CRV 26 4 8.5 8 7 5 Honda
## 342 European Honda CRV 26 4 8.5 8 7 7 Honda
## 343 European Honda CRV 26 4 8.5 8 7 6 Honda
## 344 European Honda CRV 26 4 8.5 8 7 7 Honda
## 345 European Honda CRV 26 4 8.5 8 7 6 Honda
## 346 European Honda CRV 26 4 8.5 8 7 6 Honda
## 347 European Honda CRV 26 4 8.5 8 7 6 Honda
## 437 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 438 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 439 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 441 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 442 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 443 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 489 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 490 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 491 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 492 Asian Honda CRV 26 4 8.5 8 7 3 Honda
## 493 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 494 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 497 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 498 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 499 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 500 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 501 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 502 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 503 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 504 European Honda CRV 26 4 8.5 8 7 4 Honda
## 505 European Honda CRV 26 4 8.5 8 7 6 Honda
## 506 European Honda CRV 26 4 8.5 8 7 5 Honda
## 508 European Honda CRV 26 4 8.5 8 7 6 Honda
## 509 European Honda CRV 26 4 8.5 8 7 6 Honda
## 510 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 511 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 512 European Honda Pilot 20 6 6.5 12 10 7 Honda
## 513 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 514 European Honda Pilot 20 6 6.5 12 10 4 Honda
## 515 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 516 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 517 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 519 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 619 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 620 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 621 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 622 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 623 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 624 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 625 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 626 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 627 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 628 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 630 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 631 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 632 Asian Honda Pilot 20 6 6.5 12 10 2 Honda
## 633 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 634 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 635 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 636 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 637 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 638 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 639 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 641 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 642 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 643 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 644 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 762 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 773 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 784 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 788 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 789 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 790 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 791 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 792 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 793 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 794 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 795 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 796 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 797 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 798 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 799 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 800 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 801 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 802 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 803 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 804 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 805 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 806 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 807 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 817 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 829 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 840 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 851 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 862 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 873 American Honda CRV 26 4 8.5 8 7 4 Honda
## 884 American Honda CRV 26 4 8.5 8 7 6 Honda
## 895 American Honda CRV 26 4 8.5 8 7 3 Honda
## 906 American Honda CRV 26 4 8.5 8 7 6 Honda
## 917 American Honda CRV 26 4 8.5 8 7 4 Honda
## 928 American Honda CRV 26 4 8.5 8 7 4 Honda
## 934 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 935 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 936 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 937 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 938 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 940 American Honda CRV 26 4 8.5 8 7 5 Honda
## 941 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 942 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 943 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 944 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 945 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 946 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 947 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 948 Middle Eastern Honda Pilot 20 6 6.5 12 10 4 Honda
## 949 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 950 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 951 American Honda CRV 26 4 8.5 8 7 5 Honda
## 952 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 962 American Honda CRV 26 4 8.5 8 7 4 Honda
## 973 American Honda CRV 26 4 8.5 8 7 5 Honda
## 984 American Honda CRV 26 4 8.5 8 7 7 Honda
## 995 American Honda CRV 26 4 8.5 8 7 5 Honda
## 1033 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 1034 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1035 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1036 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 1037 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1038 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1040 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## Model_v1 Attitude Parent Enjoyment Perform Word_of_Mouth
## 12 Pilot 5.0 Honda 4.000000 4.333333 5.000000
## 13 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 15 Pilot 7.0 Honda 5.500000 5.000000 5.000000
## 16 Pilot 7.0 Honda 4.500000 4.333333 6.000000
## 17 Pilot 6.0 Honda 6.000000 4.000000 5.000000
## 18 Pilot 4.0 Honda 3.000000 2.666667 6.500000
## 19 Pilot 5.0 Honda 4.500000 4.333333 5.000000
## 20 Pilot 4.5 Honda 5.000000 5.333333 7.000000
## 21 Pilot 6.0 Honda 7.000000 6.333333 7.000000
## 22 Pilot 6.0 Honda 6.000000 5.333333 7.000000
## 23 Pilot 3.5 Honda 3.000000 4.000000 6.500000
## 76 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 77 CRV 6.5 Honda 4.500000 4.333333 5.500000
## 78 CRV 7.0 Honda 7.000000 6.333333 4.000000
## 79 CRV 7.0 Honda 7.000000 5.666667 5.500000
## 80 CRV 6.0 Honda 4.500000 5.000000 6.000000
## 81 CRV 6.0 Honda 5.500000 4.000000 7.000000
## 82 CRV 6.0 Honda 5.500000 4.333333 5.500000
## 83 CRV 6.0 Honda 4.000000 5.000000 6.000000
## 84 CRV 7.0 Honda 7.000000 5.333333 6.000000
## 86 CRV 5.0 Honda 4.000000 4.000000 5.000000
## 328 CRV 6.5 Honda 6.500000 5.333333 3.500000
## 330 CRV 4.0 Honda 6.000000 5.333333 5.000000
## 331 CRV 4.0 Honda 4.500000 5.000000 5.000000
## 332 CRV 5.0 Honda 4.500000 5.666667 5.500000
## 333 CRV 5.5 Honda 6.500000 6.000000 2.000000
## 334 CRV 6.5 Honda 7.000000 5.000000 6.000000
## 335 CRV 3.5 Honda 4.000000 4.666667 6.000000
## 336 CRV 4.0 Honda 5.500000 4.000000 6.000000
## 337 CRV 4.0 Honda 6.000000 5.000000 5.000000
## 338 CRV 4.0 Honda 7.000000 7.000000 5.000000
## 339 CRV 4.5 Honda 5.500000 4.666667 6.000000
## 341 CRV 3.5 Honda 5.500000 3.666667 7.000000
## 342 CRV 4.0 Honda 5.000000 4.333333 7.000000
## 343 CRV 4.0 Honda 7.000000 4.666667 5.000000
## 344 CRV 3.5 Honda 6.000000 4.666667 5.000000
## 345 CRV 4.5 Honda 5.500000 5.333333 3.500000
## 346 CRV 4.0 Honda 3.500000 3.333333 3.000000
## 347 CRV 4.0 Honda 7.000000 5.333333 7.000000
## 437 CRV 5.0 Honda 3.500000 5.666667 5.000000
## 438 CRV 5.5 Honda 5.500000 4.666667 5.000000
## 439 CRV 5.5 Honda 5.000000 5.333333 6.000000
## 441 CRV 4.0 Honda 3.500000 4.666667 5.500000
## 442 CRV 4.5 Honda 5.000000 5.333333 5.000000
## 443 CRV 4.0 Honda 7.000000 6.333333 4.500000
## 489 CRV 6.0 Honda 6.000000 5.000000 4.000000
## 490 CRV 6.0 Honda 6.000000 5.666667 4.000000
## 491 CRV 5.0 Honda 3.000000 3.333333 5.000000
## 492 CRV 6.5 Honda 6.500000 5.333333 6.000000
## 493 CRV 7.0 Honda 7.000000 6.333333 6.500000
## 494 CRV 6.0 Honda 5.000000 5.000000 3.000000
## 497 CRV 3.5 Honda 4.500000 4.000000 5.000000
## 498 CRV 7.0 Honda 6.500000 6.666667 7.000000
## 499 CRV 5.0 Honda 4.000000 4.666667 5.000000
## 500 CRV 6.0 Honda 6.000000 5.000000 5.500000
## 501 CRV 6.5 Honda 6.000000 4.666667 5.000000
## 502 CRV 7.0 Honda 6.500000 4.000000 5.000000
## 503 CRV 7.0 Honda 7.000000 5.000000 4.000000
## 504 CRV 6.0 Honda 5.000000 5.666667 6.000000
## 505 CRV 5.5 Honda 5.500000 3.666667 5.000000
## 506 CRV 5.5 Honda 5.000000 4.666667 5.000000
## 508 CRV 7.0 Honda 7.000000 6.000000 5.000000
## 509 CRV 7.0 Honda 6.500000 4.333333 5.500000
## 510 Pilot 6.0 Honda 4.500000 4.666667 6.000000
## 511 Pilot 6.0 Honda 5.500000 3.000000 2.000000
## 512 Pilot 6.0 Honda 7.000000 6.000000 7.000000
## 513 Pilot 6.0 Honda 6.000000 5.666667 5.500000
## 514 Pilot 6.0 Honda 5.000000 4.333333 5.000000
## 515 Pilot 7.0 Honda 7.000000 6.666667 7.000000
## 516 Pilot 6.5 Honda 1.000000 2.666667 1.000000
## 517 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 519 Pilot 5.5 Honda 3.000000 2.333333 2.000000
## 619 Pilot 5.0 Honda 3.500000 2.333333 4.500000
## 620 Pilot 6.5 Honda 4.500000 4.666667 6.500000
## 621 Pilot 5.0 Honda 6.500000 5.333333 6.000000
## 622 Pilot 6.5 Honda 6.500000 6.666667 5.500000
## 623 Pilot 6.5 Honda 6.000000 4.000000 6.000000
## 624 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 625 Pilot 6.0 Honda 6.000000 5.666667 5.000000
## 626 Pilot 6.5 Honda 5.500000 4.666667 5.000000
## 627 Pilot 4.0 Honda 5.000000 6.333333 7.000000
## 628 Pilot 4.5 Honda 2.000000 4.333333 7.000000
## 630 Pilot 4.5 Honda 3.000000 3.666667 4.000000
## 631 Pilot 6.0 Honda 5.000000 5.666667 6.000000
## 632 Pilot 6.0 Honda 5.500000 4.333333 5.500000
## 633 Pilot 5.5 Honda 3.500000 4.000000 5.500000
## 634 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 635 Pilot 6.0 Honda 6.000000 5.333333 6.000000
## 636 Pilot 5.5 Honda 3.500000 5.000000 6.000000
## 637 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 638 Pilot 6.0 Honda 6.000000 5.000000 6.000000
## 639 Pilot 5.5 Honda 5.500000 5.666667 6.000000
## 641 Pilot 6.5 Honda 6.000000 5.000000 5.500000
## 642 Pilot 5.5 Honda 4.500000 3.666667 5.000000
## 643 Pilot 4.5 Honda 5.000000 4.333333 4.500000
## 644 Pilot 6.5 Honda 6.500000 4.666667 7.000000
## 762 CRV 3.5 Honda 3.000000 3.333333 5.000000
## 773 CRV 2.5 Honda 2.000000 4.000000 4.000000
## 784 CRV 4.0 Honda 3.000000 4.333333 4.000000
## 788 Pilot 7.0 Honda 7.000000 6.333333 6.500000
## 789 Pilot 5.0 Honda 2.000000 2.000000 3.000000
## 790 Pilot 6.0 Honda 3.500000 4.000000 4.500000
## 791 Pilot 4.5 Honda 3.500000 4.333333 5.000000
## 792 Pilot 5.5 Honda 6.000000 5.000000 6.500000
## 793 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 794 Pilot 5.5 Honda 5.000000 5.000000 7.000000
## 795 CRV 6.0 Honda 6.000000 5.000000 3.500000
## 796 Pilot 6.5 Honda 5.000000 4.666667 6.000000
## 797 Pilot 6.0 Honda 3.500000 4.333333 6.000000
## 798 Pilot 5.0 Honda 5.000000 3.666667 4.000000
## 799 Pilot 7.0 Honda 5.500000 6.333333 7.000000
## 800 Pilot 7.0 Honda 5.500000 5.666667 7.000000
## 801 Pilot 5.0 Honda 1.000000 2.333333 2.000000
## 802 Pilot 4.5 Honda 3.500000 3.666667 4.000000
## 803 Pilot 6.0 Honda 4.500000 6.000000 7.000000
## 804 Pilot 6.0 Honda 5.000000 5.666667 7.000000
## 805 Pilot 3.5 Honda 3.500000 2.000000 6.000000
## 806 CRV 6.5 Honda 7.000000 6.333333 3.500000
## 807 Pilot 6.0 Honda 6.500000 6.000000 7.000000
## 817 CRV 5.0 Honda 4.500000 4.333333 4.000000
## 829 CRV 6.0 Honda 5.500000 5.000000 5.000000
## 840 CRV 6.0 Honda 4.000000 4.000000 5.000000
## 851 CRV 6.0 Honda 6.500000 4.666667 6.000000
## 862 CRV 6.0 Honda 6.500000 5.333333 3.500000
## 873 CRV 6.0 Honda 6.000000 4.925712 5.174952
## 884 CRV 6.5 Honda 7.000000 5.666667 3.500000
## 895 CRV 7.0 Honda 7.000000 4.666667 5.000000
## 906 CRV 4.0 Honda 3.500000 4.666667 2.500000
## 917 CRV 7.0 Honda 4.976555 6.333333 6.500000
## 928 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 934 Pilot 5.5 Honda 4.500000 4.333333 7.000000
## 935 Pilot 4.0 Honda 2.500000 2.000000 7.000000
## 936 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 937 Pilot 3.5 Honda 4.000000 6.333333 6.500000
## 938 Pilot 6.0 Honda 6.000000 4.666667 5.000000
## 940 CRV 6.0 Honda 6.500000 6.000000 3.000000
## 941 Pilot 5.5 Honda 3.500000 4.000000 6.000000
## 942 Pilot 5.0 Honda 3.500000 4.000000 5.000000
## 943 Pilot 3.5 Honda 3.000000 3.000000 6.500000
## 944 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 945 Pilot 6.0 Honda 5.500000 5.000000 6.000000
## 946 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 947 Pilot 5.0 Honda 5.500000 4.333333 5.500000
## 948 Pilot 6.0 Honda 5.000000 4.666667 6.500000
## 949 Pilot 6.0 Honda 3.000000 2.000000 7.000000
## 950 Pilot 6.5 Honda 6.000000 5.000000 7.000000
## 951 CRV 7.0 Honda 6.500000 5.666667 4.000000
## 952 Pilot 7.0 Honda 6.500000 5.333333 6.000000
## 962 CRV 6.0 Honda 5.500000 4.333333 6.000000
## 973 CRV 6.0 Honda 6.000000 4.000000 6.500000
## 984 CRV 6.0 Honda 4.000000 3.333333 6.000000
## 995 CRV 6.5 Honda 6.500000 4.333333 6.500000
## 1033 Pilot 6.0 Honda 6.500000 5.333333 6.000000
## 1034 Pilot 3.5 Honda 1.000000 2.000000 4.000000
## 1035 Pilot 4.5 Honda 4.000000 3.666667 3.500000
## 1036 Pilot 6.0 Honda 6.000000 5.000000 3.000000
## 1037 Pilot 6.0 Honda 6.500000 5.666667 6.000000
## 1038 Pilot 4.0 Honda 2.500000 2.666667 3.000000
## 1040 Pilot 6.0 Honda 5.500000 3.666667 3.500000
## Future_Purchase_Intention Value_Perception Purchase_Process
## 12 6.000000 5.5 6.000000
## 13 5.000000 4.5 3.500000
## 15 5.500000 6.0 6.000000
## 16 5.500000 5.5 7.000000
## 17 4.000000 4.0 4.000000
## 18 6.000000 5.5 4.000000
## 19 5.000000 5.0 6.000000
## 20 5.000000 4.0 4.500000
## 21 5.500000 4.5 5.500000
## 22 5.000000 4.5 4.000000
## 23 6.500000 6.0 6.000000
## 76 2.000000 3.0 2.500000
## 77 7.000000 5.5 5.500000
## 78 5.500000 5.0 4.500000
## 79 5.000000 4.5 4.000000
## 80 4.500000 4.0 3.000000
## 81 6.000000 5.5 3.500000
## 82 4.000000 4.0 4.000000
## 83 4.500000 5.5 4.500000
## 84 7.000000 6.0 5.500000
## 86 6.000000 5.5 6.000000
## 328 7.000000 6.5 6.000000
## 330 7.000000 7.0 4.500000
## 331 4.000000 3.5 4.500000
## 332 6.000000 6.5 4.500000
## 333 6.500000 7.0 4.500000
## 334 3.000000 3.0 3.000000
## 335 7.000000 6.5 5.500000
## 336 2.000000 1.0 2.000000
## 337 5.500000 5.0 5.000000
## 338 6.500000 6.0 4.000000
## 339 5.500000 5.0 4.000000
## 341 5.500000 6.0 4.000000
## 342 7.000000 6.0 4.500000
## 343 5.000000 4.0 3.000000
## 344 6.500000 5.5 3.000000
## 345 6.000000 5.0 5.000000
## 346 6.500000 6.0 4.500000
## 347 6.500000 6.5 5.500000
## 437 3.000000 5.0 4.500000
## 438 3.000000 6.0 6.000000
## 439 4.000000 3.5 5.000000
## 441 6.500000 6.0 5.500000
## 442 6.500000 6.5 7.000000
## 443 7.000000 7.0 6.000000
## 489 6.500000 6.5 6.500000
## 490 7.000000 5.5 6.500000
## 491 4.000000 5.0 5.000000
## 492 4.000000 5.0 6.000000
## 493 2.000000 7.0 7.000000
## 494 6.500000 5.5 6.000000
## 497 6.500000 6.5 6.000000
## 498 7.000000 6.0 6.500000
## 499 3.500000 3.5 5.000000
## 500 4.500000 5.0 5.000000
## 501 5.500000 6.0 6.000000
## 502 5.000000 5.5 6.000000
## 503 6.500000 7.0 6.000000
## 504 4.000000 3.0 3.000000
## 505 4.000000 6.0 6.000000
## 506 4.000000 4.0 3.500000
## 508 5.500000 5.5 6.000000
## 509 6.000000 6.0 6.000000
## 510 6.500000 6.5 6.500000
## 511 6.000000 5.5 5.500000
## 512 6.500000 6.0 6.000000
## 513 3.500000 4.0 6.000000
## 514 6.000000 6.0 6.000000
## 515 6.000000 5.5 6.500000
## 516 4.000000 6.0 6.500000
## 517 6.000000 5.0 5.000000
## 519 7.000000 6.5 6.000000
## 619 6.000000 6.0 6.000000
## 620 6.000000 6.0 6.000000
## 621 3.000000 7.0 4.500000
## 622 5.000000 4.5 3.500000
## 623 6.000000 5.5 3.500000
## 624 6.000000 6.0 4.000000
## 625 5.000000 5.0 4.000000
## 626 4.000000 4.0 3.500000
## 627 3.000000 3.0 3.500000
## 628 4.000000 4.5 4.000000
## 630 6.000000 6.0 6.000000
## 631 5.500000 3.5 2.000000
## 632 1.000000 1.5 2.000000
## 633 6.500000 5.5 3.500000
## 634 3.500000 5.5 5.000000
## 635 4.000000 4.5 5.000000
## 636 6.500000 5.5 5.500000
## 637 5.500000 6.5 6.000000
## 638 4.000000 4.0 4.000000
## 639 5.500000 5.5 5.000000
## 641 6.500000 6.5 5.500000
## 642 6.000000 6.5 6.000000
## 643 6.000000 6.5 6.500000
## 644 4.000000 4.0 4.500000
## 762 6.000000 6.5 6.500000
## 773 6.500000 6.5 5.000000
## 784 6.500000 7.0 7.000000
## 788 5.500000 5.0 4.000000
## 789 4.000000 6.5 6.500000
## 790 6.000000 6.5 6.000000
## 791 5.000000 5.5 5.000000
## 792 6.000000 6.0 6.500000
## 793 4.500000 5.5 6.000000
## 794 6.000000 6.5 5.000000
## 795 5.000000 4.5 5.000000
## 796 6.500000 6.0 6.000000
## 797 6.000000 6.0 5.500000
## 798 6.500000 7.0 6.000000
## 799 5.500000 5.5 5.500000
## 800 5.500000 6.0 6.500000
## 801 7.000000 6.0 6.500000
## 802 5.000000 4.5 4.000000
## 803 7.000000 7.0 6.500000
## 804 4.000000 4.0 5.000000
## 805 5.500000 4.0 4.500000
## 806 6.500000 6.5 6.128107
## 807 4.500000 5.0 5.000000
## 817 7.000000 6.0 6.000000
## 829 6.000000 5.5 5.500000
## 840 5.000000 4.5 2.000000
## 851 6.500000 4.0 6.000000
## 862 6.500000 6.0 5.000000
## 873 5.660441 5.5 5.500000
## 884 6.000000 6.0 4.500000
## 895 3.500000 3.0 3.500000
## 906 5.000000 5.5 4.000000
## 917 5.160441 4.5 5.000000
## 928 6.500000 4.5 6.500000
## 934 6.000000 6.0 6.000000
## 935 3.000000 3.0 6.000000
## 936 7.000000 6.0 6.000000
## 937 3.000000 5.0 5.500000
## 938 4.000000 6.0 6.000000
## 940 4.500000 4.5 4.000000
## 941 6.000000 6.0 6.000000
## 942 4.500000 6.0 5.500000
## 943 6.500000 6.0 6.000000
## 944 6.000000 6.0 6.000000
## 945 6.000000 6.0 6.000000
## 946 6.000000 4.5 5.500000
## 947 4.000000 4.5 5.500000
## 948 4.000000 6.0 5.000000
## 949 7.000000 5.0 6.000000
## 950 6.000000 6.0 6.000000
## 951 6.000000 6.5 5.000000
## 952 4.000000 2.5 5.000000
## 962 6.000000 5.0 4.500000
## 973 6.500000 6.5 6.500000
## 984 6.000000 4.5 6.000000
## 995 5.000000 3.5 3.500000
## 1033 6.000000 5.5 5.000000
## 1034 5.500000 6.0 6.500000
## 1035 6.000000 4.5 4.500000
## 1036 5.000000 5.5 5.000000
## 1037 6.000000 6.0 5.500000
## 1038 5.500000 6.0 5.500000
## 1040 4.000000 5.0 6.000000assign into a new dataframe
ct_Honda<-str_detect(ct$Model,"Honda")see the dataframe
ct_Honda## [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [13] TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [25] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [37] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [49] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [61] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [73] FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [85] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [121] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [133] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [145] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [157] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [181] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [217] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [241] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [253] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [265] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [325] FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [337] TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [385] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [397] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [409] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [421] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [433] FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE
## [445] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [457] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [469] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [481] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE
## [493] TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [505] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [517] TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [541] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [553] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [565] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [577] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [589] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [601] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [613] FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE
## [625] TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [637] TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE
## [649] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [661] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [673] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [685] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [697] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [709] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [721] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [733] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [745] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [757] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [769] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [781] FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE
## [793] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [805] TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [817] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [829] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [841] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [853] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [865] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [877] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [889] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
## [901] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [913] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [925] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE
## [937] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [949] TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [961] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [973] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [985] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [997] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1009] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1021] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [1033] TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE FALSE FALSE
## [1045] FALSE FALSE FALSE FALSE FALSEassign subset data into a dataframe
subHonda<-ct[ct_Honda,]see the dataframe
subHonda## Resp Att_1 Att_2 Enj_1 Enj_2 Perform_1 Perform_2 Perform_3 WOM_1
## 12 Res1008 5 5 5.00000 3.00000 3.000000 5.000000 5 5
## 13 Res1009 4 4 7.00000 7.00000 7.000000 7.000000 7 7
## 15 Res1010 7 7 7.00000 4.00000 7.000000 4.000000 4 5
## 16 Res1011 7 7 7.00000 2.00000 6.000000 2.000000 5 6
## 17 Res1012 6 6 6.00000 6.00000 5.000000 3.000000 4 5
## 18 Res1013 4 4 5.00000 1.00000 1.000000 3.000000 4 7
## 19 Res1014 5 5 5.00000 4.00000 3.000000 5.000000 5 5
## 20 Res1015 4 5 5.00000 5.00000 4.000000 7.000000 5 7
## 21 Res1016 6 6 7.00000 7.00000 6.000000 7.000000 6 7
## 22 Res1017 6 6 7.00000 5.00000 5.000000 6.000000 5 7
## 23 Res1018 4 3 4.00000 2.00000 3.000000 5.000000 4 7
## 76 Res121 7 7 7.00000 6.00000 6.000000 6.000000 1 7
## 77 Res122 6 7 6.00000 3.00000 5.000000 5.000000 3 5
## 78 Res123 7 7 7.00000 7.00000 7.000000 7.000000 5 4
## 79 Res124 7 7 7.00000 7.00000 7.000000 7.000000 3 6
## 80 Res125 6 6 5.00000 4.00000 4.000000 5.000000 6 6
## 81 Res126 6 6 6.00000 5.00000 5.000000 4.000000 3 7
## 82 Res127 6 6 6.00000 5.00000 5.000000 5.000000 3 6
## 83 Res128 7 5 6.00000 2.00000 2.000000 7.000000 6 6
## 84 Res129 7 7 7.00000 7.00000 7.000000 5.000000 4 6
## 86 Res130 5 5 5.00000 3.00000 2.000000 5.000000 5 5
## 328 Res349 6 7 7.00000 6.00000 6.000000 5.000000 5 4
## 330 Res350 2 6 6.00000 6.00000 6.000000 7.000000 3 5
## 331 Res351 3 5 5.00000 4.00000 6.000000 5.000000 4 5
## 332 Res352 6 4 5.00000 4.00000 6.000000 6.000000 5 6
## 333 Res353 5 6 7.00000 6.00000 7.000000 6.000000 5 2
## 334 Res354 6 7 7.00000 7.00000 7.000000 5.000000 3 6
## 335 Res355 4 3 4.00000 4.00000 7.000000 5.000000 2 6
## 336 Res356 2 6 6.00000 5.00000 4.000000 4.000000 4 6
## 337 Res357 2 6 6.00000 6.00000 6.000000 6.000000 3 5
## 338 Res358 1 7 7.00000 7.00000 7.000000 7.000000 7 5
## 339 Res359 3 6 6.00000 5.00000 6.000000 5.000000 3 6
## 341 Res360 1 6 6.00000 5.00000 4.000000 6.000000 1 7
## 342 Res361 2 6 6.00000 4.00000 7.000000 5.000000 1 7
## 343 Res362 1 7 7.00000 7.00000 7.000000 3.000000 4 5
## 344 Res363 2 5 6.00000 6.00000 5.000000 4.000000 5 4
## 345 Res364 3 6 6.00000 5.00000 6.000000 5.000000 5 3
## 346 Res365 5 3 3.00000 4.00000 4.000000 3.000000 3 3
## 347 Res366 1 7 7.00000 7.00000 6.000000 5.000000 5 7
## 437 Res447 6 4 4.00000 3.00000 7.000000 6.000000 4 4
## 438 Res448 5 6 6.00000 5.00000 6.000000 3.000000 5 5
## 439 Res449 6 5 5.00000 5.00000 6.000000 5.000000 5 7
## 441 Res450 5 3 3.00000 4.00000 4.000000 4.000000 6 6
## 442 Res451 4 5 5.00000 5.00000 7.000000 4.000000 5 5
## 443 Res452 1 7 7.00000 7.00000 6.000000 7.000000 6 5
## 489 Res494 6 6 7.00000 5.00000 5.000000 5.000000 5 4
## 490 Res495 6 6 6.00000 6.00000 6.000000 6.000000 5 4
## 491 Res496 5 5 4.00000 2.00000 2.000000 4.000000 4 5
## 492 Res497 7 6 7.00000 6.00000 6.000000 5.000000 5 6
## 493 Res498 7 7 7.00000 7.00000 7.000000 6.000000 6 6
## 494 Res499 6 6 5.00000 5.00000 5.000000 5.000000 5 3
## 497 Res500 6 1 6.00000 3.00000 5.000000 4.000000 3 4
## 498 Res501 7 7 7.00000 6.00000 7.000000 7.000000 6 7
## 499 Res502 5 5 7.00000 1.00000 4.000000 5.000000 5 5
## 500 Res503 6 6 7.00000 5.00000 5.000000 5.000000 5 5
## 501 Res504 7 6 7.00000 5.00000 5.000000 4.000000 5 5
## 502 Res505 7 7 7.00000 6.00000 6.000000 2.000000 4 5
## 503 Res506 7 7 7.00000 7.00000 6.000000 3.000000 6 4
## 504 Res507 6 6 5.00000 5.00000 5.000000 6.000000 6 6
## 505 Res508 6 5 5.00000 6.00000 5.000000 4.000000 2 5
## 506 Res509 6 5 5.00000 5.00000 4.000000 5.000000 5 5
## 508 Res510 7 7 7.00000 7.00000 7.000000 5.000000 6 5
## 509 Res511 7 7 7.00000 6.00000 6.000000 3.000000 4 5
## 510 Res512 6 6 5.00000 4.00000 4.000000 5.000000 5 6
## 511 Res513 6 6 6.00000 5.00000 5.000000 2.000000 2 2
## 512 Res514 6 6 7.00000 7.00000 5.000000 6.000000 7 7
## 513 Res515 6 6 7.00000 5.00000 6.000000 5.000000 6 5
## 514 Res516 6 6 5.00000 5.00000 5.000000 4.000000 4 5
## 515 Res517 7 7 7.00000 7.00000 6.000000 7.000000 7 7
## 516 Res518 7 6 1.00000 1.00000 6.000000 1.000000 1 1
## 517 Res519 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 519 Res520 6 5 4.00000 2.00000 2.000000 3.000000 2 3
## 619 Res610 5 5 5.00000 2.00000 2.000000 3.000000 2 5
## 620 Res611 7 6 6.00000 3.00000 2.000000 6.000000 6 7
## 621 Res612 4 6 7.00000 6.00000 6.000000 5.000000 5 6
## 622 Res613 7 6 7.00000 6.00000 7.000000 7.000000 6 6
## 623 Res614 7 6 6.00000 6.00000 5.000000 3.000000 4 6
## 624 Res615 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 625 Res616 6 6 6.00000 6.00000 5.000000 6.000000 6 6
## 626 Res617 6 7 7.00000 4.00000 5.000000 4.000000 5 6
## 627 Res618 7 1 7.00000 3.00000 6.000000 6.000000 7 7
## 628 Res619 4 5 1.00000 3.00000 3.000000 5.000000 5 7
## 630 Res620 5 4 4.00000 2.00000 3.000000 4.000000 4 4
## 631 Res621 6 6 5.00000 5.00000 6.000000 5.000000 6 6
## 632 Res622 6 6 6.00000 5.00000 5.000000 4.000000 4 6
## 633 Res623 6 5 5.00000 2.00000 3.000000 5.000000 4 6
## 634 Res624 7 1 7.00000 7.00000 7.000000 7.000000 7 7
## 635 Res625 6 6 6.00000 6.00000 6.000000 4.000000 6 6
## 636 Res626 6 5 5.00000 2.00000 5.000000 5.000000 5 7
## 637 Res627 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 638 Res628 6 6 6.00000 6.00000 5.000000 5.000000 5 6
## 639 Res629 5 6 6.00000 5.00000 5.000000 6.000000 6 7
## 641 Res630 7 6 7.00000 5.00000 5.000000 5.000000 5 6
## 642 Res631 6 5 5.00000 4.00000 5.000000 2.000000 4 5
## 643 Res632 4 5 6.00000 4.00000 5.000000 4.000000 4 5
## 644 Res633 7 6 6.00000 7.00000 6.000000 4.000000 4 7
## 762 Res74 3 4 3.00000 3.00000 4.000000 4.000000 2 5
## 773 Res75 3 2 2.00000 2.00000 2.000000 5.000000 5 4
## 784 Res76 4 4 4.00000 2.00000 2.000000 6.000000 5 4
## 788 Res763 7 7 7.00000 7.00000 7.000000 6.000000 6 7
## 789 Res764 5 5 3.00000 1.00000 1.000000 2.000000 3 3
## 790 Res765 6 6 4.00000 3.00000 4.000000 4.000000 4 4
## 791 Res766 5 4 4.00000 3.00000 3.000000 5.000000 5 5
## 792 Res767 6 5 6.00000 6.00000 5.000000 5.000000 5 6
## 793 Res768 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 794 Res769 6 5 6.00000 4.00000 5.000000 5.000000 5 7
## 795 Res77 6 6 6.00000 6.00000 5.000000 4.000000 6 3
## 796 Res770 7 6 7.00000 3.00000 4.000000 5.000000 5 6
## 797 Res771 6 6 6.00000 1.00000 4.000000 5.000000 4 6
## 798 Res772 5 5 5.00000 5.00000 5.000000 4.000000 2 3
## 799 Res773 7 7 7.00000 4.00000 6.000000 7.000000 6 7
## 800 Res774 7 7 6.00000 5.00000 6.000000 5.000000 6 7
## 801 Res775 4 6 1.00000 1.00000 1.000000 4.000000 2 3
## 802 Res776 4 5 5.00000 2.00000 5.000000 4.000000 2 5
## 803 Res777 6 6 6.00000 3.00000 5.000000 7.000000 6 7
## 804 Res778 6 6 5.00000 5.00000 5.000000 6.000000 6 7
## 805 Res779 4 3 4.00000 3.00000 3.000000 2.000000 1 5
## 806 Res78 7 6 7.00000 7.00000 7.000000 7.000000 5 3
## 807 Res780 6 6 7.00000 6.00000 5.000000 7.000000 6 7
## 817 Res79 5 5 5.00000 4.00000 4.000000 6.000000 3 5
## 829 Res80 6 6 6.00000 5.00000 5.000000 5.000000 5 5
## 840 Res81 6 6 5.00000 3.00000 4.000000 6.000000 2 5
## 851 Res82 6 6 7.00000 6.00000 7.000000 6.000000 1 6
## 862 Res83 6 6 7.00000 6.00000 6.000000 4.000000 6 3
## 873 Res84 6 6 6.00000 6.00000 4.946514 4.830622 5 5
## 884 Res85 7 6 7.00000 7.00000 6.000000 6.000000 5 3
## 895 Res86 7 7 7.00000 7.00000 6.000000 6.000000 2 5
## 906 Res87 4 4 4.00000 3.00000 4.000000 4.000000 6 2
## 917 Res88 7 7 5.37799 4.57512 7.000000 7.000000 5 7
## 928 Res89 7 7 6.00000 7.00000 6.000000 6.000000 1 7
## 934 Res895 6 5 5.00000 4.00000 3.000000 5.000000 5 7
## 935 Res896 4 4 4.00000 1.00000 2.000000 2.000000 2 7
## 936 Res897 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 937 Res898 3 4 4.00000 4.00000 6.000000 7.000000 6 7
## 938 Res899 6 6 6.00000 6.00000 6.000000 4.000000 4 4
## 940 Res90 6 6 6.00000 7.00000 7.000000 6.000000 5 3
## 941 Res900 6 5 5.00000 2.00000 4.000000 3.000000 5 7
## 942 Res901 5 5 4.00000 3.00000 2.000000 5.000000 5 5
## 943 Res902 3 4 4.00000 2.00000 3.000000 2.000000 4 6
## 944 Res903 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 945 Res904 6 6 6.00000 5.00000 5.000000 5.000000 5 6
## 946 Res905 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 947 Res906 4 6 7.00000 4.00000 5.000000 4.000000 4 6
## 948 Res907 6 6 6.00000 4.00000 4.000000 5.000000 5 7
## 949 Res908 6 6 5.00000 1.00000 4.000000 1.000000 1 7
## 950 Res909 6 7 7.00000 5.00000 4.000000 6.000000 5 7
## 951 Res91 7 7 7.00000 6.00000 6.000000 6.000000 5 4
## 952 Res910 7 7 7.00000 6.00000 6.000000 5.000000 5 7
## 962 Res92 6 6 6.00000 5.00000 5.000000 6.000000 2 6
## 973 Res93 6 6 6.00000 6.00000 5.000000 5.000000 2 6
## 984 Res94 6 6 5.00000 3.00000 4.000000 5.000000 1 6
## 995 Res95 6 7 7.00000 6.00000 5.000000 6.000000 2 6
## 1033 Res984 6 6 7.00000 6.00000 6.000000 4.000000 6 6
## 1034 Res985 4 3 1.00000 1.00000 1.000000 4.000000 1 4
## 1035 Res986 4 5 4.00000 4.00000 4.000000 3.000000 4 4
## 1036 Res987 6 6 7.00000 5.00000 5.000000 5.000000 5 3
## 1037 Res988 6 6 7.00000 6.00000 5.000000 6.000000 6 6
## 1038 Res989 4 4 4.00000 1.00000 2.000000 4.000000 2 3
## 1040 Res990 6 6 7.00000 4.00000 5.000000 2.000000 4 3
## WOM_2 Futu_Pur_1 Futu_Pur_2 Valu_Percp_1 Valu_Percp_2 Pur_Proces_1
## 12 5.000000 6.000000 6 6 5 6.000000
## 13 7.000000 5.000000 5 5 4 4.000000
## 15 5.000000 6.000000 5 6 6 6.000000
## 16 6.000000 6.000000 5 5 6 7.000000
## 17 5.000000 4.000000 4 4 4 4.000000
## 18 6.000000 6.000000 6 6 5 4.000000
## 19 5.000000 5.000000 5 4 6 6.000000
## 20 7.000000 5.000000 5 5 3 3.000000
## 21 7.000000 6.000000 5 5 4 5.000000
## 22 7.000000 5.000000 5 5 4 4.000000
## 23 6.000000 6.000000 7 6 6 6.000000
## 76 7.000000 2.000000 2 1 5 4.000000
## 77 6.000000 7.000000 7 6 5 6.000000
## 78 4.000000 5.000000 6 5 5 5.000000
## 79 5.000000 5.000000 5 5 4 5.000000
## 80 6.000000 4.000000 5 4 4 4.000000
## 81 7.000000 6.000000 6 6 5 5.000000
## 82 5.000000 4.000000 4 4 4 4.000000
## 83 6.000000 4.000000 5 5 6 7.000000
## 84 6.000000 7.000000 7 6 6 6.000000
## 86 5.000000 6.000000 6 5 6 6.000000
## 328 3.000000 7.000000 7 7 6 6.000000
## 330 5.000000 7.000000 7 7 7 7.000000
## 331 5.000000 5.000000 3 2 5 6.000000
## 332 5.000000 6.000000 6 6 7 7.000000
## 333 2.000000 6.000000 7 7 7 7.000000
## 334 6.000000 3.000000 3 3 3 4.000000
## 335 6.000000 7.000000 7 7 6 6.000000
## 336 6.000000 2.000000 2 1 1 3.000000
## 337 5.000000 5.000000 6 4 6 6.000000
## 338 5.000000 7.000000 6 6 6 2.000000
## 339 6.000000 5.000000 6 5 5 6.000000
## 341 7.000000 6.000000 5 6 6 6.000000
## 342 7.000000 7.000000 7 6 6 7.000000
## 343 5.000000 4.000000 6 4 4 4.000000
## 344 6.000000 7.000000 6 6 5 4.000000
## 345 4.000000 6.000000 6 6 4 5.000000
## 346 3.000000 7.000000 6 5 7 7.000000
## 347 7.000000 6.000000 7 6 7 5.000000
## 437 6.000000 1.000000 5 5 5 4.000000
## 438 5.000000 3.000000 3 7 5 6.000000
## 439 5.000000 4.000000 4 4 3 5.000000
## 441 5.000000 6.000000 7 6 6 6.000000
## 442 5.000000 7.000000 6 6 7 7.000000
## 443 4.000000 7.000000 7 7 7 5.000000
## 489 4.000000 7.000000 6 6 7 6.000000
## 490 4.000000 7.000000 7 5 6 6.000000
## 491 5.000000 4.000000 4 4 6 5.000000
## 492 6.000000 4.000000 4 4 6 6.000000
## 493 7.000000 2.000000 2 7 7 7.000000
## 494 3.000000 7.000000 6 5 6 6.000000
## 497 6.000000 6.000000 7 6 7 6.000000
## 498 7.000000 7.000000 7 7 5 6.000000
## 499 5.000000 4.000000 3 3 4 5.000000
## 500 6.000000 5.000000 4 5 5 5.000000
## 501 5.000000 6.000000 5 6 6 6.000000
## 502 5.000000 4.000000 6 6 5 6.000000
## 503 4.000000 6.000000 7 7 7 6.000000
## 504 6.000000 4.000000 4 2 4 4.000000
## 505 5.000000 4.000000 4 6 6 6.000000
## 506 5.000000 4.000000 4 4 4 5.000000
## 508 5.000000 5.000000 6 5 6 6.000000
## 509 6.000000 6.000000 6 6 6 6.000000
## 510 6.000000 6.000000 7 7 6 7.000000
## 511 2.000000 6.000000 6 6 5 5.000000
## 512 7.000000 7.000000 6 6 6 6.000000
## 513 6.000000 4.000000 3 4 4 6.000000
## 514 5.000000 6.000000 6 6 6 7.000000
## 515 7.000000 6.000000 6 5 6 6.000000
## 516 1.000000 4.000000 4 6 6 6.000000
## 517 4.000000 6.000000 6 5 5 5.000000
## 519 1.000000 7.000000 7 6 7 6.000000
## 619 4.000000 6.000000 6 6 6 6.000000
## 620 6.000000 6.000000 6 6 6 6.000000
## 621 6.000000 3.000000 3 7 7 7.000000
## 622 5.000000 5.000000 5 5 4 5.000000
## 623 6.000000 6.000000 6 5 6 5.000000
## 624 4.000000 6.000000 6 6 6 6.000000
## 625 4.000000 6.000000 4 6 4 6.000000
## 626 4.000000 5.000000 3 4 4 5.000000
## 627 7.000000 3.000000 3 3 3 5.000000
## 628 7.000000 4.000000 4 4 5 6.000000
## 630 4.000000 6.000000 6 6 6 6.000000
## 631 6.000000 5.000000 6 6 1 2.000000
## 632 5.000000 1.000000 1 2 1 2.000000
## 633 5.000000 7.000000 6 5 6 6.000000
## 634 7.000000 4.000000 3 5 6 5.000000
## 635 6.000000 4.000000 4 4 5 5.000000
## 636 5.000000 6.000000 7 6 5 6.000000
## 637 4.000000 5.000000 6 7 6 6.000000
## 638 6.000000 4.000000 4 4 4 4.000000
## 639 5.000000 5.000000 6 5 6 5.000000
## 641 5.000000 6.000000 7 7 6 5.000000
## 642 5.000000 6.000000 6 6 7 6.000000
## 643 4.000000 6.000000 6 6 7 7.000000
## 644 7.000000 4.000000 4 5 3 4.000000
## 762 5.000000 5.000000 7 7 6 6.000000
## 773 4.000000 6.000000 7 6 7 7.000000
## 784 4.000000 6.000000 7 7 7 7.000000
## 788 6.000000 5.000000 6 5 5 4.000000
## 789 3.000000 4.000000 4 7 6 7.000000
## 790 5.000000 6.000000 6 6 7 6.000000
## 791 5.000000 5.000000 5 6 5 5.000000
## 792 7.000000 6.000000 6 6 6 6.000000
## 793 4.000000 5.000000 4 5 6 5.000000
## 794 7.000000 6.000000 6 7 6 5.000000
## 795 4.000000 5.000000 5 5 4 5.000000
## 796 6.000000 6.000000 7 6 6 7.000000
## 797 6.000000 6.000000 6 6 6 6.000000
## 798 5.000000 6.000000 7 7 7 6.000000
## 799 7.000000 6.000000 5 5 6 5.000000
## 800 7.000000 5.000000 6 5 7 6.000000
## 801 1.000000 7.000000 7 6 6 6.000000
## 802 3.000000 5.000000 5 5 4 4.000000
## 803 7.000000 7.000000 7 7 7 7.000000
## 804 7.000000 4.000000 4 4 4 5.000000
## 805 7.000000 5.000000 6 5 3 4.000000
## 806 4.000000 6.000000 7 6 7 5.256214
## 807 7.000000 5.000000 4 5 5 5.000000
## 817 3.000000 7.000000 7 6 6 6.000000
## 829 5.000000 6.000000 6 6 5 5.000000
## 840 5.000000 4.000000 6 5 4 1.000000
## 851 6.000000 6.000000 7 4 4 7.000000
## 862 4.000000 6.000000 7 6 6 6.000000
## 873 5.349904 5.320881 6 6 5 5.000000
## 884 4.000000 5.000000 7 5 7 7.000000
## 895 5.000000 3.000000 4 4 2 3.000000
## 906 3.000000 5.000000 5 5 6 4.000000
## 917 6.000000 5.320881 5 5 4 5.000000
## 928 7.000000 6.000000 7 3 6 7.000000
## 934 7.000000 6.000000 6 6 6 6.000000
## 935 7.000000 3.000000 3 4 2 6.000000
## 936 7.000000 7.000000 7 7 5 5.000000
## 937 6.000000 3.000000 3 7 3 6.000000
## 938 6.000000 4.000000 4 6 6 6.000000
## 940 3.000000 4.000000 5 4 5 3.000000
## 941 5.000000 6.000000 6 6 6 6.000000
## 942 5.000000 5.000000 4 6 6 6.000000
## 943 7.000000 6.000000 7 6 6 6.000000
## 944 7.000000 6.000000 6 6 6 6.000000
## 945 6.000000 6.000000 6 6 6 6.000000
## 946 7.000000 6.000000 6 4 5 6.000000
## 947 5.000000 4.000000 4 7 2 5.000000
## 948 6.000000 2.000000 6 6 6 6.000000
## 949 7.000000 7.000000 7 7 3 6.000000
## 950 7.000000 6.000000 6 6 6 6.000000
## 951 4.000000 6.000000 6 6 7 7.000000
## 952 5.000000 6.000000 2 2 3 6.000000
## 962 6.000000 6.000000 6 4 6 6.000000
## 973 7.000000 6.000000 7 6 7 7.000000
## 984 6.000000 5.000000 7 3 6 6.000000
## 995 7.000000 5.000000 5 4 3 3.000000
## 1033 6.000000 6.000000 6 6 5 5.000000
## 1034 4.000000 5.000000 6 6 6 7.000000
## 1035 3.000000 6.000000 6 6 3 3.000000
## 1036 3.000000 5.000000 5 5 6 4.000000
## 1037 6.000000 6.000000 6 5 7 4.000000
## 1038 3.000000 6.000000 5 7 5 5.000000
## 1040 4.000000 4.000000 4 5 5 6.000000
## Pur_Proces_2 Residence Pay_Meth Insur_Type Gender Age Education
## 12 6 2 3 Liability Female 29 2
## 13 3 1 3 Collision Female 32 2
## 15 6 1 1 Collision Female 32 2
## 16 7 2 1 Collision Female 32 2
## 17 4 2 1 Collision Female 32 2
## 18 4 2 1 Collision Female 34 2
## 19 6 1 1 Collision Female 34 2
## 20 6 2 3 Collision Female 34 2
## 21 6 2 1 Collision Female 34 3
## 22 4 2 1 Collision Female 35 3
## 23 6 2 1 Collision Female 35 1
## 76 1 2 3 Liability Male 48 2
## 77 5 1 3 Liability Male 49 3
## 78 4 2 3 Liability Female 49 2
## 79 3 1 3 Liability Male 50 2
## 80 2 2 2 Liability Female 52 2
## 81 2 1 2 Liability Male 53 1
## 82 4 1 2 Liability Female 53 2
## 83 2 2 2 Liability Male 53 2
## 84 5 2 1 Liability Female 54 2
## 86 6 1 1 Collision Female 55 2
## 328 6 2 2 Liability Female 60 2
## 330 2 2 2 Liability Female 18 1
## 331 3 1 2 Liability Female 18 2
## 332 2 1 2 Liability Female 18 2
## 333 2 1 2 Liability Female 19 1
## 334 2 1 3 Liability Female 19 2
## 335 5 1 2 Liability Female 19 2
## 336 1 1 2 Liability Female 19 3
## 337 4 2 2 Liability Male 19 1
## 338 6 1 2 Liability Female 21 2
## 339 2 1 2 Liability Female 21 2
## 341 2 1 2 Collision Female 21 1
## 342 2 1 2 Collision Female 21 2
## 343 2 1 2 Collision Female 21 1
## 344 2 1 2 Collision Female 22 2
## 345 5 1 2 Collision Female 23 1
## 346 2 1 2 Collision Female 23 1
## 347 6 2 2 Collision Female 23 2
## 437 5 1 3 Comprehensive Male 27 2
## 438 6 1 3 Comprehensive Male 29 2
## 439 5 1 3 Comprehensive Female 32 2
## 441 5 1 3 Comprehensive Male 32 2
## 442 7 2 3 Comprehensive Male 32 2
## 443 7 1 3 Comprehensive Female 32 1
## 489 7 1 2 Collision Female 19 2
## 490 7 1 2 Collision Female 19 2
## 491 5 2 2 Collision Female 19 2
## 492 6 1 2 Collision Female 19 2
## 493 7 2 2 Collision Female 21 2
## 494 6 1 2 Liability Male 21 2
## 497 6 1 2 Liability Female 21 2
## 498 7 2 2 Liability Female 21 2
## 499 5 2 2 Liability Female 21 1
## 500 5 1 2 Liability Female 22 3
## 501 6 1 1 Liability Female 23 2
## 502 6 1 1 Liability Female 23 2
## 503 6 1 1 Liability Female 23 2
## 504 2 2 1 Collision Female 23 2
## 505 6 2 2 Collision Female 24 2
## 506 2 1 2 Collision Female 24 2
## 508 6 2 2 Collision Female 24 2
## 509 6 1 2 Collision Male 24 2
## 510 6 1 2 Collision Male 25 2
## 511 6 1 2 Collision Female 26 3
## 512 6 2 2 Collision Male 26 2
## 513 6 2 2 Collision Female 27 2
## 514 5 1 2 Collision Male 27 1
## 515 7 2 2 Collision Female 27 2
## 516 7 2 2 Collision Male 29 2
## 517 5 1 1 Collision Female 32 2
## 519 6 1 1 Collision Female 32 2
## 619 6 1 3 Liability Female 46 2
## 620 6 1 3 Liability Female 48 3
## 621 2 1 3 Liability Female 49 3
## 622 2 2 3 Liability Female 49 2
## 623 2 2 3 Liability Female 50 1
## 624 2 2 3 Liability Female 52 3
## 625 2 2 3 Liability Female 53 3
## 626 2 1 3 Liability Male 53 3
## 627 2 1 3 Liability Female 53 1
## 628 2 1 3 Liability Female 54 1
## 630 6 1 3 Liability Female 55 1
## 631 2 2 3 Collision Female 55 2
## 632 2 1 3 Collision Female 55 1
## 633 1 2 3 Collision Female 56 3
## 634 5 1 3 Collision Female 57 3
## 635 5 1 3 Collision Female 57 3
## 636 5 1 3 Collision Female 57 3
## 637 6 1 3 Collision Female 57 1
## 638 4 1 3 Collision Female 60 2
## 639 5 1 3 Collision Male 60 3
## 641 6 1 1 Collision Female 18 3
## 642 6 1 1 Collision Female 18 2
## 643 6 2 1 Collision Female 18 3
## 644 5 1 2 Collision Female 19 1
## 762 7 2 2 Liability Male 19 2
## 773 3 2 2 Female 19 1
## 784 7 2 3 Liability Female 19 2
## 788 4 1 2 Collision Female 56 3
## 789 6 2 2 Collision Female 57 3
## 790 6 2 2 Collision Female 57 3
## 791 5 1 2 Collision Female 57 3
## 792 7 1 2 Collision Female 57 3
## 793 7 1 2 Collision Female 60 3
## 794 5 1 1 Collision Female 60 3
## 795 5 1 3 Liability Male 19 2
## 796 5 1 1 Collision Female 18 3
## 797 5 2 1 Collision Male 18 3
## 798 6 1 1 Collision Male 18 3
## 799 6 1 1 Collision Female 19 3
## 800 7 1 1 Collision Male 19 3
## 801 7 1 1 Collision Female 19 3
## 802 4 2 1 Collision Male 19 3
## 803 6 1 1 Collision Female 19 3
## 804 5 2 3 Collision Male 21 3
## 805 5 1 3 Collision Female 21 3
## 806 7 2 3 Liability Male 21 2
## 807 5 1 3 Collision Female 21 3
## 817 6 2 3 Liability Female 21 2
## 829 6 1 3 Collision Female 21 2
## 840 3 1 3 Collision Male 21 2
## 851 5 2 3 Collision Female 21 3
## 862 4 2 2 Collision Male 22 2
## 873 6 2 1 Collision Male 23 2
## 884 2 2 1 Collision Female 23 1
## 895 4 2 1 Collision Male 23 1
## 906 4 1 1 Collision Female 23 3
## 917 5 1 2 Collision Female 24 1
## 928 6 1 2 Collision Female 24 2
## 934 6 1 3 Liability Female 52 3
## 935 6 1 3 Liability Female 53 1
## 936 7 2 3 Liability Female 53 3
## 937 5 1 3 Liability Female 53 2
## 938 6 1 3 Liability Female 54 1
## 940 5 1 2 Collision Female 24 2
## 941 6 1 3 Liability Female 55 3
## 942 5 1 3 Liability Male 55 3
## 943 6 2 1 Liability Male 55 3
## 944 6 1 1 Liability Female 56 1
## 945 6 2 1 Liability Male 57 1
## 946 5 2 1 Liability Female 57 2
## 947 6 1 1 Collision Male 57 1
## 948 4 1 1 Collision Female 57 2
## 949 6 1 1 Collision Male 60 1
## 950 6 1 1 Collision Female 60 1
## 951 3 1 2 Collision Female 24 1
## 952 4 1 1 Collision Female 18 1
## 962 3 1 2 Collision Female 25 2
## 973 6 2 1 Collision Female 26 1
## 984 6 2 1 Collision Female 26 2
## 995 4 2 1 Collision Female 27 2
## 1033 5 1 3 Collision Male 19 2
## 1034 6 1 3 Collision Female 19 1
## 1035 6 2 3 Collision Female 19 1
## 1036 6 2 3 Collision Male 19 1
## 1037 7 2 1 Collision Male 21 2
## 1038 6 2 1 Collision Female 21 2
## 1040 6 2 3 Collision Female 21 2
## Region Model MPG Cyl acc1 C_cost. H_Cost Post.Satis Make
## 12 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 13 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 15 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 16 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 17 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 18 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 19 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 20 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 21 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 22 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 23 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 76 American Honda CRV 26 4 8.5 8 7 5 Honda
## 77 American Honda CRV 26 4 8.5 8 7 7 Honda
## 78 American Honda CRV 26 4 8.5 8 7 6 Honda
## 79 American Honda CRV 26 4 8.5 8 7 6 Honda
## 80 American Honda CRV 26 4 8.5 8 7 5 Honda
## 81 European Honda CRV 26 4 8.5 8 7 6 Honda
## 82 European Honda CRV 26 4 8.5 8 7 5 Honda
## 83 European Honda CRV 26 4 8.5 8 7 5 Honda
## 84 European Honda CRV 26 4 8.5 8 7 5 Honda
## 86 European Honda CRV 26 4 8.5 8 7 6 Honda
## 328 American Honda CRV 26 4 8.5 8 7 7 Honda
## 330 American Honda CRV 26 4 8.5 8 7 6 Honda
## 331 American Honda CRV 26 4 8.5 8 7 6 Honda
## 332 American Honda CRV 26 4 8.5 8 7 6 Honda
## 333 American Honda CRV 26 4 8.5 8 7 6 Honda
## 334 American Honda CRV 26 4 8.5 8 7 5 Honda
## 335 American Honda CRV 26 4 8.5 8 7 6 Honda
## 336 American Honda CRV 26 4 8.5 8 7 4 Honda
## 337 European Honda CRV 26 4 8.5 8 7 5 Honda
## 338 European Honda CRV 26 4 8.5 8 7 6 Honda
## 339 European Honda CRV 26 4 8.5 8 7 6 Honda
## 341 European Honda CRV 26 4 8.5 8 7 5 Honda
## 342 European Honda CRV 26 4 8.5 8 7 7 Honda
## 343 European Honda CRV 26 4 8.5 8 7 6 Honda
## 344 European Honda CRV 26 4 8.5 8 7 7 Honda
## 345 European Honda CRV 26 4 8.5 8 7 6 Honda
## 346 European Honda CRV 26 4 8.5 8 7 6 Honda
## 347 European Honda CRV 26 4 8.5 8 7 6 Honda
## 437 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 438 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 439 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 441 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 442 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 443 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 489 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 490 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 491 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 492 Asian Honda CRV 26 4 8.5 8 7 3 Honda
## 493 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 494 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 497 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 498 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 499 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 500 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 501 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 502 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 503 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 504 European Honda CRV 26 4 8.5 8 7 4 Honda
## 505 European Honda CRV 26 4 8.5 8 7 6 Honda
## 506 European Honda CRV 26 4 8.5 8 7 5 Honda
## 508 European Honda CRV 26 4 8.5 8 7 6 Honda
## 509 European Honda CRV 26 4 8.5 8 7 6 Honda
## 510 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 511 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 512 European Honda Pilot 20 6 6.5 12 10 7 Honda
## 513 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 514 European Honda Pilot 20 6 6.5 12 10 4 Honda
## 515 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 516 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 517 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 519 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 619 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 620 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 621 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 622 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 623 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 624 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 625 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 626 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 627 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 628 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 630 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 631 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 632 Asian Honda Pilot 20 6 6.5 12 10 2 Honda
## 633 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 634 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 635 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 636 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 637 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 638 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 639 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 641 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 642 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 643 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 644 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 762 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 773 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 784 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 788 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 789 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 790 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 791 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 792 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 793 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 794 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 795 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 796 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 797 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 798 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 799 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 800 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 801 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 802 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 803 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 804 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 805 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 806 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 807 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 817 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 829 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 840 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 851 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 862 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 873 American Honda CRV 26 4 8.5 8 7 4 Honda
## 884 American Honda CRV 26 4 8.5 8 7 6 Honda
## 895 American Honda CRV 26 4 8.5 8 7 3 Honda
## 906 American Honda CRV 26 4 8.5 8 7 6 Honda
## 917 American Honda CRV 26 4 8.5 8 7 4 Honda
## 928 American Honda CRV 26 4 8.5 8 7 4 Honda
## 934 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 935 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 936 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 937 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 938 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 940 American Honda CRV 26 4 8.5 8 7 5 Honda
## 941 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 942 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 943 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 944 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 945 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 946 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 947 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 948 Middle Eastern Honda Pilot 20 6 6.5 12 10 4 Honda
## 949 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 950 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 951 American Honda CRV 26 4 8.5 8 7 5 Honda
## 952 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 962 American Honda CRV 26 4 8.5 8 7 4 Honda
## 973 American Honda CRV 26 4 8.5 8 7 5 Honda
## 984 American Honda CRV 26 4 8.5 8 7 7 Honda
## 995 American Honda CRV 26 4 8.5 8 7 5 Honda
## 1033 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 1034 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1035 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1036 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 1037 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1038 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1040 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## Model_v1 Attitude Parent Enjoyment Perform Word_of_Mouth
## 12 Pilot 5.0 Honda 4.000000 4.333333 5.000000
## 13 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 15 Pilot 7.0 Honda 5.500000 5.000000 5.000000
## 16 Pilot 7.0 Honda 4.500000 4.333333 6.000000
## 17 Pilot 6.0 Honda 6.000000 4.000000 5.000000
## 18 Pilot 4.0 Honda 3.000000 2.666667 6.500000
## 19 Pilot 5.0 Honda 4.500000 4.333333 5.000000
## 20 Pilot 4.5 Honda 5.000000 5.333333 7.000000
## 21 Pilot 6.0 Honda 7.000000 6.333333 7.000000
## 22 Pilot 6.0 Honda 6.000000 5.333333 7.000000
## 23 Pilot 3.5 Honda 3.000000 4.000000 6.500000
## 76 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 77 CRV 6.5 Honda 4.500000 4.333333 5.500000
## 78 CRV 7.0 Honda 7.000000 6.333333 4.000000
## 79 CRV 7.0 Honda 7.000000 5.666667 5.500000
## 80 CRV 6.0 Honda 4.500000 5.000000 6.000000
## 81 CRV 6.0 Honda 5.500000 4.000000 7.000000
## 82 CRV 6.0 Honda 5.500000 4.333333 5.500000
## 83 CRV 6.0 Honda 4.000000 5.000000 6.000000
## 84 CRV 7.0 Honda 7.000000 5.333333 6.000000
## 86 CRV 5.0 Honda 4.000000 4.000000 5.000000
## 328 CRV 6.5 Honda 6.500000 5.333333 3.500000
## 330 CRV 4.0 Honda 6.000000 5.333333 5.000000
## 331 CRV 4.0 Honda 4.500000 5.000000 5.000000
## 332 CRV 5.0 Honda 4.500000 5.666667 5.500000
## 333 CRV 5.5 Honda 6.500000 6.000000 2.000000
## 334 CRV 6.5 Honda 7.000000 5.000000 6.000000
## 335 CRV 3.5 Honda 4.000000 4.666667 6.000000
## 336 CRV 4.0 Honda 5.500000 4.000000 6.000000
## 337 CRV 4.0 Honda 6.000000 5.000000 5.000000
## 338 CRV 4.0 Honda 7.000000 7.000000 5.000000
## 339 CRV 4.5 Honda 5.500000 4.666667 6.000000
## 341 CRV 3.5 Honda 5.500000 3.666667 7.000000
## 342 CRV 4.0 Honda 5.000000 4.333333 7.000000
## 343 CRV 4.0 Honda 7.000000 4.666667 5.000000
## 344 CRV 3.5 Honda 6.000000 4.666667 5.000000
## 345 CRV 4.5 Honda 5.500000 5.333333 3.500000
## 346 CRV 4.0 Honda 3.500000 3.333333 3.000000
## 347 CRV 4.0 Honda 7.000000 5.333333 7.000000
## 437 CRV 5.0 Honda 3.500000 5.666667 5.000000
## 438 CRV 5.5 Honda 5.500000 4.666667 5.000000
## 439 CRV 5.5 Honda 5.000000 5.333333 6.000000
## 441 CRV 4.0 Honda 3.500000 4.666667 5.500000
## 442 CRV 4.5 Honda 5.000000 5.333333 5.000000
## 443 CRV 4.0 Honda 7.000000 6.333333 4.500000
## 489 CRV 6.0 Honda 6.000000 5.000000 4.000000
## 490 CRV 6.0 Honda 6.000000 5.666667 4.000000
## 491 CRV 5.0 Honda 3.000000 3.333333 5.000000
## 492 CRV 6.5 Honda 6.500000 5.333333 6.000000
## 493 CRV 7.0 Honda 7.000000 6.333333 6.500000
## 494 CRV 6.0 Honda 5.000000 5.000000 3.000000
## 497 CRV 3.5 Honda 4.500000 4.000000 5.000000
## 498 CRV 7.0 Honda 6.500000 6.666667 7.000000
## 499 CRV 5.0 Honda 4.000000 4.666667 5.000000
## 500 CRV 6.0 Honda 6.000000 5.000000 5.500000
## 501 CRV 6.5 Honda 6.000000 4.666667 5.000000
## 502 CRV 7.0 Honda 6.500000 4.000000 5.000000
## 503 CRV 7.0 Honda 7.000000 5.000000 4.000000
## 504 CRV 6.0 Honda 5.000000 5.666667 6.000000
## 505 CRV 5.5 Honda 5.500000 3.666667 5.000000
## 506 CRV 5.5 Honda 5.000000 4.666667 5.000000
## 508 CRV 7.0 Honda 7.000000 6.000000 5.000000
## 509 CRV 7.0 Honda 6.500000 4.333333 5.500000
## 510 Pilot 6.0 Honda 4.500000 4.666667 6.000000
## 511 Pilot 6.0 Honda 5.500000 3.000000 2.000000
## 512 Pilot 6.0 Honda 7.000000 6.000000 7.000000
## 513 Pilot 6.0 Honda 6.000000 5.666667 5.500000
## 514 Pilot 6.0 Honda 5.000000 4.333333 5.000000
## 515 Pilot 7.0 Honda 7.000000 6.666667 7.000000
## 516 Pilot 6.5 Honda 1.000000 2.666667 1.000000
## 517 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 519 Pilot 5.5 Honda 3.000000 2.333333 2.000000
## 619 Pilot 5.0 Honda 3.500000 2.333333 4.500000
## 620 Pilot 6.5 Honda 4.500000 4.666667 6.500000
## 621 Pilot 5.0 Honda 6.500000 5.333333 6.000000
## 622 Pilot 6.5 Honda 6.500000 6.666667 5.500000
## 623 Pilot 6.5 Honda 6.000000 4.000000 6.000000
## 624 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 625 Pilot 6.0 Honda 6.000000 5.666667 5.000000
## 626 Pilot 6.5 Honda 5.500000 4.666667 5.000000
## 627 Pilot 4.0 Honda 5.000000 6.333333 7.000000
## 628 Pilot 4.5 Honda 2.000000 4.333333 7.000000
## 630 Pilot 4.5 Honda 3.000000 3.666667 4.000000
## 631 Pilot 6.0 Honda 5.000000 5.666667 6.000000
## 632 Pilot 6.0 Honda 5.500000 4.333333 5.500000
## 633 Pilot 5.5 Honda 3.500000 4.000000 5.500000
## 634 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 635 Pilot 6.0 Honda 6.000000 5.333333 6.000000
## 636 Pilot 5.5 Honda 3.500000 5.000000 6.000000
## 637 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 638 Pilot 6.0 Honda 6.000000 5.000000 6.000000
## 639 Pilot 5.5 Honda 5.500000 5.666667 6.000000
## 641 Pilot 6.5 Honda 6.000000 5.000000 5.500000
## 642 Pilot 5.5 Honda 4.500000 3.666667 5.000000
## 643 Pilot 4.5 Honda 5.000000 4.333333 4.500000
## 644 Pilot 6.5 Honda 6.500000 4.666667 7.000000
## 762 CRV 3.5 Honda 3.000000 3.333333 5.000000
## 773 CRV 2.5 Honda 2.000000 4.000000 4.000000
## 784 CRV 4.0 Honda 3.000000 4.333333 4.000000
## 788 Pilot 7.0 Honda 7.000000 6.333333 6.500000
## 789 Pilot 5.0 Honda 2.000000 2.000000 3.000000
## 790 Pilot 6.0 Honda 3.500000 4.000000 4.500000
## 791 Pilot 4.5 Honda 3.500000 4.333333 5.000000
## 792 Pilot 5.5 Honda 6.000000 5.000000 6.500000
## 793 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 794 Pilot 5.5 Honda 5.000000 5.000000 7.000000
## 795 CRV 6.0 Honda 6.000000 5.000000 3.500000
## 796 Pilot 6.5 Honda 5.000000 4.666667 6.000000
## 797 Pilot 6.0 Honda 3.500000 4.333333 6.000000
## 798 Pilot 5.0 Honda 5.000000 3.666667 4.000000
## 799 Pilot 7.0 Honda 5.500000 6.333333 7.000000
## 800 Pilot 7.0 Honda 5.500000 5.666667 7.000000
## 801 Pilot 5.0 Honda 1.000000 2.333333 2.000000
## 802 Pilot 4.5 Honda 3.500000 3.666667 4.000000
## 803 Pilot 6.0 Honda 4.500000 6.000000 7.000000
## 804 Pilot 6.0 Honda 5.000000 5.666667 7.000000
## 805 Pilot 3.5 Honda 3.500000 2.000000 6.000000
## 806 CRV 6.5 Honda 7.000000 6.333333 3.500000
## 807 Pilot 6.0 Honda 6.500000 6.000000 7.000000
## 817 CRV 5.0 Honda 4.500000 4.333333 4.000000
## 829 CRV 6.0 Honda 5.500000 5.000000 5.000000
## 840 CRV 6.0 Honda 4.000000 4.000000 5.000000
## 851 CRV 6.0 Honda 6.500000 4.666667 6.000000
## 862 CRV 6.0 Honda 6.500000 5.333333 3.500000
## 873 CRV 6.0 Honda 6.000000 4.925712 5.174952
## 884 CRV 6.5 Honda 7.000000 5.666667 3.500000
## 895 CRV 7.0 Honda 7.000000 4.666667 5.000000
## 906 CRV 4.0 Honda 3.500000 4.666667 2.500000
## 917 CRV 7.0 Honda 4.976555 6.333333 6.500000
## 928 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 934 Pilot 5.5 Honda 4.500000 4.333333 7.000000
## 935 Pilot 4.0 Honda 2.500000 2.000000 7.000000
## 936 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 937 Pilot 3.5 Honda 4.000000 6.333333 6.500000
## 938 Pilot 6.0 Honda 6.000000 4.666667 5.000000
## 940 CRV 6.0 Honda 6.500000 6.000000 3.000000
## 941 Pilot 5.5 Honda 3.500000 4.000000 6.000000
## 942 Pilot 5.0 Honda 3.500000 4.000000 5.000000
## 943 Pilot 3.5 Honda 3.000000 3.000000 6.500000
## 944 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 945 Pilot 6.0 Honda 5.500000 5.000000 6.000000
## 946 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 947 Pilot 5.0 Honda 5.500000 4.333333 5.500000
## 948 Pilot 6.0 Honda 5.000000 4.666667 6.500000
## 949 Pilot 6.0 Honda 3.000000 2.000000 7.000000
## 950 Pilot 6.5 Honda 6.000000 5.000000 7.000000
## 951 CRV 7.0 Honda 6.500000 5.666667 4.000000
## 952 Pilot 7.0 Honda 6.500000 5.333333 6.000000
## 962 CRV 6.0 Honda 5.500000 4.333333 6.000000
## 973 CRV 6.0 Honda 6.000000 4.000000 6.500000
## 984 CRV 6.0 Honda 4.000000 3.333333 6.000000
## 995 CRV 6.5 Honda 6.500000 4.333333 6.500000
## 1033 Pilot 6.0 Honda 6.500000 5.333333 6.000000
## 1034 Pilot 3.5 Honda 1.000000 2.000000 4.000000
## 1035 Pilot 4.5 Honda 4.000000 3.666667 3.500000
## 1036 Pilot 6.0 Honda 6.000000 5.000000 3.000000
## 1037 Pilot 6.0 Honda 6.500000 5.666667 6.000000
## 1038 Pilot 4.0 Honda 2.500000 2.666667 3.000000
## 1040 Pilot 6.0 Honda 5.500000 3.666667 3.500000
## Future_Purchase_Intention Value_Perception Purchase_Process
## 12 6.000000 5.5 6.000000
## 13 5.000000 4.5 3.500000
## 15 5.500000 6.0 6.000000
## 16 5.500000 5.5 7.000000
## 17 4.000000 4.0 4.000000
## 18 6.000000 5.5 4.000000
## 19 5.000000 5.0 6.000000
## 20 5.000000 4.0 4.500000
## 21 5.500000 4.5 5.500000
## 22 5.000000 4.5 4.000000
## 23 6.500000 6.0 6.000000
## 76 2.000000 3.0 2.500000
## 77 7.000000 5.5 5.500000
## 78 5.500000 5.0 4.500000
## 79 5.000000 4.5 4.000000
## 80 4.500000 4.0 3.000000
## 81 6.000000 5.5 3.500000
## 82 4.000000 4.0 4.000000
## 83 4.500000 5.5 4.500000
## 84 7.000000 6.0 5.500000
## 86 6.000000 5.5 6.000000
## 328 7.000000 6.5 6.000000
## 330 7.000000 7.0 4.500000
## 331 4.000000 3.5 4.500000
## 332 6.000000 6.5 4.500000
## 333 6.500000 7.0 4.500000
## 334 3.000000 3.0 3.000000
## 335 7.000000 6.5 5.500000
## 336 2.000000 1.0 2.000000
## 337 5.500000 5.0 5.000000
## 338 6.500000 6.0 4.000000
## 339 5.500000 5.0 4.000000
## 341 5.500000 6.0 4.000000
## 342 7.000000 6.0 4.500000
## 343 5.000000 4.0 3.000000
## 344 6.500000 5.5 3.000000
## 345 6.000000 5.0 5.000000
## 346 6.500000 6.0 4.500000
## 347 6.500000 6.5 5.500000
## 437 3.000000 5.0 4.500000
## 438 3.000000 6.0 6.000000
## 439 4.000000 3.5 5.000000
## 441 6.500000 6.0 5.500000
## 442 6.500000 6.5 7.000000
## 443 7.000000 7.0 6.000000
## 489 6.500000 6.5 6.500000
## 490 7.000000 5.5 6.500000
## 491 4.000000 5.0 5.000000
## 492 4.000000 5.0 6.000000
## 493 2.000000 7.0 7.000000
## 494 6.500000 5.5 6.000000
## 497 6.500000 6.5 6.000000
## 498 7.000000 6.0 6.500000
## 499 3.500000 3.5 5.000000
## 500 4.500000 5.0 5.000000
## 501 5.500000 6.0 6.000000
## 502 5.000000 5.5 6.000000
## 503 6.500000 7.0 6.000000
## 504 4.000000 3.0 3.000000
## 505 4.000000 6.0 6.000000
## 506 4.000000 4.0 3.500000
## 508 5.500000 5.5 6.000000
## 509 6.000000 6.0 6.000000
## 510 6.500000 6.5 6.500000
## 511 6.000000 5.5 5.500000
## 512 6.500000 6.0 6.000000
## 513 3.500000 4.0 6.000000
## 514 6.000000 6.0 6.000000
## 515 6.000000 5.5 6.500000
## 516 4.000000 6.0 6.500000
## 517 6.000000 5.0 5.000000
## 519 7.000000 6.5 6.000000
## 619 6.000000 6.0 6.000000
## 620 6.000000 6.0 6.000000
## 621 3.000000 7.0 4.500000
## 622 5.000000 4.5 3.500000
## 623 6.000000 5.5 3.500000
## 624 6.000000 6.0 4.000000
## 625 5.000000 5.0 4.000000
## 626 4.000000 4.0 3.500000
## 627 3.000000 3.0 3.500000
## 628 4.000000 4.5 4.000000
## 630 6.000000 6.0 6.000000
## 631 5.500000 3.5 2.000000
## 632 1.000000 1.5 2.000000
## 633 6.500000 5.5 3.500000
## 634 3.500000 5.5 5.000000
## 635 4.000000 4.5 5.000000
## 636 6.500000 5.5 5.500000
## 637 5.500000 6.5 6.000000
## 638 4.000000 4.0 4.000000
## 639 5.500000 5.5 5.000000
## 641 6.500000 6.5 5.500000
## 642 6.000000 6.5 6.000000
## 643 6.000000 6.5 6.500000
## 644 4.000000 4.0 4.500000
## 762 6.000000 6.5 6.500000
## 773 6.500000 6.5 5.000000
## 784 6.500000 7.0 7.000000
## 788 5.500000 5.0 4.000000
## 789 4.000000 6.5 6.500000
## 790 6.000000 6.5 6.000000
## 791 5.000000 5.5 5.000000
## 792 6.000000 6.0 6.500000
## 793 4.500000 5.5 6.000000
## 794 6.000000 6.5 5.000000
## 795 5.000000 4.5 5.000000
## 796 6.500000 6.0 6.000000
## 797 6.000000 6.0 5.500000
## 798 6.500000 7.0 6.000000
## 799 5.500000 5.5 5.500000
## 800 5.500000 6.0 6.500000
## 801 7.000000 6.0 6.500000
## 802 5.000000 4.5 4.000000
## 803 7.000000 7.0 6.500000
## 804 4.000000 4.0 5.000000
## 805 5.500000 4.0 4.500000
## 806 6.500000 6.5 6.128107
## 807 4.500000 5.0 5.000000
## 817 7.000000 6.0 6.000000
## 829 6.000000 5.5 5.500000
## 840 5.000000 4.5 2.000000
## 851 6.500000 4.0 6.000000
## 862 6.500000 6.0 5.000000
## 873 5.660441 5.5 5.500000
## 884 6.000000 6.0 4.500000
## 895 3.500000 3.0 3.500000
## 906 5.000000 5.5 4.000000
## 917 5.160441 4.5 5.000000
## 928 6.500000 4.5 6.500000
## 934 6.000000 6.0 6.000000
## 935 3.000000 3.0 6.000000
## 936 7.000000 6.0 6.000000
## 937 3.000000 5.0 5.500000
## 938 4.000000 6.0 6.000000
## 940 4.500000 4.5 4.000000
## 941 6.000000 6.0 6.000000
## 942 4.500000 6.0 5.500000
## 943 6.500000 6.0 6.000000
## 944 6.000000 6.0 6.000000
## 945 6.000000 6.0 6.000000
## 946 6.000000 4.5 5.500000
## 947 4.000000 4.5 5.500000
## 948 4.000000 6.0 5.000000
## 949 7.000000 5.0 6.000000
## 950 6.000000 6.0 6.000000
## 951 6.000000 6.5 5.000000
## 952 4.000000 2.5 5.000000
## 962 6.000000 5.0 4.500000
## 973 6.500000 6.5 6.500000
## 984 6.000000 4.5 6.000000
## 995 5.000000 3.5 3.500000
## 1033 6.000000 5.5 5.000000
## 1034 5.500000 6.0 6.500000
## 1035 6.000000 4.5 4.500000
## 1036 5.000000 5.5 5.000000
## 1037 6.000000 6.0 5.500000
## 1038 5.500000 6.0 5.500000
## 1040 4.000000 5.0 6.000000double check on the models selected
table(subHonda$Make)##
## Honda
## 159Convert Gender into numerical values
subHonda <-subHonda %>%
mutate(Gender_numeric = case_when(Gender == "Female" ~ 1,
Gender == "Male" ~ 0))Convert Insurance Type into numerical values
subHonda <- subHonda %>%
mutate(Insur_Type_numeric = case_when(Insur_Type == "Liability" ~ 1,
Insur_Type == "Collision" ~ 2,
Insur_Type == "Comprehensive" ~ 3))Convert Miles Per Gallon into numerical values
subHonda <- subHonda %>%
mutate(MPG_numeric = case_when(MPG == "20" ~ 1,
MPG == "26" ~ 2))display result
subHonda## Resp Att_1 Att_2 Enj_1 Enj_2 Perform_1 Perform_2 Perform_3 WOM_1
## 12 Res1008 5 5 5.00000 3.00000 3.000000 5.000000 5 5
## 13 Res1009 4 4 7.00000 7.00000 7.000000 7.000000 7 7
## 15 Res1010 7 7 7.00000 4.00000 7.000000 4.000000 4 5
## 16 Res1011 7 7 7.00000 2.00000 6.000000 2.000000 5 6
## 17 Res1012 6 6 6.00000 6.00000 5.000000 3.000000 4 5
## 18 Res1013 4 4 5.00000 1.00000 1.000000 3.000000 4 7
## 19 Res1014 5 5 5.00000 4.00000 3.000000 5.000000 5 5
## 20 Res1015 4 5 5.00000 5.00000 4.000000 7.000000 5 7
## 21 Res1016 6 6 7.00000 7.00000 6.000000 7.000000 6 7
## 22 Res1017 6 6 7.00000 5.00000 5.000000 6.000000 5 7
## 23 Res1018 4 3 4.00000 2.00000 3.000000 5.000000 4 7
## 76 Res121 7 7 7.00000 6.00000 6.000000 6.000000 1 7
## 77 Res122 6 7 6.00000 3.00000 5.000000 5.000000 3 5
## 78 Res123 7 7 7.00000 7.00000 7.000000 7.000000 5 4
## 79 Res124 7 7 7.00000 7.00000 7.000000 7.000000 3 6
## 80 Res125 6 6 5.00000 4.00000 4.000000 5.000000 6 6
## 81 Res126 6 6 6.00000 5.00000 5.000000 4.000000 3 7
## 82 Res127 6 6 6.00000 5.00000 5.000000 5.000000 3 6
## 83 Res128 7 5 6.00000 2.00000 2.000000 7.000000 6 6
## 84 Res129 7 7 7.00000 7.00000 7.000000 5.000000 4 6
## 86 Res130 5 5 5.00000 3.00000 2.000000 5.000000 5 5
## 328 Res349 6 7 7.00000 6.00000 6.000000 5.000000 5 4
## 330 Res350 2 6 6.00000 6.00000 6.000000 7.000000 3 5
## 331 Res351 3 5 5.00000 4.00000 6.000000 5.000000 4 5
## 332 Res352 6 4 5.00000 4.00000 6.000000 6.000000 5 6
## 333 Res353 5 6 7.00000 6.00000 7.000000 6.000000 5 2
## 334 Res354 6 7 7.00000 7.00000 7.000000 5.000000 3 6
## 335 Res355 4 3 4.00000 4.00000 7.000000 5.000000 2 6
## 336 Res356 2 6 6.00000 5.00000 4.000000 4.000000 4 6
## 337 Res357 2 6 6.00000 6.00000 6.000000 6.000000 3 5
## 338 Res358 1 7 7.00000 7.00000 7.000000 7.000000 7 5
## 339 Res359 3 6 6.00000 5.00000 6.000000 5.000000 3 6
## 341 Res360 1 6 6.00000 5.00000 4.000000 6.000000 1 7
## 342 Res361 2 6 6.00000 4.00000 7.000000 5.000000 1 7
## 343 Res362 1 7 7.00000 7.00000 7.000000 3.000000 4 5
## 344 Res363 2 5 6.00000 6.00000 5.000000 4.000000 5 4
## 345 Res364 3 6 6.00000 5.00000 6.000000 5.000000 5 3
## 346 Res365 5 3 3.00000 4.00000 4.000000 3.000000 3 3
## 347 Res366 1 7 7.00000 7.00000 6.000000 5.000000 5 7
## 437 Res447 6 4 4.00000 3.00000 7.000000 6.000000 4 4
## 438 Res448 5 6 6.00000 5.00000 6.000000 3.000000 5 5
## 439 Res449 6 5 5.00000 5.00000 6.000000 5.000000 5 7
## 441 Res450 5 3 3.00000 4.00000 4.000000 4.000000 6 6
## 442 Res451 4 5 5.00000 5.00000 7.000000 4.000000 5 5
## 443 Res452 1 7 7.00000 7.00000 6.000000 7.000000 6 5
## 489 Res494 6 6 7.00000 5.00000 5.000000 5.000000 5 4
## 490 Res495 6 6 6.00000 6.00000 6.000000 6.000000 5 4
## 491 Res496 5 5 4.00000 2.00000 2.000000 4.000000 4 5
## 492 Res497 7 6 7.00000 6.00000 6.000000 5.000000 5 6
## 493 Res498 7 7 7.00000 7.00000 7.000000 6.000000 6 6
## 494 Res499 6 6 5.00000 5.00000 5.000000 5.000000 5 3
## 497 Res500 6 1 6.00000 3.00000 5.000000 4.000000 3 4
## 498 Res501 7 7 7.00000 6.00000 7.000000 7.000000 6 7
## 499 Res502 5 5 7.00000 1.00000 4.000000 5.000000 5 5
## 500 Res503 6 6 7.00000 5.00000 5.000000 5.000000 5 5
## 501 Res504 7 6 7.00000 5.00000 5.000000 4.000000 5 5
## 502 Res505 7 7 7.00000 6.00000 6.000000 2.000000 4 5
## 503 Res506 7 7 7.00000 7.00000 6.000000 3.000000 6 4
## 504 Res507 6 6 5.00000 5.00000 5.000000 6.000000 6 6
## 505 Res508 6 5 5.00000 6.00000 5.000000 4.000000 2 5
## 506 Res509 6 5 5.00000 5.00000 4.000000 5.000000 5 5
## 508 Res510 7 7 7.00000 7.00000 7.000000 5.000000 6 5
## 509 Res511 7 7 7.00000 6.00000 6.000000 3.000000 4 5
## 510 Res512 6 6 5.00000 4.00000 4.000000 5.000000 5 6
## 511 Res513 6 6 6.00000 5.00000 5.000000 2.000000 2 2
## 512 Res514 6 6 7.00000 7.00000 5.000000 6.000000 7 7
## 513 Res515 6 6 7.00000 5.00000 6.000000 5.000000 6 5
## 514 Res516 6 6 5.00000 5.00000 5.000000 4.000000 4 5
## 515 Res517 7 7 7.00000 7.00000 6.000000 7.000000 7 7
## 516 Res518 7 6 1.00000 1.00000 6.000000 1.000000 1 1
## 517 Res519 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 519 Res520 6 5 4.00000 2.00000 2.000000 3.000000 2 3
## 619 Res610 5 5 5.00000 2.00000 2.000000 3.000000 2 5
## 620 Res611 7 6 6.00000 3.00000 2.000000 6.000000 6 7
## 621 Res612 4 6 7.00000 6.00000 6.000000 5.000000 5 6
## 622 Res613 7 6 7.00000 6.00000 7.000000 7.000000 6 6
## 623 Res614 7 6 6.00000 6.00000 5.000000 3.000000 4 6
## 624 Res615 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 625 Res616 6 6 6.00000 6.00000 5.000000 6.000000 6 6
## 626 Res617 6 7 7.00000 4.00000 5.000000 4.000000 5 6
## 627 Res618 7 1 7.00000 3.00000 6.000000 6.000000 7 7
## 628 Res619 4 5 1.00000 3.00000 3.000000 5.000000 5 7
## 630 Res620 5 4 4.00000 2.00000 3.000000 4.000000 4 4
## 631 Res621 6 6 5.00000 5.00000 6.000000 5.000000 6 6
## 632 Res622 6 6 6.00000 5.00000 5.000000 4.000000 4 6
## 633 Res623 6 5 5.00000 2.00000 3.000000 5.000000 4 6
## 634 Res624 7 1 7.00000 7.00000 7.000000 7.000000 7 7
## 635 Res625 6 6 6.00000 6.00000 6.000000 4.000000 6 6
## 636 Res626 6 5 5.00000 2.00000 5.000000 5.000000 5 7
## 637 Res627 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 638 Res628 6 6 6.00000 6.00000 5.000000 5.000000 5 6
## 639 Res629 5 6 6.00000 5.00000 5.000000 6.000000 6 7
## 641 Res630 7 6 7.00000 5.00000 5.000000 5.000000 5 6
## 642 Res631 6 5 5.00000 4.00000 5.000000 2.000000 4 5
## 643 Res632 4 5 6.00000 4.00000 5.000000 4.000000 4 5
## 644 Res633 7 6 6.00000 7.00000 6.000000 4.000000 4 7
## 762 Res74 3 4 3.00000 3.00000 4.000000 4.000000 2 5
## 773 Res75 3 2 2.00000 2.00000 2.000000 5.000000 5 4
## 784 Res76 4 4 4.00000 2.00000 2.000000 6.000000 5 4
## 788 Res763 7 7 7.00000 7.00000 7.000000 6.000000 6 7
## 789 Res764 5 5 3.00000 1.00000 1.000000 2.000000 3 3
## 790 Res765 6 6 4.00000 3.00000 4.000000 4.000000 4 4
## 791 Res766 5 4 4.00000 3.00000 3.000000 5.000000 5 5
## 792 Res767 6 5 6.00000 6.00000 5.000000 5.000000 5 6
## 793 Res768 4 4 4.00000 4.00000 4.000000 4.000000 4 4
## 794 Res769 6 5 6.00000 4.00000 5.000000 5.000000 5 7
## 795 Res77 6 6 6.00000 6.00000 5.000000 4.000000 6 3
## 796 Res770 7 6 7.00000 3.00000 4.000000 5.000000 5 6
## 797 Res771 6 6 6.00000 1.00000 4.000000 5.000000 4 6
## 798 Res772 5 5 5.00000 5.00000 5.000000 4.000000 2 3
## 799 Res773 7 7 7.00000 4.00000 6.000000 7.000000 6 7
## 800 Res774 7 7 6.00000 5.00000 6.000000 5.000000 6 7
## 801 Res775 4 6 1.00000 1.00000 1.000000 4.000000 2 3
## 802 Res776 4 5 5.00000 2.00000 5.000000 4.000000 2 5
## 803 Res777 6 6 6.00000 3.00000 5.000000 7.000000 6 7
## 804 Res778 6 6 5.00000 5.00000 5.000000 6.000000 6 7
## 805 Res779 4 3 4.00000 3.00000 3.000000 2.000000 1 5
## 806 Res78 7 6 7.00000 7.00000 7.000000 7.000000 5 3
## 807 Res780 6 6 7.00000 6.00000 5.000000 7.000000 6 7
## 817 Res79 5 5 5.00000 4.00000 4.000000 6.000000 3 5
## 829 Res80 6 6 6.00000 5.00000 5.000000 5.000000 5 5
## 840 Res81 6 6 5.00000 3.00000 4.000000 6.000000 2 5
## 851 Res82 6 6 7.00000 6.00000 7.000000 6.000000 1 6
## 862 Res83 6 6 7.00000 6.00000 6.000000 4.000000 6 3
## 873 Res84 6 6 6.00000 6.00000 4.946514 4.830622 5 5
## 884 Res85 7 6 7.00000 7.00000 6.000000 6.000000 5 3
## 895 Res86 7 7 7.00000 7.00000 6.000000 6.000000 2 5
## 906 Res87 4 4 4.00000 3.00000 4.000000 4.000000 6 2
## 917 Res88 7 7 5.37799 4.57512 7.000000 7.000000 5 7
## 928 Res89 7 7 6.00000 7.00000 6.000000 6.000000 1 7
## 934 Res895 6 5 5.00000 4.00000 3.000000 5.000000 5 7
## 935 Res896 4 4 4.00000 1.00000 2.000000 2.000000 2 7
## 936 Res897 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 937 Res898 3 4 4.00000 4.00000 6.000000 7.000000 6 7
## 938 Res899 6 6 6.00000 6.00000 6.000000 4.000000 4 4
## 940 Res90 6 6 6.00000 7.00000 7.000000 6.000000 5 3
## 941 Res900 6 5 5.00000 2.00000 4.000000 3.000000 5 7
## 942 Res901 5 5 4.00000 3.00000 2.000000 5.000000 5 5
## 943 Res902 3 4 4.00000 2.00000 3.000000 2.000000 4 6
## 944 Res903 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 945 Res904 6 6 6.00000 5.00000 5.000000 5.000000 5 6
## 946 Res905 7 7 7.00000 7.00000 7.000000 7.000000 7 7
## 947 Res906 4 6 7.00000 4.00000 5.000000 4.000000 4 6
## 948 Res907 6 6 6.00000 4.00000 4.000000 5.000000 5 7
## 949 Res908 6 6 5.00000 1.00000 4.000000 1.000000 1 7
## 950 Res909 6 7 7.00000 5.00000 4.000000 6.000000 5 7
## 951 Res91 7 7 7.00000 6.00000 6.000000 6.000000 5 4
## 952 Res910 7 7 7.00000 6.00000 6.000000 5.000000 5 7
## 962 Res92 6 6 6.00000 5.00000 5.000000 6.000000 2 6
## 973 Res93 6 6 6.00000 6.00000 5.000000 5.000000 2 6
## 984 Res94 6 6 5.00000 3.00000 4.000000 5.000000 1 6
## 995 Res95 6 7 7.00000 6.00000 5.000000 6.000000 2 6
## 1033 Res984 6 6 7.00000 6.00000 6.000000 4.000000 6 6
## 1034 Res985 4 3 1.00000 1.00000 1.000000 4.000000 1 4
## 1035 Res986 4 5 4.00000 4.00000 4.000000 3.000000 4 4
## 1036 Res987 6 6 7.00000 5.00000 5.000000 5.000000 5 3
## 1037 Res988 6 6 7.00000 6.00000 5.000000 6.000000 6 6
## 1038 Res989 4 4 4.00000 1.00000 2.000000 4.000000 2 3
## 1040 Res990 6 6 7.00000 4.00000 5.000000 2.000000 4 3
## WOM_2 Futu_Pur_1 Futu_Pur_2 Valu_Percp_1 Valu_Percp_2 Pur_Proces_1
## 12 5.000000 6.000000 6 6 5 6.000000
## 13 7.000000 5.000000 5 5 4 4.000000
## 15 5.000000 6.000000 5 6 6 6.000000
## 16 6.000000 6.000000 5 5 6 7.000000
## 17 5.000000 4.000000 4 4 4 4.000000
## 18 6.000000 6.000000 6 6 5 4.000000
## 19 5.000000 5.000000 5 4 6 6.000000
## 20 7.000000 5.000000 5 5 3 3.000000
## 21 7.000000 6.000000 5 5 4 5.000000
## 22 7.000000 5.000000 5 5 4 4.000000
## 23 6.000000 6.000000 7 6 6 6.000000
## 76 7.000000 2.000000 2 1 5 4.000000
## 77 6.000000 7.000000 7 6 5 6.000000
## 78 4.000000 5.000000 6 5 5 5.000000
## 79 5.000000 5.000000 5 5 4 5.000000
## 80 6.000000 4.000000 5 4 4 4.000000
## 81 7.000000 6.000000 6 6 5 5.000000
## 82 5.000000 4.000000 4 4 4 4.000000
## 83 6.000000 4.000000 5 5 6 7.000000
## 84 6.000000 7.000000 7 6 6 6.000000
## 86 5.000000 6.000000 6 5 6 6.000000
## 328 3.000000 7.000000 7 7 6 6.000000
## 330 5.000000 7.000000 7 7 7 7.000000
## 331 5.000000 5.000000 3 2 5 6.000000
## 332 5.000000 6.000000 6 6 7 7.000000
## 333 2.000000 6.000000 7 7 7 7.000000
## 334 6.000000 3.000000 3 3 3 4.000000
## 335 6.000000 7.000000 7 7 6 6.000000
## 336 6.000000 2.000000 2 1 1 3.000000
## 337 5.000000 5.000000 6 4 6 6.000000
## 338 5.000000 7.000000 6 6 6 2.000000
## 339 6.000000 5.000000 6 5 5 6.000000
## 341 7.000000 6.000000 5 6 6 6.000000
## 342 7.000000 7.000000 7 6 6 7.000000
## 343 5.000000 4.000000 6 4 4 4.000000
## 344 6.000000 7.000000 6 6 5 4.000000
## 345 4.000000 6.000000 6 6 4 5.000000
## 346 3.000000 7.000000 6 5 7 7.000000
## 347 7.000000 6.000000 7 6 7 5.000000
## 437 6.000000 1.000000 5 5 5 4.000000
## 438 5.000000 3.000000 3 7 5 6.000000
## 439 5.000000 4.000000 4 4 3 5.000000
## 441 5.000000 6.000000 7 6 6 6.000000
## 442 5.000000 7.000000 6 6 7 7.000000
## 443 4.000000 7.000000 7 7 7 5.000000
## 489 4.000000 7.000000 6 6 7 6.000000
## 490 4.000000 7.000000 7 5 6 6.000000
## 491 5.000000 4.000000 4 4 6 5.000000
## 492 6.000000 4.000000 4 4 6 6.000000
## 493 7.000000 2.000000 2 7 7 7.000000
## 494 3.000000 7.000000 6 5 6 6.000000
## 497 6.000000 6.000000 7 6 7 6.000000
## 498 7.000000 7.000000 7 7 5 6.000000
## 499 5.000000 4.000000 3 3 4 5.000000
## 500 6.000000 5.000000 4 5 5 5.000000
## 501 5.000000 6.000000 5 6 6 6.000000
## 502 5.000000 4.000000 6 6 5 6.000000
## 503 4.000000 6.000000 7 7 7 6.000000
## 504 6.000000 4.000000 4 2 4 4.000000
## 505 5.000000 4.000000 4 6 6 6.000000
## 506 5.000000 4.000000 4 4 4 5.000000
## 508 5.000000 5.000000 6 5 6 6.000000
## 509 6.000000 6.000000 6 6 6 6.000000
## 510 6.000000 6.000000 7 7 6 7.000000
## 511 2.000000 6.000000 6 6 5 5.000000
## 512 7.000000 7.000000 6 6 6 6.000000
## 513 6.000000 4.000000 3 4 4 6.000000
## 514 5.000000 6.000000 6 6 6 7.000000
## 515 7.000000 6.000000 6 5 6 6.000000
## 516 1.000000 4.000000 4 6 6 6.000000
## 517 4.000000 6.000000 6 5 5 5.000000
## 519 1.000000 7.000000 7 6 7 6.000000
## 619 4.000000 6.000000 6 6 6 6.000000
## 620 6.000000 6.000000 6 6 6 6.000000
## 621 6.000000 3.000000 3 7 7 7.000000
## 622 5.000000 5.000000 5 5 4 5.000000
## 623 6.000000 6.000000 6 5 6 5.000000
## 624 4.000000 6.000000 6 6 6 6.000000
## 625 4.000000 6.000000 4 6 4 6.000000
## 626 4.000000 5.000000 3 4 4 5.000000
## 627 7.000000 3.000000 3 3 3 5.000000
## 628 7.000000 4.000000 4 4 5 6.000000
## 630 4.000000 6.000000 6 6 6 6.000000
## 631 6.000000 5.000000 6 6 1 2.000000
## 632 5.000000 1.000000 1 2 1 2.000000
## 633 5.000000 7.000000 6 5 6 6.000000
## 634 7.000000 4.000000 3 5 6 5.000000
## 635 6.000000 4.000000 4 4 5 5.000000
## 636 5.000000 6.000000 7 6 5 6.000000
## 637 4.000000 5.000000 6 7 6 6.000000
## 638 6.000000 4.000000 4 4 4 4.000000
## 639 5.000000 5.000000 6 5 6 5.000000
## 641 5.000000 6.000000 7 7 6 5.000000
## 642 5.000000 6.000000 6 6 7 6.000000
## 643 4.000000 6.000000 6 6 7 7.000000
## 644 7.000000 4.000000 4 5 3 4.000000
## 762 5.000000 5.000000 7 7 6 6.000000
## 773 4.000000 6.000000 7 6 7 7.000000
## 784 4.000000 6.000000 7 7 7 7.000000
## 788 6.000000 5.000000 6 5 5 4.000000
## 789 3.000000 4.000000 4 7 6 7.000000
## 790 5.000000 6.000000 6 6 7 6.000000
## 791 5.000000 5.000000 5 6 5 5.000000
## 792 7.000000 6.000000 6 6 6 6.000000
## 793 4.000000 5.000000 4 5 6 5.000000
## 794 7.000000 6.000000 6 7 6 5.000000
## 795 4.000000 5.000000 5 5 4 5.000000
## 796 6.000000 6.000000 7 6 6 7.000000
## 797 6.000000 6.000000 6 6 6 6.000000
## 798 5.000000 6.000000 7 7 7 6.000000
## 799 7.000000 6.000000 5 5 6 5.000000
## 800 7.000000 5.000000 6 5 7 6.000000
## 801 1.000000 7.000000 7 6 6 6.000000
## 802 3.000000 5.000000 5 5 4 4.000000
## 803 7.000000 7.000000 7 7 7 7.000000
## 804 7.000000 4.000000 4 4 4 5.000000
## 805 7.000000 5.000000 6 5 3 4.000000
## 806 4.000000 6.000000 7 6 7 5.256214
## 807 7.000000 5.000000 4 5 5 5.000000
## 817 3.000000 7.000000 7 6 6 6.000000
## 829 5.000000 6.000000 6 6 5 5.000000
## 840 5.000000 4.000000 6 5 4 1.000000
## 851 6.000000 6.000000 7 4 4 7.000000
## 862 4.000000 6.000000 7 6 6 6.000000
## 873 5.349904 5.320881 6 6 5 5.000000
## 884 4.000000 5.000000 7 5 7 7.000000
## 895 5.000000 3.000000 4 4 2 3.000000
## 906 3.000000 5.000000 5 5 6 4.000000
## 917 6.000000 5.320881 5 5 4 5.000000
## 928 7.000000 6.000000 7 3 6 7.000000
## 934 7.000000 6.000000 6 6 6 6.000000
## 935 7.000000 3.000000 3 4 2 6.000000
## 936 7.000000 7.000000 7 7 5 5.000000
## 937 6.000000 3.000000 3 7 3 6.000000
## 938 6.000000 4.000000 4 6 6 6.000000
## 940 3.000000 4.000000 5 4 5 3.000000
## 941 5.000000 6.000000 6 6 6 6.000000
## 942 5.000000 5.000000 4 6 6 6.000000
## 943 7.000000 6.000000 7 6 6 6.000000
## 944 7.000000 6.000000 6 6 6 6.000000
## 945 6.000000 6.000000 6 6 6 6.000000
## 946 7.000000 6.000000 6 4 5 6.000000
## 947 5.000000 4.000000 4 7 2 5.000000
## 948 6.000000 2.000000 6 6 6 6.000000
## 949 7.000000 7.000000 7 7 3 6.000000
## 950 7.000000 6.000000 6 6 6 6.000000
## 951 4.000000 6.000000 6 6 7 7.000000
## 952 5.000000 6.000000 2 2 3 6.000000
## 962 6.000000 6.000000 6 4 6 6.000000
## 973 7.000000 6.000000 7 6 7 7.000000
## 984 6.000000 5.000000 7 3 6 6.000000
## 995 7.000000 5.000000 5 4 3 3.000000
## 1033 6.000000 6.000000 6 6 5 5.000000
## 1034 4.000000 5.000000 6 6 6 7.000000
## 1035 3.000000 6.000000 6 6 3 3.000000
## 1036 3.000000 5.000000 5 5 6 4.000000
## 1037 6.000000 6.000000 6 5 7 4.000000
## 1038 3.000000 6.000000 5 7 5 5.000000
## 1040 4.000000 4.000000 4 5 5 6.000000
## Pur_Proces_2 Residence Pay_Meth Insur_Type Gender Age Education
## 12 6 2 3 Liability Female 29 2
## 13 3 1 3 Collision Female 32 2
## 15 6 1 1 Collision Female 32 2
## 16 7 2 1 Collision Female 32 2
## 17 4 2 1 Collision Female 32 2
## 18 4 2 1 Collision Female 34 2
## 19 6 1 1 Collision Female 34 2
## 20 6 2 3 Collision Female 34 2
## 21 6 2 1 Collision Female 34 3
## 22 4 2 1 Collision Female 35 3
## 23 6 2 1 Collision Female 35 1
## 76 1 2 3 Liability Male 48 2
## 77 5 1 3 Liability Male 49 3
## 78 4 2 3 Liability Female 49 2
## 79 3 1 3 Liability Male 50 2
## 80 2 2 2 Liability Female 52 2
## 81 2 1 2 Liability Male 53 1
## 82 4 1 2 Liability Female 53 2
## 83 2 2 2 Liability Male 53 2
## 84 5 2 1 Liability Female 54 2
## 86 6 1 1 Collision Female 55 2
## 328 6 2 2 Liability Female 60 2
## 330 2 2 2 Liability Female 18 1
## 331 3 1 2 Liability Female 18 2
## 332 2 1 2 Liability Female 18 2
## 333 2 1 2 Liability Female 19 1
## 334 2 1 3 Liability Female 19 2
## 335 5 1 2 Liability Female 19 2
## 336 1 1 2 Liability Female 19 3
## 337 4 2 2 Liability Male 19 1
## 338 6 1 2 Liability Female 21 2
## 339 2 1 2 Liability Female 21 2
## 341 2 1 2 Collision Female 21 1
## 342 2 1 2 Collision Female 21 2
## 343 2 1 2 Collision Female 21 1
## 344 2 1 2 Collision Female 22 2
## 345 5 1 2 Collision Female 23 1
## 346 2 1 2 Collision Female 23 1
## 347 6 2 2 Collision Female 23 2
## 437 5 1 3 Comprehensive Male 27 2
## 438 6 1 3 Comprehensive Male 29 2
## 439 5 1 3 Comprehensive Female 32 2
## 441 5 1 3 Comprehensive Male 32 2
## 442 7 2 3 Comprehensive Male 32 2
## 443 7 1 3 Comprehensive Female 32 1
## 489 7 1 2 Collision Female 19 2
## 490 7 1 2 Collision Female 19 2
## 491 5 2 2 Collision Female 19 2
## 492 6 1 2 Collision Female 19 2
## 493 7 2 2 Collision Female 21 2
## 494 6 1 2 Liability Male 21 2
## 497 6 1 2 Liability Female 21 2
## 498 7 2 2 Liability Female 21 2
## 499 5 2 2 Liability Female 21 1
## 500 5 1 2 Liability Female 22 3
## 501 6 1 1 Liability Female 23 2
## 502 6 1 1 Liability Female 23 2
## 503 6 1 1 Liability Female 23 2
## 504 2 2 1 Collision Female 23 2
## 505 6 2 2 Collision Female 24 2
## 506 2 1 2 Collision Female 24 2
## 508 6 2 2 Collision Female 24 2
## 509 6 1 2 Collision Male 24 2
## 510 6 1 2 Collision Male 25 2
## 511 6 1 2 Collision Female 26 3
## 512 6 2 2 Collision Male 26 2
## 513 6 2 2 Collision Female 27 2
## 514 5 1 2 Collision Male 27 1
## 515 7 2 2 Collision Female 27 2
## 516 7 2 2 Collision Male 29 2
## 517 5 1 1 Collision Female 32 2
## 519 6 1 1 Collision Female 32 2
## 619 6 1 3 Liability Female 46 2
## 620 6 1 3 Liability Female 48 3
## 621 2 1 3 Liability Female 49 3
## 622 2 2 3 Liability Female 49 2
## 623 2 2 3 Liability Female 50 1
## 624 2 2 3 Liability Female 52 3
## 625 2 2 3 Liability Female 53 3
## 626 2 1 3 Liability Male 53 3
## 627 2 1 3 Liability Female 53 1
## 628 2 1 3 Liability Female 54 1
## 630 6 1 3 Liability Female 55 1
## 631 2 2 3 Collision Female 55 2
## 632 2 1 3 Collision Female 55 1
## 633 1 2 3 Collision Female 56 3
## 634 5 1 3 Collision Female 57 3
## 635 5 1 3 Collision Female 57 3
## 636 5 1 3 Collision Female 57 3
## 637 6 1 3 Collision Female 57 1
## 638 4 1 3 Collision Female 60 2
## 639 5 1 3 Collision Male 60 3
## 641 6 1 1 Collision Female 18 3
## 642 6 1 1 Collision Female 18 2
## 643 6 2 1 Collision Female 18 3
## 644 5 1 2 Collision Female 19 1
## 762 7 2 2 Liability Male 19 2
## 773 3 2 2 Female 19 1
## 784 7 2 3 Liability Female 19 2
## 788 4 1 2 Collision Female 56 3
## 789 6 2 2 Collision Female 57 3
## 790 6 2 2 Collision Female 57 3
## 791 5 1 2 Collision Female 57 3
## 792 7 1 2 Collision Female 57 3
## 793 7 1 2 Collision Female 60 3
## 794 5 1 1 Collision Female 60 3
## 795 5 1 3 Liability Male 19 2
## 796 5 1 1 Collision Female 18 3
## 797 5 2 1 Collision Male 18 3
## 798 6 1 1 Collision Male 18 3
## 799 6 1 1 Collision Female 19 3
## 800 7 1 1 Collision Male 19 3
## 801 7 1 1 Collision Female 19 3
## 802 4 2 1 Collision Male 19 3
## 803 6 1 1 Collision Female 19 3
## 804 5 2 3 Collision Male 21 3
## 805 5 1 3 Collision Female 21 3
## 806 7 2 3 Liability Male 21 2
## 807 5 1 3 Collision Female 21 3
## 817 6 2 3 Liability Female 21 2
## 829 6 1 3 Collision Female 21 2
## 840 3 1 3 Collision Male 21 2
## 851 5 2 3 Collision Female 21 3
## 862 4 2 2 Collision Male 22 2
## 873 6 2 1 Collision Male 23 2
## 884 2 2 1 Collision Female 23 1
## 895 4 2 1 Collision Male 23 1
## 906 4 1 1 Collision Female 23 3
## 917 5 1 2 Collision Female 24 1
## 928 6 1 2 Collision Female 24 2
## 934 6 1 3 Liability Female 52 3
## 935 6 1 3 Liability Female 53 1
## 936 7 2 3 Liability Female 53 3
## 937 5 1 3 Liability Female 53 2
## 938 6 1 3 Liability Female 54 1
## 940 5 1 2 Collision Female 24 2
## 941 6 1 3 Liability Female 55 3
## 942 5 1 3 Liability Male 55 3
## 943 6 2 1 Liability Male 55 3
## 944 6 1 1 Liability Female 56 1
## 945 6 2 1 Liability Male 57 1
## 946 5 2 1 Liability Female 57 2
## 947 6 1 1 Collision Male 57 1
## 948 4 1 1 Collision Female 57 2
## 949 6 1 1 Collision Male 60 1
## 950 6 1 1 Collision Female 60 1
## 951 3 1 2 Collision Female 24 1
## 952 4 1 1 Collision Female 18 1
## 962 3 1 2 Collision Female 25 2
## 973 6 2 1 Collision Female 26 1
## 984 6 2 1 Collision Female 26 2
## 995 4 2 1 Collision Female 27 2
## 1033 5 1 3 Collision Male 19 2
## 1034 6 1 3 Collision Female 19 1
## 1035 6 2 3 Collision Female 19 1
## 1036 6 2 3 Collision Male 19 1
## 1037 7 2 1 Collision Male 21 2
## 1038 6 2 1 Collision Female 21 2
## 1040 6 2 3 Collision Female 21 2
## Region Model MPG Cyl acc1 C_cost. H_Cost Post.Satis Make
## 12 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 13 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 15 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 16 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 17 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 18 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 19 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 20 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 21 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 22 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 23 American Honda Pilot 20 6 6.5 12 10 6 Honda
## 76 American Honda CRV 26 4 8.5 8 7 5 Honda
## 77 American Honda CRV 26 4 8.5 8 7 7 Honda
## 78 American Honda CRV 26 4 8.5 8 7 6 Honda
## 79 American Honda CRV 26 4 8.5 8 7 6 Honda
## 80 American Honda CRV 26 4 8.5 8 7 5 Honda
## 81 European Honda CRV 26 4 8.5 8 7 6 Honda
## 82 European Honda CRV 26 4 8.5 8 7 5 Honda
## 83 European Honda CRV 26 4 8.5 8 7 5 Honda
## 84 European Honda CRV 26 4 8.5 8 7 5 Honda
## 86 European Honda CRV 26 4 8.5 8 7 6 Honda
## 328 American Honda CRV 26 4 8.5 8 7 7 Honda
## 330 American Honda CRV 26 4 8.5 8 7 6 Honda
## 331 American Honda CRV 26 4 8.5 8 7 6 Honda
## 332 American Honda CRV 26 4 8.5 8 7 6 Honda
## 333 American Honda CRV 26 4 8.5 8 7 6 Honda
## 334 American Honda CRV 26 4 8.5 8 7 5 Honda
## 335 American Honda CRV 26 4 8.5 8 7 6 Honda
## 336 American Honda CRV 26 4 8.5 8 7 4 Honda
## 337 European Honda CRV 26 4 8.5 8 7 5 Honda
## 338 European Honda CRV 26 4 8.5 8 7 6 Honda
## 339 European Honda CRV 26 4 8.5 8 7 6 Honda
## 341 European Honda CRV 26 4 8.5 8 7 5 Honda
## 342 European Honda CRV 26 4 8.5 8 7 7 Honda
## 343 European Honda CRV 26 4 8.5 8 7 6 Honda
## 344 European Honda CRV 26 4 8.5 8 7 7 Honda
## 345 European Honda CRV 26 4 8.5 8 7 6 Honda
## 346 European Honda CRV 26 4 8.5 8 7 6 Honda
## 347 European Honda CRV 26 4 8.5 8 7 6 Honda
## 437 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 438 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 439 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 441 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 442 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 443 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 489 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 490 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 491 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 492 Asian Honda CRV 26 4 8.5 8 7 3 Honda
## 493 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 494 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 497 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 498 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 499 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 500 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 501 Asian Honda CRV 26 4 8.5 8 7 5 Honda
## 502 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 503 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 504 European Honda CRV 26 4 8.5 8 7 4 Honda
## 505 European Honda CRV 26 4 8.5 8 7 6 Honda
## 506 European Honda CRV 26 4 8.5 8 7 5 Honda
## 508 European Honda CRV 26 4 8.5 8 7 6 Honda
## 509 European Honda CRV 26 4 8.5 8 7 6 Honda
## 510 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 511 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 512 European Honda Pilot 20 6 6.5 12 10 7 Honda
## 513 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 514 European Honda Pilot 20 6 6.5 12 10 4 Honda
## 515 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 516 European Honda Pilot 20 6 6.5 12 10 5 Honda
## 517 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 519 European Honda Pilot 20 6 6.5 12 10 6 Honda
## 619 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 620 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 621 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 622 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 623 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 624 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 625 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 626 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 627 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 628 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 630 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 631 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 632 Asian Honda Pilot 20 6 6.5 12 10 2 Honda
## 633 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 634 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 635 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 636 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 637 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 638 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 639 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 641 American Honda Pilot 20 6 6.5 12 10 4 Honda
## 642 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 643 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 644 American Honda Pilot 20 6 6.5 12 10 5 Honda
## 762 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 773 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 784 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 788 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 789 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 790 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 791 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## 792 Asian Honda Pilot 20 6 6.5 12 10 6 Honda
## 793 Asian Honda Pilot 20 6 6.5 12 10 4 Honda
## 794 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 795 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 796 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 797 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 798 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 799 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 800 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 801 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 802 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 803 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 804 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 805 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 806 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 807 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 817 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 829 Asian Honda CRV 26 4 8.5 8 7 7 Honda
## 840 Asian Honda CRV 26 4 8.5 8 7 4 Honda
## 851 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 862 Asian Honda CRV 26 4 8.5 8 7 6 Honda
## 873 American Honda CRV 26 4 8.5 8 7 4 Honda
## 884 American Honda CRV 26 4 8.5 8 7 6 Honda
## 895 American Honda CRV 26 4 8.5 8 7 3 Honda
## 906 American Honda CRV 26 4 8.5 8 7 6 Honda
## 917 American Honda CRV 26 4 8.5 8 7 4 Honda
## 928 American Honda CRV 26 4 8.5 8 7 4 Honda
## 934 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 935 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 936 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 937 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 938 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 940 American Honda CRV 26 4 8.5 8 7 5 Honda
## 941 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 942 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 943 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 944 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 945 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 946 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 947 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 948 Middle Eastern Honda Pilot 20 6 6.5 12 10 4 Honda
## 949 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 950 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 951 American Honda CRV 26 4 8.5 8 7 5 Honda
## 952 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 962 American Honda CRV 26 4 8.5 8 7 4 Honda
## 973 American Honda CRV 26 4 8.5 8 7 5 Honda
## 984 American Honda CRV 26 4 8.5 8 7 7 Honda
## 995 American Honda CRV 26 4 8.5 8 7 5 Honda
## 1033 Middle Eastern Honda Pilot 20 6 6.5 12 10 7 Honda
## 1034 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1035 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1036 Middle Eastern Honda Pilot 20 6 6.5 12 10 5 Honda
## 1037 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1038 Middle Eastern Honda Pilot 20 6 6.5 12 10 6 Honda
## 1040 Asian Honda Pilot 20 6 6.5 12 10 5 Honda
## Model_v1 Attitude Parent Enjoyment Perform Word_of_Mouth
## 12 Pilot 5.0 Honda 4.000000 4.333333 5.000000
## 13 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 15 Pilot 7.0 Honda 5.500000 5.000000 5.000000
## 16 Pilot 7.0 Honda 4.500000 4.333333 6.000000
## 17 Pilot 6.0 Honda 6.000000 4.000000 5.000000
## 18 Pilot 4.0 Honda 3.000000 2.666667 6.500000
## 19 Pilot 5.0 Honda 4.500000 4.333333 5.000000
## 20 Pilot 4.5 Honda 5.000000 5.333333 7.000000
## 21 Pilot 6.0 Honda 7.000000 6.333333 7.000000
## 22 Pilot 6.0 Honda 6.000000 5.333333 7.000000
## 23 Pilot 3.5 Honda 3.000000 4.000000 6.500000
## 76 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 77 CRV 6.5 Honda 4.500000 4.333333 5.500000
## 78 CRV 7.0 Honda 7.000000 6.333333 4.000000
## 79 CRV 7.0 Honda 7.000000 5.666667 5.500000
## 80 CRV 6.0 Honda 4.500000 5.000000 6.000000
## 81 CRV 6.0 Honda 5.500000 4.000000 7.000000
## 82 CRV 6.0 Honda 5.500000 4.333333 5.500000
## 83 CRV 6.0 Honda 4.000000 5.000000 6.000000
## 84 CRV 7.0 Honda 7.000000 5.333333 6.000000
## 86 CRV 5.0 Honda 4.000000 4.000000 5.000000
## 328 CRV 6.5 Honda 6.500000 5.333333 3.500000
## 330 CRV 4.0 Honda 6.000000 5.333333 5.000000
## 331 CRV 4.0 Honda 4.500000 5.000000 5.000000
## 332 CRV 5.0 Honda 4.500000 5.666667 5.500000
## 333 CRV 5.5 Honda 6.500000 6.000000 2.000000
## 334 CRV 6.5 Honda 7.000000 5.000000 6.000000
## 335 CRV 3.5 Honda 4.000000 4.666667 6.000000
## 336 CRV 4.0 Honda 5.500000 4.000000 6.000000
## 337 CRV 4.0 Honda 6.000000 5.000000 5.000000
## 338 CRV 4.0 Honda 7.000000 7.000000 5.000000
## 339 CRV 4.5 Honda 5.500000 4.666667 6.000000
## 341 CRV 3.5 Honda 5.500000 3.666667 7.000000
## 342 CRV 4.0 Honda 5.000000 4.333333 7.000000
## 343 CRV 4.0 Honda 7.000000 4.666667 5.000000
## 344 CRV 3.5 Honda 6.000000 4.666667 5.000000
## 345 CRV 4.5 Honda 5.500000 5.333333 3.500000
## 346 CRV 4.0 Honda 3.500000 3.333333 3.000000
## 347 CRV 4.0 Honda 7.000000 5.333333 7.000000
## 437 CRV 5.0 Honda 3.500000 5.666667 5.000000
## 438 CRV 5.5 Honda 5.500000 4.666667 5.000000
## 439 CRV 5.5 Honda 5.000000 5.333333 6.000000
## 441 CRV 4.0 Honda 3.500000 4.666667 5.500000
## 442 CRV 4.5 Honda 5.000000 5.333333 5.000000
## 443 CRV 4.0 Honda 7.000000 6.333333 4.500000
## 489 CRV 6.0 Honda 6.000000 5.000000 4.000000
## 490 CRV 6.0 Honda 6.000000 5.666667 4.000000
## 491 CRV 5.0 Honda 3.000000 3.333333 5.000000
## 492 CRV 6.5 Honda 6.500000 5.333333 6.000000
## 493 CRV 7.0 Honda 7.000000 6.333333 6.500000
## 494 CRV 6.0 Honda 5.000000 5.000000 3.000000
## 497 CRV 3.5 Honda 4.500000 4.000000 5.000000
## 498 CRV 7.0 Honda 6.500000 6.666667 7.000000
## 499 CRV 5.0 Honda 4.000000 4.666667 5.000000
## 500 CRV 6.0 Honda 6.000000 5.000000 5.500000
## 501 CRV 6.5 Honda 6.000000 4.666667 5.000000
## 502 CRV 7.0 Honda 6.500000 4.000000 5.000000
## 503 CRV 7.0 Honda 7.000000 5.000000 4.000000
## 504 CRV 6.0 Honda 5.000000 5.666667 6.000000
## 505 CRV 5.5 Honda 5.500000 3.666667 5.000000
## 506 CRV 5.5 Honda 5.000000 4.666667 5.000000
## 508 CRV 7.0 Honda 7.000000 6.000000 5.000000
## 509 CRV 7.0 Honda 6.500000 4.333333 5.500000
## 510 Pilot 6.0 Honda 4.500000 4.666667 6.000000
## 511 Pilot 6.0 Honda 5.500000 3.000000 2.000000
## 512 Pilot 6.0 Honda 7.000000 6.000000 7.000000
## 513 Pilot 6.0 Honda 6.000000 5.666667 5.500000
## 514 Pilot 6.0 Honda 5.000000 4.333333 5.000000
## 515 Pilot 7.0 Honda 7.000000 6.666667 7.000000
## 516 Pilot 6.5 Honda 1.000000 2.666667 1.000000
## 517 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 519 Pilot 5.5 Honda 3.000000 2.333333 2.000000
## 619 Pilot 5.0 Honda 3.500000 2.333333 4.500000
## 620 Pilot 6.5 Honda 4.500000 4.666667 6.500000
## 621 Pilot 5.0 Honda 6.500000 5.333333 6.000000
## 622 Pilot 6.5 Honda 6.500000 6.666667 5.500000
## 623 Pilot 6.5 Honda 6.000000 4.000000 6.000000
## 624 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 625 Pilot 6.0 Honda 6.000000 5.666667 5.000000
## 626 Pilot 6.5 Honda 5.500000 4.666667 5.000000
## 627 Pilot 4.0 Honda 5.000000 6.333333 7.000000
## 628 Pilot 4.5 Honda 2.000000 4.333333 7.000000
## 630 Pilot 4.5 Honda 3.000000 3.666667 4.000000
## 631 Pilot 6.0 Honda 5.000000 5.666667 6.000000
## 632 Pilot 6.0 Honda 5.500000 4.333333 5.500000
## 633 Pilot 5.5 Honda 3.500000 4.000000 5.500000
## 634 Pilot 4.0 Honda 7.000000 7.000000 7.000000
## 635 Pilot 6.0 Honda 6.000000 5.333333 6.000000
## 636 Pilot 5.5 Honda 3.500000 5.000000 6.000000
## 637 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 638 Pilot 6.0 Honda 6.000000 5.000000 6.000000
## 639 Pilot 5.5 Honda 5.500000 5.666667 6.000000
## 641 Pilot 6.5 Honda 6.000000 5.000000 5.500000
## 642 Pilot 5.5 Honda 4.500000 3.666667 5.000000
## 643 Pilot 4.5 Honda 5.000000 4.333333 4.500000
## 644 Pilot 6.5 Honda 6.500000 4.666667 7.000000
## 762 CRV 3.5 Honda 3.000000 3.333333 5.000000
## 773 CRV 2.5 Honda 2.000000 4.000000 4.000000
## 784 CRV 4.0 Honda 3.000000 4.333333 4.000000
## 788 Pilot 7.0 Honda 7.000000 6.333333 6.500000
## 789 Pilot 5.0 Honda 2.000000 2.000000 3.000000
## 790 Pilot 6.0 Honda 3.500000 4.000000 4.500000
## 791 Pilot 4.5 Honda 3.500000 4.333333 5.000000
## 792 Pilot 5.5 Honda 6.000000 5.000000 6.500000
## 793 Pilot 4.0 Honda 4.000000 4.000000 4.000000
## 794 Pilot 5.5 Honda 5.000000 5.000000 7.000000
## 795 CRV 6.0 Honda 6.000000 5.000000 3.500000
## 796 Pilot 6.5 Honda 5.000000 4.666667 6.000000
## 797 Pilot 6.0 Honda 3.500000 4.333333 6.000000
## 798 Pilot 5.0 Honda 5.000000 3.666667 4.000000
## 799 Pilot 7.0 Honda 5.500000 6.333333 7.000000
## 800 Pilot 7.0 Honda 5.500000 5.666667 7.000000
## 801 Pilot 5.0 Honda 1.000000 2.333333 2.000000
## 802 Pilot 4.5 Honda 3.500000 3.666667 4.000000
## 803 Pilot 6.0 Honda 4.500000 6.000000 7.000000
## 804 Pilot 6.0 Honda 5.000000 5.666667 7.000000
## 805 Pilot 3.5 Honda 3.500000 2.000000 6.000000
## 806 CRV 6.5 Honda 7.000000 6.333333 3.500000
## 807 Pilot 6.0 Honda 6.500000 6.000000 7.000000
## 817 CRV 5.0 Honda 4.500000 4.333333 4.000000
## 829 CRV 6.0 Honda 5.500000 5.000000 5.000000
## 840 CRV 6.0 Honda 4.000000 4.000000 5.000000
## 851 CRV 6.0 Honda 6.500000 4.666667 6.000000
## 862 CRV 6.0 Honda 6.500000 5.333333 3.500000
## 873 CRV 6.0 Honda 6.000000 4.925712 5.174952
## 884 CRV 6.5 Honda 7.000000 5.666667 3.500000
## 895 CRV 7.0 Honda 7.000000 4.666667 5.000000
## 906 CRV 4.0 Honda 3.500000 4.666667 2.500000
## 917 CRV 7.0 Honda 4.976555 6.333333 6.500000
## 928 CRV 7.0 Honda 6.500000 4.333333 7.000000
## 934 Pilot 5.5 Honda 4.500000 4.333333 7.000000
## 935 Pilot 4.0 Honda 2.500000 2.000000 7.000000
## 936 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 937 Pilot 3.5 Honda 4.000000 6.333333 6.500000
## 938 Pilot 6.0 Honda 6.000000 4.666667 5.000000
## 940 CRV 6.0 Honda 6.500000 6.000000 3.000000
## 941 Pilot 5.5 Honda 3.500000 4.000000 6.000000
## 942 Pilot 5.0 Honda 3.500000 4.000000 5.000000
## 943 Pilot 3.5 Honda 3.000000 3.000000 6.500000
## 944 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 945 Pilot 6.0 Honda 5.500000 5.000000 6.000000
## 946 Pilot 7.0 Honda 7.000000 7.000000 7.000000
## 947 Pilot 5.0 Honda 5.500000 4.333333 5.500000
## 948 Pilot 6.0 Honda 5.000000 4.666667 6.500000
## 949 Pilot 6.0 Honda 3.000000 2.000000 7.000000
## 950 Pilot 6.5 Honda 6.000000 5.000000 7.000000
## 951 CRV 7.0 Honda 6.500000 5.666667 4.000000
## 952 Pilot 7.0 Honda 6.500000 5.333333 6.000000
## 962 CRV 6.0 Honda 5.500000 4.333333 6.000000
## 973 CRV 6.0 Honda 6.000000 4.000000 6.500000
## 984 CRV 6.0 Honda 4.000000 3.333333 6.000000
## 995 CRV 6.5 Honda 6.500000 4.333333 6.500000
## 1033 Pilot 6.0 Honda 6.500000 5.333333 6.000000
## 1034 Pilot 3.5 Honda 1.000000 2.000000 4.000000
## 1035 Pilot 4.5 Honda 4.000000 3.666667 3.500000
## 1036 Pilot 6.0 Honda 6.000000 5.000000 3.000000
## 1037 Pilot 6.0 Honda 6.500000 5.666667 6.000000
## 1038 Pilot 4.0 Honda 2.500000 2.666667 3.000000
## 1040 Pilot 6.0 Honda 5.500000 3.666667 3.500000
## Future_Purchase_Intention Value_Perception Purchase_Process Gender_numeric
## 12 6.000000 5.5 6.000000 1
## 13 5.000000 4.5 3.500000 1
## 15 5.500000 6.0 6.000000 1
## 16 5.500000 5.5 7.000000 1
## 17 4.000000 4.0 4.000000 1
## 18 6.000000 5.5 4.000000 1
## 19 5.000000 5.0 6.000000 1
## 20 5.000000 4.0 4.500000 1
## 21 5.500000 4.5 5.500000 1
## 22 5.000000 4.5 4.000000 1
## 23 6.500000 6.0 6.000000 1
## 76 2.000000 3.0 2.500000 0
## 77 7.000000 5.5 5.500000 0
## 78 5.500000 5.0 4.500000 1
## 79 5.000000 4.5 4.000000 0
## 80 4.500000 4.0 3.000000 1
## 81 6.000000 5.5 3.500000 0
## 82 4.000000 4.0 4.000000 1
## 83 4.500000 5.5 4.500000 0
## 84 7.000000 6.0 5.500000 1
## 86 6.000000 5.5 6.000000 1
## 328 7.000000 6.5 6.000000 1
## 330 7.000000 7.0 4.500000 1
## 331 4.000000 3.5 4.500000 1
## 332 6.000000 6.5 4.500000 1
## 333 6.500000 7.0 4.500000 1
## 334 3.000000 3.0 3.000000 1
## 335 7.000000 6.5 5.500000 1
## 336 2.000000 1.0 2.000000 1
## 337 5.500000 5.0 5.000000 0
## 338 6.500000 6.0 4.000000 1
## 339 5.500000 5.0 4.000000 1
## 341 5.500000 6.0 4.000000 1
## 342 7.000000 6.0 4.500000 1
## 343 5.000000 4.0 3.000000 1
## 344 6.500000 5.5 3.000000 1
## 345 6.000000 5.0 5.000000 1
## 346 6.500000 6.0 4.500000 1
## 347 6.500000 6.5 5.500000 1
## 437 3.000000 5.0 4.500000 0
## 438 3.000000 6.0 6.000000 0
## 439 4.000000 3.5 5.000000 1
## 441 6.500000 6.0 5.500000 0
## 442 6.500000 6.5 7.000000 0
## 443 7.000000 7.0 6.000000 1
## 489 6.500000 6.5 6.500000 1
## 490 7.000000 5.5 6.500000 1
## 491 4.000000 5.0 5.000000 1
## 492 4.000000 5.0 6.000000 1
## 493 2.000000 7.0 7.000000 1
## 494 6.500000 5.5 6.000000 0
## 497 6.500000 6.5 6.000000 1
## 498 7.000000 6.0 6.500000 1
## 499 3.500000 3.5 5.000000 1
## 500 4.500000 5.0 5.000000 1
## 501 5.500000 6.0 6.000000 1
## 502 5.000000 5.5 6.000000 1
## 503 6.500000 7.0 6.000000 1
## 504 4.000000 3.0 3.000000 1
## 505 4.000000 6.0 6.000000 1
## 506 4.000000 4.0 3.500000 1
## 508 5.500000 5.5 6.000000 1
## 509 6.000000 6.0 6.000000 0
## 510 6.500000 6.5 6.500000 0
## 511 6.000000 5.5 5.500000 1
## 512 6.500000 6.0 6.000000 0
## 513 3.500000 4.0 6.000000 1
## 514 6.000000 6.0 6.000000 0
## 515 6.000000 5.5 6.500000 1
## 516 4.000000 6.0 6.500000 0
## 517 6.000000 5.0 5.000000 1
## 519 7.000000 6.5 6.000000 1
## 619 6.000000 6.0 6.000000 1
## 620 6.000000 6.0 6.000000 1
## 621 3.000000 7.0 4.500000 1
## 622 5.000000 4.5 3.500000 1
## 623 6.000000 5.5 3.500000 1
## 624 6.000000 6.0 4.000000 1
## 625 5.000000 5.0 4.000000 1
## 626 4.000000 4.0 3.500000 0
## 627 3.000000 3.0 3.500000 1
## 628 4.000000 4.5 4.000000 1
## 630 6.000000 6.0 6.000000 1
## 631 5.500000 3.5 2.000000 1
## 632 1.000000 1.5 2.000000 1
## 633 6.500000 5.5 3.500000 1
## 634 3.500000 5.5 5.000000 1
## 635 4.000000 4.5 5.000000 1
## 636 6.500000 5.5 5.500000 1
## 637 5.500000 6.5 6.000000 1
## 638 4.000000 4.0 4.000000 1
## 639 5.500000 5.5 5.000000 0
## 641 6.500000 6.5 5.500000 1
## 642 6.000000 6.5 6.000000 1
## 643 6.000000 6.5 6.500000 1
## 644 4.000000 4.0 4.500000 1
## 762 6.000000 6.5 6.500000 0
## 773 6.500000 6.5 5.000000 1
## 784 6.500000 7.0 7.000000 1
## 788 5.500000 5.0 4.000000 1
## 789 4.000000 6.5 6.500000 1
## 790 6.000000 6.5 6.000000 1
## 791 5.000000 5.5 5.000000 1
## 792 6.000000 6.0 6.500000 1
## 793 4.500000 5.5 6.000000 1
## 794 6.000000 6.5 5.000000 1
## 795 5.000000 4.5 5.000000 0
## 796 6.500000 6.0 6.000000 1
## 797 6.000000 6.0 5.500000 0
## 798 6.500000 7.0 6.000000 0
## 799 5.500000 5.5 5.500000 1
## 800 5.500000 6.0 6.500000 0
## 801 7.000000 6.0 6.500000 1
## 802 5.000000 4.5 4.000000 0
## 803 7.000000 7.0 6.500000 1
## 804 4.000000 4.0 5.000000 0
## 805 5.500000 4.0 4.500000 1
## 806 6.500000 6.5 6.128107 0
## 807 4.500000 5.0 5.000000 1
## 817 7.000000 6.0 6.000000 1
## 829 6.000000 5.5 5.500000 1
## 840 5.000000 4.5 2.000000 0
## 851 6.500000 4.0 6.000000 1
## 862 6.500000 6.0 5.000000 0
## 873 5.660441 5.5 5.500000 0
## 884 6.000000 6.0 4.500000 1
## 895 3.500000 3.0 3.500000 0
## 906 5.000000 5.5 4.000000 1
## 917 5.160441 4.5 5.000000 1
## 928 6.500000 4.5 6.500000 1
## 934 6.000000 6.0 6.000000 1
## 935 3.000000 3.0 6.000000 1
## 936 7.000000 6.0 6.000000 1
## 937 3.000000 5.0 5.500000 1
## 938 4.000000 6.0 6.000000 1
## 940 4.500000 4.5 4.000000 1
## 941 6.000000 6.0 6.000000 1
## 942 4.500000 6.0 5.500000 0
## 943 6.500000 6.0 6.000000 0
## 944 6.000000 6.0 6.000000 1
## 945 6.000000 6.0 6.000000 0
## 946 6.000000 4.5 5.500000 1
## 947 4.000000 4.5 5.500000 0
## 948 4.000000 6.0 5.000000 1
## 949 7.000000 5.0 6.000000 0
## 950 6.000000 6.0 6.000000 1
## 951 6.000000 6.5 5.000000 1
## 952 4.000000 2.5 5.000000 1
## 962 6.000000 5.0 4.500000 1
## 973 6.500000 6.5 6.500000 1
## 984 6.000000 4.5 6.000000 1
## 995 5.000000 3.5 3.500000 1
## 1033 6.000000 5.5 5.000000 0
## 1034 5.500000 6.0 6.500000 1
## 1035 6.000000 4.5 4.500000 1
## 1036 5.000000 5.5 5.000000 0
## 1037 6.000000 6.0 5.500000 0
## 1038 5.500000 6.0 5.500000 1
## 1040 4.000000 5.0 6.000000 1
## Insur_Type_numeric MPG_numeric
## 12 1 1
## 13 2 1
## 15 2 1
## 16 2 1
## 17 2 1
## 18 2 1
## 19 2 1
## 20 2 1
## 21 2 1
## 22 2 1
## 23 2 1
## 76 1 2
## 77 1 2
## 78 1 2
## 79 1 2
## 80 1 2
## 81 1 2
## 82 1 2
## 83 1 2
## 84 1 2
## 86 2 2
## 328 1 2
## 330 1 2
## 331 1 2
## 332 1 2
## 333 1 2
## 334 1 2
## 335 1 2
## 336 1 2
## 337 1 2
## 338 1 2
## 339 1 2
## 341 2 2
## 342 2 2
## 343 2 2
## 344 2 2
## 345 2 2
## 346 2 2
## 347 2 2
## 437 3 2
## 438 3 2
## 439 3 2
## 441 3 2
## 442 3 2
## 443 3 2
## 489 2 2
## 490 2 2
## 491 2 2
## 492 2 2
## 493 2 2
## 494 1 2
## 497 1 2
## 498 1 2
## 499 1 2
## 500 1 2
## 501 1 2
## 502 1 2
## 503 1 2
## 504 2 2
## 505 2 2
## 506 2 2
## 508 2 2
## 509 2 2
## 510 2 1
## 511 2 1
## 512 2 1
## 513 2 1
## 514 2 1
## 515 2 1
## 516 2 1
## 517 2 1
## 519 2 1
## 619 1 1
## 620 1 1
## 621 1 1
## 622 1 1
## 623 1 1
## 624 1 1
## 625 1 1
## 626 1 1
## 627 1 1
## 628 1 1
## 630 1 1
## 631 2 1
## 632 2 1
## 633 2 1
## 634 2 1
## 635 2 1
## 636 2 1
## 637 2 1
## 638 2 1
## 639 2 1
## 641 2 1
## 642 2 1
## 643 2 1
## 644 2 1
## 762 1 2
## 773 NA 2
## 784 1 2
## 788 2 1
## 789 2 1
## 790 2 1
## 791 2 1
## 792 2 1
## 793 2 1
## 794 2 1
## 795 1 2
## 796 2 1
## 797 2 1
## 798 2 1
## 799 2 1
## 800 2 1
## 801 2 1
## 802 2 1
## 803 2 1
## 804 2 1
## 805 2 1
## 806 1 2
## 807 2 1
## 817 1 2
## 829 2 2
## 840 2 2
## 851 2 2
## 862 2 2
## 873 2 2
## 884 2 2
## 895 2 2
## 906 2 2
## 917 2 2
## 928 2 2
## 934 1 1
## 935 1 1
## 936 1 1
## 937 1 1
## 938 1 1
## 940 2 2
## 941 1 1
## 942 1 1
## 943 1 1
## 944 1 1
## 945 1 1
## 946 1 1
## 947 2 1
## 948 2 1
## 949 2 1
## 950 2 1
## 951 2 2
## 952 2 1
## 962 2 2
## 973 2 2
## 984 2 2
## 995 2 2
## 1033 2 1
## 1034 2 1
## 1035 2 1
## 1036 2 1
## 1037 2 1
## 1038 2 1
## 1040 2 1Sample t-test of Post-purchase Satisfaction of Miles Per Gallon
t.test(Post.Satis~MPG_numeric, data=subHonda, var.eq=TRUE)##
## Two Sample t-test
##
## data: Post.Satis by MPG_numeric
## t = -1.5519, df = 157, p-value = 0.1227
## alternative hypothesis: true difference in means between group 1 and group 2 is not equal to 0
## 95 percent confidence interval:
## -0.49863526 0.05984353
## sample estimates:
## mean in group 1 mean in group 2
## 5.294118 5.513514visually see the mean difference of Post-purchase Satisfaction by Miles Per Gallon.
boxplot(subHonda$Post.Satis ~ subHonda$MPG_numeric, col=c(5,7))
normality assumption on the dependent variable
shapiro.test(subHonda$Post.Satis)##
## Shapiro-Wilk normality test
##
## data: subHonda$Post.Satis
## W = 0.87891, p-value = 4.414e-10Sample t-test of Enjoyment by Miles Per Gallon
t.test(Enjoyment~MPG_numeric, data=subHonda, var.eq=TRUE)##
## Two Sample t-test
##
## data: Enjoyment by MPG_numeric
## t = -3.1043, df = 157, p-value = 0.002263
## alternative hypothesis: true difference in means between group 1 and group 2 is not equal to 0
## 95 percent confidence interval:
## -1.1395476 -0.2533005
## sample estimates:
## mean in group 1 mean in group 2
## 4.823529 5.519953visually see the mean difference of Enjoyment by Miles Per Gallon.
boxplot(subHonda$Enjoyment ~ subHonda$MPG_numeric, col=c(5,7))
normality assumption on the dependent variable
shapiro.test(subHonda$Enjoyment) ##
## Shapiro-Wilk normality test
##
## data: subHonda$Enjoyment
## W = 0.93325, p-value = 8.992e-07Sample t-test of Enjoyment by Gender
t.test(Enjoyment~Gender_numeric, data=subHonda, var.eq=TRUE)##
## Two Sample t-test
##
## data: Enjoyment by Gender_numeric
## t = -0.39813, df = 157, p-value = 0.6911
## alternative hypothesis: true difference in means between group 0 and group 1 is not equal to 0
## 95 percent confidence interval:
## -0.6412514 0.4261104
## sample estimates:
## mean in group 0 mean in group 1
## 5.065789 5.173360visually see the mean difference of Enjoyment by Gender.
boxplot(subHonda$Enjoyment ~ subHonda$Gender_numeric, col=c(5,7))
Ensure relevant columns are correctly typed
subHonda$Region <- as.factor(subHonda$Region)
subHonda$Pay_Meth <- as.factor(subHonda$Pay_Meth)
subHonda$Insur_Type <- as.factor(subHonda$Insur_Type)
subHonda$Education <- as.factor(subHonda$Education)One-way ANOVA for Age across Regions
age_aov <- aov(Age ~ Region, data = subHonda)
age_aov## Call:
## aov(formula = Age ~ Region, data = subHonda)
##
## Terms:
## Region Residuals
## Sum of Squares 2350.88 35251.39
## Deg. of Freedom 3 155
##
## Residual standard error: 15.08073
## Estimated effects may be unbalanced#histogram
hist(age_aov$residuals)
Create QQ plot (visually check normality of the data)
qqnorm(age_aov$residuals, pch=0, frame=FALSE)
qqline(age_aov$residuals, col="blue", lwd=4)
test normality of the residuals
shapiro.test(age_aov$residuals) ##
## Shapiro-Wilk normality test
##
## data: age_aov$residuals
## W = 0.88334, p-value = 7.487e-10Bartlett test of homogeneity of variances
bartlett.test(subHonda$Age, subHonda$Region)##
## Bartlett test of homogeneity of variances
##
## data: subHonda$Age and subHonda$Region
## Bartlett's K-squared = 12.058, df = 3, p-value = 0.007186One-way ANOVA for Payment Method across Regions
subHonda$Pay_Meth_numeric <- as.numeric(subHonda$Pay_Meth)
Pay_Meth_aov <- aov(Pay_Meth_numeric ~ Region, data = subHonda)
Pay_Meth_aov## Call:
## aov(formula = Pay_Meth_numeric ~ Region, data = subHonda)
##
## Terms:
## Region Residuals
## Sum of Squares 23.85730 77.51377
## Deg. of Freedom 3 155
##
## Residual standard error: 0.7071696
## Estimated effects may be unbalanced#histogram
hist(Pay_Meth_aov$residuals)
Create QQ plot (visually check normality of the data)
qqnorm(Pay_Meth_aov$residuals, pch=0, frame=FALSE)
qqline(Pay_Meth_aov$residuals, col="blue", lwd=4)
test normality of the residuals
shapiro.test(Pay_Meth_aov$residuals) ##
## Shapiro-Wilk normality test
##
## data: Pay_Meth_aov$residuals
## W = 0.90191, p-value = 8.01e-09Bartlett test of homogeneity of variances
bartlett.test(subHonda$Pay_Meth_numeric, subHonda$Region)##
## Bartlett test of homogeneity of variances
##
## data: subHonda$Pay_Meth_numeric and subHonda$Region
## Bartlett's K-squared = 27.305, df = 3, p-value = 5.081e-06One-way ANOVA for Insurance Type across Regions
subHonda$Insur_Type_numeric <- as.numeric(subHonda$Insur_Type)
insurance_aov <- aov(Insur_Type_numeric ~ Region, data = subHonda)
insurance_aov## Call:
## aov(formula = Insur_Type_numeric ~ Region, data = subHonda)
##
## Terms:
## Region Residuals
## Sum of Squares 4.84422 140.06144
## Deg. of Freedom 3 155
##
## Residual standard error: 0.9505904
## Estimated effects may be unbalanced#histogram
hist(insurance_aov$residuals)
Create QQ plot (visually check normality of the data)
qqnorm(insurance_aov$residuals, pch=0, frame=FALSE)
qqline(insurance_aov$residuals, col="blue", lwd=4)
test normality of the residuals
shapiro.test(insurance_aov$residuals) ##
## Shapiro-Wilk normality test
##
## data: insurance_aov$residuals
## W = 0.79168, p-value = 8.989e-14Bartlett test of homogeneity of variances
bartlett.test(subHonda$Insur_Type_numeric, subHonda$Region)##
## Bartlett test of homogeneity of variances
##
## data: subHonda$Insur_Type_numeric and subHonda$Region
## Bartlett's K-squared = 0.52301, df = 3, p-value = 0.9138One-way ANOVA for Education across Regions
subHonda$Education_numeric <- as.numeric(subHonda$Education)
education_aov <- aov(Education_numeric ~ Region, data = subHonda)
education_aov## Call:
## aov(formula = Education_numeric ~ Region, data = subHonda)
##
## Terms:
## Region Residuals
## Sum of Squares 3.49384 75.19798
## Deg. of Freedom 3 155
##
## Residual standard error: 0.6965259
## Estimated effects may be unbalanced#histogram
hist(education_aov$residuals)
Create QQ plot (visually check normality of the data)
qqnorm(education_aov$residuals, pch=0, frame=FALSE)
qqline(education_aov$residuals, col="blue", lwd=4)
test normality of the residuals
shapiro.test(education_aov$residuals) ##
## Shapiro-Wilk normality test
##
## data: education_aov$residuals
## W = 0.90673, p-value = 1.55e-08Bartlett test of homogeneity of variances
bartlett.test(subHonda$Education_numeric, subHonda$Region)##
## Bartlett test of homogeneity of variances
##
## data: subHonda$Education_numeric and subHonda$Region
## Bartlett's K-squared = 11.133, df = 3, p-value = 0.01103Setting interval of Age
summary(ct$Age)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 18.00 23.00 34.00 35.22 48.00 60.00ct$AgeGrp<-cut(ct$Age,
breaks = c(18, 30, 42, 54, Inf),
Labels = c("18-30", "30-42", "42-54", "54+"),
right=FALSE)
names(ct)## [1] "Resp" "Att_1"
## [3] "Att_2" "Enj_1"
## [5] "Enj_2" "Perform_1"
## [7] "Perform_2" "Perform_3"
## [9] "WOM_1" "WOM_2"
## [11] "Futu_Pur_1" "Futu_Pur_2"
## [13] "Valu_Percp_1" "Valu_Percp_2"
## [15] "Pur_Proces_1" "Pur_Proces_2"
## [17] "Residence" "Pay_Meth"
## [19] "Insur_Type" "Gender"
## [21] "Age" "Education"
## [23] "Region" "Model"
## [25] "MPG" "Cyl"
## [27] "acc1" "C_cost."
## [29] "H_Cost" "Post.Satis"
## [31] "Make" "Model_v1"
## [33] "Attitude" "Parent"
## [35] "Enjoyment" "Perform"
## [37] "Word_of_Mouth" "Future_Purchase_Intention"
## [39] "Value_Perception" "Purchase_Process"
## [41] "AgeGrp"head(ct$AgeGrp)## [1] [18,30) [18,30) [30,42) [18,30) [18,30) [18,30)
## Levels: [18,30) [30,42) [42,54) [54,Inf)Relationship between Future Purchase Intention and Enjoyment by Gender
ggplot(ct, aes(x = Future_Purchase_Intention, y = Enjoyment, color = Gender)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm") + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Future Purchase Intentions and Enjoyment by Gender",
x = "Future Purchase Intention",
y = "Enjoyment") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'
Relationship between Post Purchase Satisfaction and Performance by Age
ggplot(ct, aes(x = Perform, y = Post.Satis, color = AgeGrp)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm", se = FALSE) + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Performance and Post Purchase Intention by Age",
x = "Performance",
y = "Post Purchase Intention") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'
Relationship between Value Perception and Purchase Process by Region
ggplot(ct, aes(x = Value_Perception, y = Purchase_Process, color = Region)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm", se = FALSE) + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Value Perception and Purchase Process by Region",
x = "Value Perception",
y = "Purchase Process") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'
Relationship between Performance and Enjoyment by Gender
ggplot(ct, aes(x = Perform, y = Enjoyment, color = Gender)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm", se = FALSE) + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Performance and Enjoyment by Gender",
x = "Performance",
y = "Enjoyment") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'
Relationship between Miles Per Gallon and Post Purchase Satisfaction by Gender
ggplot(ct, aes(x = MPG, y = Post.Satis, color = Gender)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm", se = FALSE) + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Miles Per Gallon and Post Purchase Satisfaction by Gender",
x = "Miles Per Gallon",
y = "Post Purchase Satisfaction") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'
Relationship between Enjoyment and Cylinder by Gender
ggplot(ct, aes(x = Enjoyment, y = Cyl, color = Gender)) +
geom_point(alpha = 0.7) + # Points for individual observations
geom_smooth(method = "lm", se = FALSE) + # Linear trend lines
facet_wrap(~ Make, scales = "free") + # Separate panels for each brand
labs(title = "Enjoyment and Cylinder by Gender",
x = "Enjoyment",
y = "Cylinder") +
theme_minimal() +
theme(plot.background = element_rect(fill = "gray"),
panel.background = element_rect(fill = "white"))## `geom_smooth()` using formula = 'y ~ x'