Question

Mafer Dominguer EXLET Onicemsed PTOOIct le Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do G K L M N Egrollment 26,106 Part 2: Using the Data Analysis Tool Using Descriptive (Length 3.26) Statistics to find measures of central tendency and dispersion Video #20 18,864 1,718 44,354 h. GO to the Data tab, use the Data Analysis tool, select Descriptive Statistice and place the results table to the right in column N. Do not use the default setting of new worksheet. 17,194 41,444 Highlight the results for the variables you were asked to find in Part 1 23,902 Why is there a difference in the values for variance and standard deviation found 65,278 in Part 1 and Part 2? 36,493 k. How to use Descriptive Statistics to eva skewness (Length: 2:54 4,230 Vi # 28 Highlight the Skewness variable. Does this support your conclusion in Part 1 when you 20,595 compared the value of the mean, median and mode? 17,460 12,512 Skewness is from Chapter 4 Learning Outcome 4 Empirical Rule Video #22 How to apply the Empirical Rule using Descriptive Statistics (Length 4.16) Lower Limiuppe Apply the Empirical Rule and input your results into the table on the right. m. 1 s 2s 3 s Turnover Time Enrollment Type here to search

Answer 1

Question h.

Place the data in excel as shown

A B 1 Enrollment 2 26106 3 1718 4 44354 17194 5 6 41444 23902 7 8 65278 36493 10 4230 11 20595 12 17460 13 12512 14 15 16 17

Select the descriptive statistics from the Data analysis tab

O Search Share Review View Developer Data Help Data Analysis Clear Solver Reapply Outline Filter What-If Forecast Sort Text to graphy Advanced Analysis Sheet Columns Sort & Filter Data Tools Analyze Forecast s H G P Data Analysis ? Analysis Tools OK Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Cancel Correlation Help Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram

Input the values as shown.

The results will be shown as below

Data Types Sort & Filter et & Transform Data Queries & Connections fix G9 A B X Descriptive Statistics 1 Enrollment Input 2 26106 OK $A$1:$A$13 Input Range: 3 1718 Cancel Columns Grouped By: 44354 Rows Help 17194 Labels in first row 6 41444 7 23902 Output options 65278 $D$1 36493 Output Range: 10 4230 New Worksheet Ply: 11 20595 ONew Workbook 12 17460 Summary statistics 13 14 12512 95 Confidence Level for Mean: 15 1 Kth Largest: 16 1 Kth Smallest 17 18 19 . 96 Ln O Ln

Enrollment Mean 25940.5 Standard Error 5264.077066 Median 22248.5 #N/A Mode Standard Deviation 18235.29787 Sample Variance 332526088.3 Kurtosis 0.513360797 Skewness 0.786379544 Range 63560 Minimum 1718 Maximum 65278 311286 Sum Count 12

Question i
Skweness variable
Skweness helps us to understand the symmetry of the distribution.
A normal distribution has a skweness of zero.
In our current cast, the skweness value is 0.87, which indicates that data has a moderately positive skew

Note - The thumb rule suggest the following

If skew value is less than −1 or greater than +1, the distribution is highly skewed.
If skew value is between −1 and -0.5 or between 0.5 and +1, the distribution is moderately skewed.
If skew value is between - 0.5 and 0.5, the distribution is approximately symmetric.

Question m

The calculation for the empirical distribution are given below.

Empirical Rule Upper limit 7705.21 25940.5+(1*18235.29) 44175.79 Lower limit |25940.5-(1*18235.29) 25940.5-(2*18235.29) -10530.08 25940.5+(2*18235.29) 62411.08 25940.5-(3*18235.29)-28765.37 25940.5+(3*18235.29) 80646.37 1s 2s 3s

The remaining questions cannot be solved, since they have reference to other question.