Lets get started 1 Calculate the Improvement Level in column D 2 Its okay to

# Lets get started 1 calculate the improvement level in

• 17

This preview shows page 5 - 11 out of 17 pages.

Let’s get started. 1. Calculate the Improvement Level in column D. 2. Its okay to have a negative value in column D. Descriptive Statistics Let’s get started. 1. Use the descriptive statistics formulas you used in Topic 1 DQ 2. Descriptive Statistics earsoncmg.com/assets/ gtq1e_1_4_1_24_Descri ptive_Stats 2. What is the standard error?. 3. The SE = SD/sqrt(of the number of data items). Frequency Table Let’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. Frequency Table Cont.  #### You've reached the end of your free preview.

Want to read all 17 pages?

• • •  