Question

In: Statistics and Probability

Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars.

1 Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.

2 Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Foreign cars. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.

3 Compare your summary results from #1 and #2. Discuss any specific statistical results that would help the car expert understand the car market.

4 Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.

5 Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Foreign cars. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.

6 Assume the car expert requested estimates of the mean number of days to sell for the Domestic cars with a margin of error of seven days and the mean number of days of Foreign cars with a margin of error of eight days. Using 98% confidence, how large should the sample sizes be for each?

7 Suppose a Domestic car has a list price of $30,000 and a Foreign car has a list price of $30,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these cars?

	Domestic Cars			Foreign Cars
Car	List Price in K	Sale Price in K	Days to Sell	List Price in K	Sale Price in K	Days to Sell
1	6.1	4.4	36	83.1	78.5	101
2	67.6	66.8	51	59.6	57.1	62
3	14	13.4	87	37	32.5	63
4	83.4	80.5	80	43.4	43.2	47
5	40	35.4	38	16.3	15	93
6	56	52	24	8.3	5.9	21
7	71.2	68.7	27	29.2	27.5	107
8	50.7	49.7	52	32.7	32.7	15
9	4.9	4.3	74	23.9	23.5	12
10	70.5	66.5	84	85.5	85.1	58
11	58	56	30	19	16.3	96
12	75	73.7	31	19	18.9	106
13	2.8	1.1	88	80.8	77.4	50
14	7.7	4	11	17.7	15.6	42
15	20	16.2	20	71.4	70.4	75
16	23	21.5	71	16.1	13.8	62
17	6.2	6	88	49.2	45.2	91
18	18	14	43	40	38	6
19	97	93.2	95	32	29.2	52
20	69.2	66.8	37	27.2	22.5	71
21	63.5	60.7	13	85.5	82.8	106
22	65	61.9	60	87.4	85.7	91
23	9.9	7	24	58.9	56.9	83
24	90.2	88.3	42	56.2	52.8	29
25	56	55	91	13.5	10	76
26	80	75.2	39	55.7	54.2	40
27	58.7	58.3	58	75.7	74.6	47
28	33.1	32.9	47	89.1	85.7	67
29	31.5	28.7	86	3.5	3.2	106
30	54.5	54.1	88	67.5	65.3	100
31	22.4	17.8	30	41.4	40.1	10
32	40.3	38.4	29	45.3	43.3	36
33	27.2	22.6	34	87.2	85.1	61
34	14.4	14.1	12	16.4	14.3	65
35	5.6	1.5	86	32.6	29.1	25
36	42.2	40.8	72	14.2	14.2	39
37	9.5	6.2	69	60.5	59.1	79
38	93.1	90.5	32	73.1	68.3	83
39	10.7	7.3	15	48.7	44.7	65
40	93.3	91.7	15	38.3	38.2	35
41	50	49.1	19	6.6	4.3	6
42	33.2	29.6	27	86.2	81.4	53
43	67	60	18	5	4.6	108
44	56	53.1	54	37	32.7	85
45	49.5	48.2	37	23.5	21.2	32
46	52.7	48.8	66	90.7	87.4	97
47	41.1	39.7	78	84.1	83.8	16
48	72.1	70.9	12	45.1	42.7	38
49	50	46.9	84	51.7	49.9	53
50	88	84.2	20	36	34.6	97
51	11.8	11.3	20	66.8	65	45
52	69.5	69	90	54.5	50.2	31
53	63	62.6	35	33	33	44
54	60	58.1	46	11.4	10.8	92
55	66.7	66.1	47	59.7	57.9	49
56	58	55.5	51	84.2	80.1	52
57	67.2	62.7	96	48.2	43.4	101
58	74.9	70.4	59	68.9	64.9	14
59	71.4	70.2	14	60.4	59.9	98
60	71.1	67.8	75	87.1	85.1	90
61	54	54	52	68.3	66.4	61
62	19.9	17.2	60	8.9	7.5	32
63	49.5	48.6	56	39.5	39.3	48
64	56.8	54.8	11	57.8	53.1	29
65	74	71.3	71	59	57.5	98
66	20.4	17	31	22.4	19.4	6
67	34.5	32.5	40	78.5	77.3	6
68	17.2	14.4	29	11.2	9.4	83
69	45	42.5	72	86.2	82	79
70	82	81	32	4	3.5	70
71	40	39.3	21	22.6	21.1	38
72	16	12.4	62	36	36	18
73	25	20.1	72	88	87.1	26
74	64.1	61.5	10	88.1	85.2	41
75	39.5	35.4	71	66.5	61.8	100
76	72	67.3	97	4.1	3.1	7
77	13	10.4	80	22	20.6	11
78	37.1	36.1	26	71.1	70.5	33
79	67.7	62.7	29	36.7	33.5	42
80	40	36.6	28	69.2	66.3	9
81	55.9	52.8	71	14.9	12.6	94
82	51	47.4	81	81	78.8	104
83	50	45.4	41	46.9	44.3	25
84	44.2	41	15	11.2	6.6	69
85	12	9.8	31	7	5.3	66
86	72	70	78	36	31.9	52
87	51.6	46.6	84	49.6	46.8	39
88	54.4	52.6	26	42.4	38.3	92
89	44.5	42.5	92	4.5	4	46
90	61.6	60.9	19	31.6	31	64
91	34.1	33.1	91	57.1	53.3	38
92	80	79	38	42	39	64
93	61.9	61.1	85	71.9	71	11
94	74.6	73.4	84	86.6	86.5	11
95	17	14.5	90	90	87.2	6
96	10.8	7.9	70	47.8	42.9	73
97	44.7	43.8	61	52.7	52.6	66
98	11.7	10.3	73	35.7	32	31
99	97.9	95.9	92	44.9	43.3	24
100	67.5	63	10	21.5	19.4	89
101	64	61.9	43	84.3	83.2	31
102	97.7	93.7	73	69.7	65.7	100
103	8.9	6.5	87	37.9	37.9	43
104	51.3	47.7	18	49.3	45.5	18
105	56	53.1	47	82.7	82.5	67
106	12.6	8.4	95	3.6	3.2	7
107	42.6	38.7	73	53.6	48.9	87
108	50	47.7	84	74.2	69.2	11
109	25.7	24.8	38	56.7	53.2	50
110	72.4	67.6	98	54.4	51	69
111	20.7	18.3	16	38.7	34	28
112	62.3	57.9	13	4.3	2.9	85
113	41.4	37.4	61	19.4	15.9	7
114	50	49	97	16.5	12.8	95
115	77.9	76.7	84	41.9	41	52
116	10	9.2	25	73	69.4	98
117	80	76.1	44	56	55.9	68
118	61.5	60	48	69.5	68.9	43
119	61.1	58.3	73	36.1	32.4	85
120	38.6	34.2	54	32.6	28	7
121	73.9	68.9	39	85.9	80.9	63
122	30	30	94	68.9	68.8	26
123	56	51.3	17	81.3	78.6	53
124	39	36.1	72	52	50.4	104
125	7.4	3.5	81	60.4	58.2	67
126	74.9	74.5	16	23.9	19.4	43
127	40	37.9	43	59.6	55.8	28
128	43	39	23	44.5	44.3	54
129	28.8	24.6	67	90.8	88.8	67
130	14.5	10.5	14	66.5	63.5	11
131	10.8	9.9	59	60.8	56	19
132	6.6	1.9	12	83.6	82.5	8
133	12.6	10.7	51	35.6	33.7	41
134	3.4	0.2	86	81.4	78.5	45
135	40.6	40.6	30	8.6	3.7	12
136	67	63.5	70	7.2	6.3	35
137	33.6	32	97	80.6	75.7	44
138	67	66	59	3.5	3.2	84
139	14	9.5	94	52	49.4	24
140	22.7	19.7	34	6.7	2.7	18
141	69.6	65.6	26	54.6	49.6	65
142	68.7	65.2	38	11.7	8.5	13
143	70	68	95	84.7	82.7	83
144	57	54	89	57.9	57.1	103
145	56.6	54.6	89	22.6	18.3	97
146	69.4	69.2	80	85.4	80.9	77
147	81.7	77.3	86	72.7	70.8	22
148	70	65.8	72	30.3	28.5	57
149	39.3	37.2	52	10.3	6.2	108
150	16.8	13.3	49	80.8	80.1	11
151	65.3	62.5	19	64.3	59.6	100
152	15.9	14	91	31.9	29	84
153	57.5	54.8	72	70.5	66.5	45
154	55.7	55	61	7.7	5.7	71
155	67.3	63.5	39	20.3	16.5	54
156	10	9.6	72	56	52.3	77
157	96	94.1	81	6	2.1	46
158	57.7	55.7	22	24.7	23.7	75
159	15.7	15.2	77	59.7	55.4	35
160	12.2	7.8	94	53.2	48.8	13
161	56.1	52.5	58	48.1	47.8	24
162	10.3	9.6	36	19.3	16.3	64
163	58	54.7	98	6.3	3.5	61
164	7.5	6.5	59	26.5	22	84
165	14.4	12.8	62	44.4	43.7	59
166	57.5	57.4	46	89.5	89.2	36
167	40.1	39.7	68	69.1	67.5	49
168	23.3	21	33	48.3	44.7	103
169	59	57.9	53	89	84.4	108
170	24.2	19.3	33	56.2	54.6	20
171	62	59.2	22	30	25.1	67
172	45	40.7	37	57.8	56.3	42
173	42	42	33	70.4	68.5	16
174	60	59.5	54	50.1	46.5	43
175	77.8	75	32	18.8	15.9	63
176	73	70	76	24	22.2	103
177	13.4	12	53	38.4	35.5	16
178	29	27.9	57	73.6	71.5	93
179	97	92.7	31	25	24.7	60
180	10	7.7	62	19	18.5	70
181	21.7	19.5	13	49.7	49.6	47
182	42.9	41.1	69	67.9	63.2	107
183	23	20	42	28.6	28.3	50
184	35	34.7	15	26.7	24.2	40
185	3.4	3.3	34	51.4	47	25
186	45	40.6	72	53.5	53.1	99
187	7.9	4.6	50	6.9	2.2	23
188	44	41.2	63	9.1	6.2	97
189	8	3.1	36	70	68.3	83
190	33	31.9	27	17	13	106
191	2.6	2.4	63	57.6	55.6	87
192	24	23	63	19.2	17.8	52
193	23.6	19.7	30	34.6	32.2	46
194	49.1	45.3	67	57.1	54.2	37
195	1.5	1.3	69	80.5	80.4	98
196	57.4	52.8	89	81.4	80.4	108
197	60.9	59.8	56	69.9	69	88
198	59.7	56.1	65	16.7	14.9	106
199	1.8	1.7	20	78.8	75.4	7
200	63.1	61.7	40	54.1	52.2	57

