Please show steps in excel Honest Juan\'s is a used car dealer in the area. Ther
ID: 3134341 • Letter: P
Question
Please show steps in excel
Honest Juan's is a used car dealer in the area. There are six car sales representatives at the dealership. The sales for the last six months for the sales reps are as follows:
Ernie Banks - 54 Juan Marchial - 50 Willie Mays - 52 Duke Snider - 58
Elston Howard - 48 Bob Gibson - 50
a. How many samples of size two are possible? (1 pt)
b. Select all possible samples of size 2 and compute the mean number sold. (2 pts)
c. Organize the sample means into a frequency diagram. (2 pts)
d. What is the mean of the population? What is the mean of the sample means? (2 pts)
e. What is the shape of the population distribution? (1 pt)
f. What is the shape of the distribution of the sample means? (2 pts)
Explanation / Answer
Ernie Banks - 54 Juan Marchial - 50 Willie Mays - 52 Duke Snider - 58
Elston Howard - 48 Bob Gibson - 50
A) WE HAVE TOTAL 6 PEOPLE AND SAMPLE OF TWO HAS TO BE CHOOSEN
TOTAL WAYS IN WHICH THIS CAN BE DONE = 6C2 = 15WAYS
B) TOTAL SAMPLE OF 2 SIZE = 15
ARE
GROUP MEAN
BANKS,MARCHIAL 52
BANKS,MAYS 51
BANKS,SNIDER 56
BANKS,HOWARD 51
BANKS,GIBSON 52
MARCHIAL,MAYS 51
MARCHIAL,SNIDER 54
MARCHIAL,HOWARD 49
MARCHIAL,GIBSON 50
MAYS,SNIDER 55
MAYS,HOWARDS 50
MAYS,GIBSON 51
SNIDER,HOWARD 53
SNIDER,GIBSON 54
HOWARDS ,GIBSON 49
C) MEAN FREQUENCY
49 2
50 2
51 4
52 2
53 1
54 2
55 1
56 1
D) MEAN OF THE POPULATION MEANS WE HAVE TO TAKE IN ACCOUNT THE ALL THE 6 PEOPLE
MEAN WILL BE = (54+50+52+58+48+50)/6 = 312/6 52
AND THE SAMPLE MEAN ARE GIVEN ABOVE IT WILL VARY FROM 49 TO 56