0This workshop covers some basic descriptive statistical methods that can be used through the Data Analysis ToolPak Add-On of PC based Microsoft (MS) Excel 2013. This workshop moves beyond the Basic MS Excel workshop with an emphasis on descriptive statistical methods that can be executed using MS Excel. The UNM 5 skills addressed in this workshop are professionalism, research and assessment, communication, and critical thinking#Y \!LwIwU\M\IwIw|ПPwLПPwT*MwIw10IwTruIwILwYwIwTru(5fKwIwKUOw1010TruPDIwRQwRQwTruRQw10Tru1000\MwMVuTruMw Iw MVu@ OwTru\10LwTLwCF
D/-uaQtk`rQt*_,P?u<\P,T?uQ?u^@IQ?uBPtpPtpPt0! H>ukx! !H>u#xx42k0.^4=>u!untitled1k (kx!0Qtk1k (x5:ukNAI4@>uk@>u
5 V5
<
kx!0LRt0kkk1k (`d:ukNAI ){pkd{p#kk?x!P^O?uDF@u@W*̲̲p_̲11F:?upp~^ 5X4pDF@uFW*tŤ^ 5 5^4_X4_X4PQ]h{O]<*X4X4^0Pʓ^F@u@W*Ƞ>uVQwFX4^0ՠ>u̲6^</]VQw̲^0Ls;i{O]oe]фl]b]H<*!]P^00Lw":i]"]X4P,[+@uPͫ!]TsPw }Mw@8Wh`Nw8|p]\yMw@4zMw\#Statistics: Which redIntro to Stats from Khan Academy via the EASE website. jThis presentation on the EASE website. JGoogle.OThe library.KOur TAs.Statistics: Which resource was presented if I want more information on Statistics? [rSpqUemEta].Which type of test to perform given your data:dMen and women are not, on average, the same height. People from New Mexico, Texas and Nevada are not, on average, the same height.) The temperature of the earth decreases with latitude. t-test because categorical (gender) + numerical (height) and 2 groups. ANOVA because categorical (state) + numerical (height) and three groups. Regression because both variables (temperature and latitude) are numerical.Match the Hypothesis: write the appropriate type of test AND explain WHY you selected that answer. [rSpqUemEta]Regression: What is2R2 = 0.648 and yes because the significance F is smaller than our alpha.HR2 = 0.648 and no because the significance F is smaller than our alpha. IR2 = 0.620 and yes because the significance F is smaller than our alpha. HR2 = 0.620 and no because the significance F is smaller than our alpha. Regression: What is the R2 and is the regression significant? [rSpqUemEta]Regression: What doe2The size of the house is correlated with the price at which the house sells.BThe price at which the house sells affects the size of the house. ,Nothing can be inferred with this analysis. 1The size of the house affects the selling price. <There is no connection between house size and selling price.Regression: What does the regression analysis tell you about the relationship between house selling price and size? [rSpqUemEta]T-test: What is thedf9.51E-4 and yesh4.76E-4 and yes. g9.51E-4 and no. g4.76E-4 and no. T-test: What is the p-value and are the means of the two groups significantly different? [rSpqUemEta]ANOVA: What is the pdl3.36E-6, yes, and no m3.36E-6, yes, and yes.l3.36E-6, no, and n/a.3.36E-6, not enough information.

ANOVA: What is the p-value, are ANY of the groups significantly different, if so, can you tell which groups are different? [rSpqUemEta][rSpdOcmEta],$b5b518aa-ac01-4d44-a470-523f9acf946c