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

Lets get started 1 calculate the improvement level in

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.
Image of page 5
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).
Image of page 6
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.
Image of page 7
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.
Image of page 8
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.
Image of page 9
Frequency Table Cont.
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 17 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes