Statistics Help

·

Q	Answer	Q	Answer	Q	Answer	Q	Answer	Q	Answer
1		11		21		31		41
2		12		22		32		42
3		13		23		33		43
4		14		24		34		44
5		15		25		35		45
6		16		26		36		46
7		17		27		37		47
8		18		28		38		48
9		19		29		39		49
10		20		30		40		50

Using the Car Sales data in the attached spreadsheet answer the following questions

Dealership	Sales people	New Car Brand	New cars sold each week	Used Cars sold each week	BBB Rating	Profit from New Car Sales	Profit from Used Car Sales	Profit*
A1	19	Ford	12	7	AAA	45300	24047	69347
A2	10	Toyota	15	6	AA+	52995	14576	67571
A3	10	Dodge	12	8	AA+	35988	17864	45125
A4	10	VW	8	6	A	29200	2144	31344
A5	18	Dodge	12	3	AA	47124	784	47908
A6	9	Toyota	10	7	AA	36150	3719	39869
A7	20	Dodge	15	2	A	53310	-1158	52152
A8	7	Dodge	3	6	A	11562	18410	29972
A9	11	Toyota	4	2	AAA	14592	14500	15472
A10	18	Toyota	6	3	AAA	20970	14541	35511
A11	14	Honda	5	3	A	15745	47	15792
A12	15	Ford	6	2	AAA	17250	15078	32328
A13	5	Toyota	10	7	AAA	32290	24278	56568
A14	7	Dodge	11	2	AA+	45727	10942	56669
A15	19	Dodge	5	3	A	19440	13391	32831
A16	5	Ford	11	7	AAA	37928	18321	56249
A17	6	Toyota	5	8	AA+	19385	14976	34361
A18	22	Dodge	14	4	AA+	43624	12288	55912
A19	19	Ford	11	3	A	31702	991	22458
A20	10	Ford	7	2	AA+	20188	9780	29968
A21	20	Honda	5	3	AA+	16710	11591	28301
A22	7	Toyota	9	6	AA	30753	15578	46331
A23	7	VW	12	3	AA+	36564	10475	47039
A24	11	Honda	14	8	AAA	41706	20432	18423
A25	15	Ford	8	7	AAA	33536	16449	49985
A26	9	Toyota	14	5	AA+	48244	15230	63474
A27	19	Ford	5	7	AAA	15350	22913	38263
A28	15	Dodge	14	4	AA+	47768	14544	62312
A29	10	Dodge	12	2	A	33792	-2386	31406
A30	5	Dodge	3	7	AA+	12516	16365	28881
A31	20	VW	11	7	AA	31867	8563	40430
A32	8	Honda	12	7	AA+	45036	15217	60253
A33	13	Toyota	11	3	AAA	38181	1294	19875
A34	8	Honda	12	6	AA+	38268	16994	55262
A35	8	VW	9	7	AA+	26685	16218	42903
A36	2	VW	13	5	AA	41496	4350	45846
A37	8	Dodge	7	5	AA	25998	16360	42358
A38	11	Ford	12	8	AAA	48804	19720	68524
A39	8	Honda	9	5	AA	25884	16425	42309
A40	16	Ford	12	2	AA+	37920	11190	49110

* Note, other variables are included in “profit” such that the values in the Profit column do not necessarily equal the summation of Profit from New Car Sales and Profit from Used Car Sales.

1) Assuming that the Dealership column lists the names of the dealerships (i.e., it is not a variable), which variables are qualitative?

A. Sales people

B. New Car Brand

C. BBB Rating

D. Profit

E. Both B and C are correct

2) The New Car Brand is

A. nominal

B. ordinal

C. interval

D. ratio

3) New Cars Sold Each Week is

A. ratio

B. ordinal

C. interval

D. nominal

4) Used Cars Sold Each Week is

A. Discrete

B. Continuous

C. ratio

D. nominal

E. Both A and C are correct

5) The relative frequency of “AA+” rating is

A. 0.375

B. 0.25

C. 0.475

D. 1.0

6) Using the following class widths for Profit, what is the frequency for stores with a profit of 30,000 – 39,999

Profit	Freq
10000-19999
20000-29999
30000-39999
40000-49999
50000-59999
60000-69999

A. 8

B. 10

C. 7

D. 1

7) Using the above classes, the percent frequency for 50,000 to 59,999 is

A. 0.15

B. 27.5

C. 15.0

D. 0.275

8) Which histogram is correct?

9) If the car sales data is from 50 of 100 total stores in the company and it was collected on the first of July, it is:

A. A cross sectional population

B. A cross sectional sample

C. A time series sample

D. A time series population

10) If you wanted to compare Profit to Number of sales persons, which approach might be the used

A. A scatter plot with profit on the x-axis and sales persons on the y-axis

B. A scatter plot with profit on the y-axis and sales persons on the x-axis

C. A contingency table with profit as the row labels and sales people as the column headings

D. Either B or C are correct

E. Either A or C are correct

11) What is the average number of Sales People?

A. 12.93

B. 13.16

C. 11.85

D. 9.65

12) What is the standard deviation for number of Sales People?

A. 3.5

B. 5.34

C. 28.49

D. 8.65

13) Which of the following statements is correct

A. Sales people is more dispersed than New Cars Sold Each Week

B. Used cars sold each week is less dispersed New Cars Sold Each Week

C. New cars sold each week is less dispersed than Used Cars Sold Each Week

D. Both A and C are correct

14) The mode for BBB Rating is

A. 15

B. AA+

C. AAA

D. None of the above is correct (qualitative data can’t have a mode)

15) The 35th percentile for Used Cars Sold each Week (using excel) is

A. 12.00

B. 8.65

C. 3.00

D. 4.25

16) The interquartile range for Sales People is

A. 8.5

B. 20

C. 8

D. 11

17) The range for Profit is

A. $41,748.00

B. $53,875.00

C. $26,664.00

D. $48,328.00

18) What is the median number of New Cars Sold Each Week?

A. 11

B. 5.5

C. 12

D. 6.75

19) What is the correlation between New Cars sold each week and Profit?

A. -0.254

B. 0.612

C. -0.612

D. 0.779

20) What is the variance for Used Cars Sold Each Week?

A. 7.86

B. 27.97

C. 4.56

D. 2.14

Use the following information to answer questions 21 – 24. A survey was conducted by Public Policy Polling (PPP) to determine if Americans prefer Coke or Pepsi. The following result table was compiled. Use 3 decimals in all calculations.

	Gender
Preference	Female	Male	Total
Coke	85	135	220
Pepsi	120	80	200
Neither/Unsure	65	15	80
Total	270	230	500

21) If an American is selected at random, what is the probability that he or she prefers Pepsi?

A. 0.43

B. 0.16

C. 0.63

D. 0.40

22) If an American is selected at random, what is the probability that the individual is male and prefers Coke?

A. 0.43

B. 0.16

C. 0.63

D. 0.27

23) If an American is selected at random, what is the probability that the individual is male or prefers Pepsi?

A. 0.43

B. 0.16

C. 0.70

D. 0.35

24) If a male respondent is asked which soda he prefers, what is the probability that he will say Coke?

A. 0.84

B. 0.16

C. 0.58

D. 0.35

25) If 5 customers arrive at Crusty’s Pizza every 10 minutes, what is the probability of exactly 12 customers arriving in the next 30 minutes (assume Poisson distribution)?

A. 0.003

B. 0.27

C. 0.083

D. 0.07

26) If the likelihood of an incomplete order form is 0.10, what is the probability that there are at least 3 incomplete order forms in a sample of 15?

A. 0.18

B. 0.82

C. 0.38

D. 0.62