This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Cmd+Shift+Enter.

library(readxl)
data <- read_excel("problem3-oxygenpurity.xls")

modellr <- lm(purity ~ hydro, data = data)

coefficients <- coef(modellr)

print(coefficients)
(Intercept)       hydro 
   78.90306    10.71324 
#Answer 1
#The coefficient of beta0=78.90306 and beta1=10.71324 after fitting the simple linear regression model.
#Answer 2 
summary(modellr)

Call:
lm(formula = purity ~ hydro, data = data)

Residuals:
    Min      1Q  Median      3Q     Max 
-4.5048 -3.5605  0.0294  2.6550  7.3408 

Coefficients:
            Estimate Std. Error t value Pr(>|t|)    
(Intercept)   78.903      3.843  20.532 2.73e-16 ***
hydro         10.713      3.204   3.344  0.00281 ** 
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 3.494 on 23 degrees of freedom
Multiple R-squared:  0.3272,    Adjusted R-squared:  0.2979 
F-statistic: 11.18 on 1 and 23 DF,  p-value: 0.002814
#From statistics,we can see that it rejects Null hypothesis because it is a significant linear regression.
#Answer 3 
#The coefficient of determination value is r^2 is 0.3272.This value indicates that there is 32.2% of the variation in the dependent variable is explained by the independent variable.
#Answer 4 
# Calculating  the 95% confidence interval for a specific coefficient ( beta1)
ci <- confint(modellr, "hydro", level = 0.95)
ci
        2.5 %   97.5 %
hydro 4.08618 17.34031
#Answer4 
ci1 <- confint(modellr, level = 0.95)
ci1
               2.5 %   97.5 %
(Intercept) 70.95322 86.85289
hydro        4.08618 17.34031
#The confidence interval on slope Beta 0 (Lower bound is 70.95322 and upper bound is 86.85289).
#The confidence interval on slope Beta 1 (Lower bound is  4.08618 and upper bound is 17.34031).
#Answer 5 
# For finding the mean purity , we are defining the value of hydrocarbon percentage 
valuehydro<-1.05
data2<-data.frame(hydro=valuehydro)

predic<-predict(modellr,newdata=data2,interval = "confidence",level=0.95)

cat("predicted mean purity:",predic[1],"\n")
predicted mean purity: 90.15196 
cat("Lower bound:",predic[2],"\n")
Lower bound: 88.47041 
cat("upper bound:",predic[3],"\n")
upper bound: 91.83351 
#Answer 6
#correlation coefficient r between Y and X
correlation<- cor(data$purity,data$hydro)
cat("The correlation coefficient:",correlation,"\n")
The correlation coefficient: 0.5719793 
#Answer 7
#Test the hypothesis:

no<-length(data$purity)

tstats<-correlation*sqrt((no-2)/1-correlation^2)

degrfre<-no-2

# Perform a two-sample t-test
t_test_result <- t.test(data)

# Get the two-tailed p-value
pvalue <- t_test_result$p.value

#significant level
a<-0.05

#comparing p value to a 
if(pvalue<a) {
  cat("It reject the null hypothesis,\n")
  cat("There is a significant correlation between purity and hydrocarbons,\n")
} else {
  cat("It fails to  reject the null hypothesis,\n")
  cat("There is no significant correlation between purity and hydrocarbons,\n")
}
It reject the null hypothesis,
There is a significant correlation between purity and hydrocarbons,
#print t stats 
cat("t statistics",tstats)
t statistics 2.723537
#print p value
cat("pvalue",pvalue)
pvalue 3.64393e-09
  
