How to run multiple linear regression model with excel file on plink.

Question

[ali.khan.exxon]

Hi guys, I currently have the excel file and I need to run the multiple linear regression model. Do I need to covert Filename.xlxs to PED and MAP file to run it? I have no idea .Data is attached below BL_tTau” as a response (dependent) variable, DX as an independent variable, and GENDER & BL_Age as covariates to investigate the influence of PD on the level of CSF total Tau while removing confounding effects of age and sex. Help me out please. Thank you so much.

**FID**   **IID   DX  Gender BL_age educyrs BL_abeta Bl_pTau Bl_tTau** 
PPMISI3000  3000    1   2   70      18  1356    17.5             213.4          
PPMISI3001  3001    2   1   65      16  1016    14.17       158.6   
PPMISI3002  3002    2   2   68      16  535.8   28.69        302.9  
PPMISI3003  3003    2   2   57      16  731.7   9.21            110.2               
PPMISI3004  3004    1   1   60      16  612.9   8.77            95.88

[Kevin Blighe]

Please provide some background to all of this. From where did you obtain this data?; and what other data do you have? You mention linear regression, but what are you supposed to model with the linear regression?

Going by your description ("BL_tTau” as a response (dependent) variable, DX as an independent variable, and GENDER & BL_Age as covariates"), you could simply input the data to R and do:

lm(Bl_tTau ~ DX + GENDER + BL_age)

• DX and GENDER would be categorical (factor) variables
• Bl_tTau and BL_age would be continuous variables

[zx8754]

Read about plink phenotypes.