Question 1 InfectedMins Exposed# InjuriesSexCarapace LengthBlood Protein IndexPattern Recognition Protein Concentration Yes243M12.220.39 Yes1442M46.723.99 Yes722M19.521.45...

1 answer below »
Please follow answers to HW file format when completing assignment. Also very important please copy and paste relevant R data into the answers from R studio


Question 1 InfectedMins Exposed# InjuriesSexCarapace LengthBlood Protein IndexPattern Recognition Protein Concentration Yes243M12.220.39 Yes1442M46.723.99 Yes722M19.521.45 Yes484M46.4216.19 No240M12.520.11 No242F64.724.89 No962M73.020.80 No241F73.520.68 Yes963M32.620.39 Yes82F12.832.04 No481F30.830.05 Yes962M15.630.16 No482M38.531.44 No242M13.630.11 Yes245M55.230.11 No481F28.030.06 No482F49.330.73 No242M11.130.07 No483M39.537.46 No1441F77.136.93 No242F11.232.33 No481M20.731.25 Yes1202F50.630.14 Yes481F60.1317.40 No240M62.936.98 No3363M37.240.18 No01F14.840.14 Yes242M15.740.68 Yes962M16.040.34 No241M23.447.78 No241M29.543.19 Yes1200M38.241.24 No723M52.140.42 Yes723M17.041.43 No241M41.742.04 No242M43.9426.34 Yes41M113.3441.61 No962F14.240.35 No241M17.740.09 No240M18.040.05 No723M21.740.30 Yes240F14.642.84 Yes963M22.340.37 Yes722M24.240.65 Yes1202M71.741.51 Yes482M14.140.97 No961F22.543.03 Yes723M22.740.19 No722F27.840.41 No722M33.840.66 No20F36.141.09 No721F11.340.82 Yes243M35.240.40 Yes964F38.040.16 Yes724F11.340.06 Yes723M20.240.07 No11F23.048.97 No20F52.746.28 No23M105.240.24 No243M19.240.64 Yes241F126.949.25 No12F14.857.96 Yes724M18.552.23 Yes241F23.450.13 No0.51M25.950.30 Yes32M51.157.04 No243F69.254.41 No485F156.450.14 No483M11.150.21 No241M13.052.89 Yes482M18.550.13 No482M24.450.38 Yes04M24.8513.50 Yes723F52.652.50 No484M61.050.39 No241M12.750.27 No243M14.550.63 No244M18.350.05 Yes722F58.557.20 Yes480M18.954.40 Yes724F22.350.14 Yes963M26.050.43 No724M27.751.80 Yes1204M64.950.30 Yes481F41.253.98 Yes964M43.750.12 No721F52.950.62 No31M70.4512.24 No720M72.6520.24 No241M21.450.28 No45M30.250.13 No245M37.051.11 No480F43.0515.27 Yes245F46.3512.00 No244F61.051.98 No244M82.2511.76 No240M86.055.30 No240M13.050.05 No244M17.358.52 No723F19.550.05 Yes01M23.750.16 No721M25.950.08 Yes721F33.650.85 Yes241M37.550.05 No241M50.8513.33 No963F15.750.23 No11M26.650.09 No7203M28.353.38 Yes61F46.4514.48 Yes721M56.858.70 Yes480M60.253.30 Yes484M102.859.29 No1681F11.950.05 No241M16.150.24 Yes242F16.152.99 No484F23.458.14 Yes963F23.550.12 Yes1682M36.5512.33 Yes721F56.455.58 Yes41M76.250.58 No724M12.750.16 Yes242F25.550.16 No724F28.550.52 Yes961F12.661.00 No482M13.367.72 No240M14.660.07 Yes1202M18.460.14 No240M28.466.30 No240F28.7622.02 Yes725M36.3626.59 Yes240M43.8613.01 No241F67.461.27 No480M132.2620.95 No240M12.3614.76 No480M23.569.53 No480F54.767.73 No241M65.960.47 Yes244M172.164.15 No722F27.260.06 No243F11.260.52 No90M14.060.12 Yes241F14.760.08 No245M18.367.38 No240M26.064.00 Yes482F30.066.75 No962M30.663.48 Yes722F33.661.72 No720F42.560.79 Yes722F51.163.58 No243M68.160.05 Yes00M176.166.22 Yes480M11.461.07 No21M12.360.09 No241M16.660.16 Yes243M44.261.24 Yes1201F76.660.37 Yes245M15.260.30 Yes481M20.669.08 No721M35.669.65 No720F37.7611.54 Yes12F49.362.75 Yes481M63.4616.86 No200M73.7610.45 No13F16.5620.00 No242M19.860.71 No61M23.2611.14 No962M38.860.31 No31M73.4612.96 No482M75.360.48 Yes241M96.666.19 Yes23M105.5612.88 No481F11.160.08 Yes1441M13.560.51 No240M19.161.99 No960F19.362.23 No481M21.169.51 Yes40M37.561.60 No480M62.9614.13 No722M71.664.46 Yes1202M81.264.54 Yes244M120.265.98 Yes1201M19.063.93 Yes483M21.860.45 Yes1920M22.560.36 Yes722M25.3617.73 Yes482M26.260.69 Yes722M32.860.13 Yes1445F37.361.40 Yes721F53.4610.50 No481F64.163.84 Yes961M20.360.22 Yes481F26.960.16 Yes3361M31.860.57 Yes481M49.461.53 No723F55.260.07 No483M59.067.94 Yes1202M64.061.36 No243M89.2611.05 Yes241M91.2639.10 No724M113.962.62 No240F19.264.48 Yes963F33.660.05 No244F53.166.60 No241M57.260.09 No960M75.260.18 No721M90.160.79 No721F100.3610.26 Yes1443F127.160.15 Yes242F33.660.05 Yes962M11.370.96 No240M11.571.73 Yes1442M13.170.27 No481F15.770.18 No60M26.076.60 Yes245F32.470.38 No240F32.8715.83 No110M77.273.90 No481F11.770.28 Yes243M13.772.82 Yes241M17.870.10 No240F39.070.37 Yes241F43.976.63 Yes722M45.770.55 Yes482M104.7717.97 No962M68.677.44 No242M14.670.11 Yes725M17.270.19 No484F21.270.36 Yes725M29.770.08 No14F38.5779.86 No243F39.571.64 Yes244M39.973.90 No241M48.173.06 Yes965F50.670.39 Yes483F68.372.00 No481F110.370.73 Yes1201M13.171.41 No240M21.9710.36 No484M30.6716.46 Yes12F65.176.40 Yes481M81.970.80 No961M89.773.40 Yes242F90.174.26 Yes240M106.875.38 Yes241F41.573.95 Yes962M17.470.14 No724M19.370.50 No243M30.270.67 Yes965M30.970.26 No482M33.2712.87 No481M39.971.04 No721F42.170.19 Yes962M45.374.54 No243M46.772.14 No720M53.670.87 Yes721F59.2716.14 No961M74.378.48 Yes242F81.471.57 No241M96.5710.01 No721M11.072.73 No05F13.670.05 Yes481M15.9724.03 No241M18.673.32 No240M19.978.93 Yes1201M23.3712.38 No240M26.670.13 Yes481M29.370.07 Yes961M30.073.87 No480F43.172.21 Yes1442M43.6710.87 No241M52.170.84 No1200M62.9710.33 No242F66.374.66 No3364F70.674.82 No483M154.071.13 No243F13.174.62 No240F16.571.40 No01M18.070.42 Yes241M21.270.12 Yes963F21.470.29 No722M37.370.25 Yes241M39.271.51 No1680M46.970.41 No481M66.8712.63 No721M94.370.18 No42F128.375.48 No3361F144.970.28 Yes14M52.171.35 No74M21.370.10 No964F21.971.44 Yes1202F32.774.11 No11F35.570.26 Yes963F38.470.16 No481M50.470.58 Yes240M50.571.35 Yes481F50.577.11 No01M68.572.22 No242F11.676.38 No961M15.2728.09 No21M19.070.25 Yes482M44.370.47 Yes961M50.970.21 No240M55.470.36 Yes1684F58.270.52 No722M91.170.12 Yes1202M125.974.62 Yes1204F11.7716.05 Yes962F12.377.98 Yes241F13.171.03 No481M18.670.62 No243F19.170.22 No962F33.570.25 No242F34.870.13 Yes721M47.478.53 No723M74.878.91 Yes3362M17.4811.12 No245M37.980.28 No02M46.6815.51 No242M53.880.14 Yes240M59.186.35 No960M11.180.14 No243M13.083.76 Yes963F26.080.05 Yes481F30.580.23 No243F40.5812.57 Yes1444F61.7814.67 No722F63.780.09 Yes1202M85.080.57 Yes722M87.982.82 Yes481F12.880.05 Yes961F17.581.10 Yes241M18.980.06 No11F20.380.51 Yes1682F24.080.05 Yes964F24.280.50 No961M26.186.51 Yes10M30.281.83 Yes964M30.880.21 No721M31.680.68 No480M34.380.05 No10M35.383.02 No1681F36.086.36 No240F37.782.55 No482F39.380.59 No240M85.380.54 Yes04F86.084.07 Yes3364F104.380.07 Yes240M145.081.58 No241M12.6815.47 No11M19.880.92 No960F39.582.07 No722M42.980.61 No722M56.384.44 No5042F70.7815.54 No11F85.581.74 Yes244F96.989.81 No241M12.480.74 No481F14.080.13 No242F14.280.46 No31M17.687.29 No1683F26.287.80 Yes11M31.9810.65 No484M43.480.24 Yes3362F45.3818.43 No241F54.689.69 No722M66.882.56 Yes1204F89.681.62 No03M13.180.31 Yes484M14.980.14 No964F16.280.21 Yes1201F21.280.61 No21M23.180.10 No241M52.080.05 Yes961F82.7815.96 Yes241F84.5813.75 Yes3364F12.380.81 No1200M19.980.09 No1201F23.280.06 Yes1681F23.480.10 No241F28.180.14 No1684F32.280.08 Yes243M37.981.07 No963F49.481.44 Yes1204M69.380.48 Yes1682M126.9812.98 No965M17.680.18 No964M18.280.22 No242F28.6819.31 Yes24F29.180.37 No243M47.080.20 Yes240F47.788.94 No484M50.181.28 No241M61.3811.74 No21M69.680.44 No962M101.480.41 Yes482M109.287.18 No241M109.781.24 No960F151.485.05 No723M11.380.14 No1681M15.582.04 No483M18.380.08 No240F27.685.07 No241M29.386.76 No724M30.680.89 No62F49.381.46 No960F84.1811.01 Yes241M15.580.23 No481M11.581.15 No960M12.482.53 Yes240F13.180.14 Yes3364F16.780.05 No961M52.6819.99 Yes480M61.8818.57 Yes480F80.681.95 No484M87.980.08 Yes721M90.188.61 No1200M110.7810.61 Yes00M178.981.73 Yes1682M12.190.11 No721F12.890.07 No241M13.390.80 Yes5043F15.390.11 Yes722M19.090.08 Yes721F20.190.14 Yes1202M23.6921.09 No481M25.0915.02 Yes240F27.690.14 Yes1204M28.890.05 No241F30.995.93 No142M34.790.17 No721M38.298.27 No721F38.698.81 Yes244F57.893.39 No241F130.290.76 No244M14.790.07 Yes33F15.890.19 No481F16.590.20 No241F29.7910.60 Yes722M37.290.75 No482F66.290.27 No241F74.090.08 Yes960M108.191.56 No201M13.190.28 No1681M18.290.37 No483M20.890.18 Yes3362M21.490.11 No240F34.395.84 No964M38.890.05 No481M62.193.03 No482M64.194.19 No485F86.290.60 No240M146.991.72 No243F170.492.70 No961F24.290.08 No482F26.690.42 No963M32.091.31 No480F40.393.63 No13F42.991.58 Yes724F43.891.42 Yes241M53.5911.48 Yes7202M62.890.44 Yes20M81.8912.25 No242F176.298.82 No961M78.293.28 No241F13.090.28 Yes481M14.694.37 Yes484F15.290.13 Yes21M15.492.44 No61M16.890.21 Yes724M19.990.05 No240M24.091.17 No483F32.190.03 No721F32.790.23 Yes720M46.893.89 Yes963F48.0910.29 No482F48.390.16 Yes1683M51.7912.50 No1680F54.290.28 No482M55.893.41 Yes482M136.5933.96 No961F138.292.97 No2403F12.390.14 No240F13.192.84 Yes1202F14.290.52 No240F15.393.67 Yes242F15.890.49 No722F23.390.23 Yes21604M25.090.42 Yes721M25.890.44 No242F40.798.26 Yes1441M47.4912.12 No725M50.190.19 Yes241F50.890.10 No241M53.398.90 Yes5041M63.690.22 No962M70.490.32 Yes481M12.890.16 No480M14.490.08 No723M20.290.13 No12M21.190.37 Yes482F23.3913.30 No722F44.090.37 Yes240M65.391.05 Yes965F70.094.35 No243F75.7922.38 Yes2641M96.894.53 Yes20M100.190.45 Yes3362F141.390.18 No481F142.995.73 Yes1923F17.998.61 No480M24.397.15 No04M28.190.76 No242F30.590.05 Yes1681M34.594.08 Yes720F37.890.36 No241F39.498.67 No482F44.898.97 Yes962M51.7916.56 No245M69.594.54 No241M77.594.18 Yes481M103.095.53 Yes7204M31.290.25 Yes1202M35.190.28 Yes1203M114.8918.48 Yes242M150.898.93 No42M90.1930.07 Yes23F12.290.17 Yes722F13.091.34 No241M15.493.05 No241F15.4912.02 No481M18.490.39 Yes964F20.190.83 No241M21.892.07 No480M22.390.19 No52F23.690.33 No481F32.290.05 Yes721M33.496.57 No241M34.690.05 No481M39.990.74 No480M60.9914.36 No241M88.6913.04 No1682M90.199.47 No482M146.892.78 No4082M11.7102.67 Yes1201M13.5100.09 Yes240M16.6100.13 No1683M18.51014.42 No241F18.91018.11 Yes1924M27.8100.05 No244M34.91015.22 No240F43.4105.56 Yes482F46.81010.56 Yes722F55.1100.63 Yes480M56.3100.44 No240F62.0103.31 No244M69.3100.73 Yes962F90.1104.14 No482F124.6101.77 Yes244M180.1102.02 No721M17.8104.22 No482M21.7100.27 No482F22.1100.38 Yes1683M22.6101.06 Yes722F37.9100.36 Yes1681F39.7100.33 No961M42.5100.22 No13F46.71013.86 No1685F51.21017.06 Yes962F177.9105.07 Yes241M34.7100.44 No480F11.8108.62 Yes244M15.2100.64 Yes482M15.8100.09 No484M18.6108.96 Yes04F19.0100.08 No722F22.5102.45 No241F25.1101.40 No960M28.7100.21 No242M28.8101.16 No964F32.5105.92 No241F33.3100.30 No482M40.2101.11 Yes244F68.8103.56 No483M79.8100.27 No13M11.9100.52 No242M11.4101.43 No720F13.31010.26 Yes244F14.5101.26 No483M14.9100.82 No485F21.3100.40 No1203M24.1100.05 No720F28.7100.25 No0.52M39.5109.63 No10F40.4105.67 No242M46.1105.95 Yes1682M46.7100.05 Yes241M48.9105.33 Yes243F54.0100.85 No40F55.5106.01 No244M57.7100.05 Yes480M12.3100.05 Yes1682F12.81014.78 No244F14.1100.08 No243F18.6103.44 Yes03M24.01022.19 No245F27.41018.96 No240M32.8100.22 Yes3363F44.5101.78 No961F57.6101.26 Yes481M61.9100.23 Yes244F84.5107.18 Yes721M110.0100.12 No240F11.2100.11 No240M18.8100.09 No240M20.0100.42 No245F23.1100.28 Yes242M41.1100.37 No481M98.6100.18 No3362M103.7107.54 Yes962F107.5107.77 Yes482M11.1103.38 No241M17.01012.97 No242M24.3100.28 No12F36.51016.20 Yes1202F38.6100.24 No3362F47.5100.25 No241M50.1100.14 No241M68.4101.79 Yes482F68.9101.47 No722M83.4102.76 No10M132.7102.03 No1442F19.61012.56 No241M27.5103.46 No243F35.4102.59 No85F35.9108.92 No722F42.4100.12 No244M42.7100.05 No2403M63.6101.29 Yes240M175.6103.81 Yes725F181.0100.03 No484F17.1100.08 No481F28.8100.43 Yes725F29.0100.06 No243F31.8100.21 No13F36.1100.05 No241F38.8101.35 No721F71.4100.39 No122F138.1100.36 Yes1203F143.1100.39 No484F155.6102.18 No00M20.71015.64 No483M24.6100.11 No244F31.1100.10 No482F31.4101.03 No240F32.2106.03 No1202F47.5102.08 Yes14401M67.9106.75 No483M87.1100.60 No724F87.51019.89 No242F133.7104.15 Yes242F13.4110.12 Yes1921M15.0110.56
homework-3-data-2022-a23nfwda.xlsx homework-3-2022-mrddscn2.doc answers-to-hw-1-2022-nbcs5ygj.docx
Answered 1 days AfterApr 27, 2022

