chocolatejilo.blogg.se - Basic statistics in excel

#BASIC STATISTICS IN EXCEL HOW TO#
#BASIC STATISTICS IN EXCEL FOR MAC#

How to Install Excel’s Analysis ToolPak.You should study these notes carefully, follow along with the examples in the textbook, and practice the exercises in the notes using Microsoft Excel until you are comfortable with the concepts. I suggest you work out the practice problems on your own and then use the solutions to confirm your responses. I have provided practice problems with worked out solutions. This video shows how to use Excel for chi-square test for independence. Chi-Square Test of Independence in Excel (4:25).This video explains the one-way ANOVA using Excel.

This video explains the t-test for one population using six steps. This video tutorial shows how to construct a confidence interval in Excel. This video shows common mistakes you can make when using Excel to perform regression. This video covers correlation and regression using Excel.

Correlation and Regression in MS Excel 2013 (20:22).

This video provides a brief example of calculating descriptive statistics using Excel.

Calculating Descriptive Statistics in Excel (1:32).

This video provides a brief discussion of the normal and standard normal distributions including examples. Learn how to use descriptive descriptions with the Excel ToolPak. This tutorial explains how to install the Data Analysis ToolPak in Microsoft Excel.

How to Install the Data Analysis ToolPak in Microsoft Excel (2:05).

This video discusses basic statistics and its role in decision making. This video introduces you to the first chapter of an introductory statistics course.

Introductory Statistics – Chapter 1: Introduction (9:05).

This video introduces statistics and data.

Descriptive Statistics in Excel (Measures of Central Tendency and Variation).

If, during your tenure in this course, you find other videos that may be helpful in addition to or in place of these, please feel free to share them with me as I will consider adding them to the video bank for future students. These videos are all posted on YouTube and in the public domain and are presented here to provide demonstration to topics covered inside and outside of this course as a supplemental to my lecture notes and screenshots.

#BASIC STATISTICS IN EXCEL FOR MAC#

Attached are some instructions for using that software for Mac users that might be helpful. Make sure to stick with the free version, it should be fine for our purposes.

Email: | Phone: 904.863.7051 Course Content Chapter 1: Introduction to Statisticsįor Mac users only: The analysis toolpak is not icluded in the Mac version of Excel, but you can download a free substitute from I have not tested the software, and I don’t have a Mac, but it sounds promising.