library(readxl)
library(ggpubr)
## Loading required package: ggplot2
library(effsize)
library(rstatix)
## 
## Attaching package: 'rstatix'
## The following object is masked from 'package:stats':
## 
##     filter
A6Q1 <- read_excel("C:/Users/Tharu/Downloads/A6Q1.xlsx")
Before <- A6Q1$Before
After <- A6Q1$After

Differences <- After - Before
mean(Before, na.rm = TRUE)
## [1] 76.13299
median(Before, na.rm = TRUE)
## [1] 75.95988
sd(Before, na.rm = TRUE)
## [1] 7.781323
mean(After, na.rm = TRUE)
## [1] 71.58994
median(After, na.rm = TRUE)
## [1] 70.88045
sd(After, na.rm = TRUE)
## [1] 6.639509
hist(Differences,
     main = "Histogram of Difference Scores",
     xlab = "After - Before",
     ylab = "Frequency",
     col = "lightblue",
     border = "black",
     breaks = 10)

boxplot(Differences,
        main = "Difference Scores (After - Before)",
        ylab = "Difference",
        col = "lightblue")

shapiro.test(Differences)
## 
##  Shapiro-Wilk normality test
## 
## data:  Differences
## W = 0.94757, p-value = 0.3318
t.test(Before, After,paired = TRUE)
## 
##  Paired t-test
## 
## data:  Before and After
## t = 1.902, df = 19, p-value = 0.07245
## alternative hypothesis: true mean difference is not equal to 0
## 95 percent confidence interval:
##  -0.4563808  9.5424763
## sample estimates:
## mean difference 
##        4.543048
cohen.d(Before, After, paired = TRUE)
## 
## Cohen's d
## 
## d estimate: 0.6284306 (medium)
## 95 percent confidence interval:
##      lower      upper 
## -0.1035207  1.3603820
wilcox.test(Before,After,paired = TRUE)
## 
##  Wilcoxon signed rank exact test
## 
## data:  Before and After
## V = 148, p-value = 0.114
## alternative hypothesis: true location shift is not equal to 0
df_long <- data.frame(id = rep(1:length(Before),2),
  time = rep(c("Before","After"),each=length(Before)),
  weight = c(Before,After)
)

#A Dependent T-Test was conducted to determine if there was a difference in body weight before versus after participants completed the low-calorie diet. #Before body weight scores (M = 76.13, SD = 7.78) were not significantly different from after body weight scores (M = 71.59, SD = 6.64), t(19) = 1.90, p = .072. #The effect size was small, Cohen’s d = 0.42. #A Wilcoxon Signed-Rank Test was conducted to determine if there was a difference in body weight before versus after participants completed the low-calorie diet. #Before body weight scores (Mdn = 75.96) were not significantly different from after body weight scores (Mdn = 70.88), V = 62, p = .114. #The effect size was small, r = 0.27.