Answer To: Question 1 InfectedMins Exposed# InjuriesSexCarapace LengthBlood Protein IndexPattern...

Manoj answered on Apr 29 2022
98 Votes
Question 1]
Statistical Test Required:         Multinomial logistic regression
Independent Variables            1. Mins_Exposed
                    2. Injuries
                    3.Sex
                    4. Carapace_Length
                    5. Blood_Protein_Index
                    6. Pattern_Recognition_Protein_Concentration        
Dependent Variable:             Infected
Assumption Checking:         assume all are met
R:Code –
library(readxl)
library(car)
library(rcompanion)
dt1 = read_excel('D:/Tutorbin/29Apr/homework-3-data-2022-a23nfwda.xlsx','Question 1')
dt1$Infected = ifelse(dt1$Infected == 'Yes', 0,1)
model.null = glm(Infected ~ 1,
data=dt1,
family = binomial(link="logit")
)
model.full = glm(Infected ~ Mins_Exposed + Injuries + Sex + Carapace_Length + Blood_Protein_Index + Pattern_Recognition_Protein_Concentration , data = dt1, family = binomial(link="logit"))
step(model.null,
scope = list(upper=model.full),
direction="both",
test="Chisq",
data=dt1)
model.final = glm(Infected ~ Mins_Exposed + Injuries , data = dt1, family = binomial(link="logit"))
Anova(model.final, type="II", test="Wald")
nagelkerke(model.final)
R Output:
Infected ~ Mins_Exposed + Injuries + Sex
Df Deviance AIC LRT Pr(>Chi)
1933.2 1941.2
- Sex 1 1935.5 1941.5 2.3213 0.1276
+ Pattern_Recognition_Protein_Concentration 1 1932.2 1942.2 1.0545 0.3045
+ Carapace_Length 1 1932.2 1942.2 0.9578 0.3278
+ Blood_Protein_Index 1 1932.7 1942.7 0.5178 0.4718
- Injuries 1 1954.2 1960.2 21.0500 4.475e-06 ***
- Mins_Exposed 1 1959.0 1965.0 25.8106 3.766e-07 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Call: glm(formula = Infected ~ Mins_Exposed + Injuries + Sex, family = binomial(link = "logit"),
data = dt1)
Coefficients:
(Intercept) Mins_Exposed Injuries ...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?