Therefore, start by reading the example we use throughout this introductory guide in the next section. On this page, we set out the example we use to illustrate how to carry out an independent-samples t-test using R, before showing how to set up your data using Microsoft Excel, R and RStudio. On the previous page you learnt about the type of research where an independent-samples t-test can be used and the critical assumptions of the independent-samples t-test that your study design, variables and data must meet in order for the independent-samples t-test to be the correct statistical test for your analysis. How fast did you finish? Which solution(s) did you use to approach each problem? Comment and let me know.Independent-samples t-test using R, Excel and RStudio (page 2) For 99% of people, it’s also much harder to make mistakes in pivot tables than in formulas. Number-crunching experience under my belt before I even discovered that pivotĪfter that, it took another five years to realize that pivot tables are faster than formulas for 99% of people. I had a good five years of all-day-every-day I’d been taught-informally, on-the-job, by fellowīefore that, I’d also been taught-formally, in undergraduateĪnd graduate classroom settings-to use formulas in SAS and SPSS. I was personally very slow to adopt pivot tables. Better Solutionsįormulas! You’ll see countif, countifs, counta, countblank,īut you can also make typos. This is what most people do before we’ve been exposed to time-saving strategies. Anything that can’t be replicated by your Future.Highlighting a range of numbers and counting.Eye-balling (mentally tallying by looking at the.Tallying by hand (by pointing at the screen).Throughout the lesson, you’ll hear me refer to bad, better, and best solutions. Is the participant that lives in Parkside that has only one child? 33īad, Better, Best: A Range of Correct Solutions How many participants are 18 years old? 4Īges of 14 and 19 have 4 or more children?.(exactly as it appears in the data – with the misspelling): Parsdise Participant unique IDs) are included in this data set? 114Ģ0019 zip code (include anyone that does not have 20019 as a zip code)? 4 – 1 Is the participant that lives in Parkside that has only one child? How many participants that are between theĪges of 14 and 19 have 4 or MORE children?.How many participants are 18 years old?.How many African Americans live in Kenilworth.How many participants have blank (missing).(exactly as it appears in the data – with the misspelling): Please write out the misspelled value below There is a typo in one of the Neighborhoodĭata fields – one value is spelled differently than the rest.How many participants live in the Lotus.How many participants DO NOT live in theĢ0019 zip code (include anyone that does not have 20019 as a zip code)?.Participant unique IDs) are included in this data set? Lesson on January 31, 2020, so my answers are dependent on that date. Some of the questions require using a date. Your Turn: Take the Excel Test!ĭownload the spreadsheet here: Download the spreadsheet I want to show you that even somebody who does this for a living still gets stuck sometimes. Maybe I’ve still got it!Īnd I might wish I never recorded this video at all. My time training others on data visualization-which means I spend less time I’m going to see if, ten years later, I can still pass! Isaac (the interviewer) and I thought this would make a … Re-Taking the Excel Test from Ten Years Ago I hoped I could actually do those things! He led me to another office across the hall. I was going on and on about all my great spreadsheet skills.īecause that’s what you do in interviews, right?Īnd then the interviewer was like, “Prove it. Level was pretty high: that you could work totally independently. It was a fast-paced office, so the expectation I remember sitting in the interviewer’s office. Improvement Specialist,” “Research Analyst,” or even “Data Scientist.” The official job title was “Learning and Evaluation Specialist.” Nowadays, you might hear it called “Quality Ten years ago, I was interviewing for an analyst position.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |