Environment Setting

Package Load

Download and function “psych” “tidyverse” and “sm” to help the data analysis

#Generate practice dataset (once you generate, then annotate it)
#data <- mtcars
#write.csv(data, 'data/data.csv')

library(psych)
library(tidyverse)
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.3.6      ✔ purrr   0.3.4 
## ✔ tibble  3.1.8      ✔ dplyr   1.0.10
## ✔ tidyr   1.2.1      ✔ stringr 1.4.1 
## ✔ readr   2.1.2      ✔ forcats 0.5.2 
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ ggplot2::%+%()   masks psych::%+%()
## ✖ ggplot2::alpha() masks psych::alpha()
## ✖ dplyr::filter()  masks stats::filter()
## ✖ dplyr::lag()     masks stats::lag()
library(sm)
## Package 'sm', version 2.2-5.7: type help(sm) for summary information

Read data

Firstly, i used “MTCARS” to find the speification and performance of car

data <- read.csv('../data/data.csv')

Analysis

Descriptive Statistics

Then, i used descriptive statistics, which is a branch of statistics aiming at summarizing, describing and presenting a series of values or a dataset.it can caculate the basic information(maximum, maximum, median, mean, 1st quarter and 3rd quarter value) of each variable

summary(data)
##       X                  mpg             cyl             disp      
##  Length:32          Min.   :10.40   Min.   :4.000   Min.   : 71.1  
##  Class :character   1st Qu.:15.43   1st Qu.:4.000   1st Qu.:120.8  
##  Mode  :character   Median :19.20   Median :6.000   Median :196.3  
##                     Mean   :20.09   Mean   :6.188   Mean   :230.7  
##                     3rd Qu.:22.80   3rd Qu.:8.000   3rd Qu.:326.0  
##                     Max.   :33.90   Max.   :8.000   Max.   :472.0  
##        hp             drat             wt             qsec      
##  Min.   : 52.0   Min.   :2.760   Min.   :1.513   Min.   :14.50  
##  1st Qu.: 96.5   1st Qu.:3.080   1st Qu.:2.581   1st Qu.:16.89  
##  Median :123.0   Median :3.695   Median :3.325   Median :17.71  
##  Mean   :146.7   Mean   :3.597   Mean   :3.217   Mean   :17.85  
##  3rd Qu.:180.0   3rd Qu.:3.920   3rd Qu.:3.610   3rd Qu.:18.90  
##  Max.   :335.0   Max.   :4.930   Max.   :5.424   Max.   :22.90  
##        vs               am              gear            carb      
##  Min.   :0.0000   Min.   :0.0000   Min.   :3.000   Min.   :1.000  
##  1st Qu.:0.0000   1st Qu.:0.0000   1st Qu.:3.000   1st Qu.:2.000  
##  Median :0.0000   Median :0.0000   Median :4.000   Median :2.000  
##  Mean   :0.4375   Mean   :0.4062   Mean   :3.688   Mean   :2.812  
##  3rd Qu.:1.0000   3rd Qu.:1.0000   3rd Qu.:4.000   3rd Qu.:4.000  
##  Max.   :1.0000   Max.   :1.0000   Max.   :5.000   Max.   :8.000
describe(data)
##      vars  n   mean     sd median trimmed    mad   min    max  range  skew
## X*      1 32  16.50   9.38  16.50   16.50  11.86  1.00  32.00  31.00  0.00
## mpg     2 32  20.09   6.03  19.20   19.70   5.41 10.40  33.90  23.50  0.61
## cyl     3 32   6.19   1.79   6.00    6.23   2.97  4.00   8.00   4.00 -0.17
## disp    4 32 230.72 123.94 196.30  222.52 140.48 71.10 472.00 400.90  0.38
## hp      5 32 146.69  68.56 123.00  141.19  77.10 52.00 335.00 283.00  0.73
## drat    6 32   3.60   0.53   3.70    3.58   0.70  2.76   4.93   2.17  0.27
## wt      7 32   3.22   0.98   3.33    3.15   0.77  1.51   5.42   3.91  0.42
## qsec    8 32  17.85   1.79  17.71   17.83   1.42 14.50  22.90   8.40  0.37
## vs      9 32   0.44   0.50   0.00    0.42   0.00  0.00   1.00   1.00  0.24
## am     10 32   0.41   0.50   0.00    0.38   0.00  0.00   1.00   1.00  0.36
## gear   11 32   3.69   0.74   4.00    3.62   1.48  3.00   5.00   2.00  0.53
## carb   12 32   2.81   1.62   2.00    2.65   1.48  1.00   8.00   7.00  1.05
##      kurtosis    se
## X*      -1.31  1.66
## mpg     -0.37  1.07
## cyl     -1.76  0.32
## disp    -1.21 21.91
## hp      -0.14 12.12
## drat    -0.71  0.09
## wt      -0.02  0.17
## qsec     0.34  0.32
## vs      -2.00  0.09
## am      -1.92  0.09
## gear    -1.07  0.13
## carb     1.26  0.29

