Question

I honestly have a lot of questions regarding frequency tables, regression, standard deviation and so on questions. I’m not great at math and these formulas are all very confusing. Is there a simpler way to understand these formulas in your basic STAT 201 class? I really need help dumbing it down for me.... thank you!

Answer 1

Frequency tables:

Frequency table will be created in two ways.

Frequency distribution of grouped data and ungrouped data.

Grouped data :

First frequency would be measured based on the each class interval. say for example,

Formula reference

Histogram based on frequency and class interval

Ungrouped data

example:

data
18
18
17
17
17
16
16
16
16
16
16
15
15
15
15
14
14
14
14
14
14
12
12
12
12
11
11
11
10
10

based on the above data ungruped frequency table will be created

Regression

Regression is so easy to calculate in excel.

Go to data tab --> choose data analysis and choose regression statistics.

standard deviation:

you can calculate standard deviation for any data set with formula. if you type "=stdev" in excel then formula tab would open and ask input. the same way mean calculation in excel

mean	=AVERAGE(Q3:Q32)
median	=MEDIAN(Q3:Q32)
mode	=MODE(Q3:Q32)
stdev	=STDEV(Q3:Q32)