Let’s get started.1. Calculate the Improvement Level in column D.2. Its okay to have a negative value in column D.
Descriptive StatisticsLet’s get started.1. Use the descriptive statistics formulas you used in Topic 1 DQ 2. Descriptive Statisticsearsoncmg.com/assets/gtq1e_1_4_1_24_Descriptive_Stats2. What is the standard error?.3. The SE = SD/sqrt(of the number of data items).
Frequency TableLet’s get started.1. Notice that we have 11 rows in our table.2. These rows represent different groups that we are organizing our data into.3. In our table we are calling them Bins.
Frequency Table Cont.Let’s get started with the low value in cell F14.1. The low value is the minimum value from our statistics, G3.2. Note, some use G3 – 0.1 for that low value.
Frequency Table Cont.Let’s get started.1. Notice there is added a Bin Width calculation in cell G10.2. The Bin Width = the range/11. The range = MAX - MIN.3. The High value is the low value + Bin Width, =F14+G$10.