Expert Solution

1) mean of Domestic Cars List Price in K= 44.854

median of Domestic Cars List Price in K = 49.3

range of Domestic Cars List Price in K= 97.9-1.5 = 96.4

standard deviation of Domestic Cars List Price in K = 25.33192

coefficient of variation of Domestic Cars List Price in K =177.0651

mean of Domestic Cars Sale Price in K = 42.3965

Median of Domestic Cars Sale Price in K = 45.35

Range of Domestic Cars Sale Price in K = 98.9-0.2 = 98.7

Standard deviation of Domestic Cars Sale Price in K = 25.21323

coefficient of variation of Domestic Cars Sale Price in K = 168.1518

mean of Domestic Cars Days to Sell = 53.29

Median of Domestic Cars Days to Sell = 53

Range of Domestic Cars Days to Sell = 98-10 = 88

Standard deviation of Domestic Cars Days to Sell = 26.10928

coefficient of variation of Domestic Cars Days to Sell = 204.1037

2)

mean of Foreign Cars List Price in K= 47.228

median of Foreign Cars List Price in K = 48.95

range of Foreign Cars List Price in K= 90.8-3.5 = 87.3

standard deviation of Foreign Cars List Price in K = 26.09932

coefficient of variation of Foreign Cars List Price in K =180.9549

