INSTRUCTIONS As a group: Answer the following questions involving Descriptive St
ID: 3066517 • Letter: I
Question
INSTRUCTIONS
As a group: Answer the following questions involving Descriptive Statistics
Draw (create) a random sample of 50 from the full database then answer the following questions. You will ultimately use the sample of 50 from the full population of 408 to compare and contrast the sample and the population in the questions below. Typically you would not have the data for the entire population (such as in an election). So the point of this project is to use various statistical methods to examine how well your sample matches the population. It is obvious that the charts, figures etc. for the population should be the same for each group (or individual) that does this project. However, I would not expect to see the same results for any two groups (or individuals) samples since they are created using the Random number generator (RNG) mentioned below. This is a detailed and important project in this course, start early and take the time to do a good job. This assignment is worth twice what any one exam is worth.
Use the numbers below to complete 3&4
RNG
246
9
340
74
131
52
216
292
193
154
90
118
194
7
94
372
96
312
166
283
300
391
212
4
353
49
161
398
129
4
62
264
359
341
236
155
259
242
76
399
391
303
368
2
398
210
212
193
79
107
3. Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for your SAMPLE. Save yourself some work here by using the Excel Descriptive statistics function.
4. Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for the POPULATION. Save yourself some work here by using the Excel Descriptive statistics function.
RNG
246
9
340
74
131
52
216
292
193
154
90
118
194
7
94
372
96
312
166
283
300
391
212
4
353
49
161
398
129
4
62
264
359
341
236
155
259
242
76
399
391
303
368
2
398
210
212
193
79
107
Explanation / Answer
Solution3:
Select Data--->Data analysis---->Descriptive Statistics click ok
select data range as $A$1:$A$51
select labels in first row
select summary statistics
select k th largest
select kth smallest
Click OK
You ill egt below outut:
RNG Mean 201.92 Standard Error 17.66300966 Median 202 Mode 193 Standard Deviation 124.8963391 Sample Variance 15599.09551 Kurtosis -1.17665746 Skewness 0.038322695 Range 397 Minimum 2 Maximum 399 Sum 10096 Count 50 Largest(1) 399 Smallest(1) 2Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.