Manipulation

Data manipulation involves modifying data to make it easier to read and to be more organized. We manipulate data for analysis and visualization.So i divided the type into two groups(Automatic transmission type cars are in data_a group, and manual transmission type cars are in data_b group),and caculate the mean qsec of each group

table(data$am)
## 
##  0  1 
## 19 13
data_a <- filter(data, am == 0) 
data_b <- filter(data, am == 1)
mean(data_a$qsec)
## [1] 18.18316
mean(data_b$qsec)
## [1] 17.36

The average of automatic transmission type cars`1/4 time is 18.18316 while the average of manual transmission type cars 1/4mile time is 17.36 After that, i also used historgam, plot, density diagram and boxplot to visualized the solution

Visualization

Data visualization is the technique used to deliver insights in data using visual cues such as graphs, charts, maps, and many others. This is useful as it helps in intuitive and easy understanding of the large quantities of data and thereby make better decisions regarding it.

Histogram

This function takes a vector as an input and uses some more parameters to plot histograms. The basic syntax for creating a histogram using R is − v is a vector containing numeric values used in histogram.

hist(data$qsec)

plot(density(data$qsec))

sm.density.compare(data$qsec, data$am, model = "equal")
## Test of equal densities:  p-value =  0.58

#vs.f <- factor(data$vs, levels = c(0,1),
#               labels = c('V shape', 'S shape'))
#colfill<-c(2:(2+length(levels(vs.f))))
#legend(locator(1), levels(vs.f), fill=colfill)

the chart can test if qsec is really related to transmission type. In the chart, The red line is the qsec density distribution of cars with manual transmission type, the green line is the qsec density distribution of cars with automatic transmission type, and the blue area is the reference band. We can see that there is a very small difference between the two groups.

Boxplot

It shows how the distribution of a numerical variable y differs across the unique levels of a second variable, x

boxplot(qsec ~ am, data = data)

data %>%
    ggplot( 
        aes(x=am, y=qsec, group = am)
        ) +
    geom_boxplot() +
    geom_jitter(color="black", size=0.4, alpha=0.9)

In the chart, we can see that the 1/4 mile time gap between manual transmission and automatic transmission is very small, therefore the impact of transmission on 1/4 mile time is also very small

Modeling

It is a statistical or mathematical model that is used to formulate a relationship between a dependent variable and single or multiple independent variables called as, linear model in R. In that case, i used t-rese and regression to examine if the two variables are real and correlation.

Independent 2-group t-test

It is used to help us to understand that the difference between the two means is real or simply by chance. The general form of the test is t-test

t.test(qsec ~ am, data = data) # where mpg is numeric and vs is a binary factor
## 
##  Welch Two Sample t-test
## 
## data:  qsec by am
## t = 1.2878, df = 25.534, p-value = 0.2093
## alternative hypothesis: true difference in means between group 0 and group 1 is not equal to 0
## 95 percent confidence interval:
##  -0.4918522  2.1381679
## sample estimates:
## mean in group 0 mean in group 1 
##        18.18316        17.36000

P-value=0.2093, greater than 0.05. In that case, the data of group 0 and group 1 are close to equal, and transmission type does not affect 1/4 mile time.

Regression Modeling

Regression is a model that takes response variables (dependent variable) and features (independent variables) to determine the estimated probability of an event.In the caculation,

m1 <- lm(qsec ~ am, data = data)
summary(m1)
## 
## Call:
## lm(formula = qsec ~ am, data = data)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -2.8600 -0.9583 -0.3516  1.2517  4.7168 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  18.1832     0.4056  44.833   <2e-16 ***
## am           -0.8232     0.6363  -1.294    0.206    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.768 on 30 degrees of freedom
## Multiple R-squared:  0.05284,    Adjusted R-squared:  0.02126 
## F-statistic: 1.674 on 1 and 30 DF,  p-value: 0.2057

In the linear regression, Pr=0.206, greater than 0.05, and approached to 0, so transmission has no influence on 1/4 mine time, and there is no relationship between them

Conclusion

In this report, we use mean function, density function, boxplot function and t-test to study the relationship between transmission type and 1/4 mile time(qsec). The results showed that transmission had no effect on 1/4 mile time. In that case, we can couclude that there is no relationship between transmssion and 1/4 mile time.