mean of Foreign Cars Sale Price in K = 44.83

Median of Foreign Cars Sale Price in K = 45.35

Range of Foreign Cars Sale Price in K = 89.2-2.1 = 87.1

Standard deviation of Foreign Cars Sale Price in K = 26.03037

coefficient of variation of Foreign Cars Sale Price in K = 172.2219

mean of Foreign Cars Days to Sell = 56.26

Median of Foreign Cars Days to Sell = 53

Range of Foreign Cars Days to Sell = 108-6 = 102

Standard deviation of Foreign Cars Days to Sell = 30.99688

coefficient of variation of Foreign Cars Days to Sell = 181.5021

orchestra answered 2 years ago

Use Descriptive Statistics in Excel to find the mean, median, range and standard deviation of the...

Use Descriptive Statistics in Excel to find the mean, median, range and standard deviation of the data below. Table 1: Health Expenditures as a Percentage of GDP of countries around the world 3.35 5.96 10.64 5.24 3.79 5.65 7.66 7.38 5.87 11.15 5.96 4.78 7.75 2.72 9.50 7.69 10.05 11.96 8.18 6.74 5.89 6.20 5.98 8.83 6.78 6.66 9.45 5.41 5.16 8.55

* Descriptive statistics: o Find the mean, median, mode, range, and standard deviation for the data...

