¿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 .
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
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!
With a new semester, I am teaching a new statistics program – Jamovi! It is free, useful, and intuitive. I plan to add a lot more guides to the following page, but click here for my new Jamovi Statistics Help page.
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 using regression for prediction in Excel! It can be found here: https://mattchoward.com/prediction-with-regression-in-excel/ . As always, email me at MHoward@SouthAlabama.edu if you have any questions or comments!
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!
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.
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!
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.