SUMMARY STATSTICS, SIMPLE PLOTS in SAS, EXCEL, JMPPart 2: ProbabilityThen COPY/PASTE that cell to cells I3:I161In the third partThen COPY/PASTE that cell to cells K3:K161Hints on Assignment 1Part 1: Summarizing DataIn the second part:SAS Users: Run PROC MEANS 4 times (once per factor) e.g.:PROC MEANS; CLASS GROWAREA; VAR FLAVOR; RUN;PROC MEANS; CLASS HOLDTEMP; VAR FLAVOR; RUN;…EXCEL USERS: See the document on my website:OBTAINING SUMMARY STATISTICS AND PLOTS BY GROUPS (FACTOR LEVELS) IN EXCELIn the fifth part:SAS Users: Run PROC MEANS with both factors in the CLASS statement:PROC MEANS; CLASS HOLDTEMP COOKMETHOD; VAR FLAVOR; RUN;Then I would suggest entering those means in EXCEL and mimic example on Slide 12 of:SUMMARY STATSTICS, SIMPLE PLOTS in SAS, EXCEL, JMPEXCEL Users: See the document on my website:OBTAINING SUMMARY STATISTICS AND PLOTS BY GROUPS (FACTOR LEVELS) IN EXCELPart 2: ProbabilityI would suggest doing this in EXCEL (this is cells A1:H6 of my spreadsheet)COL A B C D E F G HGrowarea HoldTemp Size StorTime CookType Texture Flavor Moist1 1 1 1 1 2.9 3.2 31 1 1 1 2 2.3 2.5 2.61 1 1 1 3 2.5 2.8 2.81 1 1 1 4 2.1 2.9 2.41 1 1 1 5 1.9 2.8 2.2You can obtain probabilities by creating new columns that contain 1s and 0s, depending on whether the criterion is met.In the first part:In cell I2, type: =IF(F2>=3,1,0)Then COPY/PASTE that cell to cells I3:I161Note that this command says that if this row’s flavor score is 3, then assign a 1, otherwise assign 0.Then obtain the probability by typing (in say cell I165): =SUM(I2:I161)/COUNT(I2:I161)In the third partYou need to count the number of cases in the intersection and divide by the number of cases in the conditioning event. First, create a column (say column K) that contains 1s and 0s depending on whether or not both events occurred. In Cell K2, type: =IF(AND(A2=1,H2>3.0),1,0)Then COPY/PASTE that cell to cells K3:K161Second, you could create a column (say column L) that contains 1s and 0s depending on whether or not the conditioning event occurred (Column A is equal to 1). Alternatively, you can use the COUNTIF function.Then obtain the conditional probability by typing (in say cell K165):
View Full Document