Category Archives: Statistics Help

Regresión Cuadrática en Excel y Líneas de Tendencia Cuadráticas en Gráficos de Excel

¿Necesitas realizar una Regresión Cuadrática en Excel? ¡No busques más! Al continuar mis esfuerzos de incluir más materiales en español en mi sitio web, MattCHoward.com, ahora cuento con guías sobre cómo realizar una regresión cuadrática en Excel y cómo crear líneas de tendencia cuadráticas en gráficos de Excel. Los enlaces a estas guías están aquí: Regresión Cuadrática en Excel y Líneas de Tendencia Cuadráticas en Gráficos de Excel . Los enlaces a todos mis materiales en español están aquí: Ayuda de Estadísticas de Excel .

Una vez más, ¡gracias a krauz1 por su ayuda con la traducción! Puedes encontrar un enlace a su página de Fiverr aquí: https://www.fiverr.com/krauz1/translate-english-to-spanish-1000-words .

Mediation and Moderation in Jamovi

Hi all! I just added two new pages to MattCHoward.com for conducting statistics in Jamovi. The first covers mediation in Jamovi, whereas the second covers moderation in Jamovi. Links are below, and, as always, feel free to reach out if you have any questions. My email is MHoward@SouthAlabama.edu.

Mediation in Jamovi

Moderation in Jamovi

Help Pages in Jamovi

Several New Help Pages on Jamovi

Hi everyone!  I spent all weekend making several new help pages on the statistical software, Jamovi.  It is a wonderful and free program that can perform most basic statistical analyses, and it functions similarly to SPSS.  Because my students cannot use the on-campus computer lab at the same time this semester, I am instead teaching my stats courses using Excel and Jamovi.  It is quite the lifesaver!

Below are links to the new help pages that I made.  Also, here is a link to my page with all Jamovi guides: https://mattchoward.com/jamovi-statistics-help/ .

Chi-Square in Jamovi

Cronbach’s Alpha in Jamovi

Descriptive Statistics in Jamovi

Dummy-Coded Regression in Jamovi

One-Sample T-Test in Jamovi

One-Way ANOVA in Jamovi

Quadratic Regression in Jamovi

Regression in Jamovi

Two-Sample T-Test in Jamovi

Two-Way ANOVA in Jamovi

Please let me know if you have any questions, comments, or requests regarding Jamovi.  I am always happy to talk about such a wonderful program.  Thanks!

pyMTurkR Error and Solution

I have been learning pyMTurkR because MTurkR and MTurkRGUI no longer work.  It has been challenging, but I finally have it working. . .mostly.  I am posting this comment primarily for myself because I know I will forget this solution one day, but I hope that it can also help others at some point.

When using the GrantBonus() command, following the instructions on the pyMTurkR documentation will give you an “Invalid Request” error.  This is because the instructions tell you to type the monetary amount as “.50” for example.  It will give you an error unless you put a 0 in the dollar amount place when paying in cents.  That is, “.50” should be entered as “0.50”.  Otherwise, it will give you the Invalid Request error.  Hope this helps someone – particularly myself in the future when I forget this!

New Page on Two-Way ANOVA in Excel!

Although Excel isn’t the best at calculating a two-way ANOVA, it can provide some results.  So, I created a page on how to perform the analysis in Excel.  It can be found here: https://mattchoward.com/two-way-anova-in-excel/ .  As always, email me at MHoward@SouthAlabama.edu if you have any questions or comments!

T-Tests in Excel on YouTube

I just finished uploading my latest lecture to YouTube.  It covers how to perform one-sample t-tests and two-sample t-tests in Excel.  While both are extremely important statistics, the latter cannot be easily calculated in Excel.  So, I hope that this video is helpful in figuring out how to calculate the statistic.

Here is the link to the YouTube video: https://www.youtube.com/watch?v=GOs_IXTHT5w .

As always, please contact me at MHoward@SouthAlabama.edu if you have any questions.

One-Sample T-Test in Excel

Although I’ve been putting it off for months (years?), I finally made a guide on performing a one-sample t-test in Excel.  The “Data Analysis” add-on in Excel is not able to calculate this statistic directly, so we have to trick Excel into calculating it for us.  Nevertheless, the guide provides clear instructions on how to do so.

Here is a link to it: https://mattchoward.com/one-sample-t-test-in-excel/ .

Please email me at MHoward@SouthAlabama.edu if you have any questions!

Statistics Lectures Now on YouTube!

Every semester, I try to upload my lectures to the University of South Alabama’s course management site, and, every semester, I run out of space before the halfway mark of the semester.  Our IT department recently recommended that I upload my videos to YouTube to avoid these space difficulties.  So, I am doing just that!

I already uploaded my first two lectures.  The first is a general review of statistics with a focus on descriptive statistics and p-values.  The second is an overview of one-variable chi-square tests and the chi-square test of independence (also called two-variable chi-square tests).  The links are provided below:

Lecture 1 – Review – https://www.youtube.com/watch?v=-IvU7uTQ9u0

Lecture 2 – Chi-Square – https://www.youtube.com/watch?v=sRxTvZiV8Lg

As always, if you have any questions or comments, please contact me at MHoward@SouthAlabama.edu.