T-TEST on Excel
In this video, I showed how to place a t-test on Excel
1. Double Click on any empty box
2a. Formulas
2b. More Functions
2c. Scroll down for T-TEST
3. Array 1 is your first set of data
Array 2 is your second set of data
Tails 2
Type 2
122
views
1
comment
Standard Deviation on Excel
How to put a standard deviation on Excel
In this video I used STDEV.S
1.Click on any empty box
2. Type =STDEV.S( Inside the parenthesis type the letter and number of where your data begins, colon, letter and number of where your data ends, then click enter. For instance mine was =STDEV.S(A2:A11).
Different types of standard deviation on Excel
1. STANDARDIZE is used for the mean and standard deviation
2. STDEV.P is used for an entire population excluding/no the text and logical values
3. STDEV.S is used for a sample, excluding/no text and logical values
4. STDEVA is used for a sample with text and logical values
5. STDEVPA is used for an entire population with text and logical values
96
views
Mean on Excel
There are three ways to put a mean on Excel
1a. Click on an empty box
b. Type =AVERAGE,
c. Click on AVERAGE
d. Then type the opening parenthesis, type the letter and the number of where your first data set is, then colon, type the letter and number of where your last data point is, then the closing parenthesis. Lastly, click Enter. For Example =AVERAGE(A2:A11). You would know that you are doing it correctly because your data set would be highlighted as you go.
2a. Click on an empty box
b. Click on AutoSum, then on the drop-down click on AVERAGE
c. Then type the letter and the number of where your first data set is, then colon, type the letter and number of where your last data point is. For instance =AVERAGE(B2:B11). then click Enter
3a. Click on an an empty box
b. Click on Formulas, then click on More Functions, on the drop down choose Statistical, then AVERAGE.
c. Use only Number1 if you are only using one set of data.
However, if you are using multiple data sets then type the letter and the number of the first and last of your data sets for Number1, Number2, etc.
For instance one data set
Number1 (A2:A11)
Multiple data sets
Number1 A2:A11
Number2 B2:B11
87
views
How to Bake using Pillsbury Vanilla Cake
This is a step by step video on how I baked using Pillsbury Vanilla Cake Mix. I placed the mixture in the oven for 36 minutes.
82
views