# -*- coding: utf-8 -*-
"""
Created on Thu Oct  6 14:32:14 2022

@author: Gable
"""

import pandas as pd
import numpy as np
df = pd.read_excel (r"C:\Users\Gable\Downloads\activity assay raw data.xlsx", header=2)
# print (df)

from scipy.stats import ttest_ind
from scipy.stats import t

m1 = df.mean()['50C.1']
m2 = df.mean()['74C.1']
d1 = df.std()['50C.1']
d2 = df.std()['74C.1']
n1 = 3
n2 = 4
dof = n1+n2-2
tstat = (m1 - m2)/np.sqrt(d1**2/n1+d2**2/n2)

alpha = 0.05
cv = t.ppf(1.0 - alpha, dof)

p = (1 - t.cdf(abs(tstat), dof))

print(p)