0 This 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 \ !Lw Iw U\M\ Iw Iw |ПPwLПPwT*Mw Iw 10 IwTru Iw ILwYw IwTru (5fKw IwKUOw10 10Tru P D IwRQw RQwTru RQw10Tru 10 00 \Mw MVuTruMw Iw MVu@ OwTru \10 Lw TLw C F
D /-uaQt k` rQt*_,P?u<\P ,T?uQ?u^ @IQ?uB PtpPtpPt0 ! H>u kx ! ! H>u#x x 42 k0 .^4=>u! untitled 1 k ( kx ! 0 Qt k1 k ( x 5:u k NAI 4@>u k @>u
5 V5
<
kx ! 0 LRt 0 k k k1 k ( `d:u k NAI ){p k d{p # k k ?x ! P ^O?uDF@u@W*̲̲p _̲11 F:?upp ~^ 5 X4p DF@uFW*tŤ^ 5 5^ 4 _ X4 _X4PQ] h{O]<*X4X4^0 P ʓ^ F@u@W* Ƞ>uVQw F X4^0ՠ>u̲ 6^</]VQw̲^0Ls ;i{O]oe]ф l ] b]H<*!]P ^0 0Lw":i ] "]X4P ,[+@uP ͫ !] TsPw }Mw@ 8 Wh `Nw 8 | p ]\yMw@ 4zMw \ # Statistics: Which re d Intro to Stats from Khan Academy via the EASE website. j This presentation on the EASE website. J Google. O The library. K Our TAs. Statistics: Which resource was presented if I want more information on Statistics? [rSpqUemEta] . Which type of test to perform given your data: d Men 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 is 2 R2 = 0.648 and yes because the significance F is smaller than our alpha. H R2 = 0.648 and no because the significance F is smaller than our alpha. I R2 = 0.620 and yes because the significance F is smaller than our alpha. H R2 = 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 doe 2 The size of the house is correlated with the price at which the house sells. B The price at which the house sells affects the size of the house. , Nothing can be inferred with this analysis. 1 The 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 the d f 9.51E-4 and yes h 4.76E-4 and yes. g 9.51E-4 and no. g 4.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 p d l 3.36E-6, yes, and no m 3.36E-6, yes, and yes. l 3.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