LS0tCnRpdGxlOiAiUHJvYmxlbSAzIgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpUaGlzIGlzIGFuIFtSIE1hcmtkb3duXShodHRwOi8vcm1hcmtkb3duLnJzdHVkaW8uY29tKSBOb3RlYm9vay4gV2hlbiB5b3UgZXhlY3V0ZSBjb2RlIHdpdGhpbiB0aGUgbm90ZWJvb2ssIHRoZSByZXN1bHRzIGFwcGVhciBiZW5lYXRoIHRoZSBjb2RlLiAKClRyeSBleGVjdXRpbmcgdGhpcyBjaHVuayBieSBjbGlja2luZyB0aGUgKlJ1biogYnV0dG9uIHdpdGhpbiB0aGUgY2h1bmsgb3IgYnkgcGxhY2luZyB5b3VyIGN1cnNvciBpbnNpZGUgaXQgYW5kIHByZXNzaW5nICpDbWQrU2hpZnQrRW50ZXIqLiAKCmBgYHtyfQpsaWJyYXJ5KHJlYWR4bCkKZGF0YSA8LSByZWFkX2V4Y2VsKCJwcm9ibGVtMy1veHlnZW5wdXJpdHkueGxzIikKCm1vZGVsbHIgPC0gbG0ocHVyaXR5IH4gaHlkcm8sIGRhdGEgPSBkYXRhKQoKY29lZmZpY2llbnRzIDwtIGNvZWYobW9kZWxscikKCnByaW50KGNvZWZmaWNpZW50cykKYGBgCgoKYGBge3J9CiNBbnN3ZXIgMQojVGhlIGNvZWZmaWNpZW50IG9mIGJldGEwPTc4LjkwMzA2IGFuZCBiZXRhMT0xMC43MTMyNCBhZnRlciBmaXR0aW5nIHRoZSBzaW1wbGUgbGluZWFyIHJlZ3Jlc3Npb24gbW9kZWwuCmBgYAoKCmBgYHtyfQojQW5zd2VyIDIgCnN1bW1hcnkobW9kZWxscikKCiNGcm9tIHN0YXRpc3RpY3Msd2UgY2FuIHNlZSB0aGF0IGl0IHJlamVjdHMgTnVsbCBoeXBvdGhlc2lzIGJlY2F1c2UgaXQgaXMgYSBzaWduaWZpY2FudCBsaW5lYXIgcmVncmVzc2lvbi4KCmBgYApgYGB7cn0KI0Fuc3dlciAzIAojVGhlIGNvZWZmaWNpZW50IG9mIGRldGVybWluYXRpb24gdmFsdWUgaXMgcl4yIGlzIDAuMzI3Mi5UaGlzIHZhbHVlIGluZGljYXRlcyB0aGF0IHRoZXJlIGlzIDMyLjIlIG9mIHRoZSB2YXJpYXRpb24gaW4gdGhlIGRlcGVuZGVudCB2YXJpYWJsZSBpcyBleHBsYWluZWQgYnkgdGhlIGluZGVwZW5kZW50IHZhcmlhYmxlLgoKCmBgYAoKCmBgYHtyfQojQW5zd2VyIDQgCiMgQ2FsY3VsYXRpbmcgIHRoZSA5NSUgY29uZmlkZW5jZSBpbnRlcnZhbCBmb3IgYSBzcGVjaWZpYyBjb2VmZmljaWVudCAoIGJldGExKQpjaSA8LSBjb25maW50KG1vZGVsbHIsICJoeWRybyIsIGxldmVsID0gMC45NSkKY2kKYGBgCgoKYGBge3J9CiNBbnN3ZXI0IApjaTEgPC0gY29uZmludChtb2RlbGxyLCBsZXZlbCA9IDAuOTUpCmNpMQojVGhlIGNvbmZpZGVuY2UgaW50ZXJ2YWwgb24gc2xvcGUgQmV0YSAwIChMb3dlciBib3VuZCBpcyA3MC45NTMyMiBhbmQgdXBwZXIgYm91bmQgaXMgODYuODUyODkpLgojVGhlIGNvbmZpZGVuY2UgaW50ZXJ2YWwgb24gc2xvcGUgQmV0YSAxIChMb3dlciBib3VuZCBpcyAgNC4wODYxOCBhbmQgdXBwZXIgYm91bmQgaXMgMTcuMzQwMzEpLgpgYGAKCgpgYGB7cn0KI0Fuc3dlciA1IAojIEZvciBmaW5kaW5nIHRoZSBtZWFuIHB1cml0eSAsIHdlIGFyZSBkZWZpbmluZyB0aGUgdmFsdWUgb2YgaHlkcm9jYXJib24gcGVyY2VudGFnZSAKdmFsdWVoeWRybzwtMS4wNQpkYXRhMjwtZGF0YS5mcmFtZShoeWRybz12YWx1ZWh5ZHJvKQoKcHJlZGljPC1wcmVkaWN0KG1vZGVsbHIsbmV3ZGF0YT1kYXRhMixpbnRlcnZhbCA9ICJjb25maWRlbmNlIixsZXZlbD0wLjk1KQoKY2F0KCJwcmVkaWN0ZWQgbWVhbiBwdXJpdHk6IixwcmVkaWNbMV0sIlxuIikKY2F0KCJMb3dlciBib3VuZDoiLHByZWRpY1syXSwiXG4iKQpjYXQoInVwcGVyIGJvdW5kOiIscHJlZGljWzNdLCJcbiIpCgpgYGAKYGBge3J9CiNBbnN3ZXIgNgojY29ycmVsYXRpb24gY29lZmZpY2llbnQgciBiZXR3ZWVuIFkgYW5kIFgKY29ycmVsYXRpb248LSBjb3IoZGF0YSRwdXJpdHksZGF0YSRoeWRybykKY2F0KCJUaGUgY29ycmVsYXRpb24gY29lZmZpY2llbnQ6Iixjb3JyZWxhdGlvbiwiXG4iKQpgYGAKYGBge3J9CiNBbnN3ZXIgNwojVGVzdCB0aGUgaHlwb3RoZXNpczoKCm5vPC1sZW5ndGgoZGF0YSRwdXJpdHkpCgp0c3RhdHM8LWNvcnJlbGF0aW9uKnNxcnQoKG5vLTIpLzEtY29ycmVsYXRpb25eMikKCmRlZ3JmcmU8LW5vLTIKCiMgUGVyZm9ybSBhIHR3by1zYW1wbGUgdC10ZXN0CnRfdGVzdF9yZXN1bHQgPC0gdC50ZXN0KGRhdGEpCgojIEdldCB0aGUgdHdvLXRhaWxlZCBwLXZhbHVlCnB2YWx1ZSA8LSB0X3Rlc3RfcmVzdWx0JHAudmFsdWUKCiNzaWduaWZpY2FudCBsZXZlbAphPC0wLjA1CgojY29tcGFyaW5nIHAgdmFsdWUgdG8gYSAKaWYocHZhbHVlPGEpIHsKICBjYXQoIkl0IHJlamVjdCB0aGUgbnVsbCBoeXBvdGhlc2lzLFxuIikKICBjYXQoIlRoZXJlIGlzIGEgc2lnbmlmaWNhbnQgY29ycmVsYXRpb24gYmV0d2VlbiBwdXJpdHkgYW5kIGh5ZHJvY2FyYm9ucyxcbiIpCn0gZWxzZSB7CiAgY2F0KCJJdCBmYWlscyB0byAgcmVqZWN0IHRoZSBudWxsIGh5cG90aGVzaXMsXG4iKQogIGNhdCgiVGhlcmUgaXMgbm8gc2lnbmlmaWNhbnQgY29ycmVsYXRpb24gYmV0d2VlbiBwdXJpdHkgYW5kIGh5ZHJvY2FyYm9ucyxcbiIpCn0KCiNwcmludCB0IHN0YXRzIApjYXQoInQgc3RhdGlzdGljcyIsdHN0YXRzKQoKI3ByaW50IHAgdmFsdWUKY2F0KCJwdmFsdWUiLHB2YWx1ZSkKCiAgCmBgYAo=