* Descriptive statistics: o Find the mean, median, mode, range, and standard deviation for the data set. o Create a scatter plot for the data set. * Regression Analysis: o Perform a linear regression analysis onto the data set. o Report the correlation coefficient, the equation of the regression function, and make a few predictions base on hypnotical input values. o Write down a summary of your conclusions (How well does the regression fit the values? How correlated are the...

Calculate the Mean, Median, Standard Deviation, Coefficient of Variation and 95% population mean confidence intervals for...

Calculate the Mean, Median, Standard Deviation, Coefficient of Variation and 95% population mean confidence intervals for property prices of Houses based on the following grouping:  Proximity of the property to CBD Note: Calculate above statistics for both “Up to 5KM” and “Between 5KM and 10KM”  Number of bedrooms Note: Calculate above statistics for “One bedroom”, “Two bedrooms” and “Three bedrooms or more”  Number of bathrooms Note: Calculate above statistics for “One bathroom”, “Two bathrooms”, “Three bathrooms or...

Calculate the range, interquartile range, variance, standard deviation and coefficient of variation.

A sample has data values 27, 25, 20, 15, 30, 34, 28, 25. Calculate the range, interquartile range, variance, standard deviation and coefficient of variation.

Compute the mean, range, and standard deviation for the data items in each of the three...

Compute the mean, range, and standard deviation for the data items in each of the three samples. Then describe one way in which the samples are alike and one way in which they are different. Sample A: 6, 14, 22, 30, 38, 46, 54 Mean ? Range ? Standard Deviation ? Sample B: 6, 10, 14, 30, 46, 50, 54 Mean ? Range ? Standard Deviation ? Sample C: 6, 6, 6, 30, 54, 54, 54 Mean ? Range ?...

Please assist with finding the mean, standard deviation and coefficient variation for the monthly profit of...

Please assist with finding the mean, standard deviation and coefficient variation for the monthly profit of all the small, medium, large and very larges stores listed below. Store Size Monthly Profit VL $9,984 VL $8,387 VL $9,679 VL $21,591 VL $8,197 VL $20,930 M $3,305 S -$11,264 VL $28,367 VL $18,904 S $18,934 VL $11,845 M $15,747 L $23,107 VL $18,461 VL $2,035 L $11,771 VL $22,783 M -$3,619 L $13,326 VL $19,157 VL $16,047 L $5,675 M $11,720 L...

Use appropriate descriptive statistics to summarize each of the two variables for the 40 Gulf View...

Use appropriate descriptive statistics to summarize each of the two variables for the 40 Gulf View condominiums, and each of the two variables for the 18 No Gulf View condominiums. What are the means and standard deviations of the four variables? . Compare your summary results. Discuss any specific statistical results that would help a real estate agent understand the condominium market. In particular, what are the percent discounts between the average list and sale price for Gulf View and...

Calculate the standard deviation and coefficient of variation for each data set below, be sure to...

Calculate the standard deviation and coefficient of variation for each data set below, be sure to attach an Excel file to show the work. Explain which of the two mentioned measures can more accurately specify which of these two data sets has more variability or dispersion in their data values, and why. Data set 1= 11,12,13,14,15,16,17,18,19,20 Data set 2= 8,9,28,29,5,4,1,3,2,10

Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion,...

Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion, median, mode)that we've covered in class for the two following variables: Variable X Variable Y 4 40 2 36 8 49 6 38 10 56 5 58 3 39 9 53 10 34 9 47

For the following distribution find the mean, median, mode, range and standard deviation: 13, 10, 16,...

For the following distribution find the mean, median, mode, range and standard deviation: 13, 10, 16, 20, 10, 14, 13, 25